Solved

Listener syntax

Posted on 2004-10-09
7
9,081 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

732 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