Install 10g oracle on 32bit redhat linux

[root@ORATEST ~]# grep MemTotal /proc/meminfo
MemTotal: 2016344 kB
[root@ORATEST ~]# grep SwapTotal /proc/meminfo
SwapTotal: 4192956 kB
[root@ORATEST ~]#

[root@ORATEST ~]# uname -mi
x86_64 x86_64
[root@ORATEST ~]#

+++++++++++++++Packages Check
[root@orcprmy ~]# rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n’ \
gcc gcc-c++ libstdc++-devel cpp glibc-devel glibc-headers glibc-kernheaders gnome-libs compat-db \
ORBit gtk+ imlib libpng10 gdk-pixbuf libungif sysstat xorg-x11-deprecated-libs xorg-x11-libs \
xorg-x11-Mesa-libGL expat fontconfig freetype zlib libaio compat-libstdc++ glibc-devel libgcc binutils \
control-center xscreensaver eel2 gail gnome-desktop gnome-icon-theme libgail-gnome libxklavier \
metacity nautilus startup-notification xloadimage xorg-x11-Mesa-libGLU at-spi desktop-backgrounds-basic \
eog gnome-panel gnome-vfs2-smb hicolor-icon-theme libexif librsvg2 nautilus-cd-burner redhat-artwork \
scrollkeeper cdrecord docbook-dtds evolution-data-server intltool libcroco libgnomeprint22 libgnomeprintui22 \
libgsf libwnck mkisofs samba-common ghostscript ghostscript-fonts gnutls libgnomecups libsoup openjade \
perl-XML-Parser sgml-common urw-fonts xml-common VFlib2 chkfontpath perl-URI perl-libwww-perl \
xorg-x11-font-utils perl-HTML-Parser xorg-x11-xfs perl-HTML-Tagset ttmkfdir

rpm -Uvh xorg-x11-deprecated-libs-6.8.2-1.EL.13.20.i386.rpm \
xorg-x11-libs-6.8.2-1.EL.13.20.i386.rpm \
xorg-x11-Mesa-libGL-6.8.2-1.EL.13.20.i386.rpm \
expat-1.95.7-4.i386.rpm \
fontconfig-2.2.3-7.i386.rpm \
freetype-2.1.9-1.i386.rpm \
zlib-1.2.1.2-1.2.i386.rpm

++++++++++++++++Kernel Parameter – 1GB Memory
[root@ORATEST etc]# pwd
/etc
[root@ORATEST etc]# vi sysctl.conf
[root@ORATEST etc]#

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 512
kernel.msgmax = 32768
kernel.msgmnb = 65535
kernel.msgmni = 512
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.ipv4.ip_local_port_range = 1024 65000
fs.file-max = 1597481
kernel.threads-max = 270336

[root@ORATEST etc]# sysctl -p

+++++++++++++++++++++ Oracle User and Group – Password oracle

Create the group “dba” and user “oracle”

[root@ORATEST etc]# groupadd dba
[root@ORATEST etc]# useradd -c “Oracle Software Owner” -g dba oracle
[root@ORATEST etc]# passwd oracle
[root@ORATEST etc]# mkdir -p /u01/app/oracle
[root@ORATEST etc]# chown -R oracle.dba /u01
[root@ORATEST etc]# mkdir /var/opt/oracle
[root@ORATEST etc]# chown oracle.dba /var/opt/oracle
[root@ORATEST etc]# chmod 755 /var/opt/oracle
[root@ORATEST etc]#

+++++++++++++++++++ Installer download and extract

[root@ORATEST software]# pwd
/u01/software
[root@ORATEST software]# ls -ltr 10201_database_linux_x86_64.cpio.gz
-rwxr-xr-x 1 oracle dba 758433170 Nov 16 2008 10201_database_linux_x86_64.cpio.gz
[root@ORATEST software]#

[oracle@ORATEST software]$ gunzip 10201_database_linux_x86_64.cpio.gz
[oracle@ORATEST software]$

[oracle@ORATEST software]$ cpio -idmv < 10201_database_linux_x86_64.cpio

[oracle@ORATEST software]$ ls -ltr
total 1945716
drwxr-xr-x 6 oracle dba 4096 Oct 23 2005 database
-rwxr-xr-x 1 oracle dba 801603584 Nov 16 2008 10201_database_linux_x86_64.cpio

+++++++++++++++++++ Installing Oracle software
Connect to CYGWIN
Type startx to get graphics
$ ssh -X -Y ORATEST -l oracle

export ORACLE_BASE=/u01/app
export ORACLE_SID=orcprmy
unset ORACLE_HOME
unset TNS_ADMIN

[root@ORATEST RPM_64]# rpm -Uvh libaio-0.3.102-1.x86_64.rpm
warning: libaio-0.3.102-1.x86_64.rpm: V3 DSA signature: NOKEY, key ID db42a60e
Preparing… ########################################### [100%]
1:libaio ########################################### [100%]

[root@ORATEST RPM_64]# rpm -qa |grep libaio
libaio-0.3.102-1

Make sure ORACLE_HOME in universal installer set to /u01/app/oracle/product/10.2.0/db_1

++++++++++++++ After Universal Installer

export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

+++++++++++++++ Management Consoles

isqlplus
http://ORATEST.localdomain:5560/isqlplus

isqlplus dba
http://ORATEST.localdomain:5560/isqlplus/dba

Enterprise Manager 10g
http://ORATEST.localdomain:1158/em

isqlplus stop and start

isqlplusctl stop

EM Console stop and start
emctl stop dbconsole

listener start

++++++++++++++++ Patch Apply 10.2.0.4

1. Stop iSQLPLUS

isqlplusctl stop

2. Stop EM Console

emctl stop dbconsole

3. Stop Listener

listnrctl stop

4. Stop Database

Sqlplus /nolo
connect / as sysdba
shutdown immediate

[oracle@ORATEST software]$ pwd
/u01/software
[oracle@ORATEST software]$ ls -ltr p6810189_10204_Linux-x86-64.zip
-rwxr-xr-x 1 oracle dba 1195551830 Mar 19 2008 p6810189_10204_Linux-x86-64.zip
[oracle@ORATEST software]$

— Database Upgrade manual
[oracle@ORATEST ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 – Production on Tue Jul 14 09:45:52 2009

SQL> connect / as sysdba
Connected to an idle instance.
SQL>
SQL> startup nomount
ORACLE instance started.

Total System Global Area 587202560 bytes
Fixed Size                  2085680 bytes
Variable Size             163581136 bytes
Database Buffers          415236096 bytes
Redo Buffers                6299648 bytes
SQL> SHOW PARAMETER PFILE;

NAME TYPE VALUE
———————————— ———– ——————————
spfile string /u01/app/oracle/product/10.2.0
/db_1/dbs/spfileORATEST.ora
SQL> SHOW PARAMETER SHARED_POOL_SIZE

NAME TYPE VALUE
———————————— ———– ——————————
shared_pool_size big integer 0
SQL> SHOW PARAMETER JAVA_POOL_SIZE

NAME TYPE VALUE
———————————— ———– ——————————
java_pool_size big integer 0
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE=’150M’ SCOPE=spfile;

System altered.

SQL> ALTER SYSTEM SET JAVA_POOL_SIZE=’150M’ SCOPE=spfile;

System altered.

SQL> SHUTDOWN
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> STARTUP UPGRADE
ORACLE instance started.

Total System Global Area 587202560 bytes
Fixed Size                  2085680 bytes
Variable Size             322964688 bytes
Database Buffers          255852544 bytes
Redo Buffers                6299648 bytes
Database mounted.
Database opened.
SQL> SPOOL patch.log
SQL>@$ORACLE_HOME/rdbms/admin/catupgrd.sql
SQL>shutdown
SQL>startup
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Tag Archive

Installing Oracle 10g on Redhat 32 bit

DBA Expert Search

Today

Categories

Meta

Archives

Recent Posts