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