You can restrict the sysdba login. when you get the ORA-01031: insufficient privileges error while connecting / as sysdba
Make sure the value in sqlnet.ora location $ORACLE_HOME/network/admin SQLNET.AUTHENTICATION_SERVICES=NTS or ALL. If the value is NONE
it will not allow you to login. either you can comment line as below or set it to NTS or ALL
#SQLNET.AUTHENTICATION_SERVICES=NTS
After changing the value to NTS, able to login / as sysdba
Make sure the value in sqlnet.ora location $ORACLE_HOME/network/admin SQLNET.AUTHENTICATION_SERVICES=NTS or ALL. If the value is NONE
it will not allow you to login. either you can comment line as below or set it to NTS or ALL
#SQLNET.AUTHENTICATION_SERVICES=NTS
After changing the value to NTS, able to login / as sysdba
No comments:
Post a Comment