OraFAQ Forum: Server Administration » Deallocating Memory Segments of Crashed Oracle Instance

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Deallocating Memory Segments of Crashed Oracle Instance [message #432274]

Mon, 23 November 2009 06:14

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

Report message to a moderator

Re: Deallocating Memory Segments of Crashed Oracle Instance [message #432298 is a reply to message #432274]

Mon, 23 November 2009 08:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

one solution is

init 6

Report message to a moderator

Re: Deallocating Memory Segments of Crashed Oracle Instance [message #432315 is a reply to message #432274]

Mon, 23 November 2009 09:44

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 30 01:43:10 CDT 2025