Configure Install Setup

Oracle Architecture overview
The oracle 9i RDBMS contains a suite of software that includes required components, work-saving tools, utilities, and management software that is primarily user for DBA. More features for use with the Internet than prior releases for example, a new XML DB (database) feature provides an interface within the database for easily storing, updating, […]

Duplicating a Database using RMAN

Run the script below
on the database in which you plan to duplicate to generate the new paths for
the data files. This example assumes you have enough disk space on one mount
point. However, you can easily change some of the mount points in VI to
point another location or modify the script to […]

Combine RAC, Linux and FireWire disk for low-cost development environment.
Toolbox:
Oracle 9i (9.0.1.4.0) Database Server with RAC option; Red Hat Linux 7.1.
Topics include:
Oracle database installation, Linux kernel versions, and kernel settings. You should have a good knowledge of Oracle database administration and Linux (or UNIX) operating system management, but whether you’re […]

Step by step setting Oracle Environment Server On Linux (part 2)
Shutdown Oracle Instance (Shutdown Oracle instance before applying patch)
1. su - oracle
2. sqlplus /nolog
3. connect sys as sysdba
4. Password - oracle
5. shutdown
6. exit
To unzip OPatch files (p2617419)
1. […]

Setting Oracle Environment

su - oracle
vi .bash_profile

Append
#Oracle Environment
export ORACLE_BASE=/home/opt/oracle
export ORACLE_HOME=/home/opt/oracle/product/9.2.0.4
export ORACLE_SID=TMS
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
Save file

Installation Procedures

Copy Oracle installation disk to /home folder

mkdir /home/setup
mkdir /home/patch
cd /mnt/cdrom
cp *.* /home/setup
cd
umount /mnt/cdrom
eject
repeat step 3-7 for 3 times (3 cds)
cp *.* /home/patch (to copy patch cd to /patch folder)