Re: 11g Dataguard and REMOTE_LOGIN_PASSWORDFILE

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Fri, 15 Jan 2016 14:57:47 -0600
Message-ID: <CAEueRAXtbWt-Q-yQBO+LGuUcf74OuTZoaZcSxPxcorDeF6hxdA_at_mail.gmail.com>

For setup, you don't need any connection between the two databases. Your standby database needs to be a copy of your primary.

But, I think what you're asking is if it is possible to ship redo between a primary and standby database without a password file. The answer is yes, you can use SSL with Oracle Internet Directory (OID) and an Oracle Wallet (or hardware security module).

Seth Miller

On Fri, Jan 15, 2016 at 2:09 PM, Bala <oratips_at_gmail.com> wrote:

> Thank you Seth for the email.
> No i am asking all the gurus here, if there is a option to setup
> Datagaurd without using Remote Login password file anywhere in environment
> and if anyone has done it since Security team is saying "Remote login
> password file constitutes a security loop hole... blah blah'..
>
> Thanks again!
>
>
>
>
> On Fri, Jan 15, 2016 at 12:01 PM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>> Bala,
>>
>> Are you asking if there is another way of creating the password file for
>> the standby?
>>
>> Seth Miller
>>
>> On Fri, Jan 15, 2016 at 10:37 AM, Bala <oratips_at_gmail.com> wrote:
>>
>>> We use REMOTE_LOGIN_PASSWORDFILE= Exclusive -- on primary database and
>>> have created Datagaurd environment and copied the same file to it from
>>> primary ( created by orapwd)
>>>
>>> Can we use any other method for physical standby setup ?
>>>
>>> Thank you for any ideas.
>>>
>>> Sincerely,
>>>
>>> Environment : 11.2.0.3, AIX 6.0
>>>
>>> --
>>> Bala Rao
>>>
>>
>>
>
>
> --
> Bala Rao
>

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

Received on Fri Jan 15 2016 - 21:57:47 CET