修改sys密碼報錯：ORA-01994: Password file missing or disabled

raysuen發表於2021-02-02
密碼

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部落格 ” ，連結：http://blog.itpub.net/28572479/viewspace-2755397/，如需轉載，請註明出處，否則將追究法律責任。

相關文章