ITPub博客

首页 > 数据库 > Oracle > 修改sys密码报错:ORA-01994: Password file missing or disabled

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

原创 Oracle 作者:raysuen 时间:2021-02-02 14:11:24 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
擅长oracle,Linux。精通shell,python。

注册时间:2016-08-23

  • 博文量
    138
  • 访问量
    179040