Home » RDBMS Server » Enterprise Manager » ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #266840] Tue, 11 September 2007 14:34 Go to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Hi Gurus

OS :Red Hat Enterprise Linux 4
Oracle : 10.2.0.1

I Installed OEM .And when I'm trying to connect to DB through URL
I get error message ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

My listener is also up..

Can somebody help me to troubleshoot this problem.

Regards

Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #266875 is a reply to message #266840] Tue, 11 September 2007 22:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This is the things that came more than 100 times in this forum. Search.
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #266943 is a reply to message #266840] Wed, 12 September 2007 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12541: TNS:no listener
 *Cause: The connection request could not be completed because the listener
 is not running.
 *Action: Ensure that the supplied destination address matches one of
 the addresses used by the listener - compare the TNSNAMES.ORA entry with
 the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
 go by way of an Interchange). Start the listener on the remote machine.

Regards
Michel
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267166 is a reply to message #266943] Wed, 12 September 2007 11:20 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Thanks for you replies

I read forums before putting my question into forum.
I dont know everything looks fine to me ,but still OEM is not starting.Can you see my listener.ora below ,if I did some mistakes.

SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.2.0.1/db_1)
      (PROGRAM = extproc)
     )
     (SID_DESC =
      (GLOBAL_DBNAME = MODVMXLA01)
      (SID_NAME = MODVMXLA01)
      (ORACLE_HOME = /home/oracle/product/10.2.0.1/db_1)
     )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.11)(PORT = 1521))
    )
  )

Tnsnames.ora
MODVMXLA01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.11)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = MODVMXLA01)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
MODVMXLA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.32)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MODVMXLA)
    )
  )



Thanks.
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267167 is a reply to message #267166] Wed, 12 September 2007 11:20 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
[oracle@localhost admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-SEP-2007 12:19:50

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                12-SEP-2007 11:59:30
Uptime                    0 days 0 hr. 20 min. 19 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Listener Log File         /home/oracle/product/10.2.0.1/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.11)(PORT=1521)))
Services Summary...
Service "MODVMXLA01" has 1 instance(s).
  Instance "MODVMXLA01", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[Updated on: Wed, 12 September 2007 11:23]

Report message to a moderator

Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267180 is a reply to message #267167] Wed, 12 September 2007 11:47 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Does this works?

sqlplus username/password@MODVMXLA
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267190 is a reply to message #267180] Wed, 12 September 2007 12:13 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
[oracle@localhost install]$ sqlplus vmxla_user/VMXLA@MODVMXLA

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 12 13:12:32 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267195 is a reply to message #267190] Wed, 12 September 2007 13:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
OEM again throwing the same error??

EMCTL STATUS???
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267203 is a reply to message #267195] Wed, 12 September 2007 13:18 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
[oracle@localhost install]$ emctl status dbconsole
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /home/oracle/product/10.2.0.1/db_1/localhost.localdomain_MODVMXLA01/sysman/log
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267204 is a reply to message #267203] Wed, 12 September 2007 13:20 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Database Instance: MODVMXLA01
	
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.	
Page Refreshed		Sep 12, 2007 2:18:53 PM		
	
Database Instance
	
	
Host		
localhost.localdomain
Port		
1521
SID		
MODVMXLA01
Oracle Home		
/home/oracle/product/10.2.0.1/db_1
	
	
Listener
	
Status		
Unavailable
Host		
Port		
Name		
Oracle Home		
Location		
Details		
	
	
Agent Connection to Instance
Status		
Failed
Details		ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
	

[Updated on: Wed, 12 September 2007 13:21]

Report message to a moderator

Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267205 is a reply to message #266840] Wed, 12 September 2007 13:20 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>localhost.localdomain_MODVMXLA01
above might make network communications a bit difficult
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267240 is a reply to message #267204] Wed, 12 September 2007 16:00 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Can changing this setting help me.localhost.localdomain_MODVMXLA01

and if so how can i change it....?

Thanks

Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267245 is a reply to message #267240] Wed, 12 September 2007 16:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Using vi editor.
Re: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) [message #267519 is a reply to message #267245] Thu, 13 September 2007 10:50 Go to previous message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Thanks everybody

The problem was solved by recreating listener using NETCA.

I think in listener configuration even spaces matter??

Regards

Previous Topic: problem while importing from a without data dump
Next Topic: OEM_REPOSITORY Tablespace
Goto Forum:
  


Current Time: Wed Dec 07 02:41:13 CST 2016

Total time taken to generate the page: 1.22970 seconds