Home » RDBMS Server » Networking and Gateways » lsnrctl status Gives TNS-01150 and NL-00303
lsnrctl status Gives TNS-01150 and NL-00303 [message #255124] Mon, 30 July 2007 12:58 Go to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Hey Experts

I am working on 10.2.0.1 AND RHEL enterprise Linux 4.
I want to install dataguard on two servers.
When I run lsnrctl status.

I am fighting with an error message TNS-01150 - THE ADDRESS OF THE SPECIFIED LISTENER IS INCORRECT.

[oracle@OHIO1_203 admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/netw

ork/admin/tnsnames.ora

# Generated by Oracle configuration tools.



OHIO1_203 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =10.100.100.53 )(PORT =1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME =OHIO1 )

)

)



OHIO1_204 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =10.100.100.51 )(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = OHIO1)

)

)







EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

###################################################################333

LISTENER =

(DESCRIPTION=

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.100.53)(PORT=1521))

)



SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU=8192)

(TDU=8192)

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(SDU=8192)

(TDU=8192)

(GLOBAL_DBNAME = OHIO1)

(SID_NAME =OHIO1)

(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

)

)



######################################################################

[oracle@OHIO1_203 admin]$ lsnrctl status



LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-JUL-2007 13:54:33



Copyright (c) 1991, 2005, Oracle. All rights reserved.



TNS-01150: The address of the specified listener name is incorrect

NL-00303: syntax error in NV string

###########################################################################333

[oracle@OHIO1_203 admin]$ echo $ORACLE_HOME

/home/oracle/product/10.2.0/db_1

[oracle@OHIO1_203 admin]$ echo $ORACLE_SID

OHIO1

##############################################################################3
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255125 is a reply to message #255124] Mon, 30 July 2007 13:07 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
01150, 00000, "The address of the specified listener name is incorrect"
// *Cause:  The address on which the listener attempted to listen contains a
// syntax error.
// *Action: For the listener name or service name specified to LSNRCTL, check
// that the address or connect descriptor is well-formed. You can find the
// listener name in LISTENER.ORA, or you can access the listener through
// the service name is TNSNAMES.ORA.

Who/what made the listener.ora file; which is where the problem exists?
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255126 is a reply to message #255125] Mon, 30 July 2007 13:15 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Actually due to some errors, I deleted the old listener.ora and reconfigured it ,with similar listener.ora from other server.

What Do you suggest me to do now ??

Thanks for your reply

[Updated on: Mon, 30 July 2007 13:16]

Report message to a moderator

Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255128 is a reply to message #255124] Mon, 30 July 2007 13:27 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
read & FOLLOW the contents of this URL: http://www.orafaq.com/forum/t/85036/74940/

use "code tags" & post a well formatted copy of your listener.ora file
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255132 is a reply to message #255124] Mon, 30 July 2007 13:45 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
[LISTENER =

(DESCRIPTION=

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.100.53)(PORT=1521))

)
SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU=8192)

(TDU=8192)

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(SDU=8192)

(TDU=8192)

(GLOBAL_DBNAME = OHIO1)

(SID_NAME =OHIO1)

(ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

)

)
]

[Updated on: Mon, 30 July 2007 13:55]

Report message to a moderator

Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255133 is a reply to message #255124] Mon, 30 July 2007 13:55 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
It seems you are challenged to read & follow directions.
Does yours look like mine?
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /a/oracle/product/10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
        (SID_NAME = dbx1 
        (ORACLE_HOME=/a/oracle/product/10.2.0)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbx1.example.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
INBOUND_CONNECT_TIMEOUT_LISTENER=600
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255137 is a reply to message #255133] Mon, 30 July 2007 14:06 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
I am trying to format it according to instructions in the file you forwarded me, but I'm not able to.Next time posting a new topic I will make sure about the "code tags"

Plz help me out this time with this code.
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255140 is a reply to message #255137] Mon, 30 July 2007 14:41 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
[oracle@OHIO1_203 admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/netw

ork/admin/tnsnames.ora

# Generated by Oracle configuration tools.



OHIO1_203 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST =10.100.100.53 )(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME =OHIO1 )

    )

  )



OHIO1_204 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST =10.100.100.51 )(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = OHIO1)

    )

  )







EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

###################################################################333

LISTENER =

   (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

    (ADDRESS_LIST=

       (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.100.53)(PORT=1521))

    )



 SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

    (SDU=8192)

    (TDU=8192)

    (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SDU=8192)

      (TDU=8192)

      (GLOBAL_DBNAME = OHIO1)

      (SID_NAME =OHIO1)

      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

    )

  )



######################################################################

[oracle@OHIO1_203 admin]$ lsnrctl status



LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-JUL-2007 13:54:33



Copyright (c) 1991, 2005, Oracle.  All rights reserved.



TNS-01150: The address of the specified listener name is incorrect

 NL-00303: syntax error in NV string

###########################################################################333

[oracle@OHIO1_203 admin]$ echo $ORACLE_HOME

/home/oracle/product/10.2.0/db_1

[oracle@OHIO1_203 admin]$ echo $ORACLE_SID

OHIO1

##############################################################################3
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255141 is a reply to message #255124] Mon, 30 July 2007 14:43 Go to previous messageGo to next message
babble
Messages: 25
Registered: July 2007
Location: new york
Junior Member
Hey Anacedent I tried it and was succesfull with the formatting

here is my listener.ora
 LISTENER =

   (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

    (ADDRESS_LIST=

       (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.100.53)(PORT=1521))

    )



 SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

    (SDU=8192)

    (TDU=8192)

    (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SDU=8192)

      (TDU=8192)

      (GLOBAL_DBNAME = OHIO1)

      (SID_NAME =OHIO1)

      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)

    )

  )
Re: lsnrctl status Gives TNS-01150 and NL-00303 [message #255143 is a reply to message #255141] Mon, 30 July 2007 15:15 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Try this coding

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 5521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SDU = 8192)
      (TDU = 8192)
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SDU = 8192)
      (TDU = 8192)
      (GLOBAL_DBNAME = MYDB.xyz.com)
      (ORACLE_HOME = /opt/oracle/10.2.0)
      (SID_NAME = MYDB)
    )
    (SID_DESC =
      (SDU = 8192)
      (TDU = 8192)
      (GLOBAL_DBNAME = OMZIMP14_MYDB)
      (ORACLE_HOME = /opt/oracle/10.2.0)
      (SID_NAME = MYDB)
    )

[Updated on: Mon, 30 July 2007 15:15]

Report message to a moderator

Previous Topic: FAILOVER_MODE causes ORA-01012 and ORA-24313
Next Topic: gateways error,help me~
Goto Forum:
  


Current Time: Sat Dec 03 09:44:32 CST 2016

Total time taken to generate the page: 0.04623 seconds