OraFAQ Forum: SQL & PL/SQL » Instance terminated by user, pid=27875

Home » SQL & PL/SQL » SQL & PL/SQL » Instance terminated by user, pid=27875 (HP-UX 11.11/ORACLE 10G REL2)

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

Instance terminated by user, pid=27875 [message #335638]

Wed, 23 July 2008 01:43

razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh

Member

Hi,

HP-UX 11I
Oracle 10g Rel2 Database

My database one of a instance ABCD2 re-started automatically and altert*.log file throws following details.

*Shutting down instance (aboart)
licence high water mark=343
Instance terminated by user , pid=27875 ....@23:34:35 time

and next

starting oracle instance (normal).......@23:34:51 time

My Question is :

1.Why my ABCD2 second instance stopped and started automatically, I checked the network,OCR,RAC activities everything seems normal.

I appreciate your valuable experienced advice.

Have a wonderful day ///// Cheez

Report message to a moderator

Re: Instance terminated by user, pid=27875 [message #335647 is a reply to message #335638]

Wed, 23 July 2008 02:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If everything is normal, then this did not happen.

More seriously, how could we help you with the information you gave.
Check other messages in alert.log, trace files, OS/rman jobs and so on.

Regards
Michel

Report message to a moderator

Re: Instance terminated by user, pid=27875 [message #335661 is a reply to message #335638]

Wed, 23 July 2008 03:40

razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh

Member

Hi Michel,

Thanks for your quick reply, Please find an enclosed file of database alert.log for that particular instance, OS is ok , rman is not configured since 2yrs database works fine without rman. But yesterday only i faced this problem first time.

Attachment: New Text Document.txt
(Size: 9.89KB, Downloaded 1268 times)

Report message to a moderator

Re: Instance terminated by user, pid=27875 [message #335662 is a reply to message #335661]

Wed, 23 July 2008 03:59

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to investigate who is/was pid 27875 and what it was doing, most likely it is a "startup force".

Regards
Michel

Report message to a moderator

Re: Instance terminated by user, pid=27875 [message #335678 is a reply to message #335661]

Wed, 23 July 2008 05:03

razisolaris
Messages: 48
Registered: February 2008
Location: Riyadh

Member

Hi,

Iam unable to track pid 27875 with the help of #ps -ef
|grep 27875 command, Could you help me how to track this pid on HP-UX server.

Thanks a lot for your valuable suggestions.

Report message to a moderator

Re: Instance terminated by user, pid=27875 [message #335690 is a reply to message #335678]

Wed, 23 July 2008 05:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is likely no more there.
You have to search in all the programs, scripts, cron jobs and so on which one does a "startup force".

Regards
Michel

Report message to a moderator

Previous Topic:	passing parameters to SQL file through shell scripts
Next Topic:	How to retrive the latest updated records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:44:15 CST 2024