-
idle instance
Hi,
I have a database named TFAP01 in unix machine.
Please see the following
["/applications/home/tf01" ]>ps -ef | grep pmon
oracle 3108 1 0 2007 ? 01:30:41 ora_pmon_TFAP01
oracle 14517 1 0 2007 ? 00:59:48 ora_pmon_DBDOCR2
tf01 3294 3289 0 19:53 pts/10 00:00:00 grep pmon
["/applications/home/tf01" ]>echo $ORACLE_SID
TFAP01
["/applications/home/tf01" ]>sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.6.0 - Production on Wed May 14 19:54:14 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> select instance_name,status from v$instance;
select instance_name,status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL>
When i grep for the process it shows the database but while connecting it shows connected to idle instance.
pls help.
-
your ORACLE_HOME is probably set wrong
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
|