Answer the question
In order to leave comments, you need to log in
How to login/reset password in oracle 11G database?
Good afternoon!
The problem is the following... Yesterday we changed the password from the SCOTT user, and in the settings of the utility that connected to the database, they forgot to set a new password, as a result, the user was blocked, and the password from SYS and SYSDBA was lost. Now I'm running into the same errors...
I log in as an admin, I'm in the ora_dba group, why can't I log in on command
connect / as sysdbawrites error ORA-01031: insufficient privileges
orapwd, then rebooted the server, but it didn't work, writes that the password is not correct ORA-01017...
Answer the question
In order to leave comments, you need to log in
For information, in case someone needs it: Members of the group dba (unix) and ora_dba (win when using sqlnet.authentication_services=(NTS)
in
sqlnet.ora) can log in locally under "/ as sysdba".
sec_case_sensitive_logon, that is, the software most likely can not access oracle with a password set in non-capital characters.In order to transfer nls_lang to 866, it is better to transfer the console to cp1251.mode
con: cp select=1251
The cmd font must be Truetype.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question