Thanks to all those who responded.

1. Yes, I am connecting from remote machine.
2. Connecting with "system as sysdba" on the server itself works.
3. On the remote machine I am getting "insufficient privileges" error.

Thanks
B

----Original Message-----
From: Dean Hamann
[mailto:oracledba-ezmlmshield-x2324326.[Email address protected]
Sent: Tuesday, October 09, 2007 4:18 AM
To: LazyDBA Discussion
Subject: 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
>
>
>
>


---------------------------------------------------------------------
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