ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312103] |
Tue, 08 April 2008 00:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43710.gif) |
Barbara Boehmer
Messages: 9097 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
I am a retired developer, not a DBA, with a home computer (Windows Vista Home Basic) that has had an Oracle 11g Enterprise Edition database running on it without problems. I accidentally ran a script that I should not have run and now I cannot login. I am hoping that someone can help me fix it. I have poked around somewhat, but am hoping that someone will just provide a quick spoonfeed, so I can get it up and running again.
This is the script that I ran, with settings that do not correspond to my system and apparently with obsolete parameters:
set echo on
connect sys/orcl as sysdba
alter system set log_archive_start=true scope=spfile;
alter system set log_archive_dest='/tmp/' scope=spfile;
shutdown immediate;
startup pfile=init.ora mount
alter database archivelog;
alter database open;
I have tried shutting down my laptop computer and re-starting it. The Oracle services all show started and automatic, but when I try to login through SQL*Plus I get:
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Apr 7 21:55:22 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name: sys/orcl as sysdba
Connected to an idle instance.
SYS@orcl_11g>
SYS@orcl_11g> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
SYS@orcl_11g>
I don't know what the correct pfile or spfile was or how to find it or how to fix the archive log mess. Please help me.
|
|
|
|
|
|
|
|
|
|
|