Install Oracle-client

Instructions on how to install the Oracle client

Installation of Oracle client


In order to access an Oracle database from a Windows machine, an Oracle client needs to be installed. The Oracle client installation files are located at P:\site\oracle. To install the client (on Win7 64bit):

  1. Open a 'cmd'-window with 'Run as administrator'. Fill in the administrator credentials. Make sure the the M- and P-drives are mounted properly 
  2. Navigate to P:\site\oracle\Client_<version>\<version>\client
  3. Run setup.exe
  4. Choose 'Administrator' as the 'Installation type'. For the 'Installation location' use C:\oracle. In the 'Summary' window, click 'Install'
  5. Click 'Close' to fullfill the installation

Client configuration


After installation, the client needs to be configured:

  1. Login as the user who will access the database
  2. Navigate to Start -> All Programs -> Oracle - OracleClient<version>_home1 -> Configuration and Migration tools -> Net Configuration Assistant
  3. Login with administrator credentials
  4. Select 'Local Net Service Name configuration' and click 'Next'
  5. Select 'Add' and click 'Next'
  6. Enter the service name. This is usually in the form of <a certain name>.uio.no (see below).
  7. Select 'TCP' and click 'Next'
  8. Enter the hostname and the port number (see below) and click 'Next'.
  9. You could test the connection, but this is not necessary.
  10. For the net service name, choose the default and click 'Next'
  11. Click 'Next' several times until finished.
  12. Finally, send an e-mail to oracle-drift@usit.uio.no to register the IP-addresse of the user's machine for accessing the necessary database service (GEOPRD.UIO.NO)

Services at the Department of Geosciences, UiO


Service name GEOPRD.UIO.NO
Hostname dbora-prod04.uio.no
Port 1593

 

 

 

 

 

 

 

Tags: database, Oracle, client By Michel Heeremans
Published Sep. 26, 2016 1:02 PM - Last modified Sep. 26, 2016 1:10 PM