?
Solved

Listener syntax

Posted on 2004-10-09
7
Medium Priority
?
9,088 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

764 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