Hi,
I am having 3 database instances on a HP-UX box
One of the instance crashed in last week and I had to open database by renaming the instance
However the memory segments allocated for the instance are not deallocated and thus I am getting following error while mounting the instance
SQL> startup nomount
ORA-27100: shared memory realm already exists
HPUX-ia64 Error: 17: File exists
SQL>
Since I am unable to mount the instance, I am unable to locate memory segments allocated to it for deallocation.
I am able to find out the memory segments of other 3 databases instances
Can I deallocate all the memory segments as ouputed from (ipcs -pmb) excluding memory segments of the 3 active databases instances?
The Output of ipcs -pmb is as follows
oracle@dev.com:$ipcs -pmb|grep oracle
m 720905 0xe63dccd4 --rw-r----- oracle dba 3241115648 13252 27246
m 1343499 0xe63dccd5 --rw-r----- oracle dba 3241115648 13250 27246
m 2162701 0x02c24068 --rw-r----- oracle dba 3241115648 3956 28689
m 3571726 0xcca6e4f4 --rw-r----- oracle dba 3241115648 10894 28206
m 1835023 0x00c8abb0 --rw-r----- oracle dba 3241115648 16219 27992
The value of 'Shmid' in the trace files of all the 3 database instances are
Instance 1 3571726
Instance 2 2162701
Instance 3 1835023
These are found using following method
% ps -ef | grep <instancename> | grep LOCAL
SQL> oradebug setospid <above proces id>
SQL> oradebug ipc
Thanks and Regards,
Chetana
] 
Blog
Search
Help
Members
Register
Login
Home
