Home » RDBMS Server » Server Administration » ORA-28009 ORA-01031: insufficient privileges
ORA-28009 ORA-01031: insufficient privileges [message #221744] Wed, 28 February 2007 04:53 Go to next message
laksha
Messages: 42
Registered: June 2006
Member
I am not able to conect as sys and system as sysdba.Why?
I am doing this on the server as the oracle user.
If i use operating system authentication is it possible to connect as sysdba.

SQL> conn / as sysdba;
Connected.

SQL> conn sys/syspw@prod
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper

SQL> conn sys/syspwd@prod as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> conn system/systempwd@prod
Connected.

SQL> conn system/systempwd@prod as sysdba
ERROR:
ORA-01031: insufficient privileges


Database:oracle 9.2.0.5
O7_DICTIONARY_ACCESSIBILITY FALSE
remote_login_passwordfile NONE

v$pwfile_users has no data.


Re: ORA-28009 ORA-01031: insufficient privileges [message #221748 is a reply to message #221744] Wed, 28 February 2007 05:10 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search the forum before posting.
Too many examples/threads on this topic.
Most recent one
http://www.orafaq.com/forum/?t=rview&goto=221085#msg_221085

First make user your tnsalias (prod) is working.
Remote_login_passwordfile should be exclusive.
May be you need to reset passwordfile.
Previous Topic: Tablespace alert script that will ignore autoextend
Next Topic: Import Error Messages
Goto Forum:
  


Current Time: Mon Dec 05 19:22:11 CST 2016

Total time taken to generate the page: 0.06384 seconds