Re: connect as sysdba

Re: connect as sysdba

 

  

grant sysdba to system (if you want to use it as such), in order to do
that you will need to make sure you have a password file, then you
should be able to connect from a remote machine.

Dean
M. Dean Hamann
Associate Director, Administrative Computing Services
Information Systems
University of Indianapolis
317-788-3238



Bheemsen Aitha wrote:
> Hi,
>
>
>
> I am able to connect to sqlplus using "system as sysdba" at Unix prompt
> on the server. But I am not able to connect using "system as sysdba" in
> sqlplus from my machine on Windows to the same db.
>
>
>
> Is it something to do with tnsnames or sqlnet?
>
>
>
> Any help is appreciated.
>
>
>
> Thanks
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>

Oracle LazyDBA home page