Home » RDBMS Server » Networking and Gateways » Listener wouldn't start though correctly defined in LISTENER.ORA (Oracle Apps 11.5.10.2, DB 9.2.0.6 on Solaris 10)
icon4.gif  Listener wouldn't start though correctly defined in LISTENER.ORA [message #389983] Wed, 04 March 2009 07:33 Go to next message
_X_S_
Messages: 10
Registered: March 2009
Junior Member
Hi Oracle Experts,

Urgent help needed on a weird issue!! I am trying to up the database starting with the listeners. Unfortunately, the error below is being displayed despite listener.ora appearing to be correct:

Quote:

/external1/oracle/testdb/9.2.0/network/admin /TEST_test:appltest:aaovis#lsnrctl start TEST

LSNRCTL for Solaris: Version 8.0.6.3.0 - Production on 04-MAR-2009 18:16:52

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Starting /external1/oracle/testora/8.0.6/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.0.6.3.0 - Production
Log messages written to /external1/oracle/testora/8.0.6/network/log/test.log
TNS-01151: Missing listener name, TEST, in LISTENER.ORA



/external1/oracle/testdb/9.2.0/network/admin/TEST_test:appltest:aaovis#more lis
tener.ora

TEST =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCTEST))
        (ADDRESS= (PROTOCOL= TCP)(Host= test.hcm.gov.na )(Port= 1521))
  )

SID_LIST_TEST =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= /external1/oracle/testdb/9.2.0)
      (SID_NAME = TEST)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /external1/oracle/testdb/9.2.0)
      (PROGRAM = extproc)
    )
  )

STARTUP_WAIT_TIME_TEST = 0
CONNECT_TIMEOUT_TEST = 10
TRACE_LEVEL_TEST = OFF

LOG_DIRECTORY_TEST = /external1/oracle/testdb/9.2.0/network/admin
LOG_FILE_TEST = TEST
TRACE_DIRECTORY_TEST = /external1/oracle/testdb/9.2.0/network/admin
TRACE_FILE_TEST = TEST
ADMIN_RESTRICTIONS_TEST = OFF


IFILE=/external1/oracle/testdb/9.2.0/network/admin/TEST_test/listener_ifile.ora
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #389990 is a reply to message #389983] Wed, 04 March 2009 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check /external1/oracle/testora/8.0.6/network/log/test.log
TNS_ADMIN set?

Regards
Michel


Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #389993 is a reply to message #389990] Wed, 04 March 2009 08:08 Go to previous messageGo to next message
_X_S_
Messages: 10
Registered: March 2009
Junior Member
Quote:

Check /external1/oracle/testora/8.0.6/network/log/test.log
TNS_ADMIN set?

Regards
Michel



TNSLSNR for Solaris: Version 8.0.6.3.0 - Production on 04-MAR-2009 18:16:55

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Log messages written to /external1/oracle/testora/8.0.6/network/log/test.log

TNS-01151: Missing listener name, TEST, in LISTENER.ORA
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #389994 is a reply to message #389993] Wed, 04 March 2009 08:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Repeating what you posted is not answering my questions.

Regards
Michel
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #389999 is a reply to message #389994] Wed, 04 March 2009 08:59 Go to previous messageGo to next message
_X_S_
Messages: 10
Registered: March 2009
Junior Member
Hi Michel,

Thanks for your input. The quote from the previous post was, as requested, from /external1/oracle/testora/8.0.6/network/log/test.log. Sorry for having been unclear.

I am new to admin tasks actually. Can you kindly advise where to set TNS_ADMIN?

Cheers,
Pravish
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390001 is a reply to message #389983] Wed, 04 March 2009 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Listener wouldn't start though correctly defined in LISTENER.ORA
If this were really true, then no error would be generated.
You should reset the assumption.
When did this last work?
What changed?

[Updated on: Wed, 04 March 2009 09:04]

Report message to a moderator

Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390003 is a reply to message #389999] Wed, 04 March 2009 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your listener.ora is NOT in the default directory so you have to precise in which directory Oracle has to find it:
export TNS_ADMIN=/external1/oracle/testdb/9.2.0/network/admin/TEST_test
then
lsnrctl start TEST

Regards
Michel

[Updated on: Wed, 04 March 2009 09:07]

Report message to a moderator

Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390006 is a reply to message #389983] Wed, 04 March 2009 09:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>LSNRCTL for Solaris: Version 8.0.6.3.0 - Production on 04-MAR-2009 18:16:52

how/where did V8.0.6 get involved with V9.2 DB?
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390177 is a reply to message #390003] Thu, 05 March 2009 06:09 Go to previous messageGo to next message
_X_S_
Messages: 10
Registered: March 2009
Junior Member
Thanks for the useful input.

The path was specified before starting the listener and, apparently, it completed successfully as can be seen below:
/external1/oracle/testdb/9.2.0/network/admin/TEST_test:appltest:aaovis#lsnrctl
start TEST

LSNRCTL for Solaris: Version 8.0.6.3.0 - Production on 05-MAR-2009 16:48:22

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Starting /external1/oracle/testora/8.0.6/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.0.6.3.0 - Production
System parameter file is /external1/oracle/testdb/9.2.0/network/admin/TEST_test/
listener.ora
Log messages written to /external1/oracle/testdb/9.2.0/network/admin/test.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=8)(KEY=EXTPROCTEST))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=192.168.1.225)(PORT=1572))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
STATUS of the LISTENER
------------------------
Alias                     TEST
Version                   TNSLSNR for Solaris: Version 8.0.6.3.0 - Production
Start Date                05-MAR-2009 16:48:36
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /external1/oracle/testdb/9.2.0/network/admin/TEST_test
/listener.ora
Listener Log File         /external1/oracle/testdb/9.2.0/network/admin/test.log
Services Summary...
  PLSExtProc            has 1 service handler(s)
  TEST          has 1 service handler(s)
The command completed successfully


BUT checking the status, it appears that it does not work.

/external1/oracle/testdb/9.2.0/network/admin/TEST_test:appltest:aaovis#lsnrctl
status

LSNRCTL for Solaris: Version 8.0.6.3.0 - Production on 05-MAR-2009 17:01:09

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
TNS-12224: TNS:no listener
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    Solaris Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=aaovis))
TNS-12618: TNS:versions are incompatible
/external1/oracle/testdb/9.2.0/network/admin/TEST_test:appltest:aaovis#


Can you please advise accordingly?
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390179 is a reply to message #390177] Thu, 05 March 2009 06:15 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Try

Lsnrctl Status Test
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390184 is a reply to message #390179] Thu, 05 March 2009 06:31 Go to previous messageGo to next message
_X_S_
Messages: 10
Registered: March 2009
Junior Member
Shows it as up. But still cannot up the DB Sad
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390188 is a reply to message #390184] Thu, 05 March 2009 06:45 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>But still cannot up the DB

I think we are discussion about listener only not your database.

Actually what's the problem? Post your alert log.

Babu
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390196 is a reply to message #390184] Thu, 05 March 2009 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
_X_S_ wrote on Thu, 05 March 2009 13:31
Shows it as up. But still cannot up the DB Sad

This is a different question, create a new topic and you have to show us what you did.

Regards
Michel
Re: Listener wouldn't start though correctly defined in LISTENER.ORA [message #390201 is a reply to message #389983] Thu, 05 March 2009 07:37 Go to previous message
_X_S_
Messages: 10
Registered: March 2009
Junior Member
Yes will do so. Thanks so much again for your help Smile
Previous Topic: TNS-12547: TNS:lost contact when using Microsoft loopback adapter
Next Topic: Listener service on Windows
Goto Forum:
  


Current Time: Mon Mar 18 21:08:01 CDT 2024