Sqlplus has several landing methods such as: 1. C: > Sqlplus "/as sysdba" --Oracle SYS administrator logged in 2 with operating system Authority authentication. C: > Sqlplus/nolog --not in CMD or terminal the way to expose the password sql> conn/as sysdba&sql> conn Sys/password as Sysdba3. C: > Sqlplus scott/tiger --Non-admin user login 4. C: > Sqlplus scott/[email Protected] --Non-admin user login 5 using TNS alias. C: > Sqlplus sys/[email protected] as SYSDBA-Admin user Login 6 using TNS alias. C: > Sqlplus --do not reveal the login mode of the password enter User-name:sysenter Password:password as SYSDBA--with the SYS user must add as SYSDBA clause
in Oracle Server, regardless of whether the database is started, you can use the password file authentication method to log on to the database, and through the Sqlplus client at the remote login, start the database can only be logged in the Dba_users table password to log in, You can no longer log on by using the password file authentication method. Details