A
A
Alexey M.2015-05-19 11:39:07
Oracle
Alexey M., 2015-05-19 11:39:07

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 sysdba
writes error ORA-01031: insufficient privileges
Tried to reset the SYS password using the command
orapwd
, then rebooted the server, but it didn't work, writes that the password is not correct ORA-01017...
ORACLE_HOME and ORACLE_SID are set, if this information is needed
I tried everything already, how to be? Waiting for the timeout to pass is also not an option, the database is urgently needed ... Help, please?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Lebedev, 2015-05-22
@lnl

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.

O
OracleDBA, 2018-02-26
@OracleDBA

RESETTING AN ORACLE ACCOUNT PASSWORD
dbpilot.net/2018/01/15/resetting-an-oracle-account...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question