Assignment 6
INSTALLATION OF ORACLE 8 SERVER Release 3.0.2
(Travis Angle, Adam Fuller, Roger Smith, Rajiv Zutshi)
Introduction & Summary: (Travis Angle)
Oracle is a object/relational database server that has a large and flexible architecture. Our install was for the Oracle 8 server. Oracle is the most widely used database in the world and will run on just about any kind of computer. Oracle Corp. is the largest supplier of software for information management, and the world's second largest software company. This database server we installed will allow for client/server connectivity in order to implement and maintain a functional and robust system. The Oracle 8 server is host-based (which means that users are connected directly to the same computer on which the database resides) and has the capability of connectivity via the web through open database connectivity (ODBC). This is especially important in a distributed systems environment. The most important functions of the database is distributed processing (users ability to access the database that is spread out on more than one computer), and web-enabled computing, which is the ability to access data from an internet-based application. Other benefits of the Oracle server include security, backup and recovery, space management, and compatibility with a wide range of development tools. Oracle is the most robust and finely tuned database server on the market today.
NB - the ORACLE 8 Beginner's Guide was used in providing information in this introduction
Narrative: (Adam Fuller & Roger Smith)
CD-ROM INSTALL
Installation Process for Oracle 8 Server, Release 3.0.2 for Linux
Before we began the installation process, we mounted the CD as root
mount /mnt/cdrom
1. Check memory allocation
ipcs
2. Created mount points
mkdir u01 u02 u03 u04
3. Mount cdrom
mount /mnt/cdrom
4. Create dba group
pico /etc/group
dba:x:600:oracle
5. Added User named oracle
useradd -u 1002 -g 600 -d /home/oracle -s /bin/tcsh oracle
6. Set oracle's passwd
passwd oracle
password
7. Had to change shell from bashrc to tcshrc. Copied .tcshrc was running in root to
home/oracle and we killed the bashrc shell that was running there. We then changed owner
and group owner of the shell to oracle.(chown oracle.dba .tcshrc).
8. Changed owner to oracle
chown oracle .tcshrc
9. Changed group to dba
chown oracle.dba .tcshrc
10. Tried to run the /mnt/cdrom/orainst/oratab.sh script receeved error "command not
found."
11. Typed head oratab.sh and saw the path was /usr/bin/sh. The correct path was /bin/sh
12. Created link from /usr/bin/sh to /bin/sh.
ln -s /bin/sh /usr/bin/sh
13. Set ORACLE_OWNER to oracle
setenv ORACLE_OWNER oracle
14. ran mnt/cdrom/orainst/oratab.sh.
15. Verified oratab had been created in /etc.
16.changed user to oracle.
su oracle
17.had to set unmask to 022
umask 022
18. Set oracle enviornment variables in the .tcshrc file
setenv ORACLE_HOME /u01/app/oracle/product/8.0.5
setenv LD_LIBRARY_PATH /u01/app/oracle/product/8.0.5/lib
setenv ORACLE_BASE /u01/app/oracle
setenv ORACLE_SID orfr
setenv ORACLE_TERM vt100
setenv ORACLE_NLS33 /u01/app/oracle/product/8.0.5/ocommon/nls/admin/data
setenv PATH /u01/app/oracle/product/8.0.5/bin
setenv TMPDIR /tmp
Verified correctness of .tcshrc by typing source .tcshrc.
19. As oracle user we ran orainst.
cd /mnt/cdrom/orainst
./orainst
20. Ran default install.
21. established database mount points of u02, u03, u04 during installation. u01 was the
software mount point
Oracle Script File
Functionality: (Rajiv Zutshi)
To test the functionality of the system we became the oracle user and executed the following commands
SVRMGR> SELECT OWNER,TABLE_NAME,TABLESPACE_NAME FROM DBA_TABLES WHERE OWNER='POLLY';
OWNER
TABLE_NAME
TABLESPACE_NAME
------------------------------ ------------------------------
------------------------------
POLLY
ALOHA
TOOLS
POLLY
A_HUNDRED
TOOLS
POLLY
A_INTEGRITY_TEMP
TOOLS
POLLY
A_SAVEUPDATES
TOOLS
POLLY
A_SEL100RAND
TOOLS
POLLY
A_SEL100SEQ
TOOLS
POLLY
A_TENPCT
TOOLS
POLLY
A_TINY
TOOLS
POLLY
A_UNIQUES
TOOLS
POLLY
A_UPDATES
TOOLS
10 rows selected.
SVRMGR>