-
shutdown but still got oracle processes
hi, in svrmgrl, i did a shutdown, the system replied that the database is shutdown. however, i did a ps -ef | grep ora, and i still find these oracle processes. afterwhich i did a startup, and the system told me that oracle is still running. what is wrong?
-
you didnt actually shut it down, lets see what you typed and variables and such like
-
You can try shutting down the database again, then kill the othe oracle process manually, then you can start your db.
-
Can you paste output of the command
ps -ef | grep ora
Dilip Patel
OCP 8i
Catch me online at Yahoo: ddpatel256
-
Do you have multiple databases on the system? If so, did you set the ORACLE_SID to shutdown the appropriate database? The SID name is appended to oracle processes.
-
I guess your listener service is still alive.
-
In a normal shutdown, oracle will wait untill all the connections are closed and then only it will shutdown.
You might want to issue shutdown immediate/shutdown abort
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Can you paste output of the command
ps -ef | grep ora
i wished i could. but now the database is okay and running. anyway, the output of ps -ef | grep ora is the oracle processes with smon, pmon, archiver, lgwr, dbwr and etc.......
Originally posted by sambavan
In a normal shutdown, oracle will wait untill all the connections are closed and then only it will shutdown.
You might want to issue shutdown immediate/shutdown abort
Sam
this is what actually happens
1) we had scripts to shutdown/startup the database for offline backup in our crontab entries
2) and these scripts had been working fine.
3) but recently, there had been 2 times when the scripts are not working
4) scenario: couldnt startup database therefore go and analyze
5) found that the shutdown script did not shutdown the database. Cos going into svrmgrl, and doing a startup says that "the oracle instance is still running"
5.1) do a ps -ef | grep ora and indeed saw all these oracle processes including the shutdown script entry.
5.2) going back to svrmgrl, did a shutdown immediate. still same result in 5.1
5.3) colleague did a shutdown abort and it works.
my questions
1)is that isnt it dangerous to do a shutdown abort. actually, i was thinking about killing all the orace processes. so which is more advisable?
2) what are the valid reasons doing a shutdown abort.
thanks
-
-
Originally posted by adewri
.............
4. When you need to .......................
Contd. on the last page... [/B]
where is the last page?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|