Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: force dedicated connection in shared server environment
You should test this one, without the db_domain :
mydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host=orasun.mydomain.com)(Port= 1632))
(CONNECT_DATA = (SERVICE_NAME = FOOT)(SEVER=DEDICATED))
)
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
Received on Thu Jun 15 2006 - 07:01:33 CDT