Home » RDBMS Server » Server Administration » Deallocating Memory Segments of Crashed Oracle Instance (Oracle 9.2.0.6.0 on HP-UX B.11.23 U ia64)
Deallocating Memory Segments of Crashed Oracle Instance [message #432274] Mon, 23 November 2009 06:14 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
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
Re: Deallocating Memory Segments of Crashed Oracle Instance [message #432298 is a reply to message #432274] Mon, 23 November 2009 08:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
one solution is

init 6

Re: Deallocating Memory Segments of Crashed Oracle Instance [message #432315 is a reply to message #432274] Mon, 23 November 2009 09:44 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Thanks BlackSwan !!

Is init 6 good on HP-UX? I have never tried it on HP-UX

is there any other option to check memory segments for the crashed instance?

I tried to get into the database using 'sqlplus prelim' but it did not succeed

Regards,
Chetana




Previous Topic: oracle client
Next Topic: what datatype should the column that sequence generate store in?
Goto Forum:
  


Current Time: Tue Dec 03 12:19:32 CST 2024