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

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Mon, 18 May 2009 16:42:34 +0200
Message-ID: <8580d4110905180742j19066b11o28d5abc83f9de4b3_at_mail.gmail.com>

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
>
>
>

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

Received on Mon May 18 2009 - 09:42:34 CDT