| 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
|
|
|
|
| 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:
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
|
|
|
|
| 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
|
|
|
|
|
|
| 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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
