| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: connect / as sysdba
Hi Deepak,
Here I am sending you some excercise, go thru from this.. hope that will solve you issue :-
This error usually comes when you have different password for user sys and password file.
eg:
orapwd file=pwdsunil.ora password=sunil entries=10
Say, but for sys user is having passowrd ORACLE.
when i will do:
connect sys/oracle
will connect successffuly
but if i will do :
connect sys/oracle as sysdba
than it will echo a message ORA-01031: insufficient privileges
but if i will do:
connect sys/sunil as sysdba
it will work
so after creating a password file always change the password for sys with something new so that the new password will sync. with the password file.
Hope this will clear your doubt :-)
QUERIES in Oracle, Feel free to Join:
http://groups.yahoo.com/group/oracle_expert/
Regards,
Sunil Bhola
Oracle_Expert, Moderator
Lou Fangxin <anysql_at_gmail.com> wrote:
Are you connect to the domain? If so, you need to create the ORA_DBA in the domain control. And after you add the group, please restart the oracle service.
Good luck.
On 9/8/05, DBA Deepak <oracle.tutorials_at_gmail.com> wrote: Hi All,
I am trying to connect to my local DB (Windows XP Pro Box) using
connect / as sysdba
I am geting the error and unable to log in because of insufficient privilleges.
I have the following settings.
In initSID.ora
remote_login_passwordfile=EXCLUSIVE
In sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Under ORA_DBA os group I have added the currect os user.
What might be the problem? Please help.
--
Regards,
Deepak
Oracle DBA
--
Welcome, http://www.anysql.net/en/
 |
 |