Skip to end of metadata
Go to start of metadata

Install Oracle

  1. Navigate to destination on the server and launch the setup.exe option.
  2. Click the Next button.
  3. Make sure the “Administrator” option is selected and click Next.

  4. Ensure the name and the path are the same as above and click Next.

    If using 64bit OS it should come back with an error for the Operating system requirements and the service pack requirements. 
  5. Check the box and click Next.
  6. Click Yes
  7. Click Install and allow Oracle to Install..

  8. Exit the installation.

Configure Oracle's settings.


  1. Click Start > All Programs > Oracle-OraClient11g_home1 > Configuration and Migration Tools > Net Configuration Assistant.
  2. Select or type what is shown on the screenshots below and click Next.

  3. Note the server names for other databases:
    1. ODSPROD - Atlas
    2. TEST8 - Smokey

  4. Have the user enter their PROD credentials.

  5. Click Next and exit setup.

Now you need to launch the ODBC Data Source Administrator tool.

  1. Windows running 32-bit OS should just be able to click start and in the search box type "Microsoft ODBC Administrator"
  2. Windows running 64-bit OS will have to go to Computer > C: drive > Windows > SysWOW64 > odbcad32.exe
  3. Once you have opened the administrator tool go to the System DSN tab.

  4. Click Add.

  5. Click Oracle in OraClient11g_home1 and then click Finish.

  6. Type PROD in both Data Source Name and TNS Service Name. 
  7. Click OK and exit the admin tool.

Check your set up

  1. Open Exel and select the Data tab.
  2. Click on From Other Sources tab.
  3. Click From Microsoft Query. In the box that comes up you should see PROD as a Database option.


For questions or comments, contact the Computer Services Help Desk