Plsql connecting to a server Oracle

Oracle is very memory-eating, and I'm often reluctant to download this very memory-eating app. Of course there is a solution, if you already have the Oracle database on the server, you only need to download the Oracle client, you locally installed a tool to connect to the Oracle database (no better than plsql with Oracle), you can connect the server database , so the local is very happy.

I use a 64-bit local operating system, the server is also a 64-bit operating system, the server is installed on the Oracle 11g, its Oci.dll library of course is also 64-bit.

We first download the Plsql application (to download the cracked version yourself), Plsql is a 32-bit application, unable to load the 64-bit Oracle Oci.dll library, so local need to download Oracle provided 32-bit instant client, download here, click Download

Choose:

Instant Client for Microsoft Windows (32-bit)

The server is oracle11g, so I downloaded

Instantclient-basic-nt-11.2.0.4.0.zip (51,477,933 bytes)

This plsql loads your local Oracle Instant client and the instant client is 32-bit.

After the download, unzip the extracted Instantclient_11_2 folder separately, placed in their own creation of the Oracle folder (I prefer this clean, do not leave so many useless file path)

Then we create the Network/admin folder under the Instantclient_11_2 folder, and create a new Tnsnames.ora file in the Admin folder (it is not recommended to use a text file).

The contents of the Tnsnames.ora file are as follows:

# Tnsnames.ora Network Configuration file:e:\oracle\oracleinstall\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. ORCL=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST = 255.255.255.255) (PORT = 1521)) (Connect_data=(SERVER=dedicated) (Service_Name=ORCL)) ) Listener_oracle=(ADDRESS= (PROTOCOL = TCP) (HOST = 255.255.255.255) (PORT = 1521)) Oraclr_connection_data=(DESCRIPTION=(Address_list=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC)) ) (Connect_data=(SID=Clrextproc) (PRESENTATION=RO)) )

All you need to do is modify the content:

HOST  is your server's Ipport  is your server's Oracle-opened port number Service_Name  is your server's Oracle name

Then set up two environment variables:

Tns_admin = E:\oracle\instantclient_11_2\NETWORK\ADMIN

Nls_lang = American_america. Zhs16gbk

My server is encoded as ZHS16GBK, if your server is encoded as AL32UTF8, replace it yourself.

Then start Plsqldev.exe, do not use password login, enter after click Tools-Preferences

Set the Oracel home directory name to:

E:\oracle\instantclient_11_2

The OCL library is:

E:\oracle\instantclient_11_2\oci.dll

Close and then restart Plsqldev.exe, enter your username password, and the database for your server service_name name.

After successful click on the tables in all objects to see the table in server Oracle.

Plsql Connect to server Oracle