RE: Question about database and service name

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 05 Sep 2002 12:33:27 -0800
Message-ID: <F001.004C90C6.20020905123327@fatcity.com>

Couldn't this also be

 somealias_or_servicename1 eg mydb=

    (DESCRIPTION_LIST=

       (DESCRIPTION=
       (ADDRESS_LIST=
          (ADDRESS=(PROTOCOL=TCP)
          (HOST=dbserver.yourdomain.com_or_IPADDRESS)
          (PORT=1521_or_port_matching_in_listener.ora)
        )
     )

   (CONNECT_DATA= (SERVICE_NAME=servicename1)))  

> In the init.ora for the database:
> service_names = servicename1, servicename2, ...
>
> In the tnsnames.ora;
>
> servicename1=
> (DESCRIPTION_LIST=
> (DESCRIPTION=
> (ADDRESS_LIST=
> (ADDRESS=(PROTOCOL=TCP)
> (HOST=dbserver.yourdomain.com)
> (PORT=1521)
> )
> )
> (CONNECT_DATA= (SERVICE_NAME=servicename1)))
>
> HTH
>
> Jared
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Sep 05 2002 - 15:33:27 CDT