PLSQL Developer database connection and tnsname. ora configuration, plsqltnsname. ora

PLSQL Developer database connection and tnsname. ora configuration, plsqltnsname. ora

PLSQL Developer database connection and tnsname. ora Configuration

Operating System: WIN10

Resource preparation:

Find the PLSQLDeveloper _ decompressed (64-bit available) resources on the Internet, including the content of instantclient_11_2 and PLSQL, And the readme.txt tutorial file for configuring the internal parameters.Address: http://download.csdn.net/detail/wuqinfei_cs/7740373. You must have a csdn user name before downloading.

Configuration process:

1. decompress the resource, open the PLSQL development folder in the decompressed directory, and double-click the plsqldev.exe icon to open PLSQL Developer.

2. In the displayed dialog box, click Cancel without connecting to the database.

3. Configure the PLSQL Developer tool. On the menu bar, choose tools> preferences> connect. Enter the full path of instantclient_11_2 in the decompressed path in "Oracle main directory name" on the right panel, such as D: \ Soft \ Component \ PLSQL Developer \ PLSQL \ instantclient_11_2 (you need to change it to the local decompression path ). In the "OCI library", enter D: \ Soft \ Component \ PLSQL Developer \ PLSQL \ instantclient_11_2 \ oci. dll (you need to change it to the local decompressed path ). To save the settings, you must restart PLSQL Developer to enable the new settings.

4. Create a folder network in the instantclient_11_2 directory, create a folder admin in the network directory, and migrate the tnsnames. ora file in the instantclient_11_2 directory to the admin directory. The complete path is:

D: \ Soft \ Component \ PLSQL Developer \ PLSQL \ instantclient_11_2 \ network \ admin \ tnsnames. ora

(You need to change it to the local decompressed path)

5. Use notepad to open the tnsnames. ora file and configure the listening content, such:

CONN_13 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.1.10.13) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = rac)
)
)

CONN_13 is a custom connection name. HOST writes the address of the database to be connected. SERVICE_NAME also needs to write its own content. Save the modified content.

6. Open PLSQL Developer and enter the username and password for connecting to the database. The database drop-down box automatically displays the connection name set in tnsnames. ora, for example, CONN_13. Select Normal for "connection. Click OK to connect to the database.

7. Right-click the left-side Navigation Pane and select the new -- SQL window. In the displayed SQL window, write SQL statements to test whether the database is connected successfully.

In the left-side tree, if Tables exists, all Tables in the database are displayed when the tree node is opened. If you only want to view your table, change All objects (drop-down box) above the tree chart to My objects.

Top

1

Step on

0

View comments