Skip to Main Content

Enterprise Manager

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!

Drop DB control, error: Could not connect to SYS, ORA-12541

684566Feb 11 2009 — edited Feb 18 2009
Hi All,

I am new to Oracle. I am struggling to solve this problem for 2 days, but still couldn't get it done. I post my problem here and wish every guru in this forum to offer some help. Any suggestions are greatly appreciated.

I have Oracle 10.2.0.3.0 installed on GNU/Linux. There are several instances there. The database, listener, sql/plus all work fine. Yesterday, I installed 10g database control on server. The information showed that dbconsole created successfuly. However, I use the produced url (http:// xxx(hostname):1158/em)in my local machine (Win XP) to connect the databse, and the webpage opened. The information showed that EM couldn't be connected to database, and the status of Listener is unavailable, the inforamtion for agent connect.. is: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).

I googled lots of posts both in this forum and internet and tried to make some changes, but the things get worse. It still didn't work. Even i failed to drop the DB control with the command of emca -config dbcontrol db -repos recreate. the error log information in cfgtoollogs/emca is:

Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=svv.X.XXX.net)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL3))): ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).

I understand it's the problem related to listener, but i have no idea how to verify it. I put the tns.ora and listener.ora here.

tnsnames.ora:

xxxxx

ORCL3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.149.210)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL3)
)
)

listener.ora

LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.149.210)(PORT=1521)))

SID_LIST_LISTENER=

(SID_DESC=
(GLOBAL_DBNAME=ORCL2)
(SID_NAME=ORCL2)
(ORACLE_HOME=/opt/app/oracle/product/10.2)
)

(SID_DESC=
(GLOBAL_DBNAME=ORCL3)
(SID_NAME=ORCL3)
(ORACLE_HOME=/opt/app/oracle/product/10.2)
)
)

The above is the problem description, any suggestion and help are greatly appreciated.

Thanks,

Kind regards,

Ian
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2009
Added on Feb 11 2009
29 comments
4,156 views