sqlplus remote server

Sqlplus Connecting a remote database Zhou__zhou **************sqlplus connecting a remote database system **********************Mode one: Simple connection, without network configuration, is actually Tnsname.ora file, but only support oracle10g

1, first you have to install the Oracle database server and client software, in the installation process to be aware of, select the Oracle installation directory, remember not to use the Chinese directory or a directory with

The following figure shows two steps for installing the Oracle database server software and client software: Through the above process, we know that the server and the client have a file to be configured, the server is the listener

I. Software Download and environment configuration 1. download the software to http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html download the following three packages: Current address: Copy to c: \ instantclient_10_

Sqlplus has several landing methods such as: 1. 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

Click "Run", enter "Sqlplus", pop，Enter the account again. Scott, password TigerOr, click "Run", enter "Sqlplus/nolog", this time only to open the login, log in and connect to the remote server need to enter the Operation commandWhere the @ server

1.sqlplus Sys/[email protected] as SYSDBA with SYS as the system administrator to connect to the remote database ORCL name is located in the D:\app\lenovo\product\11.2.0\dbhome_1\ Network\admin\tnsnames.ora inside;OrSqlplus/nolog logging in Sqlplus

These days encountered two problems, are very wonderful, distressed for three days, the final positioning out.Problem one, inserting data through PL/SQL developer to a remote Oracle database server, querying data through PL/SQL developer queries,

Problem Description:Local is Win7 operating system, cmd inside Sqlplus go in and connect Oracle database, Chinese can be displayed normally, but Plsql Connection Oracle database, Chinese display garbled, and Xshell Remote Connection Oracle server

********************* * Method 1: Simple connection. network configuration is not required. It is actually a tnsname. ora file, but only Oracle10g or above is supported.Command: sqlplus user name/password @ IP Address [: Port]/SERVICE_NAME [as