当前位置：首页 > 数据库 > Oracle教程 > 修改sys密码报错：ORA-01994: Password file missing or disabled > 正文

修改sys密码报错：ORA-01994: Password file missing or disabled

来源：这里教程网 时间：2026-03-03 16:24:36 作者：
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

编辑推荐：

相关推荐

最新软件资讯

延迟密码验证特性引起的数据库HANG死及宕机
延迟密码验证特性引起的数据库HANG死及宕机

热文推荐

天极热推