How to set Password for sqlplus /as sysdba

Question

I am new to Oracle. I would like to know how to set login password for sqlplus / as sysdba in oracle 11g.

I want to set the password for my next login, i dont want to login as sqlplus / as sysdba since anyone can log in using sqlplus / as sysdba and can easily access the data or change password for the existing user.I need to restrict the login.

Answer 1

To set a new password you should (after connecting to the DB):

alter user SYS identified by "newpassword";

But if you want to prevent connecting without a password - sqlplus / as sysdba, then you need to add this:

SQLNET.AUTHENTICATION_SERVICES=none

in sqlnet.ora