Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issues with OEM configuration

user13010474Jan 16 2011 — edited Jan 17 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2011
Added on Jan 16 2011
11 comments
358 views