Re: SERVICE_NAME and SID can't be resolved

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/20
Message-ID: <961532315.22214.0.pluto.d4ee154e@news.demon.nl>#1/1

The sid_list_listener section is missing from listener.ora An example follows
sid_list_listener_name=
  (sid_list=
   (sid_desc=

    (global_dbname=global_database_name)
    (sid_name=sid)
    (oracle_home=oracle_home)
    (prespawn_max=99)
    (prespawn_list=
      (prespawn_desc=
        (protocol=tcp)
        (pool_size=10)
        (timeout=2))
        (prespawn_desc=...))

  )

Everything below oracle-Home is not mandatory.

Hth,

Sybrand Bakker, Oracle DBA

"Frank" <wangfsh_at_cs.ucla.edu> wrote in message news:394FC6A3.CBD68961_at_cs.ucla.edu...
> My tnsnames.ora is as follows:

>

> #TNSNAMES.ORA Configuration
> # Generated by Oracle configuration tools.
> TESTORA_SERVICE_NAME.MyDomain =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = testora.MyDomain)
> )
> )

>
>

> My listener.ora is:

>

> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))
> )

>
>
>

> Sybrand Bakker wrote:

>


> > Which will be very difficult without looking at the actual contents of

> > listener.ora, tnsnames.ora and sqlnet.ora.

> > If you want a solution, you have to post them.
> > Generally speaking 12514 means your tnsnames.ora is incorrect, or
 doesn't
> > match the listener.ora.
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> > >

> Received on Tue Jun 20 2000 - 00:00:00 CDT