Pre-Instalation Tasks:
Step1)Create oracle dba group and user account.
Log in as root and create oracle user account which belongs to dba group.
su -
[root@oral01 ~]# groupadd -g 1000 dba
[root@oral01 ~]# echo $?
0
[root@oral01 ~]# useradd -m -s /bin/ksh -g dba -u 1000 oracle
[root@oral01 ~]# echo $?
0
[root@oral01 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@oral01 ~]# id oracle
uid=1000(oracle) gid=1000(dba) groups=1000(dba)
Login as the oracle user and add the following lines .profile :
#########################################
export VISUAL=vi
export EDITOR=/usr/bin/vi
ENV=$HOME/.kshrc
export ENV
umask 022
stty erase ^?
export HOST=`hostname`
export PS1='$HOST:$PWD>'
export PS2="$HOST:`pwd`>>"
export PS3="$HOST:`pwd`=="
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0.4/db_1
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
unalias ls
############################
Set Kernel Parameters
Add the following lines to the /etc/sysctl.conf file:fs.file-max=327679
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4294967295
net.core.rmem_default = 262144
net.core.rmem_max=2097152
net.core.wmem_default = 262144
net.core.wmem_max=262144
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range=1024 65000
[root@oral01 ~]# sysctl -p
Add the following lines to the /etc/security/limits.conf file:
oracle soft nofile 131072
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 3500000
oracle hard memlock 3500000
Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:
mkdir -p /u01/app/oracleSELINUX=disabled
Configure oracleasm :
[root@oral01 tmp]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]
[root@oral01 tmp]# oracleasm createdisk ASM1 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@oral01 tmp]# oracleasm listdisks
ASM1
Installation:
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:
DISPLAY=<machine-name>:0.0; export DISPLAY
We are installing oracle 10.2.0.1 on RHEL5 and you will get os not certified and you can safely ignore it.
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory to create ASM home.
./runInstaller -ignoreSysPrereqs Starting Oracle Universal Installer... Checking installer requirements... Checking operating system version: must be redhat-3,
SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Please wait ...oral01.ukatru.com:/u01/database>Oracle Universal Installer, Version 10.2.0.1.0 ProductionInstaller from /tmp/OraInstall2011-02-05_11-19-20PM.
Copyright (C) 1999, 2005, Oracle. All rights reserved
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to dba.
The execution of the script is complete
[root@oral01 asm]# /u01/app/oracle/product/10.2.0/asm/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/asm
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0.4/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Step 3:Applying oracle 10g R2 patch set 3 on both Asm and Database homes.
Step 3:Create and start ASM instance.
oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm>export ORACLE_HOME=/u01/app/oracle/product/10.2.0/asm
oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm>export ORACLE_SID=+ASM
oral01.ukatru.com:/u01/app/oracle/product/10.2.0/asm/bin>./dbca &
[1] 25327
/etc/oracle does not exist. Creating it now.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized
Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
oral01
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)
oracle 25887 1 0 00:08 ? 00:00:00 asm_pmon_+ASM
oracle 25889 1 0 00:08 ? 00:00:00 asm_psp0_+ASM
oracle 25891 1 0 00:08 ? 00:00:00 asm_mman_+ASM
oracle 25893 1 0 00:08 ? 00:00:00 asm_dbw0_+ASM
oracle 25895 1 0 00:08 ? 00:00:00 asm_lgwr_+ASM
oracle 25897 1 0 00:08 ? 00:00:00 asm_ckpt_+ASM
oracle 25899 1 0 00:08 ? 00:00:00 asm_smon_+ASM
oracle 25901 1 0 00:08 ? 00:00:00 asm_rbal_+ASM
oracle 25903 1 0 00:08 ? 00:00:00 asm_gmon_+ASM
Step 4:Create Database
export ORACLE_HOME=/u01/app/oracle/product/10.2.0.4/db_1
SQL> select INSTANCE_NAME,HOST_NAME,VERSION from v$instance;
INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION
-----------------
oradv1
oral01.ukatru.com
10.2.0.4.0
No comments:
Post a Comment