How to Connect to Legacy Oracle Instances

Procedure

  1. Login to any CSE 64-bit Linux system (a system whose OS=Linux and whose Processor=x86_64).
  2. Set the ORACLE_HOME environment variable:

    % setenv ORACLE_HOME /util/oracle-10g
    

  3. Add the Oracle client library to your LD_LIBRARY_PATH environment variable:

    % setenv LD_LIBRARY_PATH ${LD_LIBRARY_PATH}:/util/oracle-10g/lib
    

  4. Which Oracle instance would you like to connect to? Set the Oracle TWO_TASK environment variable with syntax:

    % setenv TWO_TASK [ multidb | oraserve ]
    

  5. Connect to the Oracle service with the Oracle 10g sqlplus client:

    
    % /util/oracle-10g/bin/sqlplus
                               
    SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 9 16:15:33 2009
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    Enter user-name: cwmiller
    Enter password: 
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    
    SQL> 
    
    

  6. When you're done, quit:

    SQL> quit
    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production