Oracle sqlplus logon command

Remember how to use the oracle sqlplus logon command. 1, {<username> [/<password>] [@ <connect_identifier>] |/} [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION = value] specifies the database account user name, the connection identifier of the password and the database connection. If there is no connection identifier, SQL * Plus will connect to the default database. As sysdba, as sysoper, and as sysasm options are database management permissions. <Connect_identifier> can be a Net service name or easily connected. In this case, you can connect to the local machine without starting lsnrctl. 2, {<username> [/<password>] @ [//] Host [: Port]/<service_name>] Host specifies the Host name or IP address of the database server computer. Port specifies the listening Port on the database server. <Service_name> specify the service name of the database to be accessed. In this case, you need to start the lsnrctl example: commonly used: sqlplus username/password, for example, normal user login sqlplus scott/tigersqlplus username/password @ net_service_name, for example: sqlplus scott/tiger @ orclsqlplus username/password as sysdba For example: sqlplus sys/admin as sysdbasqlplus username/password @ // host: port/sid note: sys and system must be logged on with sysdba. After Entering SQL * plus, you can use conn to connect to other users, such as conn sys/admin as sysdba.