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 21:42:08 +0200
Message-ID: <8580d4110905181242r79839f6cv660560cc36e4752b_at_mail.gmail.com>

Have you tried connecting to it using SQL*Net? If you cannot connect like sqlplus sys_at_db_name, then I donät think youäll get a db link to work as it uses sql*net.
Mathias

On Mon, May 18, 2009 at 8:23 PM, Terrian, Thomas J Mr CTR DLA J6DIB < Tom.Terrian.ctr_at_dla.mil> wrote:

> Good idea. I added the UR=A option to the listener and reloaded it
> without success.
>
> -----Original Message-----
> From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
> Sent: Monday, May 18, 2009 10:46 AM
> To: mathias.magnusson_at_gmail.com
> Cc: Terrian, Thomas J Mr CTR DLA J6DIB; oracle-l_at_freelists.org
> Subject: Re: Is there any way to create a database link with sysdba
> privs?
>
> 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 - 14:42:08 CDT