PMON killed, I can't start Oracle
Unknown
Hi all, I am a newbie DBA, please bear with me.
This morning I accidentally killed the PMON ( hurriedly used the wrong PID ).
Now my Oracle instance won't start. I get the following messages:
SQLDBA > connect internal
Connected.
SQLDBA > startup mount
DBA-00342: unable to complete internal login
ORA-00472: PMON process terminated with error
SQLDBA >
The server messages and codes manual asks me to check the background process
trace file, and then shutdown and restart the instance. But I am not able to
shutdown the database. Any command I execute gives me the above two
error messages. What went wrong ?
I am running Oracle 7.1.4 on AT&T SVR4 Rel 2.03.01.
I would appreciate any help. Thanks
Nalini Vallampati
AT&T Credit
Maimisburg, Ohio 45342
Carl Gohringer
A SHUTDOWN ABORT should clear the instance.
--
regards, \\\\
Carl Designer/2000 (@ @)
+--------------------------------------------------ooO-()-Ooo-----------+
Oracle Corporation
Carl Gohringer, Senior CASE Products Training Consultant
World Wide Education
European Development Centre
Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG
+-----------------------------------------------------------------------+
David Kaufman
Shutdown Abort
?
This will always kill a rogue database. If you just want to start it up
again with an automatic shutdown, try
Startup Force
This does the shutdown abort and then restarts the database with a startup
open.
David Kaufman
Managing Consultant
Unknown
writes:
I noted your suggestions down for future reference. However, the problem
detected
was that the shared memory area was full, so I cleared the shared memory area
(with help from Tech support ).
$ ipcs -b
IPC status from /dev/kmem as of Mon Aug 14 10:11:36 1995
T ID KEY MODE OWNER GROUP QBYTES
Message Queues:
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x4c0635b9 -Crw-rw-r-- lanman sys 73728
m 1 0x2a399db4 -Crw-r----- oracle7 dba4386816 <------- !!!!
T ID KEY MODE OWNER GROUP NSEMS
Semaphores:
s 0 0x00000000 --ra-r----- oracle7 dba 25
s 1 0x00000000 --ra-r----- oracle7 dba 25
$
$ ipcrm -m 1
$ ipcs -b
$ IPC status from /dev/kmem as of Mon Aug 14 10:11:36 1995
T ID KEY MODE OWNER GROUP QBYTES
Message Queues:
T ID KEY MODE OWNER GROUP SEGSZ
Shared Memory:
m 0 0x4c0635b9 -Crw-rw-r-- lanman sys 73728
< shared memory cleared here >
T ID KEY MODE OWNER GROUP NSEMS
Semaphores:
s 0 0x00000000 --ra-r----- oracle7 dba 25
s 1 0x00000000 --ra-r----- oracle7 dba 25
$
Then I did a 'startup mount' and 'alter database open'. The instance
started immediately.
I appreciate your help.
Nalini Vallampati
UNIX Admin./Oracle DBA
AT&T Credit
Miamisburg, Ohio 45342
Jim (Kyung-Jin) Yoo
I had instances where if you have processes still hanging it takes
long time before it shuts down. If your oracle already terminated and
will not let you re-start try using "shutdown abort" from sqldba.
Good luck.
Nalini Vallampati <> wrote:
>Hi all, I am a newbie DBA, please bear with me.
>This morning I accidentally killed the PMON ( hurriedly used the wrong PID ).
Barry Roomberg
>
>
>Hi all, I am a newbie DBA, please bear with me.
>
>This morning I accidentally killed the PMON ( hurriedly used the wrong PID ).
>Now my Oracle instance won't start. I get the following messages:
>
>SQLDBA > connect internal
>Connected.
>SQLDBA > startup mount
>DBA-00342: unable to complete internal login
>ORA-00472: PMON process terminated with error
>SQLDBA >
>
>The server messages and codes manual asks me to check the background process
>trace file, and then shutdown and restart the instance. But I am not able to
>shutdown the database. Any command I execute gives me the above two
>error messages. What went wrong ?
>
>I am running Oracle 7.1.4 on AT&T SVR4 Rel 2.03.01.
>
>I would appreciate any help. Thanks
>
>Nalini Vallampati
>AT&T Credit
>Maimisburg, Ohio 45342
>
Do a "CONNECT INTERNAL" and then a "SHUTDOWN ABORT"
to sqldba.
Also, your mail header does not have a recognizable
address, you I can't mail this to you directly.