Re: force dedicated connection in shared server environment

NetComrade wrote:
> All,
>
> I throught the <SID> option has been depreciated in 10g, yet that's
> what I had to use to get a dedicated connection into oracle
>
> e.g. this worked:
> mydb_d =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host=orasun.mydomain.com)(Port= 1632))
> (CONNECT_DATA = (SID = FOOT)(SEVER=DEDICATED))
> )
>
> this didn't
>
> mydb =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host=orasun.mydomain.com)(Port= 1632))
> (CONNECT_DATA = (SERVICE_NAME = FOOT.world)(SEVER=DEDICATED))
> )
>
> The latter worked fine since version 8i i think.. my db_domain is set
> to 'world'
>
> Did something change with config, that the service_name now needs to
> be something else?
>
> Thanks
>
>
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3
> remove NSPAM to email

This is the basic 10g syntax:

ORCL =
   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = PERRITO2)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcl)
     )

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org