Re: Enterprise manager is Not Connecting to database

<saurabh881_at_gmail.com> schreef in bericht news:b2961a9f-0a88-4b26-9cf7-a466f3bb484f_at_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 Received on Mon Jul 07 2008 - 03:45:15 CDT