Simple configuration of PLSQL connection to Oracle

I wrote TMD tricks on the Internet.

Idea: PLSQL depends on OCI. dll and some other files in the client, so it must be provided.

Locate listener. ora through the Environment Variable tns_admin,
Tnsnames. ora to establish a connection.

Steps:

1. Install oracle_client

2. Go to PLSQL to set the OCI. dll file path and its directory path

3. Create a network directory in the same directory of OCL. dll, in which the Admin directory is created.

4. Create two files, listener. ora and tnsnames. ora. (change the Suffix in Notepad)

Listener. ora content:

Listener =

(Description_list =

(Description =

(Address = (Protocol = TCP) (host = bjyw-zhugecs3.360buyAD.local) (Port = 1521 ))
# Bjyw-zhugecs3.360buyAD.local
Full name of the Local Computer

(Address = (Protocol = IPC) (Key = extproc1521 ))

)

(Sid_desc =

# Database Name

(Global_dbname = mydb)

# Local Oracle installation path

(ORACLE_HOME = D: \ app \ weihaifeng \ product \ 11.1.0 \ db_1)

# Database instance names and Sid must be consistent

(Sid_name = mydb)

)

)

Tnsnames. ora (configure the ing between data names and IP addresses) Content

# Database Name When PLSQL is started

Mydb =

(Description =

(Address_list =

# Database IP Address
And Port

(Address = (Protocol = TCP) (host = 10.12.144.188) (Port = 1521 ))

)

(CONNECT_DATA =

# Database instances

(SERVICE_NAME = mydb)

)

)

You can.