OraFAQ Forum: Networking and Gateways » listener error

Home » RDBMS Server » Networking and Gateways » listener error (oracle 9i os ibm-aix 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

listener error [message #524346]

Fri, 23 September 2011 03:37

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...

Report message to a moderator

Re: listener error [message #524350 is a reply to message #524346]

Fri, 23 September 2011 03:50

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

env | grep NLS | sort

Regards
Michel

Report message to a moderator

Re: listener error [message #524351 is a reply to message #524346]

Fri, 23 September 2011 03:51

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: listener error [message #524352 is a reply to message #524351]

Fri, 23 September 2011 03:55

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

Report message to a moderator

Re: listener error [message #524354 is a reply to message #524352]

Fri, 23 September 2011 04:20

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

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)
)
)

Report message to a moderator

Re: listener error [message #524377 is a reply to message #524358]

Fri, 23 September 2011 06:12

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read again my previous post and repost indenting the lines.

Regards
Michel

Report message to a moderator

Re: listener error [message #524385 is a reply to message #524377]

Fri, 23 September 2011 06:56

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)

Report message to a moderator

Re: listener error [message #524404 is a reply to message #524385]

Fri, 23 September 2011 08:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

i could not understand what you are asking could you explain

Report message to a moderator

Re: listener error [message #524974 is a reply to message #524973]

Wed, 28 September 2011 03:00

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: listener error [message #524975 is a reply to message #524974]

Wed, 28 September 2011 03:08

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

Report message to a moderator

Re: listener error [message #524977 is a reply to message #524975]

Wed, 28 September 2011 03:21

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't you see the character in red in my post?

Regards
Michel

Report message to a moderator

Re: listener error [message #524984 is a reply to message #524977]

Wed, 28 September 2011 03:47

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]

Report message to a moderator

Re: listener error [message #524991 is a reply to message #524984]

Wed, 28 September 2011 04:07

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the command was?
Why do people post partial outputs without the commands that generate them?

Regards
Michel

Report message to a moderator

Re: listener error [message #524993 is a reply to message #524991]

Wed, 28 September 2011 04:12

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...

Report message to a moderator

Re: listener error [message #524997 is a reply to message #524993]

Wed, 28 September 2011 04:47

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

Check that.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:22:24 CST 2025