Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database started without PMON

Santosh KumarJul 10 2008 — edited Jul 11 2008
Hi,

Is it possible that database is started and PMON and SMON are not there.

*******************************************************************************************
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
UDRINT READ WRITE
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
UDRINT:/uu00/home/oracle/scr$ export ORACLE_SID=RCATAM
RCATAM:/uu00/home/oracle/scr$ sqlplus "/as sysdba"
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 24 03:04:35 2007
(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- ----------
RCATAM READ WRITE
SQL> !ps -ef |grep pmon
oracle 2821 2817 0 03:04:45 pts/0 0:00 grep pmon
SQL> !
RCATAM:/uu00/home/oracle/scr$ ps -ef |grep pmon
oracle 2922 2920 0 03:06:40 pts/0 0:00 grep pmon
RCATAM:/uu00/home/oracle/scr$ ps -ef |grep smon
root 1763 1 0 02:28:42 ? 0:00 /etc/opt/resmon/lbin/emsagent
root 2919 783 0 02:29:01 ? 0:00 /etc/opt/resmon/lbin/registrar
root 3358 1 0 02:29:16 ? 0:00 /etc/opt/resmon/lbin/p_client
oracle 2926 2920 1 03:06:45 pts/0 0:00 grep smon
*********************************************************************************************
What could be the reason there? Although I have restarted the database and now it's showing in right way.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2008
Added on Jul 10 2008
11 comments
1,434 views