Home » RDBMS Server » Server Administration » PMON
icon4.gif  PMON [message #268002] Mon, 17 September 2007 02:08 Go to next message
harneetsingh
Messages: 4
Registered: September 2007
Junior Member

Hi Gurus,

I am having a database running and due to some operations on OS level itself through the Cron jobs, the PMON process of the database got killed, although my instance remained running for quite a while without that, but it crashes as soon as new user logged in. (thats the expected behaviour).
I am just wondering if there is any way I could have just started the pmon process alone.
Because we have some testing going on the test server and I expect this to be repeated few more times in coming days.

Any ideas if and how that can be achieved.

Re: PMON [message #268008 is a reply to message #268002] Mon, 17 September 2007 02:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

due to some operations on OS level itself through the Cron jobs, the PMON process of the database got killed
Fix your OS level problem which fix terminate pmon process

Regards
Mohammed Taj
Re: PMON [message #268009 is a reply to message #268008] Mon, 17 September 2007 02:29 Go to previous messageGo to next message
harneetsingh
Messages: 4
Registered: September 2007
Junior Member

Wink nice one
I already told this will be fixed, I just need to know if there is anyway to start only the PMON process.
Re: PMON [message #268010 is a reply to message #268009] Mon, 17 September 2007 02:30 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

No way... AFAIK.(As far as I know)

except "startup" on SQLPLUS prompt.

[Updated on: Mon, 17 September 2007 02:35]

Report message to a moderator

Re: PMON [message #268011 is a reply to message #268002] Mon, 17 September 2007 02:32 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I really don't know what is AFAIK .....
Re: PMON [message #268012 is a reply to message #268011] Mon, 17 September 2007 02:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Now it is ok...
http://www.orafaq.com/forum/t/89439/93410/
Re: PMON [message #268013 is a reply to message #268010] Mon, 17 September 2007 02:36 Go to previous messageGo to next message
harneetsingh
Messages: 4
Registered: September 2007
Junior Member

lol, ok that test server part story is a hoax, fact is that I was asked this in an interview and I replied the same thing which you said, but Interviewer says there is a way, Sad
I am still wondering if he was saying the truth ..
Re: PMON [message #268022 is a reply to message #268013] Mon, 17 September 2007 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but Interviewer says there is a way,

And you didn't ask him which one?

Regards
Michel
Re: PMON [message #268023 is a reply to message #268002] Mon, 17 September 2007 03:10 Go to previous messageGo to next message
harneetsingh
Messages: 4
Registered: September 2007
Junior Member

i did, he said try it yourself Wink
Re: PMON [message #268024 is a reply to message #268002] Mon, 17 September 2007 03:17 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I believe that he was saying false. PMON as well as any other background process can't be done so.
Previous Topic: What is actually undo_retention
Next Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Goto Forum:
  


Current Time: Thu Apr 25 15:05:14 CDT 2024