Detailed instructions on installing and configuring the Oracle 10g Client

Oracle 10g ClientThe installation configuration is very important for Oracle users. installing and configuring the Oracle client properly will bring great convenience to our work. This article describes how to install and configure the Oracle 10g client.

1. Configure the listener for the Oracle server

Modify the listener. ora and tnsnames. ora files in the <installation directory>/network/admin/directory. Where

The listener file is roughly as follows:

 
 

  
  
# Listener. ora Network Configuration File:/oracle/app/product/10.1.0/db_1/network/admin/listener. ora
  
  
# Generated by Oracle configuration tools.
  
  
SID_LIST_LISTENER =
  
  
(SID_LIST =
  
  
(SID_DESC =
  
  
(SID_NAME = PLSExtProc)
  
  
(ORACLE_HOME =/oracle/app/product/10.1.0/db_1)
  
  
(PROGRAM = extproc)
  
  
)
  
  
(SID_DESC =
  
  
(GLOBAL_DBNAME = demo1) # demo1 is the oracle Instance name
  
  
(ORACLE_HOME =/oracle/app/product/10.1.0/db_1)
  
  
(SID_NAME = demo1)
  
  
)
  
  
)
  
  
LISTENER =
  
  
(DESCRIPTION_LIST =
  
  
(DESCRIPTION =
  
  
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521) # The ip address is the oracle server.
  
  
)
  
  
)
 
 

The tnsnames. ora file is roughly modified as follows:

 
 

  
  
# Tnsnames. ora Network Configuration File:/oracle/app/product/10.1.0/db_1/network/admin/tnsnames. ora
  
  
# Generated by Oracle configuration tools.
  
  
DEMO1 =
  
  
(DESCRIPTION =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521) # The ip address is the oracle server.
  
  
(CONNECT_DATA =
  
  
(SERVER = DEDICATED)
  
  
(SERVICE_NAME = DEMO1) # demo1 is the name of the oracle instance, or the service name can be modified through netmgr or netca.
  
  
)
  
  
)
  
  
EXTPROC_CONNECTION_DATA =
  
  
(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
  
  
)
  
  
(CONNECT_DATA =
  
  
(SID = PLSExtProc)
  
  
(PRESENTATION = RO)
  
  
)
  
  
)
 
 

The preceding modifications can also be configured through netmgr and netca on the graphic interface. After modification, restart the listener.

2. download and install the oracle client.

On the local machine where pl/SQL developer is installed, the oracle client must be installed. Here, the pointer is for the oracle 10 GB version. In other words, you can only install the relevant driver, such as the oci driver,

Details are not available. And the client is not necessarily set to 10g, 8i, 9i ).

1. Download the green version client from the official website. The address is as follows or changed ):

Http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Oracle users are required for downloading and can register for free.

2. You do not need to install the green version. Download and unzip the package to a specific place, and create a network directory under it. Then, create the admin directory under the directory. The structure is as follows:

<Client directory>/network/admin: Create the tnsnames. ora file in the admin directory. The content is roughly as follows:

 
 

  
  
Demo1 = # oracle service name
  
  
(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521) # oracle server ADDRESS and PORT
  
  
)
  
  
(CONNECT_DATA =
  
  
(SERVICE_NAME = demo1)
  
  
)
  
  
)
 
 

3. Configure the client information in PL/SQL developer.

Open PL/SQL developer and do not log on. Choose tools> preferences> connection and set the following items:

Oracle Home: D: \ Program Files \ instantclient_11_1 # extract the directory from the client.

OCI library: D: \ Program Files \ instantclient_11_1 \ oci. dll # oci library file path. oci. dll should be in the client directory.

Save and restart PL/SQL developer. You can see the "demo1" service instance on the remote server you Just configured in the "Database drop-down" option of the logon box.

This section describes how to install and configure the Oracle 10g client.