Part I: Installation
Present kernel version: 2.6.18-8.el5
This kernel supplied in updates, works with Oracle Database 10g Release 2.
Checked kernel version by running the following command:
Uname -r
Ex:
# uname -r
2.6.18-8.el5
All of the packages required for Oracle Database 10g Release 2 have been installed.
Verified this using the command below.
rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common libstdc++ libstdc++-devel make ksh sysstat libaio
Installed package versions:
binutils-2.17.50.0.6-2.el5
compat-db-4.2.52-5.1
control-center-2.16.0-14.el5
gcc-4.1.1-52.el5
gcc-c++-4.1.1-52.el5
glibc-2.5-12
glibc-common-2.5-12
libstdc++-4.1.1-52.el5
libstdc++-devel-4.1.1-52.el5
make-3.81-1.1
ksh-20060214-1.4
sysstat-7.0.0-3.el5
libaio-0.3.106-3.2
Part II: Verifying System Requirements
Checked the amount of RAM and swap space available,
Command:
# grep MemTotal /proc/meminfo
MemTotal: 1944424 kB
# grep SwapTotal /proc/meminfo
SwapTotal: 1638620 kB
Note: The minimum RAM required is 1024MB, and the minimum required swap space is 1GB.
Disk partition details:
df -h
Ex:
# df –h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
19G 379M 18G 3% /
/dev/sda1 487M 16M 446M 4% /boot
/dev/mapper/VolGroup00-LogVol05
48G 36G 9.5G 79% /data
tmpfs 950M 0 950M 0% /dev/shm
/dev/mapper/VolGroup00-LogVol04
19G 12G 6.2G 66% /oracle
/dev/mapper/VolGroup00-LogVol01
1.4G 421M 932M 32% /tmp
/dev/mapper/VolGroup00-LogVol02
9.7G 3.2G 6.1G 35% /usr
/dev/mapper/VolGroup00-LogVol03
5.7G 242M 5.2G 5% /var
Part III : Creation of oracle Groups and User Account
Linux groups and user account that is used to install and maintain the Oracle Database 10g Release 2 software.
The user account is oracle, and the groups is oinstall and dba.
Execute the following commands as root:
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
Setting the password on the oracle account:
Passwd oracle
# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
Part IV: Create Directories
Created directories to store the Oracle Database 10g Release 2 software and the database files
Issue the following commands as root:
# mkdir -p /oracle/app/
# chown -R oracle:oinstall /oracle/app/
# chmod -R 775 /oracle/app/
# mkdir -p /data/oradata/
# chown -R oracle:oinstall /data/oradata
# chmod -R 775 /data/oradata
The partition used for ORACLE software installation is /oracle/app
The partition used for DATABASE FILES is /data/oradata
The above adheres to the Optimal Flexible Architecture (OFA) for the naming conventions used in creating the directory structure.
Part V: Configuring the Linux Kernel Parameters
Oracle Database 10g Release 2 requires the kernel parameter settings shown below. The values used are given below.
/etc/sysctl.conf is the file where the entries are made.
fs.file-max = 65536
kernel.shmall = 2097152
kernel.shmmax = 1073741824
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
Setting Shell Limits for the oracle User
Oracle recommends setting limits on the number of processes and open files each Linux account may use.
/etc/security/limits.conf is the file where the below entry is made.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
/etc/pam.d/login is the file where the below entry is made.
session required /lib/security/pam_limits.so
If it already exists it can be ignored.
Part VI : Installing Oracle
Oracle Database 10g Release 2 can be downloaded from OTN.
Downloaded 10201_database_linux32.gz gunzip and extract the file:
gunzip 10201_database_linux32.gz
Install the Software and Create a Database
Log in using the oracle account.
Ex:
$ cd database
Start the Oracle Universal Installer.
$ ./runInstaller
1. Select Installation Method
o Select Basic Installation
o Oracle Home Location: /oracle/app/product/10.2.0/db_1
o Installation Type: Enterprise Edition (1.3GB)
o UNIX DBA Group: oinstall
o Make sure Create Starter Database is checked
o (Database is created using DBCA along with installation) or (DBCA can be invoked for database creation once installation completes)
o Global Database Name: fops
o Enter the Database Password and Confirm Password
o Click on Next
2. Specify Inventory Directory and Credentials
o Inventory Directory: /oracle/app/product/10.2.0/db_1
o Operating System group name: oinstall
o Click on Next
3. Product-specific Prerequisite Checks
o If you've been following the steps above, all the checks should pass without difficulty. If one or more checks fail, correct the problem before proceeding.
o Click on Next
4. Summary
o A summary of the products being installed is presented.
o Click on Install.
5. Configuration Assistants
o The Oracle Net, Oracle Database, and iSQL*Plus configuration assistants will run automatically
6. Execute Configuration Scripts
o At the end of the installation, a pop up window will appear indicating scripts that need to be run as root. Login as root and run the indicated scripts.
o Click on OK when finished.
7. End of Installation
o Make note of the URLs presented in the summary, and click on Exit when ready.
Note: The tablespaces are created using the scripts provided.
The Schemas and objects are created using the dump provided using
No comments:
Post a Comment