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

What is probably meant by 'a search' is going to groups.google.com and searching for 'listener'.

Be sure to order the results by date, or you will most likely be looking at older posts first.

"Keld Nielsen" <keldnielsen_at_image.dk> wrote in message news:4eMo8.2003$567.139029_at_news000.worldonline.dk...
> 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 - 17:09:38 CST