Installation
1) To install the Oracle 10G client code click the link below which will bring you to the zip file:
2) Execute the Setup.exe program and follow the dialogs below
Figure 1 Depress the Next Button
Figure 2 Select the Runtime Button and Depress Next
Figure 3 Keep the Default Name and Path, Depress the Next Button
Figure 4 Depress the Next Button
Figure 5 Depress the Next Button When Completed
Figure 6 Depress the Next Button
Finally depress the Finish button when the installation finishes.
Configuration:
Oracle Directory
Naming method for Database Connections
With the new version of Oracle, Oracle 10g, ECG is requiring Oracle Directory Naming for connection to Oracle databases. ECG manages more than 60 databases on many servers which are high-availability RAC clusters. High availability requires dynamic database location information. Oracle’s Directory Naming method allows ECG to provide this dynamic database location information. When ECG adds, removes or moves a database the directory will provide dynamic information to users and applications for this location change. Below is a description of how to configure your desktop to use Oracle directory naming; a requirement of all ECG databases that are 10g databases.
- Login into the ECG VPN you normally login to when accessing ECG supported applications such as BANNER Finance/HR (BPRD) and BANNER Student (PROD).
- Select Start and run on your local desktop.
- Enter \\ecglib\public$ into the dialog box.
- Copy the LDAP.ORA file and the SQLNET.ORA file to your local desktop into the following folder:
ORACLE/network/admin
Note: your local folder’s full path maybe different than above, you just need to find where the network/admin subdirectory is and place copies of the two aforementioned files in the ADMIN subdirectory. And example of a different full patch is shown below:
Example: C:\oracle\product\10.2.0\client_2\network\ADMIN