Home » RDBMS Server » Enterprise Manager » **Repository database connection disabled**%BR%ORA-12541: TNS:no listener (Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 - SPARC 2.8 64Bit)
**Repository database connection disabled**%BR%ORA-12541: TNS:no listener [message #537413] Wed, 28 December 2011 03:56 Go to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member
I upgraded from 92080 to 10201 and configured EM DB Control but I cannot log into the EM DB Control. I have tried to reconfigure using EMCA even though it completes successfully I still cannot connect. My database is a NON-RAC environment running on a Sun Cluster. The EM is configured on the primary node.

I get the error below when looking at RDA output.


**Repository database connection disabled**%BR%ORA-12541: TNS:no listener


Output if lsnrctl status is setup as follows



Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.31.86)(PORT=2500)))
Services Summary...
Service "billing-lh" has 1 instance(s).
Instance "KFXPR", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



listener.ora is below

LSNR_KFXPR =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host=billing-lh)(Port=2500))
)
SID_LIST_LSNR_KFXPR =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=billing-lh)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/KFXPR)
(SID_NAME = KFXPR)
)
)


here billing-lh is a logical name for the active cluster node but I just wanted to setup EM for a single physical/primary node.

Please assist some body.

Report message to a moderator

Re: **Repository database connection disabled**%BR%ORA-12541: TNS:no listener [message #537464 is a reply to message #537413] Wed, 28 December 2011 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>listener.ora is below

content is mal-formed & filled with error(s).
As a sanity test remove, rename, or delete listener.ora file then do as below

lsnrctl start

COPY command & results then PASTE all back here

Report message to a moderator

Re: **Repository database connection disabled**%BR%ORA-12541: TNS:no listener [message #537530 is a reply to message #537464] Thu, 29 December 2011 03:31 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member
The listener works fine in its current configuration ; an application connect to that service and also maintain that connection capability across cluster nodes. NOT RAC but Sun Clusters, the problem is getting EM to connect using that logical name to the same service.

Report message to a moderator

Re: **Repository database connection disabled**%BR%ORA-12541: TNS:no listener [message #537531 is a reply to message #537530] Thu, 29 December 2011 03:32 Go to previous message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member
Content is not malformed and there are no errors in the listener.ora file.

Report message to a moderator

Previous Topic: How to set a schedule to export data
Next Topic: Io exception: Unknown host specified
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 06:54:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.