You are currently browsing the tag archive for the ‘Installation 10g Oracle’ tag.
[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
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
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