Home » Infrastructure » Unix » Connected to an idle instance (Unix and oracle)
Connected to an idle instance [message #356788] Sun, 02 November 2008 07:54 Go to next message
yanz_shi
Messages: 5
Registered: November 2008
Location: MALAYSIA
Junior Member

Hii all..

i got problem to connect to oracle in unix os...when i try to connect sys as sysdba,CONNECTED TO AND IDLE INSTANCE will appeard..anybody know to solve that..plzz help me...thanks
Re: Connected to an idle instance [message #356789 is a reply to message #356788] Sun, 02 November 2008 07:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It means either you have not set the proper ORACLE_SID
or
the instance referred by ORACLE_SID is down.
Re: Connected to an idle instance [message #356792 is a reply to message #356789] Sun, 02 November 2008 08:02 Go to previous messageGo to next message
yanz_shi
Messages: 5
Registered: November 2008
Location: MALAYSIA
Junior Member

hi Razz thanks for reply...but the problem still happen..
im try to change the tnsnames and listener,but is still happen..

here i show you my tnsnames:-

bash-3.00$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/InfoVista/oracle/product/10.2/ne
twork/admin/tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.233.225.134)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

IVDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.233.225.134)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = IVDB)
)
)


and this is my listener
# listener.ora Network Configuration File: /opt/InfoVista/oracle/product/10.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_IVDB =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/InfoVista/oracle/product/10.2)
(PROGRAM = extproc)
)
)

LISTENER_IVDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cbj-ip-iv-orcl01)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

Re: Connected to an idle instance [message #356795 is a reply to message #356792] Sun, 02 November 2008 08:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check your ORACLE_HOME too. You are sure the database is running (ie. ps -ef | grep ivdb ) ?

In this case, listener.ora & tnsnames.ora don't have an affect.
Re: Connected to an idle instance [message #356796 is a reply to message #356795] Sun, 02 November 2008 08:20 Go to previous messageGo to next message
yanz_shi
Messages: 5
Registered: November 2008
Location: MALAYSIA
Junior Member

i try to grep ivdb..this is the output
so,is it correct..i still face the same problem like connect to an idle instance..
bash-3.00$ ps -ef | grep IVDB
oracle 8115 1 0 14:27:57 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 1949 1 0 Oct 31 ? 0:12 ora_dbw2_IVDB
oracle 1957 1 0 Oct 31 ? 0:12 ora_dbw4_IVDB
oracle 13029 1 0 19:14:22 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 1934 1 0 Oct 31 ? 3:33 ora_pmon_IVDB
oracle 12992 1 0 19:13:14 ? 0:03 oracleIVDB (LOCAL=NO)
oracle 1936 1 0 Oct 31 ? 0:06 ora_psp0_IVDB
oracle 16435 1 0 21:45:48 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 16370 1 0 21:42:43 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 8117 1 0 14:27:57 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13065 1 0 19:14:25 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 8111 1 0 14:27:54 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 8113 1 0 14:27:54 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13053 1 0 19:14:24 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 1939 1 0 Oct 31 ? 0:07 ora_mman_IVDB
oracle 1959 1 0 Oct 31 ? 0:12 ora_dbw5_IVDB
oracle 1974 1 0 Oct 31 ? 1:53 ora_ckpt_IVDB
oracle 1954 1 0 Oct 31 ? 0:13 ora_dbw3_IVDB
oracle 1964 1 0 Oct 31 ? 0:12 ora_dbw6_IVDB
oracle 1946 1 0 Oct 31 ? 0:13 ora_dbw1_IVDB
oracle 1944 1 0 Oct 31 ? 0:17 ora_dbw0_IVDB
oracle 1967 1 0 Oct 31 ? 0:12 ora_dbw7_IVDB
oracle 1969 1 0 Oct 31 ? 1:17 ora_lgwr_IVDB
oracle 1979 1 0 Oct 31 ? 0:27 ora_smon_IVDB
oracle 1981 1 0 Oct 31 ? 0:01 ora_reco_IVDB
oracle 12998 1 0 19:13:14 ? 0:00 oracleIVDB (LOCAL=NO)
root 2005 1 0 Oct 31 ? 0:04 ora_dism_IVDB
oracle 8109 1 0 14:27:54 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 8105 1 0 14:27:54 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 8107 1 0 14:27:54 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 8103 1 0 14:27:54 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 16362 1 0 21:42:28 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13061 1 0 19:14:25 ? 0:02 oracleIVDB (LOCAL=NO)
oracle 13055 1 0 19:14:25 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 16372 1 0 21:42:43 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 16366 1 0 21:42:43 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 16390 1 0 21:42:58 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 12990 1 0 19:13:14 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 7799 1 0 14:03:59 ? 0:05 oracleIVDB (LOCAL=NO)
oracle 5294 1 0 13:03:58 ? 0:14 oracleIVDB (LOCAL=NO)
oracle 7180 1 0 14:00:32 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13021 1 0 19:14:21 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 7164 1 0 13:59:51 ? 0:08 oracleIVDB (LOCAL=NO)
oracle 13049 1 0 19:14:24 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 16364 1 0 21:42:43 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13041 1 0 19:14:23 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 16336 1 0 21:41:08 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 12994 1 0 19:13:14 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 13031 1 0 19:14:22 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 12966 1 0 19:12:49 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 12988 1 0 19:13:14 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 16380 1 0 21:42:50 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 13067 1 0 19:14:25 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 17064 16258 0 22:18:47 pts/17 0:00 grep IVDB
oracle 13063 1 0 19:14:25 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 13059 1 0 19:14:25 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13045 1 0 19:14:24 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 12974 1 0 19:12:54 ? 0:05 oracleIVDB (LOCAL=NO)
oracle 13023 1 0 19:14:22 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 17012 17011 0 22:12:44 ? 0:00 oracleIVDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 16437 1 0 21:45:51 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 13071 1 0 19:14:26 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 8101 1 0 14:27:54 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13035 1 0 19:14:23 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 16388 1 0 21:42:56 ? 0:01 oracleIVDB (LOCAL=NO)
oracle 16368 1 0 21:42:43 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 16376 1 0 21:42:48 ? 0:00 oracleIVDB (LOCAL=NO)
oracle 13025 1 0 19:14:22 ? 0:00 oracleIVDB (LOCAL=NO)
bash-3.00$
Re: Connected to an idle instance [message #356798 is a reply to message #356796] Sun, 02 November 2008 08:24 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It appears the the database is running.

What is the output of env | grep ORA.

You need to ensure your ORACLE_SID & ORACLE_HOME are set appropriately.
Re: Connected to an idle instance [message #356799 is a reply to message #356798] Sun, 02 November 2008 08:26 Go to previous messageGo to next message
yanz_shi
Messages: 5
Registered: November 2008
Location: MALAYSIA
Junior Member

the output is like this..so,u know what the problem?

bash-3.00$ env | grep ORA
ORACLE_SID=IVDB
ORACLE_HOME=/opt/InfoVista/oracle/product/10.2
Re: Connected to an idle instance [message #356800 is a reply to message #356799] Sun, 02 November 2008 08:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you know if the database was started with a different ORACLE_HOME ?

What is the output of ps -ef | grep tns ?
Re: Connected to an idle instance [message #356803 is a reply to message #356800] Sun, 02 November 2008 08:44 Go to previous messageGo to next message
yanz_shi
Messages: 5
Registered: November 2008
Location: MALAYSIA
Junior Member

ps -ef | grep tns the output is like this..
but,i still got the same problem.


bash-3.00$ ps -ef | grep tns
oracle 17054 1 0 22:17:30 ? 0:02 /opt/InfoVista/oracle/product/10.2/bin/tnslsnr LISTENER -inherit
oracle 17773 17680 0 22:42:04 pts/17 0:00 grep tns
Re: Connected to an idle instance [message #356809 is a reply to message #356803] Sun, 02 November 2008 10:07 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That's strange...maybe I'm totally missing something.

Can you connect to the database as:

sqlplus sys/<sys_password>@IVDB as sysdba

and then run the following:

SQL> oradebug setmypid
SQL> oradebug ipc
SQL> oradebug tracefile_name

Can you post the first 15-20 lines of the trace file that gets generated ?
Previous Topic: ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
Next Topic: help in AIX
Goto Forum:
  


Current Time: Tue Dec 06 00:25:34 CST 2016

Total time taken to generate the page: 0.13046 seconds