Re: Is my Oracle instance still running?

From: Jim Cheng <jim_pku_at_yahoo.com>
Date: 24 Oct 2004 23:19:54 -0700
Message-ID: <6028007c.0410242219.5eb56341@posting.google.com>

>
> Who can tell? Try this instead:
>
> ps -ef | grep ora

This returns exactly the same result:

oracle   12176     1  0 Oct07 ?        00:12:08 /oracle/home/bin/tnslsnr LISTENE
oracle   12185     1  0 Oct07 ?        00:00:00 /bin/sh /oracle/home/bin/dbsnmpw
oracle   12188 12185  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12190 12188  0 Oct07 ?        00:00:25 /oracle/home/bin/dbsnmp
oracle   12191 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12195 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12196 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12197 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12198 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12199 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12200 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12201 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12202 12190  0 Oct07 ?        00:00:02 /oracle/home/bin/dbsnmp
oracle   12203 12190  0 Oct07 ?        00:01:00 /oracle/home/bin/dbsnmp
oracle   12204 12190  0 Oct07 ?        00:02:44 /oracle/home/bin/dbsnmp
oracle   12205 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12206 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12207 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   12212 12190  0 Oct07 ?        00:00:00 /oracle/home/bin/dbsnmp
oracle   25851 25839  0 Oct21 pts/1    00:00:00 zsh
root     19967 18318  0 23:14 pts/4    00:00:00 grep ora

>
> Is SMON there? PMON? the rest of the processes?
> Have you checked listener status? lsnrctl status
> Have you tried to log on as SYS on the box? / AS SYSDBA

---

Could you explain it in a bit more detail?

Thanks! Received on Mon Oct 25 2004 - 01:19:54 CDT