Oracle is not installed locally, and PL/SQL remote access to Oracle Database Configuration

I wrote a blog about Oracle Database remote connection: Oracle database -- server-side remote connection configuration.

In that article, I recommended someone else's blog, which is the topic of this blog. However, I recently used it, so I went through my blog and found that the blog had been restricted for a long time. I found this on the Internet, so I decided to write it myself, for future use and convenience.

1. Install PL/SQL. This process is easy and I will not talk about it anymore. My directory is C: \ plsql.

2. Go to the Oracle website to download the Instant Client. Ask someone to leave a message and send you a Network Disk link. After installation, I directly installed it in the PL/SQL installation directory. The directory is C: \ plsql \ odac_client.

3. Create a new file named tnsnames. ora in this directory and enter the following content:

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

4. Add an environment variable named TNS_ADMIN and set the value to the path of the tnsnames. ora file.

5. Open PL/SQL and click Cancel to go to the main interface. Select Preference in Tools and set Oracle Home to C: \ plsql \ odac_client, and OCI Library to C: \ plsql \ odac_client \ oci. dll.

6. Restart PL/SQL after the configuration is complete.

7. garbled characters may occur. You only need to run the following command to check the encoding:

Select userenv ('language') from dual;

You only need to add an environment variable NLS_LANG with the value as shown in the preceding statement.

Finally, I personally suggest using a notebook. For a functional blog (for example, this article), I will add it to my favorites, but simply adding an address to my favorites is not so reliable, write this article to make some suggestions and make your own learning more efficient.

After Oracle 10g is installed, restart the system. If PLSQL is used for connection, no listening is reported.

ORA-03114 PLSQL process compilation disconnection Error

Simple configuration of PLSQL connection to Oracle

Detailed description on Performance Improvement of PLSQL batch Forall operations

Use Oracle SQLDeveloper to connect to the database and create a user

Oracle PL/SQL Developer import and export data

Install the Oracle 11g and Oracle SQL Developer clients in 64-bit Windows 7