9.2Installation | John & Kathy Purcell

http://www.oracle-base.com/Articles/9i/Oracle9iInstallationOnRedHat8.asp

gunzip lnx_920_disk1.cpio.gz
gunzip lnx_920_disk2.cpio.gz
gunzip lnx_920_disk3.cpio.gz
cpio -idmv <lnx_920_disk1.cpio
cpio -idmv <lnx_920_disk2.cpio
cpio -idmv <lnx_920_disk3.cpio

Add to /etc/profile
ORACLE_HOME=/opt/oracle/product/9.2.0; export ORACLE_HOME
ORACLE_SID=VEN1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_OWNER=oracle; export ORACLE_OWNER
TNS_ADMIN=/home/oracle/config/9.2.0; export TNS_ADMIN
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH

export JAVA_HOME=/usr/local/jdk
export JSDK_HOME=/usr/local/jsdk
CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JSDK_HOME/lib/jsdk.jar
export CLASSPATH

Add user & group
groupadd -g 400 dba
useradd -u 400 -c "Oracle Owner" -d /home/oracle -g "dba" -m -s /bin/bash oracle

change in ctx/lib/ins_ctx.mk add -ldl
"ctxhx: $(CTXHXOBJ)
$(LINK) $(CTXHXOBJ) $(INSO_LINK) -ldl"
change in env_ctx.mk add -ldl
"LINK=$(PURECMDS) gcc -ldl $(LDFLAGS) $(COMPSOBJS)"

cat /proc/sys/kernel/shmmax
>> 33554432
echo `expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax
cat /proc/sys/kernel/shmmax
>> 1073741824

Start a VNC Session from another machine
su oracle
cd Disk1
DISPLAY=purcell-linux:1
export DISPLAY
./runInstaller

use http://www.akadia.com/services/ora_linux_install_9i.html#Download%20Scripts%20for%20RedHat%20Linux%207.2 as a guide
Oracle Enterprise Edition was Installed
Data Location = /opt/oracle/product/9.2.0/oradata/db1

HOSTNAME: purcell-linux
SERVICE NAME: db1.oracle
DATABASE:
LISTENER:
USERID: john or SYSTEM
PASSWORD: password

sqlplus john/password
SQL> select table_name from all_tables;
SQL> select * from user_tablespaces;

SQL> create table sample (
2 name varchar2(50),
3 value varchar2(50)
4 );
SQL> insert into sample (name,value) values ('weather','cloudy');
SQL> insert into sample (name,value) values ('First Name','John');
SQL> insert into sample (name,value) values ('Last Name','Purcell');

SQL> GRANT grant any object privilege TO john;
SQL> GRANT CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, CREATE PROCEDURE TO john;

Reinstall

Global Database Name: purcell-linux
SID: db1