Re: DO I HAVE LISTENER? HOW TO START LISTENER? ERRORS: ORA-12224: no listener AND, ORA 12545 NO SERVICE NAME

On 28 Mar 2002 14:40:49 -0800, matt.nalepinski_at_eds.com (Matt nalepinski) wrote:

>I have 2 simple questions:
> - Do I have a listener?
> (executing lsnrctl at dos prompt says it does neot exist)
> - How (where) do you START THE LISTENER?
>
>I installed Oracle 8i client (in c:\orant), then the 8i Enterprise (in
>c:\oradev).
>
>
>Now the 1 complex question:
>
>
>I am getting the NO LISTENER ERROR.
>ORA-12154: TNS:could not resolve service name
>
>
>I have a listener.ora in c:\orant\network\admin\
> …but not in c:\oradev\net80\admin\
>
>
>
>I try to start SQL*PLUS, but get the NO LISTENER ERROR, using:
>
>USER NAME: scott
>PASSWORD: tiger
>HOST STRING: ORCL <--- ERROR: ORA-12154: TNS:could not resolve
>service name
>
>I also try to logon using:
>
>USER NAME: scott
>PASSWORD: tiger
>HOST STRING: w2tzf93101 <--- ERROR: ORA-12224: TNS:no listener
>
>I can logon to a remote oracle database with SQL*PLUS using:
>
>USER NAME: xxxx
>PASSWORD: yyyyy
>HOST STRING: qrepdev <--- CONNECTS TO A REMOTE SERVER DATABASE OK.
>
>
>
>1) The LISTENER.ORA in c:\orant\network\admin\ contains:
>
># LISTENER.ORA Network Configuration File:
>C:\orant\network\admin\listener.ora
># Generated by Oracle configuration tools.
>
>SAVE_CONFIG_ON_STOP_LISTENER = TRUE
>
>LISTENER1 =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = w2tzf93101)(PORT = 1521))
> )
> )
> )
>
>USE_PLUG_AND_PLAY_LISTENER = ON
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = w2tzf93101)(PORT = 1521))
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = Oracle8)
> (ORACLE_HOME = c:\oradev)
> (SID_NAME = ORCL)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = Oracle8)
> (SID_NAME = ORCL)
> )
> )
>
>
>
>
>
>2) The LISTENER.ORA in c:\oradev\net80\admin\ contains:
>
>Beq-local.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = beq.world)
> (PROTOCOL = BEQ)
> (PROGRAM = oracle73)
> (ARGV0 = oracle73ORCL)
> (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>Example1.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = Production1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = SID1)
> )
> )
>Example2.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = spx.world)
> (PROTOCOL = SPX)
> (Service = Server_lsnr)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>Example3.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = nmp.world)
> (PROTOCOL = NMP)
> (Server = FinanceServer1)
> (Pipe = ORAPIPE)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
>
>
>
>3) The TNSNAMES.ORA file in c:\orant\network\admin\ contains:
>
>####################################
># TNSNAMES.ORA Configuration File:C:\orant\NETWORK\ADMIN\tnsnames.ora
># Generated by Oracle Enterprise Manager V2
># Date..........: Wed Mar 27 16:40:11 EST 2002
>####################################
>
>QREPDEV =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST =
>trstow01.capctr.globalsd.eds.com)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = qrepdev))
> )
>
>ORCL_127.0.0.1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = ORCL)(SERVER = DEDICATED))
> )
>
>
>
>4) There is no TNSNAMES.ORA file in c:\oradev\net80\admin\

Your tnsnames.ora doesn't match any entry in the listener.ora How do you expect it will work?
Just use the net8 assistant to configure your listener and service name preferably *after* reading some installation instructions and you will be ok.

And oh yes: PLEASE DON'T SHOUT IN THIS FORUM

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 28 2002 - 17:29:02 CST