Re: Do I Have a LISTENER? How to start LISTENER? ERRORS: ORA-12224: no listener AND, ORA 12545 NO SERVICE NAME

Home -> Community -> Usenet -> c.d.o.misc -> Re: Do I Have a LISTENER? How to start LISTENER? ERRORS: ORA-12224: no listener AND, ORA 12545 NO SERVICE NAME

From: Matt nalepinski <matt.nalepinski_at_eds.com>
Date: 1 Apr 2002 08:55:10 -0800
Message-ID: <1bfdf1e9.0204010855.437253cd@posting.google.com>

Sybrand,

What does not match between my TNSNAMES.ORA and LISTENER.ORA?

PS: I seatched my hard drive for a listener program and there isn't one?

(no file that starts with 'lsnrctl*' or with 'lsnr*')

PS: Sorry - I did not mean to yell. I'm new to these usenet newsgroups.

Thanks,
Matt Nalepinski

# LISTENER.ORA Network Configuration File: C:\orant\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SAVE_CONFIG_ON_STOP_LISTENER = TRUE USE_PLUG_AND_PLAY_LISTENER = ON LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = w2tzf93101)(PORT = 1521)) (PROTOCOL_STACK =

      (PRESENTATION = GIOP)
      (SESSION = RAW)

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = c:\oradev)
      (SID_NAME = ORCL)

)
(SID_DESC =

      (GLOBAL_DBNAME = Oracle8)
      (SID_NAME = ORCL)

)
)

# TNSNAMES.ORA Network Configuration File: C:\orant\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

QREPDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = trstow01.capctr.globalsd.eds.com)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SID = qrepdev)
    )
  )

CCQDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = trstow01.capctr.globalsd.eds.com)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SID = ccqdev)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))     )
    (CONNECT_DATA =

      (SID = ORCL)
      (SERVER = DEDICATED)

)
)

####################################

# Date..........: Wed Mar 27 16:40:11 EST 2002

####################################

ORCL_127.0.0.1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))     )
    (CONNECT_DATA =

      (SID = ORCL)
      (SERVER = DEDICATED)

)
)

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<jl97au0cmcfq15fa5sng571k0qopm2hq4j_at_4ax.com>...
> 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 Mon Apr 01 2002 - 10:55:10 CST