RE: Is there any way to create a database link with sysdba privs?
- From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
- To: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>, <mathias.magnusson@xxxxxxxxx>
- Date: Mon, 18 May 2009 14:23:40 -0400
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.'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
