RE: non-RAC service names ?

  • From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
  • To: "'CRISLER, JON A (ATTCORP)'" <JC1706@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 6 Dec 2010 15:51:20 -0600

No, we used it in the primary and physical standby dataguard servers (albeit no 
broker), no problems at all.

From: CRISLER, JON A (ATTCORP) [mailto:JC1706@xxxxxxx]
Sent: Monday, December 06, 2010 3:49 PM
To: Newman, Christopher; oracle-l@xxxxxxxxxxxxx
Subject: RE: non-RAC service names ?

Did it give you any headaches or bad behavior ?  Any downside ?

From: Newman, Christopher [mailto:cjnewman@xxxxxxxxxxxxx]
Sent: Monday, December 06, 2010 4:48 PM
To: CRISLER, JON A (ATTCORP); oracle-l@xxxxxxxxxxxxx
Subject: RE: non-RAC service names ?

We've done this before, it's just service_names=X, Y, Z in the init.  They will 
dynamically register and you can test by connecting to each.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of CRISLER, JON A (ATTCORP)
Sent: Monday, December 06, 2010 3:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: non-RAC service names ?

Can additional service names be defined for a non-RAC 10g database, similar to 
how multiple service names can be configured for RAC ?  This would be to 
support JDBC connections, so a tnsnames alias would not work.   I have looked 
over various docs and I do not see any way of creating them- and I tried DBCA 
as well as that allows managing service names on a RAC db, but that option is 
disabled for a non-RAC db.

Other related posts: