OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Listener Not Working

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

Listener Not Working [message #16158]

Fri, 12 November 2004 06:59

Tom
Messages: 67
Registered: June 1998

Member

I have 9.2 running on my Dell Laptop. SqlPlus works OK unless I place the Host string "GeoBase" into, i.e., If I leave it blank I can get into SqlPlus. However, if I try and use lsnrctl from the command prompt or if I try and connect�to OEM I get the No Listener error. So, the services are running but some components cannot see the listener.�Are there some configuration parameters I need to set?

GDN = geobase.GriffithLaptop

SID = geobase

Host = GriffithLaptop or localhost

�

Thanks

�

�

Report message to a moderator

Re: Listener Not Working [message #16160 is a reply to message #16158]

Fri, 12 November 2004 07:42

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Assuming you are using local naming (you are using tnsnames) locate your sqlnet.ora and tnsnames.ora files. Typically NAMES.DEFAULT_DOMAIN = world or in your case may be something like GriffithLaptop.

You should have an entry in tnsnames.ora something like:

Code: [Select all] [Show/ hide]

geobase.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = geobase)
    )
  )

From DOS, try to see if the tnsnames.ora can resolve your service name.
tnsping geobase
tnsping geobase.world
tnsping geobase.griffithlaptop

Report message to a moderator

Re: Listener Not Working [message #16161 is a reply to message #16160]

Fri, 12 November 2004 09:06

Tom
Messages: 67
Registered: June 1998

Member

Thanks for the advise. I'm still getting TNS-12541: TNS: no listener

tnsnames.ora has....
GEOBASE.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = geobase)
)
)

sqlnet.ora has.....
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

NAMES.DEFAULT_DOMAIN = WORLD

listener.ora has....
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = GriffithLaptop)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = geobase)
(ORACLE_HOME = C:oracle)
(SID_NAME = geobase)
)
)

Any ideas will be appreciates

Report message to a moderator

Re: Listener Not Working [message #16164 is a reply to message #16161]

Fri, 12 November 2004 09:38

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Try starting the listener manually:
DOS> lsnrctl start

Status:
lsnrctl stat

Services (databases):
lsnrctl services

Stop:
lsnrctl stop

Report message to a moderator

Re: Listener Not Working [message #16165 is a reply to message #16164]

Fri, 12 November 2004 09:50

Tom
Messages: 67
Registered: June 1998

Member

Thanks again Andrew for your concern.
I can get to the LSNRCTL prompt. But any command I issue generally gives the following error

TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bi8t Windows Error: 61: Unkown error

Again, I can get into SqlPlus...

Report message to a moderator

Previous Topic:	How to turn on Tracing? nmi.log
Next Topic:	Net8 assistant and net8 configuration assitant not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 22:43:47 CDT 2025