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
1. logged into the server manager
svrmgrl
2. connected as INTERNAL which is an alias for the SYS user name and SYSDBA privilege
connect internal
3. shutdown the oracle instance (ormg). This killed all the oracle processes
shutdown
4. restarted the oracle instance
startup
5. connected to the default user that was supplied to us.
connect scott/tiger
6. executed SQL statements on some default tables created during the installation process:
a) obtained a list of tables created by user "scott"
select table_name from user_tables;
b) ran a select statement that outputted some values residing in the table.
select * from bonus;
7. As the system manager we checked to see what  tables were created by user polly.


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>