Re: ORA-01031: insufficient privileges when conn sys/password as sysdba
Any idea? It is newly copied db.
I can connect localy. I get the error when I try to connect as sys remotely. All other user can connect okay, except sys. Any idea?
# sqlnet.ora Network Configuration File: /opt/oracle/product/10.1.0/oradbhome/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (NTS, TNSNAMES, EZCONNECT)
Last edited by dba_dada; 10-04-2005 at 03:05 PM.
how on earth you expect sysdba/sysoper working when you have this?
1. is service properly created in tnsnames.ora file
2. r u using service name while connecting like sys/pass@ser1 as sysdba
3. if os is windows then make SQLNET.authentication_services=(NTS)
1. Make remote operating system user, the member of oradba group at database server.
Click Here to Expand Forum to Full Width