Databases

NCSU provides access to several database clients via AFS addable lockers. To access these tools, ssh to a solaris or linux box and then type add dbtools. This should give you access to mysql and sybase client tools. To access the Oracle sqlplus client, type add oracle (for version 9) or add oracle10g (for version 10g). For more information about Oracle logins to CSC Oracle server see: http://www.csc.ncsu.edu/techsupport/technotes/oracle.php

Setting up a RHEL server with the Oracle instant Client

  1. Download oracle-instantclient-basic-10.2.0.4-1.i386.rpm and oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm from http://www.oracle.com/technology/products/database/oracle10g/index.html One has a dependency on the other.
  2. Download the perl-DBD-Oracle-1.19-1.el5.i386.rpm
  3. Install both instantclient rpms mentioned in step 1
  4. Set up your instantclient environment variables as follows:
    • Add the name of the directory containing the Instant Client libraries to LD_LIBRARY_PATH:
      LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib:${LD_LIBRARY_PATH}
      export LD_LIBRARY_PATH
    • Set SQLPATH to the directory containing glogin.sql:
      SQLPATH=/usr/lib/oracle/10.2.0.4/client/lib:${SQLPATH}
      export SQLPATH
    • If you want to use Net Service Names configured in a local Oracle Net tnsnames.ora file:
      TNS_ADMIN=/usr/lib/oracle/10.2.0.4
      export TNS_ADMIN
  5. Install the perl-DBD-Oracle rpm you downloaded in step 2. If it complains about dependencies type:
    rpp -ivh perl-DBD-Oracle-1.19-1.el5.i386.rpm --nodeps
  6. to test your sqlplus environment variables type which sqlplus  and it should return /usr/bin/sqlplus
  7. to login, type sqlplus
  8. enter username@orcl.world
  9. password

For additional information check