1, first of all to the oracle database or the oracle server, can be realized using PLSQL Developer tools to connect to the oracle database.

Link: https://pan.baidu.com/s/1QtMPpv8XxZohdKvUgw1GRQ
The extracted code: lce6

2, download PLSQLDeveloper and extract the


3, configure the environment variables
1) variable name: ORACLE_HOME variable values: E: \ tool_01 \ PLSQL Developer \ instantclient_11_2

2) variable name: TNS_ADMIN variable value: E: \ tool_01 \ PLSQL Developer \ instantclient_11_2

3) variable name: NLS_LANG variable value: SIMPLIFIED CHINESE_CHINA. ZHS16GBK

4) to modify the Path variable, in the back to add E: \ tool_01 \ PLSQL Developer \ instantclient_11_2



Note: according to the path of the corresponding change (1) (2) and (4) the values of the variables, I am the direct decompression under E dish, path is the path, and 3) copy can

4,

Configure the oracle monitor file

Find E: \ PLSQLDeveloper \ PLSQL \ instantclient_11_2 path tnsnames. Ora file, use the editor open (notebook),

According to their own actual need to edit, as shown in the figure below, ORCL_27 is to display the database name, HOST back fill is to connect the address, after editing,



5, open E: \ PLSQLDeveloper \ PLSQL \ PLSQL Developer folder plsqldev. Exe file, right-click and run as an administrator,



6, fill in your user name and password to connect to database, and in the column of the database drop-down list, select you want to connect the database, if in this step can't show the name of the database, do the following step



7,

Click tools - "preferences, as shown in the figure below,

The Oracle home directory name



E: \ tool_01 \ PLSQL Developer \ instantclient_11_2



OCI library



E: \ tool_01 \ PLSQL Developer \ instantclient_11_2 \ oci DLL



Can ~ to restart

CodePudding user response:

Thanks for sharing!

Just: click tools - "preferences, as shown in the figure below,


Where is the picture?