-
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?
Thanks!
----
OS- Solaris
10g
# sqlnet.ora Network Configuration File: /opt/oracle/product/10.1.0/oradbhome/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES=(NONE)
NAMES.DIRECTORY_PATH= (NTS, TNSNAMES, EZCONNECT)
Also remote_login_passwordfile=NONE
Last edited by dba_dada; 10-04-2005 at 03:05 PM.
-
how on earth you expect sysdba/sysoper working when you have this?
remote_login_passwordfile=NONE
-
Check
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)
possible Suggestions
1. Make remote operating system user, the member of oradba group at database server.
~KD.DBA~
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|