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.