Oracle 8i is not supported
Download 32.41 Kb.
|
- Navigate this page:
- ODBC Configuration for Windows XP and Windows 7 (32-bit)
- ODBC Configuration for Windows 7 (64-bit)
Oracle 10g Client Install Guide
ContentsContents 1 ODBC Configuration for Windows XP and Windows 7 (32-bit) 20 ODBC Configuration for Windows 7 (64-bit) 23
Please be aware that Oracle 10g (recommended) or Oracle 9i is required for SiteManager 3.11a, Oracle 8i is not supported. Windows XP and Windows 7 are both supported starting with this version. SiteManager 3.11a is a 32-bit application. Therefore Windows 7 (64-bit) requires the 32-bit version of Oracle Client and configuration with the 32-bit version of the ODBC Data Source Administrator. TDOT does not manage non-TDOT computers and does not have sufficient security rights to administer shared software like Oracle on non-TDOT computers. However, because Oracle 9i or 10g is required to run SiteManager, we have provided a convenient link to download the Oracle 10g install program and this guide for configuring Oracle to work with SiteManager. Note: Oracle 10g and Oracle 10.2.0.1.0 are two names for the same software and are used interchangeably. SiteManager setup guides are located on the TDOT Construction SiteManager website: http://www.tdot.state.tn.us/construction/SiteManager.htm
Oracle 10g Client Installation To install Oracle 10g client you must login as an administrator on the machine. To download the client from TDOT  
Extract and create folder client_10201 
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. 
Check “Custom” and Click on “Next” 
Give the Name and Path like shown in the screen..and Click “Next” 
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
Then Click “NEXT” 
Then Click “NEXT” 
Click On ‘Install” 
Installation will take few minutes to complete… 
Click on “Cancel” 
Click on “Yes” 
Click on “OK” 
Click on “Cancel” 
Click on “OK” 
Click on “Yes” Then installation has been completed successfully. 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 
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 System DNS>ADD> 
Use Oracle in OraClient10g_home or the 10g from your oracle home path. 
Test Connection test test
 
If your get invalid username/password this is okay the oracle is set up correctly. 
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.
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.
This completes the 32-bit ODBC setup for the 3.11a version of SiteManager Client on Windows 7 (64-bit). Test from a VPN connection: Start/Run open CMD as below:\ 
Look for “OK“message as seen below. This verifies database server is up. 
** If you do not get the ‘OK’ get the sqlnet.ora and ldap.ora files in Utilites.zip   
Delete the install and the ZIP files from your pc c:\client_10201 if the test is okay. 
Page of Directory: assets -> entities assets -> 12 Step Retreats For Everyone in Twelve Step Recovery Ratner Fellowship assets -> 12 Step Retreats For Everyone in Twelve Step Recovery Ratner Fellowship assets -> Sigaccess annual Report assets -> Central Government is expected to ask the seventh pay commission to consider merging 50% dearness allowance assets -> List of accessible executive records assets -> Emergency telephone numbers Call toll-free from anywhere in France entities -> Cross-Systems Crisis Plan entities -> Specifications for Statewide Fleet Vehicle Purchases All Manufacturers rfx 7148 State of Tennessee Department of General Services, Central Procurement Office entities -> Information Technology Download 32.41 Kb. Share with your friends:
|