Oracle Client Install Guide

(1)

Oracle 10g Client Install Guide

1. Follow the Oracle 10g Client Install directions on page 2.

2. Setup Oracle for SiteManager using the directions on page 19

3. Configure ODBC using the instructions that match your operating

system on page 20 or page 23

4. If you will use VPN to connect to TDOT, test your connection using

the instructions on page 28

(2)

Oracle 10g Client Installation

To install Oracle 10g client you must login as an administrator on the machine. To download the client from TDOT

(3)

After completion Double click on the setup.exe to install Oracle 10g client. A screen will come up titled “Oracle Universal Installer” Choose Next to install the client.

(4)

(5)

Check “Custom” and Click on “Next”

(6)

(7)

(8)

Check mark for the below features(Shown in the above screens): Oracle Client 10.2.0.1.0

- Oracle Database Utilities 10.2.0.1.0 - SQL*Plus 10.2.0.1.0

- Oracle Windows Interfaces 10.2.0.1.0 - Oracle ODBC Driver 10.2.0.1.0 - Oracle Programmer 10.2.0.1.0

- Oracle Net 10.2.0.1.0

(9)

Then Click “NEXT”

(10)

(11)

Installation will take few minutes to complete…

(12)

(13)

Click on “Cancel”

(14)

(15)

Click on “OK”

(16)

(17)

Click on “OK”

(18)

Click on “Yes”

(19)

Oracle Setup for Site Manager

*******

Copy C:\client_10201\client “sqlnet.ora“And “ldap.ora” See Page 29 for how to get these files.

TO: C:\Oracle\product\10.2.0\client\NETWORK\ADMIN folder

(20)

ODBC Configuration for Windows XP and Windows 7 (32-bit)

ODBC Settings:

Navigate to: start > Control Panel > Administrator Tools> Data Sources (ODBC)> System DSN

***Remove the any old - PSMR ODBC from previous versions****

On the ‘Create New Data Source’ screen. Do this test in a VPN session

(21)

Test Connection

test test

(22)

(23)

ODBC Configuration for Windows 7 (64-bit)

SiteManager Client 3.11a requires that a 32-bit version of Oracle Client (10g is recommended) must be installed on the Windows 7 (64-bit). Windows 7 (64-bit) comes with both the 32-bit and 64-bit ODBC Administrator. The ODBC connection for the SiteManager Client must be configured in the 32-bit ODBC Administrator.

This section of the installation guide will walk you through how to setup the ODBC connection in the 32-bit ODBC Administrator for New SiteManager Client installs.

1. Select the Start Button

2. Open Administrative Tools, Right Click on Data Sources (ODBC), and Select Properties.

(24)

3. Rename the Data Source on the General Tab of the Properties Dialog Box to Data Source (ODBC 32

(25)

4. Select the Shortcut Tab on the Properties Dialog Box.

5. Edit the Target Field with %windir%\SysWOW64\odbcad32.exe.

(26)

6. Edit the Start in Field with %windir%\SysWOW64. 7. Select OK to close the Properties Dialog Box.

Note: The 64-bit version of the ODBC Data Source Administrator will have the “Target” set to %windir %\System32\odbcad32.exe and the “Start in” set to %windir%\System32.

(27)

8. Open the ODBC Data Source Administrator from Administrative Tools 9. Select the Drivers Tab, scroll down until you see Oracle in OraClient X

a. This will indicate to you that the correct ODBC Administrator is now being used.

(28)

10. Select the Systems DSN 11. Add a new ODBC for PSMR.

(29)

Test from a VPN connection:

Start/Run open CMD as below:\

1. C:\> tnsping psmr

Look for “OK“message as seen below. This verifies database server is up.

(30)

(31)

Delete the install and the ZIP files from your pc c:\client_10201 if the test is okay.