Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dblink as sysdba ?

Re: dblink as sysdba ?

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Thu, 1 Sep 2005 11:43:08 -0400
Message-ID: <52a152eb0509010843e686d73@mail.gmail.com>


Actually, i want to create a dblink to the ASM instance, so that I dont have to connect to it everything i want to see what's going on :)

On 9/1/05, Paul Drake <bdbafh_at_gmail.com> wrote:
> On 9/1/05, Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
> >
> > Does anyone know how to create a dblink that connects with sysdba
> priviliges ?
> >
> > --
> > Christo Kutrovsky
> > Database/System Administrator
> > The Pythian Group
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
> Is that for a dataguard setup?
> Databases participating in a primary/standby arrangement perform tasks
> connected as sysdba.
> This is supported via the use of a pre-shared password file.
>
> I can't think of anything else that would need to.
>
> Perhaps you just need to grant a specific sys_priv or tab_priv to a service
> account to accomplish the task?
> Perhaps you just need to logon to the host via ssh to perform the task?
>
> Paul
>
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 01 2005 - 11:27:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US