Different Ways to Login to Database

Login into Database by Different Ways

Login into database Externally as OS (Operating System) User Name

Steps

SQL> Alter system set os_authent_prefiex=ops$ scope=spfile;

SQL> Create user ops$<username> identified by externally;  -- here username should be same as os user name

SQL> Alter system set remote_os_authent='true' scope=spfile;

Change NTS instead of NONE in SQLNET.ora file

SQL > Startup force

SQL> conn /

Login into database by using Password File