Re: Using Service Names for database

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 19 Feb 2015 13:47:12 -0700
Message-Id: <4220D235-C131-4DFE-91B3-A7A6C6EBC33A_at_gmail.com>

Most places use service names for RAC and non-RAC. It has many uses related to workload separation. A common one is to distinguish between a primary and a standby open in read only or read only with apply. You don't need to change your tnsnames entry if you do a switch over.

Sent from my iPhone

> On Feb 19, 2015, at 1:28 PM, Steve Harville <steve.harville_at_gmail.com> wrote:
>
> Hi Jeff,
> It is a good practice, especially on RAC. We create services for each distinct workload. For instance the Warehouse Operations group use a service that is different from the Order Management group. This way we can "pin" one type of workload to it's own node and another type of workload to a different node. This reduces the interconnect traffic between nodes since the different services are not updating the same data blocks.
> Steve
>

>> On Thu Feb 19 2015 at 2:44:29 PM Jeff C <backseatdba_at_gmail.com> wrote:
>> Does anybody use or have experience with using multiple Service Names for your database? Is this a normal thing people do?  I have a database that is a mix of a bunch of different applications and I would like to better identify them from database connection and so giving them their own service name to connect to seems like the perfect fit.  One thing I did noticed that we will have to be careful about is if you restore that database to the same server with a different name and you don't change the service name parameter then the listener will pick up that service name and your users may be going to the restored database and not production.
>> Any other things to think about and/or is this a bad practice?
>> 
>> Thanks,
>> Jeff

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 19 2015 - 21:47:12 CET