Oracle Database 10g Client Release 2 for Microsoft Windows (32-bit):

• http://www.oracle.com/technology/software/products/database/oracle10g/index.html
• \\sharedvol.ad.umbc.edu\Dept\Grads\Information Technology\Software\Oracle\Client 10g\Oracle_10g_201_client_win32.zip

1. Uninstall old Oracle client versions
2. Insert Oracle 10g install CD or start installation program.
   
3. In the Welcome window, Click Next.
   
4. In the Select Installation Type window, under “What type of installation do you want?”’ choose Custom, Click Next.
   
5. In the Specify Home Details window, ussually keep the defaults. Click the Help button for details. Click Next.
   
6. In the Available Product Components window, select the below componenets to be installed 1). Click Next.
   
   • SQL*Plus
   • Oracle ODBC Driver
     Note: You must select Oracle Windows Interfaces, and unselect everything else under it.
   • Oracle Net 10.2.0.1.0 Click Next
     
7. In the Product-Specific Prerequisite Checks window, make sure all checks pass. Click Next.
   
8. In the Summary window, click Install.
   
9. If the Oracle Net Configuration Assistant window comes up, click Cancel. Click Yes, when it asks if you are sure. Click OK when the Error window comes up to tell you that some configuration assistants failed. This is what we want. Do not bother with any ‘Net Configuration’ settings. These will be set manually by us in the next steps.
   
10. In the Configuration Assistants window, click Next. Click OK when the Error window comes up to tell you that some configuration assistants were not completed. Again, we do not need to set any settings with a wizard interface. We are geeks, we do it manually Yes, yes you are geeks!
    
11. In the End of Installation window, click Exit. Click Yes when the Exit window comes up to ask if you are sure.
    
12. Update client with sqlnet.ora and ldap.ora files (These files originally came from UMBC DBA Todd Haddaway.)
    \\sharedvol.ad.umbc.edu\Dept\Grads\Information Technology\Software\Oracle\NETConnections
    The Oracle Descriptor for the UMBC SIS is

    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraumbc.mis.umbc.edu)(PORT=1522)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=UMBC.WORLD)))

13. Put the above files into the \NETWORK\ADMIN directory of Oracle’s base install.
    • For example, C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
14. Test that the connection is working by opening the newly installed SQL Plus application. Look in the windows Start>All programs>oracle 10g>Application Development menu for this
    • Remember to login to VPN first
    • User name and password are your Oracle shadow SIS credentials
    • Host String is “umbc”

Bring images from below document
From \\sharedvol.ad.umbc.edu\Dept\Grads\Information Technology\Documentation

1. Set up ODBC system connection to SIS for “In-House Access Systems”

(Graduate Admissions Only)

1. Open Administrative Tools from Control Panel
2. Open Data Sources (ODBC)
3. Open System DSN tab
4. ‘Add…’ a data source
5. Select Oracle in OraClient10g and finish (see screen shot below)
6. Configure and Test from setup info below
7. Add Shadow SIS ODBC connection for resources that access the SIS’s converted-to-oracle shadow database, if needed. (UserID, TNS, and Desc all the same)
   • Data Source Name: graduate
   • Description: shadow sis connection (whatever you want)
   • TNS Service Name: umbc
   • User ID: <valid oracle user id - get from OIT>
   • Password: <corresponding password>
8. Add Paradocs ODBC connection for resources that access the ParaDocs database backend, if needed. (UserID, TNS, and Desc all the same)
   • Data Source Name: paradocs
   • Description: paradocs (whatever you want)
   • TNS Service Name: paradocs
   • User ID: paradocs
   • Password: paradocs1