Solved

Listener syntax

Posted on 2004-10-09
7
9,084 Views
Last Modified: 2012-06-21
What is wrong with this listener?
LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 09-OCT-2004 18:47:40
                                                                               
Copyright (c) 1991, 2004, Oracle.  All rights reserved.
                                                                               
Starting /usr/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...
                                                                               
TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /usr/u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
TNS-01150: The address of the specified listener name is incorrect
                                                                               
Listener failed to start. See the error message(s) above...

#LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0.1.0/net#work/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.40)(PORT = 1521))
      )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = PLSExtProc)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (PROGRAM = extproc)
      )
      (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
      )
  )
)                                                                                
~
                                                                               

0
Comment
Question by:xoxomos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
7 Comments
 
LVL 23

Accepted Solution

by:
seazodiac earned 150 total points
ID: 12268917
try to replace yours with this one:

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
     )
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.40)(PORT = 1521))
     )
   )
)
SID_LIST_LISTENER =
   (SID_LIST =
     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
       (PROGRAM = extproc)
     )
     (SID_DESC =
       (GLOBAL_DBNAME = owbnewrp)
       (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
       (SID_NAME = owbnewrp)
     )
 )
0
 

Author Comment

by:xoxomos
ID: 12269415
#LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0.1.0/net#work/a#min/listener.ora$
# Generated by Oracle configuration tools.$
LISTENER =$
  (DESCRIPTION_LIST =$
    (DESCRIPTION =$
      (ADDRESS_LIST =$
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))$
      )$
      (ADDRESS_LIST =$
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.40)(PORT = 1521))$
      )$
    )$
    SID_LIST_LISTENER =$
    (SID_LIST =$
      (SID_DESC =$
        (SID_NAME = PLSExtProc)$
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)$
        (PROGRAM = extproc)$
      )$
      (SID_DESC =$
        (GLOBAL_DBNAME = owbnewrp)$
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)$
      )
)                                                                                


TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /usr/u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
TNS-01150: The address of the specified listener name is incorrect
 
Listener failed to start. See the error message(s) above...


0
 

Author Comment

by:xoxomos
ID: 12269436
# listener.ora Network Configuration File: /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
                                                                               
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
    )
  )
                                                                               
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST =  darius)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )


I ran netca to get a new one.  This starts but is shows nothing for owbnewrp.
                                                                               
0
Technology Partners: 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!

 

Author Comment

by:xoxomos
ID: 12269447
This starts without error but does not show service for owbnewrp/

# listener.ora Network Configuration File: /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
                                                                               
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
    )
  )
                                                                               
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = darius)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
       (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
       )
                                                                               
    )
  )

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 10-OCT-2004 00:36:18
                                                                                     
Copyright (c) 1991, 2004, Oracle.  All rights reserved.
                                                                                     
Starting /usr/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...
                                                                                     
TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /usr/u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))(SID_DESC=(GLOBAL_DBNAME=owbnewrp)(ORACLE_HOME=/usr/u01/app/oracle/product/10.1.0/db_1)(SID_NAME=owbnewrp)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))(SID_DESC=(GLOBAL_DBNAME=owbnewrp)(ORACLE_HOME=/usr/u01/app/oracle/product/10.1.0/db_1)(SID_NAME=owbnewrp)))                                                                                      
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=darius)(PORT=1521))(SID_DESC=(GLOBAL_DBNAME=owbnewrp)(ORACLE_HOME=/usr/u01/app/oracle/product/10.1.0/db_1)(SID_NAME=owbnewrp)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date                10-OCT-2004 00:36:18
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File         /usr/u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))(SID_DESC=(GLOBAL_DBNAME=owbnewrp)(ORACLE_HOME=/usr/u01/app/oracle/product/10.1.0/db_1)(SID_NAME=owbnewrp)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))(SID_DESC=(GLOBAL_DBNAME=owbnewrp)(ORACLE_HOME=/usr/u01/app/oracle/product/10.1.0/db_1)(SID_NAME=owbnewrp)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



                                                                               
0
 

Author Comment

by:xoxomos
ID: 12269477
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
       )
     )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
       )
     )
# listener.ora Network Configuration File: /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
                                                                                         
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
       )
     )
 )
 # listener.ora Network Configuration File: /usr/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
This seems to be working


# Generated by Oracle configuration tools.
                                                                                         
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
       )
     )
 )
                                                                                       
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.40)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
                                                                                         
    )
  )
                                                                                         


0
 

Author Comment

by:xoxomos
ID: 12269480
This seems to be working


# Generated by Oracle configuration tools.
                                                                                         
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
     )
      (SID_DESC =
        (GLOBAL_DBNAME = owbnewrp)
        (ORACLE_HOME = /usr/u01/app/oracle/product/10.1.0/db_1)
        (SID_NAME = owbnewrp)
       )
     )
 )
                                                                                       
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.40)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
                                                                                         
    )
  )
                                                                                         


0
 

Author Comment

by:xoxomos
ID: 12269555
The redo from netca helps a lot!
Thanks
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question