Shulou(Shulou.com)06/01 Report--

sqlplus login mode

sqlplus has several login methods such as:

1.C: > sqlplus "/as sysdba" --Log in as an Oracle sys administrator with operating system privileges

2.C: > sqlplus /nolog --login methods that do not expose passwords in cmd or terminal

SQL> conn /as sysdba

&

SQL> conn sys/password as sysdba

3.C: > sqlplus scott/tiger --login for non-admin users

4.C: > sqlplus scott/tiger@orcl --non-admin users log in using tns alias

5.C: > sqlplus sys/password@orcl as sysdba --admin user logs in using tns alias

6.# sqlplus --login method without revealing password

Enter user-name：sys

Enter password: password as sysdba --If you log in as sys user, you must add the as sysdba clause.

#sqlplus test --login method without revealing password

Enter password:

7. in ord to facilitate that management of database connections to other server that are not on the local database, you can add other database-related IP, listening, sid configurations to the tnsnames.ora file:

# vi $ORACLE_HOME/network/admin/tnsnames.ora

TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.12)(PORT = 1521)) ) (CONNECT_DATA = (SID = test) ) )LISTENER_TEST = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.12)(PORT = 1521)) )

#sqlplus test@sid --login method without revealing password

Enter password:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.