Home » RDBMS Server » Server Administration » ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist (Oracle11g on Windows Vista Home Basic)
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
Barbara Boehmer
Messages: 9090
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.

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312105 is a reply to message #312103] Tue, 08 April 2008 00:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have a PM.

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312109 is a reply to message #312103] Tue, 08 April 2008 00:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:
alter system set log_archive_start=true scope=spfile;
alter system set log_archive_dest='/tmp/' scope=spfile;


log_archive_start has been deprecated. please don't use it.
setting log_archive_dest='/tmp/' is ok but I think you don't have /tmp location in your computer. As you are in windows edition . So locate like 'C:\'.

By the way you can run your database now with another newly created pfile only by putting the entry of right control_files parameter in it.

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312117 is a reply to message #312105] Tue, 08 April 2008 00:51 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
The problem has been solved, thanks to some quick PM's from anacedent. Here is what fixed it, in case anyone else ends up in a similar situation.

By doing:

create pfile from spfile;

it created a new pfile with today's date.

So, by doing:

dir init*.ora/s/p

I was able to locate the new pfile, edit it, remove the two lines that said:

*.log_archive_dest='/tmp/'
*.log_archive_start=TRUE

then startup using the new pfile with the directory path.

Thanks a millions to anacedent!

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312118 is a reply to message #312103] Tue, 08 April 2008 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Assuming you previously were in noarchivelog mode, you can use:
startup mount;
alter system reset log_archive_start scope=spfile sid='*';
alter system reset log_archive_dest scope=spfile sid='*';
alter database noarchivelog;
shutdown
startup

If this does not work, you can:
startup nomount;
create pfile from spfile;
-- here, remove the 2 lines from pfile in notepad
create spfile from pfile;
alter database mount;
alter database noarchivelog;
shutdown
startup

Regards
Michel

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312215 is a reply to message #312117] Tue, 08 April 2008 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Gee! I didn't see you posted you found a solution at the same time I was writing mine.
...And it was the same... Laughing

Regards
Michel

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312218 is a reply to message #312103] Tue, 08 April 2008 04:14 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
I tried to sum up this problem in,

http://arjudba.blogspot.com/2008/04/ora-32004-obsolete-andor-deprecated.html

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312240 is a reply to message #312218] Tue, 08 April 2008 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Arju,
If you want to promote your site do it in Marketplace forum.

It is annoying to see you repeating the same things that are in the topics to promote your new pages.
You do it, good, don't promote it in the topics.

Regards
Michel

Report message to a moderator

Re: ORA-01034: Oracle not available; ORA-27101: shared memory realm does not exist [message #312253 is a reply to message #312103] Tue, 08 April 2008 05:17 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Ok,Thank you Michel, I will try to do it.

Report message to a moderator

Previous Topic: ORA-27091 & ORA-27037
Next Topic: Adding a Datafile to an existing Index Tablspace on a Live Busy System
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 18:29:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.