Home » RDBMS Server » Performance Tuning » shared memory realm already exists
shared memory realm already exists [message #262136] Fri, 24 August 2007 12:38 Go to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Hi. I have increased too much the memory for my oracle database I get this message when I want to start it: shared memory realm already exists. How do I fix this. I am desperate. Please help. Thank you!
icon8.gif  Re: shared memory realm already exists [message #262137 is a reply to message #262136] Fri, 24 August 2007 12:39 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I am using oracle 9. Please help.
Re: shared memory realm already exists [message #262138 is a reply to message #262136] Fri, 24 August 2007 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> SHUTDOWN ABORT
SQL> STARTUP
Re: shared memory realm already exists [message #262139 is a reply to message #262138] Fri, 24 August 2007 12:48 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I cannot connect to sql. I have tried from command prompt:
sqlplus and then to connect as sys. But I get shared memory realm does not exists. Thanks!
Re: shared memory realm already exists [message #262140 is a reply to message #262139] Fri, 24 August 2007 12:48 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Forgot to tell. I am using windows 2003.
Re: shared memory realm already exists [message #262145 is a reply to message #262138] Fri, 24 August 2007 13:00 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Please help somebody!
Re: shared memory realm already exists [message #262150 is a reply to message #262136] Fri, 24 August 2007 13:10 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
I suspect your environment is incorrect or missing.
LOCAL=<your_SID>
sqlplus
/ as sysdba
Re: shared memory realm already exists [message #262153 is a reply to message #262150] Fri, 24 August 2007 13:28 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I do not understand. Please give more details. I know a few things about oracle, but I do not claim to be an expert as you can see. Should I just type in command prompt LOCAL=<the name of the instance>? Like LOCAL=test? I have tried. Nothing. Could you please give me some more details Please?! Thank you!
Re: shared memory realm already exists [message #262154 is a reply to message #262150] Fri, 24 August 2007 13:30 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I have tried SQLPLUS LOCAL=<DATABASE NAME>. It asked me for a password. I have tried the password but it says ORACLE NOT AVAILABLE.
Re: shared memory realm already exists [message #262155 is a reply to message #262150] Fri, 24 August 2007 13:38 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I have two instances on the same server, but one of them is stopped. I hope this is not a problem. Where can I find AWE_WINDOW_MEMORY to modify it? I have read that this might help. Thanks!
Re: shared memory realm already exists [message #262156 is a reply to message #262150] Fri, 24 August 2007 13:39 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
It is not in the registry as i thought. Guys please help!
icon7.gif  Re: shared memory realm already exists [message #262172 is a reply to message #262156] Fri, 24 August 2007 15:21 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
I have found the solution. it is here
http://nixforums.org/about53458.html
May God give long life and good health to the one who posted it there. It works like charm.
Re: shared memory realm already exists [message #264695 is a reply to message #262136] Tue, 04 September 2007 04:02 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
When you increased memory exceed the total of physical memory, you usually encounter like this error message. The SGA includes Shared Pool, DB buffer Cache, Redo Log Buffer, Java Pool and Large Pool.
Sometime I attempted to increase SGA.

When you get this error message, don't sad or worry. From the Oracle 9i, the Instance startup by spfile - server parameter file which created by pfile manually. However, when you re-create spfile from the exists pfile, some parameters that was tuned will become for the firs time.


..shared memory realm already exists
....
SQL> Shutdown abort
Instance shutdown


Create spfile from pfile
With Unix..
$SQL>create spfile from pfile='/u01/ORACLE_HOME/DB_1/DBS/initSID.ora'

File created
$SQL>startup mount
....
Instance startup
SQL>Alter database Open;


With Windows..
SQL>create spfile from pfile='C:\ORACLE_HOME\DB_1\DBS\initSID.ora'

File created
SQL>Startup mount
...
Instance start
SQL> Alter database open;
Database opened


If necessary, backup the pfile to the other location.

The oradim -SID is need to create one new SID, sometime it's unnecessary.
Regards!
Previous Topic: Hash join vs NL join
Next Topic: db_cache_size - correct size
Goto Forum:
  


Current Time: Fri Dec 09 17:21:18 CST 2016

Total time taken to generate the page: 0.22676 seconds