Shulou(Shulou.com)06/01 Report--

To facilitate the project team developers to use the oracle11g RAC database, install a client and configure PLSQL to access the database server.

Download the following three packages from oracle:

Instantclient-basic-win32-11.2.0.1.0.zip, this is the core package.

Instantclient-jdbc-win32-11.2.0.1.0.zip package containing JDBC Driver

Instantclient-sqlplus-win32-11.2.0.1.0.zip 's simplest SQLPLUS package

First, extract the three compressed package files to the oracleclient under the root of disk D (or the specified directory under other disks)

The final file structure should be as follows:

two。 Configure tnsnames.ora, and if you don't have oracle installed on this machine, you can copy a (tnsnames.ora file) from the server where oracle is installed.

(the file is under $ORACLE_HOME/network/admin) put it in the directory D:\ oracleclient above. The content of tnsnames.ora is:

# tnsnames.ora Network Configuration File: / s01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac-scan) (PORT= 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = prod)

)

)

3. Add an environment variable named TNS_ADMIN to my computer-Properties-Advanced system Settings-environment variable with the value of the path where the tnsnames.ora file is located (e.g. D:\ oracleclient), in order to be able to find the tnsnames.ora mentioned above. If ORACLE is installed on this machine and the ORACLE_HOME environment variable is set, the tnsnames.ora file is automatically looked up under the $ORACLE_HOME/network/admin/ location.

4. Set the language of ORACLE and add the registry key: "NLS_LANG=SIMPLIFIEDCHINESE_CHINA.ZHS16GBK", located at HKEY_LOCAL_MACHINE\ SOFTWARE\ ORACLE. If ORACLE is not installed on this machine, there is no "ORACLE" under HKEY_LOCAL_MACHINE\ SOFTWARE\. You need to create it manually, and then create the key NLS_LANG under ORACLE. The key value is: SIMPLIFIEDCHINESE_CHINA.ZHS16GBK.

That's it. The name of the database you want to connect to is usually the same as the name of SERVICE_NAME.

5, download and install PL.SQL.Developer and configure the application

Open PLSQL and configure tools- > preferences- > connection

Fill in the corresponding content

Oracle Home (empty is autodetect) = D:\ OracleClient

OCI library (empty is autodetect) = D:\ OracleClient\ oci.dll

The box of □ Checkconnection should be √.

Note: after the Oracle tool PL/SQL Developer logs in, it is often disconnected automatically, which is very inconvenient to use. Setting "check connection" can solve this problem.

6. If you open plsql again, you will have the prod option in database. Enter the corresponding user name and password and corresponding role permissions to log in.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.