====== Oracle Client 10g Installation ======
===== Download =====
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]]

===== Instructions =====
  - [[Oracle client uninstall|Uninstall old Oracle]] client versions
  - Insert Oracle 10g install CD or start installation program. \\ {{software:oracle:oracle10gsetup.gif}}
  - In the **Welcome** window, Click **Next**. \\ {{software:oracle:oracle10gnext.gif}}
  - In the **Select Installation Type** window, under "What type of installation do you want?"' choose **Custom**, Click **Next**. \\ {{software:oracle:oracle10gcustom.gif}} {{software:oracle:oracle10gnext.gif}}
  - In the **Specify Home Details** window, ussually **keep the defaults**. Click the Help button for details. Click **Next**. \\ {{software:oracle:oracle10ghomedetails.gif}} {{software:oracle:oracle10gnext.gif}} 
  - In the **Available Product Components** window, **select the below componenets** to be installed ((Others components are ussually not needed on ordinary client setups. They take up disk space and clog up the computer.)). Click **Next**. \\ {{software:oracle:oracle10gcomponents.gif}} {{software:oracle:oracle10gnext.gif}}
    * 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** \\ {{software:oracle:oracle10gnext.gif}}
  - In the **Product-Specific Prerequisite Checks** window, make sure all checks pass. Click **Next**. \\ {{software:oracle:oracle10gnext.gif}}
  - In the **Summary** window, click **Install**. \\ {{software:oracle:oracle10ginstall.gif}}
  - 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. \\ {{software:oracle:oracle10gcancel.gif}} {{software:oracle:oracle10gyes.gif}} {{software:oracle:oracle10gok.gif}}
  - 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! \\ {{software:oracle:oracle10gnext.gif}} {{software:oracle:oracle10gok.gif}}
  - In the **End of Installation** window, click **Exit**. Click **Yes** when the **Exit** window comes up to ask if you are sure. \\ {{software:oracle:oracle10gexit.gif}} {{software:oracle:oracle10gyes.gif}}
  - 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 <code>(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraumbc.mis.umbc.edu)(PORT=1522)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=UMBC.WORLD)))</code>
  - 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
  - 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"

====== Oracle ODBC Windows Setup ======
FIXME Bring images from below document\\
From [[\\sharedvol.ad.umbc.edu\Dept\Grads\Information Technology\Documentation]]

  - Set up ODBC system connection to SIS for “In-House Access Systems”
(Graduate Admissions Only)
    - Open Administrative Tools from Control Panel
    - Open Data Sources (ODBC)
    - Open System DSN tab
    - ‘Add…’ a data source
    - Select Oracle in OraClient10g and finish (see screen shot below)
  - Configure and Test from setup info below
    - 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>
    - 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