Enterprise manager is Not Connecting to database
in [Oracle]
|
From: saurabh881 on 6 Jul 2008 15:42 Hi I installed oracle 10g on my system the installation was successfull but in the enterprise manager console 1.database instance is down 2.Listener is up and running 3.Agent Connection to Instance Status Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) starting the database with sysoper I m having following queries executed but EMC is not able to connect to the database SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 2 23:58:04 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> SQL> Connected to an idle instance. SQL> ORACLE instance started. Database mounted. Database opened. SQL> Disconnected from Oracle Database 10g Release 10.2.0.1.0 - Production starting the database with sysdba I m having following exception SQLException Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL10G))) I m able to work from windows commant prompt by using following commands Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. G:\oracle\product\10.2.0\db_2\BIN>emctl status dbconsole Environment variable ORACLE_SID not defined. Please define it. G:\oracle\product\10.2.0\db_2\BIN>set ORACLE_SID=ORCL10G G:\oracle\product\10.2.0\db_2\BIN>emctl status dbconsole Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. http://127.0.0.1:5500/em/console/aboutApplication Oracle Enterprise Manager 10g is running. ------------------------------------------------------------------ Logs are generated in directory g:\oracle\product \10.2.0\db_2/127.0.0.1_ORCL10G/ sysman/log G:\oracle\product\10.2.0\db_2\BIN>lsnrctl status LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02- APR-2008 23:36 :55 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) (PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ ction Start Date 02-APR-2008 23:17:44 Uptime 0 days 0 hr. 19 min. 11 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File g:\oracle\product\10.2.0\db_2\network\admin \listener.o ra Listener Log File g:\oracle\product\10.2.0\db_2\network\log \listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully G:\oracle\product\10.2.0\db_2\BIN>lsnrctl service LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02- APR-2008 23:37 :06 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) (PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER The command completed successfully G:\oracle\product\10.2.0\db_2\BIN>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 2 23:37:28 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn/as sysdba Connected. SQL> services started are OracleServiceORCL10G OracleOraDb10g_home2TNSListener OracleMTSRecoveryService OracleJobSchedulerORCL10G OracleDBConsoleORCL10G Please tell Me what is the problem
From: sybrandb on 6 Jul 2008 18:06 On Sun, 6 Jul 2008 12:42:42 -0700 (PDT), saurabh881(a)gmail.com wrote: > Please tell Me what is the problem Simple: you refuse to look up the error messages in the online documentation, expecting this forum is going to look them up and abstract them for you. All of your error messages are known issue, with info all over the Internet. -- Sybrand Bakker Senior Oracle DBA
From: Shakespeare on 7 Jul 2008 04:45 <saurabh881(a)gmail.com> schreef in bericht news:b2961a9f-0a88-4b26-9cf7-a466f3bb484f(a)z72g2000hsb.googlegroups.com... > Hi > > I installed oracle 10g on my system the installation was successfull > but in the enterprise manager console > > 1.database instance is down > 2.Listener is up and running > 3.Agent Connection to Instance > Status Failed > Details ORA-12505: TNS:listener does not currently know of SID > given in connect descriptor (DBD ERROR: OCIServerAttach) > > starting the database with sysoper I m having following queries > executed but EMC is not able to connect to the database > > SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 2 23:58:04 2008 > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > SQL> SQL> Connected to an idle instance. > SQL> ORACLE instance started. > Database mounted. > Database opened. > SQL> Disconnected from Oracle Database 10g Release 10.2.0.1.0 - > Production > > starting the database with sysdba I m having following exception > > SQLException > > Listener refused the connection with the following error: ORA-12514, > TNS:listener does not currently know of service requested in connect > descriptor The Connection descriptor used by the client was: > (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) > (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL10G))) > > > I m able to work from windows commant prompt by using following > commands > > Microsoft Windows XP [Version 5.1.2600] > (C) Copyright 1985-2001 Microsoft Corp. > > G:\oracle\product\10.2.0\db_2\BIN>emctl status dbconsole > Environment variable ORACLE_SID not defined. Please define it. > > G:\oracle\product\10.2.0\db_2\BIN>set ORACLE_SID=ORCL10G > > G:\oracle\product\10.2.0\db_2\BIN>emctl status dbconsole > Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 > Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. > http://127.0.0.1:5500/em/console/aboutApplication > Oracle Enterprise Manager 10g is running. > ------------------------------------------------------------------ > Logs are generated in directory g:\oracle\product > \10.2.0\db_2/127.0.0.1_ORCL10G/ > sysman/log > > > G:\oracle\product\10.2.0\db_2\BIN>lsnrctl status > > LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02- > APR-2008 23:36 > :55 > > Copyright (c) 1991, 2005, Oracle. All rights reserved. > > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) > (PORT=1521))) > STATUS of the LISTENER > ------------------------ > Alias LISTENER > Version TNSLSNR for 32-bit Windows: Version > 10.2.0.1.0 - Produ > ction > Start Date 02-APR-2008 23:17:44 > Uptime 0 days 0 hr. 19 min. 11 sec > Trace Level off > Security ON: Local OS Authentication > SNMP OFF > Listener Parameter File g:\oracle\product\10.2.0\db_2\network\admin > \listener.o > ra > Listener Log File g:\oracle\product\10.2.0\db_2\network\log > \listener.log > > Listening Endpoints Summary... > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) > Services Summary... > Service "PLSExtProc" has 1 instance(s). > Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this > service... > The command completed successfully > > G:\oracle\product\10.2.0\db_2\BIN>lsnrctl service > > LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 02- > APR-2008 23:37 > :06 > > Copyright (c) 1991, 2005, Oracle. All rights reserved. > > Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1) > (PORT=1521))) > Services Summary... > Service "PLSExtProc" has 1 instance(s). > Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this > service... > Handler(s): > "DEDICATED" established:0 refused:0 > LOCAL SERVER > The command completed successfully > > G:\oracle\product\10.2.0\db_2\BIN>sqlplus /nolog > > SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 2 23:37:28 2008 > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > SQL> conn/as sysdba > Connected. > SQL> > > > services started are > > OracleServiceORCL10G > OracleOraDb10g_home2TNSListener > OracleMTSRecoveryService > OracleJobSchedulerORCL10G > OracleDBConsoleORCL10G > > > > Please tell Me what is the problem You're problem is using 127.0.0.1 as the server ip address. Shakespeare
|
Pages: 1 Prev: Differences in BULK COLLECT between 9i and 10g? Next: ORA-01157 |