Issues with OEM configuration
Hi All, I am facing issues after I configured Enterprise Manager. I am using OVM on Win 7 and network netting for OVM is NAT.
Basically I am facing 2 issues after configuring OEM. After I start the OEM using "emca start dbconsole" command
1) When I issue "LSNTCTL STATUS" it displays the status after few minutes instead of instant response. And also When I open my SQL Developer and try to connect to my db it does not connect and timeout's (Socket Read Timed out - Vendor code 504)
2) When I put the address in the URL it takes about 10-15 mins and the OEM page shows the below info instead of showing the login screen.
Database Instance: orcl.localdomain
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
Page Refreshed Jan 16, 2011 6:11:30 PM EST
Database Instance
Status Open
Host localhost.localdomain
Port 1521
SID orcl
Oracle Home /u01/app/oracle/product/11.2.0/dbhome_1
Details The instance is open.
Listener Status - Unavailable
Agent Connection to Instance Status
Succeeded
Output of the TNSPING and LSNRCTL.
----------------------------------------------------
[oracle@localhost log]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2011 18:42:16
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.localdomain)))
TNS-12547: TNS:lost contact
[oracle@localhost log]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-JAN-2011 18:38:23
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 16-JAN-2011 17:44:50
Uptime 0 days 0 hr. 54 min. 56 sec
Trace Level user
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listener Trace File /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/ora_2227_46938601169696.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "orcl.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.localdomain" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
I have dropped and recreated the OEM respository but am still facing the same issue. When I stop the dbcontrol then issues with sql developer, tnsping and lsnrctl.... works very fine. Am not sure whats wrong, please advise.