Re: TNS-12541 TNS:no listener

this is actually a no listener error, so after starting the listener
>lsnrctl start

run the command
netstat -ap tcp
this will show you all the ports that are listening for a connection you should see something like;

Proto    Local Address        Foreign Address        State
TCP    host:1521                host:0                         LISTENING

now check what "julian" actually resolve to....

Daniel...

"Julian K. Black" <julianb_at_bellsouth.net> wrote in message news:Kjlm8.140622$Nn6.6908516_at_e3500-atl2.usenetserver.com...
> Hello gang
>
> I am having a problem connecting to my oracle server thru clients
software.
> I am running the client and the server off the same machine. The OS is
> windows 2000 server
>
> My listener is up and running but I cannot seem to connect to my oracle
> server.
>
> Here is my listener.ora file:
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = julian)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\Oracle\Ora81)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = jkbdata)
> (ORACLE_HOME = C:\Oracle\Ora81)
> (SID_NAME = jkbdata)
> )
> )
>
> Here is my tnsmanes.ora file:
>
> JKBDATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = julian)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = jkbdata)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> The only thing I can think off is that I had uninstalled and reinstalled
> some database with different listeners. The old databases is not listed
in
> the Services window under 2000 but the old listeners are. The old
listeners
> are not running and the startup type is manual. Is there a file in the
bin
> directory I can modify to remove these old listeners from the service
list?
>
> Most importantly can anyone help me resolve this issue? Thanks.
>
>
>
Received on Thu Mar 21 2002 - 13:59:50 CST