Re: Force users to use Active DG for reporting
- From: Ricard Martinez <ricard.martinez@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Tue, 1 Apr 2014 09:46:37 +0100
Thanks for all the ideas.
Im afraid the main problem we have is how to prevent them from using RW for
all work. They use MS Access odbc (ye...i know) to connect to the
databases, so they just connect to the RW and run their updates and reports
for it. Without using a web/app-tier (as they should and we are trying to
force) its difficult that service or load balancing help us on that. Anyway
thanks again for all the ideas.
On Mon, Mar 31, 2014 at 11:25 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
> Yup, and you can set up a service like this:
>
> srvctl add service -d dbname -s service_name -r instname -l
> PHYSICAL_STANDBY
>
> to create a service that is only running when the role is physical standby.
>
>
> On Mon, Mar 31, 2014 at 5:21 PM, Karth Panchan <keyantech@xxxxxxxxx>wrote:
>
>> If I am not wrong, Active Data Guard enables read-only access to Primary
>> standby from Oracle 11g.
>>
>> This will enable to run for Reporting.
>>
>> Karth
>>
>>
>> Sent from my IPhone
>>
>> > On Mar 31, 2014, at 11:55 AM, Ricard Martinez <
>> ricard.martinez@xxxxxxxxx> wrote:
>> >
>> > Hi list,
>> >
>> > We got an environment formed by one standalone 11g database (lets call
>> it RW) with an active dataguard on another server (lets call it RO)
>> > We have provided to the users 2 tnsnames, one pointing to RW and the
>> other to the RO, and we have told them to use the first one for DML, etc
>> and the RO only for runing the reporting statments.
>> >
>> > As good users, they just ignore us and run all on the RW database, so
>> we want to force them to use the RO for reporting.
>> > Meanwhile they got the 2 tnsnames entries, i see no real options to
>> force them to use the RW, unless we separate the schema in two (one with
>> insert/update, the other only with select), and we kill any session of the
>> select schema on the RO (using a cron maybe, forcing them to use RW to be
>> able to end their reports)
>> >
>> > Has any of you found in a similar situation, or can think in other
>> options?
>> >
>> > Thanks
>> >
>> >
>> >
>> >
>> >
>> >
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
Other related posts:
