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

1. Sqlplus / as sysdba

Operating system authentication does not require the database server to start listener, nor does it require the database server to be available. For example, if we want to start the database, we can enter it in this way.

Sqlplus, and then start it with the startup command.

2. Sqlplus username/password

The listener process of the database server is not required to connect to the native database, but because the authentication of the user name and password is required, the database server is required to be available.

3. Sqlplus usernaem/password@orcl

Through a network connection, it is required that the listener of the database server be in a listening state. The approximate steps for establishing a connection at this point are as follows

a. Query sqlnet.ora to see how names are resolved. The default is TNSNAME.

b. Query the tnsnames.ora file, find the orcl record inside, and find the hostname or IP, port and service_name of the database server

c. If there is nothing wrong with the server listener process, establish a connection with the listener process.

d. Depending on the server mode, such as dedicated server mode or shared server mode, listener takes the next action. The default is dedicated server mode, and if there is no problem, the client connects to the server process of the database.

e. At this point, the connection has been established and the database can be operated.

4.sqlplus [username] / [password] @ [host]: [port] / [sid]

Enter the database address, port number, SID, user name, password, this method is the simplest, as long as there is sqlplus can be used, do not need to configure.

Example:

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.