Re: Is there any way to create a database link with sysdba privs?
- From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- To: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
- Date: Mon, 18 May 2009 21:42:08 +0200
Have you tried connecting to it using SQL*Net? If you cannot connect like
sqlplus sys@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@xxxxxxx> 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@xxxxxxxxx]
> Sent: Monday, May 18, 2009 10:46 AM
> To: mathias.magnusson@xxxxxxxxx
> Cc: Terrian, Thomas J Mr CTR DLA J6DIB; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx> 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@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@xxxxxxx> 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@B;
> select sysdate from dual@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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
>
Other related posts:
