Using Oracle from Steel

The DMS instructional Oracle server is installed on a separate dedicated database server machine. Individuals who want to connect to the Oracle server from a Unix environment need to get a Unix account on steel (a cluster of four Sun UltraSPARC workstations running Solaris 8). Steel has the Unix version of the Oracle client installed on it.

What you need to use Oracle from Steel:

• Acquire a Steel Unix account if you don't already have one. Point your Web browser (which must support secure authentication) to the Network ID Services page:
  
  http://iuaccts.ucs.indiana.edu
  
  Network ID Services will require you to log in with your Network ID username and password. Once you are logged in, select the first option, "Create accounts on the UITS computers (e.g., e-mail, file lockers)." From there, follow the instructions.
  
  All IU students, staff, and faculty may have accounts on Steel.



• Connect to your UNIX account on Steel using SSH Secure Shell Client.
  
  The SSH2 client software licensed by Indiana University is SSH Communications Security SSH Secure Shell. If you are an IU student, staff member, or faculty member, you can download SSH Secure Shell from the IU Information Technology Security Office (ITSO) Web site at:
  
  https://www.itso.iu.edu/services/ssh/



• Modify your Steel environment:
  
  This page assumes that you have basic knowledge on using UNIX, UNIX shells, and setting environment variables. If you are not familiar with modifying your .cshrc or .profile files, consult with your instructor or your department's computing support provider.
  
  
  For c-shell or t-shell users, add the following lines into your .cshrc file after the existing set path=line:
  
  setenv ORACLE_HOME /usr/local/app/oracle/home
  set path=($ORACLE_HOME/bin $path)
  setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
  
  
  For b-shell or k-shell users, add the following lines to your .profile file, after the existing PATH line:
  
  ORACLE_HOME=/usr/local/app/oracle/home; export ORACLE_HOME
  PATH=$ORACLE_HOME/bin:$PATH; export PATH
  LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
  



• To make your new environment variables take effect, re-login into your Steel account and you are ready to use Oracle from Steel .

Logging into Oracle for the first time:

• At your UNIX shell prompt type: sqlplus


• When prompted for your user-name type: username@database (example: dms@oed1)


• Enter your password


• To change your password, at the SQLPlus prompt type: PASSWORD


• You will be prompted to type your old password and your new password, and then to retype your new password