Sqlplus command usage

The basic format of the sqlplus command is sqlplus <username> [/<password>] [@ <connect_identifier>]/[as sysdba | as sysoper]/nolog, where: username: username password: password connect_identifier: Connection ID string. If you connect to the current instance, you do not need to specify this parameter. If you connect to other databases, You need to specify the parameter, that is, specify the NET service name as sysdba | as sysoper as the logon identity. For operating system authentication, specify as sysdba or as sysoper to log on, or even do not enter the user name and password nolog, if you directly use the nolog parameter, you cannot specify the preceding parameter. Note: nolog does not mean that logs are not recorded, but no login means to enter the sqlplus environment without authentication and logon, then, create an instance using the connect command in sqlplus. Connection. For example, to connect to the current instance, log on as an operating system authentication: [oracle @ localhost ~] $ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.1.0-Production on Wednesday April 10 04:47:48 2013 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>