Oracle telnet command

Sqlplus has several landing methods such as: 1. C: > Sqlplus "/as sysdba"   
  C: > Sqlplus/as sysdba     --Oracle SYS administrator logged in 2 with operating system Authority authentication. C: > Sqlplus/nolog             --not in CMD or terminal the way to expose the password sql> conn/as sysdba&sql> conn Sys/password as Sysdba3. C: > Sqlplus scott/tiger        --Non-admin user login 4. C: > Sqlplus scott/[email Protected]    --Non-admin user login 5 using TNS alias. C: > Sqlplus sys/[email protected] as SYSDBA-Admin user Login 6 using TNS alias. C: > Sqlplus                       --do not reveal the login mode of the password enter User-name:sysenter Password:password     as SYSDBA--with the SYS user must add as SYSDBA clause


Oracle connects to remote databases

1. Connect the Oracle command syntax remotely with Sqlplus:

Sqlplus Usr/[email Protected]//host:port/sid

Example: sql> conn scott/[email protected]//192.168.130.99:1521/risenet Connected.

2. Follow the instructions with Netmanager Yes

When I first learned Oracle, I remembered some commands. After a while, forget to make as many tools as possible. The development tool is for the convenience of the use of SQL Plus the next plsql Developer

Local connection sqlplus scott/[email protected]: 1521/orcl This sentence equals Sqlplus Scott/tiger

Remote connection (Oracle on a virtual machine)

Sqlplus scott/[email protected]: 1521/ORCL

Sqlplus system/[email protected]: 1526/I2KDB (i2kdb as service name)

Sqlplus system/[email protected]

Can be viewed through the Sqlplus help document in CMD

There are usually four ways to connect SQLPlus 1. Sqlplus/as SYSDBA    Operating system authentication, does not require the database server to start listener, and does not require the database server to be in a usable state. For example, if we want to start the database, we can enter the sqlplus in this way and    start with the startup command. 2. Sqlplus Username/password    connects to the native database and does not require the listener process of the database server, but requires that the database server be in a usable state because authentication of the user name password is required. 3. Sqlplus Usernaem/[email protected]    through the network connection, this is the need for the database server listener is in the listening state. The approximate steps to establish a connection are as follows a. Query Sqlnet.ora to see how the name is parsed, by default Tnsname B. Query the Tnsnames.ora file, find the ORCL record from the inside, and find the hostname or IP, port, and service of the database server　　　　_name c. If the server listener process is not a problem, establish a connection to 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 the private server mode, and the client connects to the      database's server process if there is no problem. E. The connection is now established and the database can be manipulated. 4.sqlplus username/[email protected]//host:port/sid remote connection with Sqlplus Oracle Command (example: Sqlplus risenet/[email protected]// 192.168.130.99:1521/risenet)