| shared memory realm already exists [message #262136] |
Fri, 24 August 2007 12:38  |
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!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: shared memory realm already exists [message #262153 is a reply to message #262150] |
Fri, 24 August 2007 13:28  |
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 #264695 is a reply to message #262136] |
Tue, 04 September 2007 04:02 |
trantuananh24hg
Messages: 744
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
