Home » SQL & PL/SQL » SQL & PL/SQL » Instance terminated by user, pid=27875 (HP-UX 11.11/ORACLE 10G REL2)
icon5.gif  Instance terminated by user, pid=27875 [message #335638] Wed, 23 July 2008 01:43 Go to next message
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
Re: Instance terminated by user, pid=27875 [message #335647 is a reply to message #335638] Wed, 23 July 2008 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
icon5.gif  Re: Instance terminated by user, pid=27875 [message #335661 is a reply to message #335638] Wed, 23 July 2008 03:40 Go to previous messageGo to next message
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.


Re: Instance terminated by user, pid=27875 [message #335662 is a reply to message #335661] Wed, 23 July 2008 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
icon5.gif  Re: Instance terminated by user, pid=27875 [message #335678 is a reply to message #335661] Wed, 23 July 2008 05:03 Go to previous messageGo to next message
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.
Re: Instance terminated by user, pid=27875 [message #335690 is a reply to message #335678] Wed, 23 July 2008 05:26 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: passing parameters to SQL file through shell scripts
Next Topic: How to retrive the latest updated records
Goto Forum:
  


Current Time: Mon Dec 05 20:59:29 CST 2016

Total time taken to generate the page: 0.09569 seconds