修改sys密码报错：ORA-01994: Password file missing or disabled
SQL> conn / as sysdba
Connected.
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string racscan:1521
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
remote_recovery_file_dest string
result_cache_remote_expiration integer 0
SQL> alter user sys identified by 123456;
User altered.
SQL> alter system set remote_login_passwordfile=none scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2634022312 bytes
Fixed Size 8900008 bytes
Variable Size 1073741824 bytes
Database Buffers 1543503872 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string racscan:1521
remote_login_passwordfile string NONE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
remote_recovery_file_dest string
result_cache_remote_expiration integer 0
SQL> alter user sys identified by 123456;
alter user sys identified by 123456
*
ERROR at line 1:
ORA-01994: Password file missing or disabled
SQL> alter system set remote_login_passwordfile=EXCLUSIVE scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2634022312 bytes
Fixed Size 8900008 bytes
Variable Size 1073741824 bytes
Database Buffers 1543503872 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.
SQL> alter user sys identified by 123456;
User altered.
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string racscan:1521
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
remote_recovery_file_dest string
result_cache_remote_expiration integer 0
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28572479/viewspace-2755397/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
