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 a password for my next login, I do not want to log in as sqlplus / as sysdba , since any user can log in using sqlplus / as sysdba and can easily access data or change the password for an existing user . I need to restrict login.

Answer 1

To set a new password, you must (after connecting to the database):

alter user SYS identified by "newpassword"; 

But if you want to deny connection without a password - sqlplus / as sysdba , you need to add this:

 SQLNET.AUTHENTICATION_SERVICES=none 

in sqlnet.ora

Answer 2

Not everyone can log in using sqlplus / as sysdba . The OS user must be a member of the OS DBA group created to manage the database (this group may have a different name).

You should only assign a valid membership in this group. And, in my opinion, no one should log in as oracle (assuming a Unix (-like) system here).

Answer 3

 SQLPLUS username/password@identifier_name