Using Oracle9i

  1. Checking the Oracle Help Pages .

  2. The Server with an IP Address 172.20.4.9 Hosting the Oracle9.2.0i The Oracle9i is hosted on the server 172.20.4.9 using a Sun Solaris OS 5.10. Note that the IP address of this server is not fixed. Once it is changed, this page will be updated.


  3. Logining into the Server 172.20.4.9 Follow the following two steps to login into the server 172.20.4.9:

    1. Login into the shell.aero.und.edu server by using telnet or ssh such as F-Secure SSH Client.
    2. Remotely login into the server 172.20.4.9 by using the following command from the shell.aero.und.edu server: 
         shell> ssh 172.20.4.9
   Password:
    If you have not received an account and a password for the server 172.20.4.9 and Oracle9i, contact the instructor. You need to change your server password by using the command passwd.


  4. Modifying the .profile File The .profile file in your home directory is a collection of Korn shell commands that are executed whenever you login. Commonly, the .profile file is used to set environment variables and shell options. Put the following code in the ~/.profile file:

    ~/.profile 
    ORACLE_BASE=/export/home/oracleuser
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE
export ORACLE_HOME
ORACLE_SID=aero
export ORACLE_SID
PATH=/usr/bin:/usr/ucb:/etc:.
PATH=$PATH:$ORACLE_HOME/bin
export PATH
ORAENV_ASK=NO
. /usr/local/bin/oraenv

    After changing the .profile file, you may exit the server 172.20.4.9 and re-enter it to have the environment variables and shell options set.


  5. Oracle Accounts Oracle accounts and Unix accounts are different. They are valid for only one semester. Save your databases at some other places at the end of each semester.


  6. Logining into Oracle9i Now you can start Oracle applications. The basic Oracle interface is sqlplus, and to start it, enter 
      $ sqlplus  userid/password
  SQL*Plus: Release 9.2.0.1.0 - Production on Sun Dec 30 13:24:00 2007
  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved. 
  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
    You need to change your password with the command: 
      SQL> alter user userid identified by pwpwpwpw;
    where pwpwpwpw is whatever new password you want. Note that, unlike Unix login names and passwords, Oracle account names and passwords are NOT case sensitive.


  7. Exiting from Oracle9i and the Server 172.20.4.9 
      SQL> exit
  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

  $ exit
  Connection to 172.20.4.9 closed.
  shell>