?
Solved

Listener syntax

Posted on 2004-10-09
7
Medium Priority
?
9,092 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
  • 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

850 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