Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Listener syntax

Posted on 2004-10-09
7
Medium Priority
?
9,089 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 450 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
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

618 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