Is there any way to create a database link with sysdba privs?
Date: Mon, 18 May 2009 10:11:21 -0400
Message-ID: <B538F62DA0448741B308EA69417CC30201462B10_at_COL1SMX19.USE.AD.DLA.MIL>
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-lReceived on Mon May 18 2009 - 09:11:21 CDT