Enterprise manager is Not Connecting to database
Date: Sun, 6 Jul 2008 12:42:42 -0700 (PDT)
Message-ID: <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: Version10.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 Received on Sun Jul 06 2008 - 14:42:42 CDT