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