Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!feeder.news-service.com!feeder.news-service.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!transit3.news.xs4all.nl!post.news.xs4all.nl!not-for-mail From: "Shakespeare" Newsgroups: comp.databases.oracle.server References: Subject: Re: Enterprise manager is Not Connecting to database Date: Mon, 7 Jul 2008 10:45:15 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Original Lines: 145 Message-ID: <4871d7e7$0$14346$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: 82.95.215.210 X-Trace: 1215420391 news.xs4all.nl 14346 [::ffff:82.95.215.210]:49779 X-Complaints-To: abuse@xs4all.nl Xref: usenetserver.com comp.databases.oracle.server:446300 X-Received-Date: Mon, 07 Jul 2008 04:46:31 EDT (text.usenetserver.com) schreef in bericht news:b2961a9f-0a88-4b26-9cf7-a466f3bb484f@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