ORA-01031 Insufficient privilege when connecting from client
Hi Guys,
Oracle 81730 on Win2000 platform.
ORA-01031 error is somehow always haunting me. Today, I found out that from client, if I say connect sys/@xyz as sysdba, it gives ORA-01031 Insufficient privilege.
But from server, the same thing works.
remote_login_passwordfile = exclusive
select * from v$pwfile_users
USERNAME SYSDBA SYSOPER
------------------------------
INTERNAL TRUE TRUE
SYS TRUE TRUE
In SQLNET.ORA on server,
#
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
Pl. help....
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart