Slide 10.8: Database accessing embedded in Java host language (JDBC)
Slide 10.10: Using JDBC on the server shell
Home

Using Oracle9.2.0i on the Server with an IP Address 172.20.4.9


  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>