Installing the Oracle Client

You will need the following information from your DBA to install and configure Oracle client software:

  • The TNS Service Name for the database in which your workspace repositories will be stored.

  • The host name for the computer on which the database resides.

  • The port number for communications with the host, if it is not the standard port number.

  • A database user ID and password.

  1. Double-click the setup.exe program for the Oracle client installation. The Welcome screen opens.
  2. Click Next. The Select Installation Type screen opens. Select Custom.
  3. Click Next. The Specify Home Details screen opens. Enter an alternate name and path for the installation, if desired. Otherwise, accept the defaults.
  4. Click Next. The Available Product Components screen opens. Select the following components:
    • SQL *Plus
    • Oracle JDBC/THIN Interfaces
    • Oracle Windows Interfaces. Deselect every choice under Oracle Windows Interfaces except Oracle ODBC Driver.
    • Oracle Call Interface (OCI)
    • Oracle Net
  5. Click Next. The installer checks for prerequisites to ensure your environment meets the minimum requirements for installation. Resolve any flagged items, if necessary.
  6. Click Next. Review the Summary screen to confirm your selections. Use the Back button to correct any errors. When you are satisfied that all the information is correct, click Install.
  7. When installation completes, the Oracle Net Configuration Assistant is launched.
  8. Click Next. The Naming Methods Configuration screen opens. Verify that Local Naming is shown in the Selected Naming Methods field.
  9. Click Next. The Net Service Name Configuration screen opens. In the Service Name field, enter the TNS Service Name for the database your workspace repositories will be stored in. This name is provided by your DBA.
  10. Click Next. The Select Protocols screen opens. Select TCP.
  11. Click Next. The TCP/IP Protocol screen opens. Enter the host name for the computer on which the Oracle database resides. This name is provided by your DBA. Use the standard port number of 1521 unless otherwise instructed by your DBA.
  12. Click Next. The Test screen opens. Select Yes, perform a test.
  13. Click Next. You should receive a message that the test did not succeed. This is because the default login used for the test is the Oracle SYSTEM login. You must change the user name and password to those provided by your DBA.
  14. Click Change Login. In the Change Login dialog, enter the user ID and password provided by your DBA.
  15. Click OK. You should now receive a message that the connection test was successful. If the test remains unsuccessful, click Change Login and confirm that you entered the correct credentials as provided by your DBA. If problems persist, contact your DBA for assistance.
  16. Click Next. The Net Service Name screen opens.
  17. The Net Service Name field is prefilled with the TNS Service Name you specified in Net Service Name Configuration screen. Click Next. The Additional Net Service Names screen opens.
  18. In the Additional Net Service Names screen, configure additional TNS Service Names, one per database instance you need to connect with. This step is optional. Select Yes to configure additional TNS Service Names. Select No to complete the configuration.
    Note: If you need to connect to additional database instances at a later date, you can add TNS Service Names by manually editing the tnsnames.ora file in Repository_Client_HOME. See your DBA for details.
  19. Click Next. Then click Next on the following two screens to complete the Oracle Net Configuration.
  20. On the Oracle Net Configuration completion screen, click Finish to exit the Net Configuration Assistant.
  21. The Oracle Installer window opens Click Exit. You are prompted to confirm that you want to exit. Click Yes.
Parent topic: Installing the Database Client
Related tasks
Configuring an Oracle ODBC Data Source Name