RE: non-RAC service names ?

  • From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
  • To: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 6 Dec 2010 16:52:31 -0500

Ah, yes- for DG....I forgot about that.

 

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

 

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: