查看:
SQL> show parameter remote
NAME TYPE VALUE
------------------------------------ ----------- ---------------
remote_archive_enable string true
remote_dependencies_mode string TIMESTAMP
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
正常应该为EXCLUSIVE.
发现也是正常的。
解决方法:重新启动oracle 问题解决。
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 605099548 bytes
Fixed Size 452124 bytes
Variable Size 385875968 bytes
Database Buffers 218103808 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
总结: 1. sys 密码挂失并不可怕,我们可以重建,如上。
2.远程登录要用remote_login_passwordfile = EXCLUSIVE
3.查看当前具有sysdba权限用:
select * from v$pwfile_users;