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

Home -> Community -> Usenet -> c.d.o.server -> Re: "/ as sysdba" Failes But "sys/password@service_name" Works ???

Re: "/ as sysdba" Failes But "sys/password@service_name" Works ???

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 1 Mar 2004 16:30:47 +0100
Message-ID: <40435686$0$29944$626a14ce@news.free.fr>

"Ibrahim DOGAN" <idogan_tech_at_yahoo.com> a écrit dans le message de news:6bf58828.0403010646.63ea87f4_at_posting.google.com...
> > What is the REMOTE_LOGIN_PASSWORDFILE parameter value
> > on each database?
> >
>
> on 8i_dbi and 9i_db2, REMOTE_LOGIN_PASSWORDFILE = ESXLUSIVE
> on 9i_db1, REMOTE_LOGIN_PASSWORDFILE = NONE
>
> i.d.

So you have your answer.
9i_db1, none = no remote sysdba login
8i_dbi and 9i_db2, exclusive = users in password file can remote login as sysdba/sysoper.

Regards
Michel Cadot Received on Mon Mar 01 2004 - 09:30:47 CST

Original text of this message

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