• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 29331
  • Last Modified:

Cant start listener, TNS-01151: Missing listener name, oem, in LISTENER.ORA

Hi Experts.

I have a problem with a 9i database on win2k svr , I cant start the listener for OEM

LSNRCTL> start oem
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 9.2.0.2.0 - Production
System parameter file is D:\oracle\ora92\network\admin\listener.ora
Log messages written to D:\oracle\ora92\network\log\oem.log
TNS-01151: Missing listener name, oem, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

As I read this error lsnrctl cant find an entry in listener.ora for OEM, I dont understand this since there is an entry for the OEM.

Problem startet after I shut down OEM and made a cold backup (simple file copy).
Oem service is running and on the server I can:
Set oracle_sid=oem
sqlplus /nolog
connect /as sysdba;
... and now i can select from whatever tables i like.

On my own labtop:
SQL> conn system/*mypwd*@oem;
ERROR:
ORA-12541: TNS:No listener.


My Listener.ora

# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = oem)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = oem)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = XLA)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = XLA)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = RMAN)
      (ORACLE_HOME = D:\oracle\ora92)
      (SID_NAME = RMAN)
    )
  )


Any ideas to get the listener up running again ?
0
dk_akj
Asked:
dk_akj
  • 5
  • 2
  • 2
  • +3
4 Solutions
 
Ivo StoykovCommented:
Hello dk_akj,

Use net configuration assistant to create a new one or to reconfigure existing one...

HTH

I
0
 
dk_akjAuthor Commented:
When using the "Net conf. assistant" I can only select one listener to reconfigure and that is "Listener"

Kind regards
Anders
0
 
vishal68Commented:
As per your listener.ora, the name of your listener is listener and not oem. Oem is the SID for your database, It might also be the connect string defined in the tnsnames.ora To start your listener use the following command

lsnrctl start

afte this try to connect to your database. If you still face problems, post your tnsnames.ora file and the error.

HTH
Vishal
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Ivo StoykovCommented:
Hi dk_akj,

Listener Configuration -> Add -> type your listener name (replacing suggested LISTENER name), choose protocol from list, choose port (if you have already one listener choose different port!), next, etc...

regards

I
0
 
dk_akjAuthor Commented:
Vishal,

The XLA instance on the server is running and I can connect to that one from both server and clients.

"lsnrctl start":
Starting tnslsnr: please wait...

Service OracleOraHome92TNSListener already running.
TNS-12536: TNS:operation would block
 TNS-12560: TNS:protocol adapter error
  TNS-00506: Operation would block
   32-bit Windows Error: 997: Unknown error


From my laptop:
tnsping oem

used file:
\\01DB02\TNS_ADM\sqlnet.ora

Used TNSNAMES adaptor to translate alias.
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp
.world) (PROTOCOL = TCP) (Host = XXX.XXX.X19.52) (Port = 1521)) (ADDRESS = (COMM
UNITY = tcp.world) (PROTOCOL = TCP) (Host = XXX.XXX.X19.52) (Port = 1526))) (CON
NECT_DATA = (SID = ORCL)))
OK (50 msec)

From TNSNAMES.ORA:
oem.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = XXX.XXX.X19.52)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = XXX.XXX.X19.52)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )



Kind regards
Anders
0
 
vishal68Commented:
The error means your listener is already running. Tnsping also confirms that you have a listener running at the address pointed by tnsnames.ora file. The problem that I can see here is that in tnsnames.ora SID is written as ORCL, while your post as well as the listener.ora the SID is oem. Try the following, in the tnsnames.ora file change the line
from
 (CONNECT_DATA = (SID = ORCL)
to
 (CONNECT_DATA = (SID = OEM)

Then try the connection. If it still does not work, post the exact error and output of following command

lsnrctl services

HTH
Vishal
0
 
ravindran_eeeCommented:
Stop the Oracle Listener service..
Then type "LSNRCTL Start" from command prompt.. Please check if this command gives any error..
If so then please post the same..
0
 
dk_akjAuthor Commented:
Vishal,

You made my day :-)

Changed to OEM from ORCL and now I can connect.

Now I'm just wondering how this can happen.....

Thank you all very much for your help.
Kind regards
Anders
0
 
schwertnerCommented:
Hm, I think OEM on 9i do not uses his own Listener.
It uses the instance Listener.
So you have to ensure that you can connect to the Instance using SQL*Plus.

After that use the tnsnames with the particular entry for this instance and invoke OEM 9i,
add the database to the tree and work.
0
 
dk_akjAuthor Commented:
schwertner, I can connect from sqlplus but not from OEM (client)...

Working on solving that now.

Kind regards
Anders
0
 
dk_akjAuthor Commented:
Ahh, OMS was not startet...
"oemctl start oms" and it worked :-)

Kind regards
Anders
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 5
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now