Slide 13.11: Using Oracle9.2.0i at the server with an IP address 172.20.2.253

Slide 13.10: Web hosting
Slide 13.12: Using CGI at the shell server
Home

Using Oracle9.2.0i at the Server with an IP Address 172.20.2.253

The Server with an IP Address 172.20.2.253 Hosting the Oracle9.2.0i The Oracle9i is hosted at the server 172.20.2.253 using a Sun Solaris OS 5.10.

Logining into the Server 172.20.2.253 Follow the following two steps to login into the server 172.20.2.253:
1. Login into the shell.aero.und.edu server by using telnet or ssh such as PuTTY.
2. Remotely login into the server 172.20.2.253 by using the following command from the shell.aero.und.edu server:
```
   shell> ssh 172.20.2.253
   Password:
```
If you have not received an account and a password for the server 172.20.2.253 and Oracle9i, please contact the instructor. You need to change your server password by using the command passwd.

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.2.253 and re-enter it to have the environment variables and shell options set.

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.

Logining into Oracle9i Now you can start Oracle applications. The basic Oracle interface is sqlplus, and to start it, enter
```
  $ sqlplus
```
You can 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.