Access Oracle Server
a. Using Oracle Client.
Download Oracle9i Database
Client for Microsoft Windows 98/2000/NT/XP and install it on your home computer. Installation is pretty
straight forward (chose ). After the installation you need to configure the network settings. Network
Configuration Assistant will start automatically just follow instructions on the pictures:
Now you can start SQL+. Click Start/Programs/Oracle OraHome92/Application Development/SQL Plus. Enter your login name and password and the Net Service Name you've chosen.
b. Connecting to the IST server.
Using any SSH Client connect to the IST server ist.marshall.edu using
your Marshall login name and password. Once you connected to the Linux server run sqlplus
to connect to the Oracle server:
ist:~/> sqlplus
SQL*Plus: Release 9.0.1.0.0 - Production on Mon Aug 26 18:37:12 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Enter user-name: your_login_name
Enter password: get your password from the teacher
If you connected successfully you'll see SLQ+ prompt. Immediately change your password by running:
SQL> alter user your_login identified by "your_new_password";
User altered.
Recall from last semester.
Entity-Relationship Model
Functional Dependencies
Normalization