Re: Is there any way to create a database link with sysdba privs?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 18 May 2009 09:46:26 -0500
Message-ID: <ad3aa4c90905180746g30ae3cecg8772b134545e024e_at_mail.gmail.com>



Did you try setting up the destination listener with the UR=A option?

On Mon, May 18, 2009 at 9:42 AM, Mathias Magnusson < mathias.magnusson_at_gmail.com> wrote:

> Just a guess. For DB links to work you would need SQL Net to be working,
> but it is probably not when you are in recovery mode.
>
> Can you logon to the db with user_at_db? If you cannot do that, then I'd
> think you'd not be able to access the DB via a DB link.
>
> Mathias
>
>
> On Mon, May 18, 2009 at 4:11 PM, Terrian, Thomas J Mr CTR DLA J6DIB <
> Tom.Terrian.ctr_at_dla.mil> wrote:
>
>> 10.2.0.4
>>
>> I want to create a database link in database "A" that connects to a
>> physical standby database "B" that is in recovery mode:
>>
>> SQL> create database link B connect to yyy identified by zzz using 'B';
>> Database link created.
>>
>> SQL> select sysdate from dual_at_B;
>> select sysdate from dual_at_B
>> ERROR at line 1:
>> ORA-02068: following severe error from B
>> ORA-01033: ORACLE initialization or shutdown in progress
>>
>> The "B" database is in recovery mode. Is there any way to connect to it
>> with sysdba from the "A" database using a database link?
>>
>> -------------------------------------------------------
>> If I sign on directly to "B" as sysdba it works fine so I know the
>> command will work even though it is in recovery mode:
>>
>> $> sqlplus /nolog
>>
>> SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 18 07:08:40 2009
>>
>> Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
>>
>> SQL> connect / as sysdba;
>> Connected.
>> SQL> select sysdate from dual;
>>
>> SYSDATE
>> ---------
>> 18-MAY-09
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 18 2009 - 09:46:26 CDT

Original text of this message