Oracle 10G installation in RHEL: 6 Steps

Step 1:
--------------------
Create user: oracle
Create group: oinstall,dba
Add oinstall,dba to user oracle

groupadd oinstall
groupadd dba
useradd oracle -g oinstall -G dba
passwd oracle

chown -R oracle:oinstall oracle_installation_path

Step 2:
------------------
unzip the zip file:
gunzip file_name.cpio.gz
cpio -idmv < filename.cpio [for 64bit Oracle only]

Step 3:
------------------
Change Kernel Parameters

append below lines in file:/etc/sysctl.conf

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 2147483648 [keep OS provided one]

# Controls the maximum number of shared memory segments
kernel.shmall = 268435456 [keep OS provided one]
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536 #ins/decrease
net.ipv4.ip_local_port_range=1024 65000

net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

---------------------------------
append below lines in file:/etc/security/limits.conf

* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536


-----------------------------
append below lines in file:/etc/pam.d/login

session required pam_limits.so

----------------------------
sysctl -p

Step 4:
--------------------------------------
vi /etc/redhat-release and edit as below (if OS is newer than RHEL4 or Fedora)
Red Hat Enterprise Linux Server release 3 (Taroon)

Step 5:
------------------
rpm needed(if we use default dev packages then no need to install extra packages rhel4.5)

binutils-2.15.92.0.2-24
gcc-3.4.6-9
gcc-c++-3.4.6-9
glibc-2.3.4-2.39
glibc-2.3.4-2.39
glibc-common-2.3.4-2.39
glibc-devel-2.3.4-2.39
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.6-9
libstdc++-3.4.6-9
libstdc++-3.4.6-9
libstdc++-3.4.6-9
make-3.80-6.EL4
pdksh-5.2.14-30.6
compat-db-4.1.25-9
compat-gcc-32-c++-3.2.3-47.3
compat-oracle-rhel4-1.0-5
compat-libstdc++-33-3.2.3-47.3
compat-libcom_err-1.0-5
compat-openldap-2.1.30-8
compat-libstdc++-33-3.2.3-47.3
compat-db-4.1.25-9
compat-libcom_err-1.0-5
compat-libgcc-296-2.96-132.7.2
compat-gcc-32-3.2.3-47.3
compat-libcwait-2.1-2
compat-libstdc++-296-2.96-132.7.2
control-center-2.8.0-12.rhel4.5

please keep in mind that on 64bit server both 32 and 64 bit rpm installation will reduce complexity. If not then you can face below error

error in invoking target 'install' of makefile
'u01/app/oracle/oracle/product/10.2.0/db/ctx/lib/ins_ctx.mk'.
or
error in invoking target 'agent nmo nmb' of makefile
'u01/app/oracle/oracle/product/10.2.0/db/ctx/lib/ins_sysman.mk'.
or
error in invoking target 'all_no_orcl' of makefile
'u01/app/oracle/oracle/product/10.2.0/db/ctx/lib/ins_rdbms.mk'.


Step 6:
----------------

vi ~/.bash_profile

PATH=$PATH:$HOME/bin
ORACLE_BASE=mention_your_path
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME PATH

Comments

Post a Comment

Popular posts from this blog

Restoring Master, Model and MSDB from Netbackup

Restoring System Databases got two parts: Taking the instance in single user mode and Restoring the Master Database If you need to rebuild the system databases on top of this you can use the below command: "C:\Program Files\Microsoft SQL Server\ 100 \Setup Bootstrap\ SQLServer2008R2 \setup.exe" /ACTION=REBUILDDATABASE /INSTANCENAME=SQL008 /SQLSYSADMINACCOUNTS=domain\ServiceUserName /SAPWD="yourpasswordOfSAuser" /SQLCOLLATION="Latin1_General_CI_AS" here 100 is for SQL Server 2008R2. It can vary case by case. How to take instance to single user mode: Two situation can happen: 1. Standalone Instance  2. Failover Cluster Instance 1. Standalone Instance: Go to SQL Config Manager SQL Service Properties -> Advanced Properties -> Startup Parameters put -m; in the Startup Parameters Apply and Okay - it will ask to restart the SQL Service to take effect. Stop and Start the service from Config Manager or you can stop and serv...
Read more

Oracle Job Operations

As a DBA, often I need to deal with Client's Jobs. Sometimes the jobs got hault, needs to break etc etc. Here are some useful commands for this sort of operations. ## Job Owner Schema can do this execute dbms_job.remove(444); execute dbms_job.broken(444, true); ## If Sys User needs to remove the job exec SYS.DBMS_IJOB.REMOVE(444); ## to find which jobs are running SELECT a.sid, c.serial#, a.job, a.failures, to_char(a.this_date, 'mm/dd/yyyy hh:mi pm') startdatetime, b.what FROM dba_jobs_running a, dba_jobs b, v$session c WHERE a.job = b.job AND a.sid = c.sid order by a.this_date ##let say we have only sid and serial and we need to kill the process from both OS and database. So first we need to find out the SPID. this query for any RAC database select P.SPID ,S.SID ,S.SERIAL#, S.SCHEMANAME, S.PROGRAM, S.INST_ID, S.OSUSER, S.STATUS from gv$process p, gv$session s where P.ADDR=S.PADDR and S.SID=888 and s.serial#=9293; ## kill the job al...
Read more