Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> force dedicated connection in shared server environment
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 Wed Jun 14 2006 - 17:58:04 CDT