1.找到Sqlnet.ora文件,将SQLNET.AUTHENTICATION_SERVICES= (NTS)注销成以下形式:
# SQLNET.AUTHENTICATION_SERVICES= (NTS)
2.找到initSID.ora文件,修改remote_login_passwordfile的值为:
remote_login_passwordfile='EXCLUSIVE'重启动数据库,即可。
# SQLNET.AUTHENTICATION_SERVICES= (NTS)
2.找到initSID.ora文件,修改remote_login_passwordfile的值为:
remote_login_passwordfile='EXCLUSIVE'重启动数据库,即可。
You need to protect connect internal by password, even if you are logged in dba group.
Required steps:
1. Create password file in $ORACLE_HOME/dbs
2. Edit your init.ora file:
Fill in parameter REMOTE_LOGIN_PASSWORDFILE = exclusive
See [NOTE:1029539.6] SETTING UP ORACLE PASSWORD (ORAPWD)
3. Edit your sqlnet.ora file:
Fill in parameter SQLNET.AUTHENTICATION_SERVICES = (NONE)
但我用orapwd更改后,却无论是口令oracle或新改的密码都连不上,
错误信息是insufficient privilege权限不够,为什么?