Oracle 8.0.5.0.0 on RedHat Linux 5.2

Oracle 8.0.5.0.0 Installation on RedHat Linux 5.2 Installation

The following work should be done as root :

Some work needed to be done for organizational purposes on the machine first. This consisted of the following :

I usually patch the operating system before installing Oracle, but on the Linux releases, there is so much variation, that I skipped this step. I will research later and see what is needed. I also know that I will be upgrading this server to version 6.0 soon, so I will handle all patches then.

In addition, I usually tune many kernel parameters, but being new to Linux, I would rather see what is needed.

We will simply start by downloading the release of Oracle 8.0.5.0.0 from their website, and untar into /oracle/Install. I have created a seperate filesystem, called /oracle, of 1 Gb size, to house this stuff. I find that after untarring into /oracle/Install, and installing the database, I have only 5% free. So I deleted /oracle/Install when finished.

These are some other steps that I perform when setting up a Unix box. Some will be realized much after the install, and some much quicker. These next few are certainly not mandatory, but make life easier in the long run.

Create a directory called /usr/local/bin, which will hold local binary or executable files/scripts for local SCO machine.
Modify roots /.profile, to set interrupt key, and path’s.

We dont need to load the compiler because it is already there in this release.

Now for some setup pieced need to install oracle :

Create "dba" group thru linuxconf utility
Create "oper" group thru linuxconf utility (Note that in this release, and I dont know why, the Oracle Installer would not let me change the group to this, so this is really unneccessary).
Create "oracle" user thru scoadmin utility - member of dba group.
Find a home for oracle software - I chose /oracle
Find a name for the SID of the new database - I chose "rhl8" for Unix platform and Oracle version (RedHatLinux8)
Setup umask and ulimit, so that umask=022 and ulimit is large enough to allow files for install.

For orainst, we must setup the oracle environment specially like this :

##### ##### Ulimit is measure in blocks, and this equates to 2gig which is ##### largest file size available in 32 bit. ##### #umask 022 #ulimit 4194303

##### ##### The following lines added by Paul A. Luzzi on 12-10-97 ##### Needed for oracle and oracle installer specifically. ##### ORACLE_HOME=`/bin/grep oracle /etc/passwd | /bin/awk -F: '{print $6}' ` ORACLE_BASE=$ORACLE_HOME ORACLE_DOC=$ORACLE_HOME/doc ORACLE_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/lbin:/usr/local/bin ORACLE_SID=rhl8 ORACLE_TERM=386u ORA_CSM_MODE=line LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export ORACLE_HOME ORACLE_BASE ORACLE_DOC ORACLE_SID ORACLE_PATH ORACLE_TERM \ ORA_CSM_MODE LD_LIBRARY_PATH unset SRCHOME unset TWOTASK

Make sure you are logged in as root.
set ORACLE_HOME=/oracle and export it
mkdir $ORACLE_HOME/orainst $ORACLE_HOME/bin and $ORACLE_HOME/doc and /var/opt/oracle
chown oracle $ORACLE_HOME/orainst $ORACLE_HOME/bin $ORACLE_HOME/doc /var/opt/oracle
chgrp dba $ORACLE_HOME/orainst $ORACLE_HOME/bin $ORACLE_HOME/doc /var/opt/oracle
chmod 775 $ORACLE_HOME/orainst $ORACLE_HOME/bin $ORACLE_HOME/doc /var/opt/oracle
set ORACLE_OWNER=oracle and export
edit /etc/group, and MAKE SURE that oracle is listed in the dba line.
root must run the /oracle/Install/orainst/oratab.sh to setup that file PRIOR to installation of the database, or it will fail.
Now exit out and login as oracle

The following work should be done as oracle :

cd /oracle/Install/orainst
set your DISPLAY variable and export (also not needed on Linux, because they dont support the motif installation)
If you happen to be on the console, use an xterm like below, but if on a remote pc’s xterm like I was, you need to do nothing.

exec ksh -o vi
xterm -sb -sl 10000 -fn 6x13 &

Run the oracle installer in motif mode by typing : ./orainst from the /oracle/orainst directory
./orainst (options are as follows)

Choose custom install
OK to preamble.txt
OK to readme.first
Install new product - create DB objects
Change/make sure that ORACLE_BASE=/oracle
Change/make sure that ORACLE_HOME=/oracle
Accept defaults for all log files
Choose install from staging area of /oracle/Install
Accept SID name from our pre-set environment
Select America/English since we wont need all languages
	(Write down the location of the postinstall script - s/b /oracle/orainst/root.sh)

Products to install are :

Client Software 8.0.5.0.0
TCP/IP Protocal Adapter 8.0.5.0.0
Oracle Intelligent Agent 8.0.5.0.0
Oracle Unix Installer 4.0.3.0.0
Oracle Server Specific Documentation 8.0.5.0.0
Oracle8 Standard (RDBMS) 8.0.5.0.0
PL/SQL 8.0.5.0.0
SQL*Plus 8.0.5.0.0

Totals are 259 Mb in 9 products.

Select Install from the button between the two windows. (This will actually launch some dependency checks and eventually the installer itself.

Click on "OK" to accept the message about the ulimit.  That is "OK" because we already set it.
"dba" will be unix group name for dba’s.
select "dba" for OSOPER group since you cant select "oper"
Choose filesystem type for database (Very Important !!!!)
Yes to distribute the control files over 3 mount points if possible, but on single disk machines, choose no.
Mount Point will be /oracle
Character set is US7ASCII
Select system password of "******" and confirm
Select sys password of "******" and confirm
choose "YES" to change/set the internal password
Select "******" for internal password and confirm
choose 1 concurrent dba users
select "******" for tns password and confirm
select "NO" to configure MTS listener
select "YES" to create control files as named.
Select "OK" to options on size of files.
Select "YES" to accept defaults for tablespace sizes and locations.
Select "YES" to accept all of these choices
select "YES" to load SQL*Plus help facility
select "NO" to load SQL*Plus demo tables
Accept preset default for DOC directory
Select HTML for documentation format.

That will begin the installation ! This should take you straight thru to completion. Any errors at all will require out of the ordinary troubleshooting and are therefore not covered in this manual.

At this point, the installation should basically be complete. You will need to take care of a few other post install steps. They follow.

The following work should be done as root (again) :

run the root.sh scripts located in the /usr1/oracle/orainst directory.

Choose a directory of /usr/local/bin for the local bin directory.
Answer OK for ORACLE_OWNER, ORACLE_HOME, and ORACLE_SID

Reboot the machine, by typing "cd / ; shutdown -g0 -y -i6"

Now go and add any users to the system that need to be dba users. They must be members of the "dba" group by default, on adding.

Setup /etc/rc0.d and /etc/rc2.d for shutdown and startup scripts of the database respectively.

The following work should be done as oracle (again) :

Edit $ORACLE_HOME/dbs/init$SID.ora (Note that the choice for a "medium" sized database only works for single installed instance - multiple instances on the same machine, will initially have to be "small" instead of "medium") :

set "open_cursors" to 200
change all sections from small to medium (again - only for single instance install)

and set the compatible parameter.

The global names parameter should remain false for the database links to work properly.

below is a subsection of the file :

##### ##### Added by Paul A. Luzzi on 12-15-1997 ##### as per oracle's instructions on 5-3 of install book. ##### open_cursors = 200

# tuning parameters db_files = 80

db_file_multiblock_read_count = 8 # SMALL # db_file_multiblock_read_count = 16 # MEDIUM # db_file_multiblock_read_count = 32 # LARGE . . . . . . compatible = 8.0.0.0.0 global_names = FALSE

Now stop and restart the database to make sure that these changes dont cause any problems, before going any further. Use server manager in line mode to do this :

svrmgrl
SVRMGR> connect internal
Connected.
SRVMGR> shutdown immediate;
Statement processed.
SVRMGR> startup;
SVRMGR> Connected to an idle instance.
SVRMGR> ORACLE instance started.
Total System Global Area	457196 bytes
Fixed Size                       	54988 bytes
Variable Size                  	4218880 bytes
Database Buffers               	409600 bytes
Redo Buffers                     	73728 bytes
Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

Setup the login ability as a dba, from a networked terminal now, by editing the configsco7.ora file in the same directory as the initsco7.ora file resides. Add the following line as the last line in the file :

remote_login_passwordfile = exclusive

Now stop and restart the database. You should already know how to do that.
Now we need to setup the listener and naming files for the database. Edit the $ORACLE_HOME/network/admin versions of the files, and then link them to /etc. There are samples included on the orange diskette. I recommend the prebuild …/network/admin versions. Link them into the /etc directory. If they need to be edited for the database name, do so now.
Copy $ORACLE_HOME/network/admin/listener.ora to /etc/listener.ora. Do the same copy for tnsnames.ora.
Before starting up the listener, we need to add a line to the /etc/services file that looks like :

tcptlisrv 1521/tcp tnslsnr # Oracle 8.0 network listener

and make sure that the listener.ora and tnsnames.ora files, all reference the proper port number of 1521

Now finally we should be able to startup the listener. We do so by typing (as oracle) :

lsnrctl start (for the database listener daemon - regular connections)

lsnrctl dbsnmp_start (for the Oracle Enterprise Manager listener daemon)

Now we should be able to connect in from a client side sqlplus or server manager if available.

Create new tablespace, for storage of all of our products. Use either server manager (GUI Windows version if still operational, or Server Manager in line mode). Choose to create a new tablespace, and use a datafile of ‘/oracle/oradata/rhl8/???.dbf’. If using OEM or some other graphical utility, choose to autoextend if the option exists.
If you couldnt autoextend above, then modify the tablespaces/datafiles for USERS and new one, to make them autoextend now. Below is one example. You will need to change the names of the datafiles, and tablespaces. Do this by bringing up a unix window as oracle and using server manager in line mode :

svrmgrl
SVRMGR> connect internal
Connected.
SRVMGR> alter tablespace edumet offline;
Statement processed.
SVRMGR> alter database datafile ‘/oracle/oradata/rhl8/new_one.dbf’ autoextend on;
Statement processed.
SVRMGR> alter tablespace edumet online;

Do the same thing for any other tablespaces that you need this option.
We also had to manually set the /etc/oratab file to a Y for startup of the sco8 database. Otherwise, when the machine boots, the database stays down.

We want to be able to collect statistics, among other things, with these databases, so be sure to run the dbms and other packages :

Connect internal in a sqldba session and run the following 3 scripts :

@$ORACLE_HOME/rdbms/admin/standard
@$ORACLE_HOME/rdbms/admin/dbmsstdx
@$ORACLE_HOME/rdbms/admin/catproc

Log into sqlplus for the correct instance, in this case test1. Use a username/password of system/system_password. Run the following script :

@$ORACLE_HOME/sqlplus/admin/pupbld