Добрый день!

У меня заблкировались все юзеры.

Разблокировал и поменял пароль sys

Пытаюсь разблокировать SCOTT и получаю ошибку - недостаточно прав.

Что можно сделать? Спасибо!

C:>sqlplus sys/manager as sysdba;

SQL*Plus: Release 11.2.0.2.0 Production on Fr Apr 14 11:13:36 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics,
Oracle Database Vault and Real Application Testing options

SQL> ALTER USER SCOTT ACCOUNT UNLOCK;
ALTER USER SCOTT ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01031: Nicht ausreichende Berechtigungen

SQL> alter user SCHEMA_NAME account unlock;
alter user SCHEMA_NAME account unlock
*
ERROR at line 1:
ORA-01031: Nicht ausreichende Berechtigungen

SQL>

Не помогает
SQL> ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01031: Nicht ausreichende Berechtigungen

Как это сделать
"Залогиниться с OS-аутентификацией"

Я так всё и сделал :-)

C:>sqlplus sys/manager as sysdba;

SQL*Plus: Release 11.2.0.2.0 Production on Fr Apr 14 11:13:36 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics,
Oracle Database Vault and Real Application Testing options

SQL> ALTER USER SCOTT ACCOUNT UNLOCK;
ALTER USER SCOTT ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01031: Nicht ausreichende Berechtigungen

C:\>set LOCAL=

C:\>set ORACLE_SID=orcl

C:\>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fr Apr 14 14:04:04 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics,
Oracle Database Vault and Real Application Testing options

SQL> ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01031: Nicht ausreichende Berechtigungen


SQL>

SQL> connect / as sysdba
Connected.
SQL>

SQL> ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;
ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01031: Nicht ausreichende Berechtigungen

Может в этом проблема?
Есть ещё база XE.

Но в sqldeveloped as sysdba с базой 12 получаю я теже проблемы


Fehler beim Start in Zeile 9 in Befehl:
ALTER USER "SCOTT" DEFAULT ROLE "RESOURCE","CONNECT","DV_OWNER","DV_ACCTMGR"
Fehlerbericht:
SQL-Fehler: ORA-01031: Nicht ausreichende Berechtigungen

00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password

without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.

*Action: Ask the database administrator to perform the operation or grant

the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.

Спасибо
Следующий вопро, как отключить Vault


SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

PARAMETER
----------------------------------------------------------------
VALUE CON_ID
---------------------------------------------------------------- ----------
Oracle Database Vault
TRUE 0

SQL> CONNECT SYS AS SYSOPER
Enter password:
Connected.
SQL> EXEC DBMS_MACADM.DISABLE_DV;
BEGIN DBMS_MACADM.DISABLE_DV; END;

*
ERROR at line 1:
ORA-06550: Zeile 1, Spalte 7:
PLS-00201: Bezeichner 'DBMS_MACADM' muss deklariert werden
ORA-06550: Zeile 1, Spalte 7:
PL/SQL: Statement ignored

\\\\Windows: In the ORACLE_BASE\ORACLE_HOME\bin directory, rename the oradvll.dll file to another name, such as oradvll.dll.dbl.


Для отключения vault требуется переименовать файл oradvll.dll. У меня этот файл отсутствует. Кто то с этим сталкивался?