Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> force dedicated connection in shared server environment

force dedicated connection in shared server environment

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 14 Jun 2006 18:58:04 -0400
Message-ID: <bt41929jhhrh9mqu5t08dtbn2se97bldug@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US