Solaris - Problem with Oracle database

 
If you have Oracle database problems:

1. Login to the server and check database and listener running.

# ps -ef|grep pmon|grep -v grep ## Verify Oracle database process
# ps -ef|grep tnslsnr|grep -v grep ## Verify Oracle listener process


2. On Oracle Enterprise Manager Grid Control check and verify no target or database down.

3. On Oracle Enterprise Manager Grid Control, select tab Targets and verify the target is in good status.

Note the server shows status up   .

4. In Oracle Enterprise Manager Grid Control select tab Databases and verify the target is in good status:

Note the database status shows up   .