Archive for the 'Databases' Category

Knows Oracle 9i database administrator: implementing and administration

Friday, May 9th, 2008

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, […]

How to Duplicating a Database using RMAN

Tuesday, March 11th, 2008

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 […]

FireWire Real Application Cluster on Oracle 9i

Tuesday, March 11th, 2008

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)

Wednesday, February 6th, 2008

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. […]

Step by step setting Oracle Environment Server on Linux

Wednesday, February 6th, 2008

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

Step by step deployment process of Oracle Server on Linux

Monday, February 4th, 2008

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)