Home » RDBMS Server » Networking and Gateways » listener error (oracle 9i os ibm-aix 5.3)
listener error [message #524346] Fri, 23 September 2011 03:37 Go to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues please help me


LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist

Listener failed to start. See the error message(s) above...
Re: listener error [message #524350 is a reply to message #524346] Fri, 23 September 2011 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
env | grep NLS | sort

Regards
Michel
Re: listener error [message #524351 is a reply to message #524346] Fri, 23 September 2011 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also:
TNS-01155: Incorrectly specified SID_LIST_%s parameter in LISTENER.ORA
 *Cause:  SID_LIST_<listener_name> in LISTENER.ORA has an error in it.
 *Action: Be sure this parameter is specified as described in the
 Oracle9i Net Services Reference Guide. For example,
 SID_LIST_LISTENER = (SID_LIST=(SID_DESC=(SID_NAME=<sid>)(ORACLE_HOME=<oracle_home>)))

Regards
Michel
Re: listener error [message #524352 is a reply to message #524351] Fri, 23 September 2011 03:55 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
Re: listener error [message #524354 is a reply to message #524352] Fri, 23 September 2011 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And listener.ora content?

Please read How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Fri, 23 September 2011 04:21]

Report message to a moderator

Re: listener error [message #524358 is a reply to message #524354] Fri, 23 September 2011 04:28 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/network/admin/listener.ora
# Generated by Oracle configuration tools.


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.1.17.43)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product)
)
(SID_DESC =
(GLOBAL_DBNAME = HRUAT)
(ORACLE_HOME = /u01/app/oracle/product)
(SID_NAME = HRUAT)
)
(SID_DESC =
(GLOBAL_DBNAME = HRSTAGE)
(ORACLE_HOME = /u01/app/oracle/product)
(SID_NAME = HRSTAGE)
)
(SID_DESC =
(GLOBAL_DBNAME = HRDEMO)
(ORACLE_HOME = /u01/app/oracle/product)
(SID_NAME = HRDEMO)
)
(SID_DESC =
(GLOBAL_DBNAME = HC890DMO)
(ORACLE_HOME = /u01/app/oracle/product)
(SID_NAME = HC890DMO)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME - /u01/app/oracle/product)
(SID_NAME = TEST)
)
)
Re: listener error [message #524377 is a reply to message #524358] Fri, 23 September 2011 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read again my previous post and repost indenting the lines.

Regards
Michel
Re: listener error [message #524385 is a reply to message #524377] Fri, 23 September 2011 06:56 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/network/admin/listener.ora
# Generated by Oracle configuration tools.

      LISTENER =
       (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 172.1.17.43)(PORT = 1521))
)
)
)
        SID_LIST_LISTENER =
         (SID_LIST =
          (SID_DESC =
            (SID_NAME = PLSExtProc)
              (ORACLE_HOME = /u01/app/oracle/product)
          )
        (SID_DESC =
         (GLOBAL_DBNAME = HRUAT)
            (ORACLE_HOME = /u01/app/oracle/product)
              (SID_NAME = HRUAT)
           )
        (SID_DESC =
         (GLOBAL_DBNAME = HRSTAGE)
           (ORACLE_HOME = /u01/app/oracle/product)
            (SID_NAME = HRSTAGE)
           )
         (SID_DESC =
          (GLOBAL_DBNAME = HRDEMO)
            (ORACLE_HOME = /u01/app/oracle/product)
              (SID_NAME = HRDEMO)
           )
          (SID_DESC =
           (GLOBAL_DBNAME = HC890DMO)
             (ORACLE_HOME = /u01/app/oracle/product)
              (SID_NAME = HC890DMO)
           )
          (SID_DESC =
            (GLOBAL_DBNAME = TEST)
              (ORACLE_HOME - /u01/app/oracle/product)
                  (SID_NAME = TEST)
Re: listener error [message #524404 is a reply to message #524385] Fri, 23 September 2011 08:50 Go to previous messageGo to next message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
>(ORACLE_HOME - /u01/app/oracle/product)
above does not look like the others in this file.
Why is it different?

[Updated on: Fri, 23 September 2011 08:51]

Report message to a moderator

Re: listener error [message #524973 is a reply to message #524404] Wed, 28 September 2011 02:54 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
i could not understand what you are asking could you explain
Re: listener error [message #524974 is a reply to message #524973] Wed, 28 September 2011 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
She is not (actually) asking anything, she just pointed you to the syntax error:
(ORACLE_HOME - /u01/app/oracle/product)

Regards
Michel
Re: listener error [message #524975 is a reply to message #524974] Wed, 28 September 2011 03:08 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
what syntax error i am not able to find please help me to find the syntax error
Re: listener error [message #524977 is a reply to message #524975] Wed, 28 September 2011 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't you see the character in red in my post?

Regards
Michel
Re: listener error [message #524984 is a reply to message #524977] Wed, 28 September 2011 03:47 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member

After Changing the equal sign i lsnrctl start error is thrown



LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.1.17.43)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused[/code]
Re: listener error [message #524991 is a reply to message #524984] Wed, 28 September 2011 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the command was?
Why do people post partial outputs without the commands that generate them?

Regards
Michel
Re: listener error [message #524993 is a reply to message #524991] Wed, 28 September 2011 04:12 Go to previous messageGo to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
[/u01/app/oracle/product/network/admin]lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 28-SEP-2011 15:42:07

Copyright (c) 1991, 2006, Oracle Corporation.  All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
 NL-00303: syntax error in NV string

Listener failed to start. See the error message(s) above...

Re: listener error [message #524997 is a reply to message #524993] Wed, 28 September 2011 04:47 Go to previous message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

Check that.

Regards
Michel
Previous Topic: FRM-92102: A network error has occurred. The Forms Client has attempted to reestablish its connect
Next Topic: Maintaining a single listener in a multi-instance dB server w/ 3 different Oracle home
Goto Forum:
  


Current Time: Fri Sep 19 13:52:11 CDT 2014

Total time taken to generate the page: 0.06711 seconds