PL/SQL Developer remote connection to Oracle database

Http://database.51cto.com/art/201108/280487.htm

Online Search a lot of methods, this feasible!

1, Configure the server Tnsnames.ora file, if there is no Oracle installed on this machine, you can copy a (Tnsnames.ora file) from the machine with Oracle installed in the specified directory, Because I have installed Oracle, I configured the file directly.

# Tnsnames.ora Network Configuration File:d:\oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

Oraclr_connection_data =

(DESCRIPTION =

(address_list =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

 )

(Connect_data =

(SID = clrextproc)

(PRESENTATION = RO)

 )

 )

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.25.224) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = orcl)

 )

 )

ORCL is the instance name of the remote Oracle database, and the IP address and port are also configured correctly.

2. After the configuration is complete, the Oracle client should be able to connect to the remote Oracle database.

3. Connect to the database using PL/SQL developer

The database is populated with the service_name of the remote databases ,

Note: According to the actual user name, password and database:

User name: Gateway Password: Gateway database: ORCL

4, after the connection in the PL/SQL developer operation of the remote database, create a new SQL window,

5, in the new SQL window for remote operation,

6. View individual table data,

7. View a single table structure,

Not verified:

No installation Customers

1, Oracle does not install the client can also use Plsql remote connection      first, in the installation oracle Search for the following files on the server's machine, Oci.dll Ocijdbc10.dll Ociw32.dll Orannzsbb10.dll Oraocci10.dll Oraociei10.dll     (may not have the server, if not, pl sql   User name password can login) Sqlnet.ora Tnsnames.ora Classes12.jar Ojdbc14.jar put in a folder, such as  oraclient 2, configuration Tnsnames.ora, if there is no Oracle installed on this machine, you can copy one (Tnsnames.ora file under%oracle_home%\network\admin) on the machine with Oracle installed in the above directory D:\ Under the oraclient. Oracledata = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521)) ) (Connect_data = (service_name = oracledata) ) ) 3, add an environment variable named Tns_admin, the value is the path of the Tnsnames.ora file (for example: D:\oraclient, In particular, after reloading or other operations, forget the tns_admin variable, plsql login will be reported cannot parse the specified connection identifier), this is to be able to find the above said Tnsnames.ora. If ORACLE is installed on this machine and the ORACLE_HOME environment variable is set, the Tnsnames.ora file is automatically found in the%oracle_home%/network/admin/location. 4. Set the Oracle language and add environment variables: "Nls_lang = simplified Chinese_china. ZHS16GBK ", (American_america. Us7ascii is ASCII encoding type, other types can go to the server to look at or online search (This step is for the time being correct, if the coding is not correct, will produce garbled) 5. Download and install the PL.SQL.Developer configuration app Configure Tools->preferences->connection Oracle home=d:\oracleclient OCI Library=d:\oracleclient\oci.dll 6, open again plsql will be in the database in the Oracledata option to enter the user name password can login.

PL/SQL Developer remote connection to Oracle database