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

I believe you will find what your looking for, if you do a search -

the issue has been discussed quite a lot during the past week or two (been of great help to me so thanks to those of you who contributed !)

<matt.nalepinski_at_nospam.com> wrote in message news:a801bk$v1v$1_at_news.netmar.com...
>
>
> I have 1 simple question - How (where) do you START THE LISTENER?
>
> And 1 comlex question:
>
> I am getting the NO LISTENER ERROR.
> ORA-12154: TNS:could not resolve service name
> I installed Oracle 8i client (in c:\orant),
> then the 8i Enterprise (in c:\oradev)
>
> I have a listener.ora in c:\orant\network\admin\
> .but not in c:\oradev\net80\admin\
>
> Should
>
> 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\
>
>
>
>
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse_at_newsone.net Received on Thu Mar 28 2002 - 15:50:27 CST