shubhendu_gupta

 Profile Answers by shubhendu_gupta 

• Sep 23rd, 2007

 

Reshma

At OS level you can check for Oracle background process (SMON, PMON) are running or not using the Unix command (ps -ef)

Eg:
1) ps -ef |grep smon
2) ps -ef |grep pmon

You can check for your listener also like this

ps -ef |grep -i listener

Punithavel

 Profile Answers by Punithavel 

• Mar 3rd, 2009

 

1. Checking from O/S level

ps -ef | grep pmon

2. Checking through connectivity

sqlplus apps/apps

3. Checking the listener. (Listener can run even without DB startup) but without listener we cant connect to DB from outside of server.