Friday, August 3, 2012
Thursday, June 14, 2012
Oracle Database 11g Release 2 Installation On Oracle Linux 5
Oracle Database 11g Release 2 Installation On Oracle Linux 5
This article describes the installation of Oracle Database 11g Release 2 on Oracle Linux 5 . The article is based on a server installation with a minimum of 2G swap, secure Linux disabled.
Download Software
Download the following software.
Download the Oracle software from OTN or edilevery depending on your support status.
Oracle Database 11g Release 2 (11.2.0.1) Software
Unpack Files
Unzip the files.
unzip 11gR2_database_1of2.zip
unzip 11gR2_database_2of2.zip
You should now have a single directory called "database" containing installation files.
Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.
For example.
127.0.0.1 localhost.localdomain localhost
192.168.16.1 shoaib-11gr2 shoaib-11gr2
Oracle recommend the following minimum parameter settings.
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
The current values can be tested using the following command.
/sbin/sysctl -a
grep
Add or amend the following lines in the "/etc/sysctl.conf" file.
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
* soft nproc 2047
* hard nproc 16384
* soft nofile 4096
* hard nofile 65536
* soft stack 10240
Install the following packages if they are not already present.
rpm -Uvh binutils-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh compat-libstdc++-33*.i386.rpm
rpm -Uvh elfutils-libelf*
rpm -Uvh gcc-4.*
rpm -Uvh gcc-c++-4.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh glibc-headers-2.*
rpm -Uvh ksh*
rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh libgomp-4.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh make-3.*
rpm -Uvh sysstat-7.*
rpm -Uvh unixODBC-2.*
rpm -Uvh unixODBC-devel-2.*
rpm -Uvh numactl-devel-*
Create the new groups and users.
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
Note. We are not going to use the "asmadmin" group, since this installation will not use ASM.
Additional Setup
The following setup tasks must be performed regardless of which setup method you used previously.
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=disabled
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
Login as root and issue the following command.
xhost +
Login as the oracle user and add the following lines at the end of the ".bash_profile" file, remembering to adjust them for your specific installation.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=SHODB11G; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.
DISPLAY=:0.0; export DISPLAY
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
./runInstaller
Post Installation
Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
SHODB11G:/u01/app/oracle/product/11.2.0/db_1:Y
*************************************
rpm -qa | grep binutils-2.*
rpm -qa | grep compat-libstdc++-33*
rpm -qa | grep compat-libstdc++-33*
rpm -qa | grep elfutils-libelf*
rpm -qa | grep gcc-4.*
rpm -qa | grep gcc-c++-4.*
rpm -qa | grep glibc-2.*
rpm -qa | grep glibc-common-2.*
rpm -qa | grep glibc-devel-2.*
rpm -qa | grep glibc-headers-2.*
rpm -qa | grep ksh*
rpm -qa | grep libaio-0.*
rpm -qa | grep libaio-devel-0.*
rpm -qa | grep libgomp-4.*
rpm -qa | grep libgcc-4.*
rpm -qa | grep libstdc++-4.*
rpm -qa | grep libstdc++-devel-4.*
rpm -qa | grep make-3.*
rpm -qa | grep sysstat-7.*
rpm -qa | grep unixODBC-2.*
rpm -qa | grep unixODBC-devel-2.*
rpm -qa | grep numactl-devel-*
rpm -ivh binutils-2.*
rpm -ivh compat-libstdc++-33*
rpm -ivh elfutils-libelf*
rpm -ivh gcc-4.*
rpm -ivh gcc-c++-4.*
rpm -ivh glibc-2.*
rpm -ivh glibc-common-2.*
rpm -ivh kernel-headers-2.6.18-53.el5.i386.rpm
rpm -ivh glibc-headers-2.5-18.i386.rpm
rpm -ivh gcc-4.1.2-14.el5.i386.rpm
rpm -ivh gcc-c++-4.1.2-14.el5.i386.rpm
rpm -ivh --force compat-libstdc++-33*.i386.rpm
rpm -ivh --force glibc-devel-2.*
rpm -ivh --force glibc-headers-2.*
rpm -ivh ksh*
rpm -ivh libaio-0.*
rpm -ivh libaio-devel-0.*
rpm -ivh libgomp-4.*
rpm -ivh libgcc-4.*
rpm -ivh libstdc++-4.*
rpm -ivh libstdc++-devel-4.*
rpm -ivh make-3.*
rpm -ivh sysstat-7.*
rpm -ivh unixODBC-2.*
rpm -ivh unixODBC-devel-2.*
rpm -ivh numactl-devel-*
rpm -ivh --force elfutils-libelf-devel-*
This article describes the installation of Oracle Database 11g Release 2 on Oracle Linux 5 . The article is based on a server installation with a minimum of 2G swap, secure Linux disabled.
Download Software
Download the following software.
Download the Oracle software from OTN or edilevery depending on your support status.
Oracle Database 11g Release 2 (11.2.0.1) Software
Unpack Files
Unzip the files.
unzip 11gR2_database_1of2.zip
unzip 11gR2_database_2of2.zip
You should now have a single directory called "database" containing installation files.
Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.
For example.
127.0.0.1 localhost.localdomain localhost
192.168.16.1 shoaib-11gr2 shoaib-11gr2
Oracle recommend the following minimum parameter settings.
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
The current values can be tested using the following command.
/sbin/sysctl -a
grep
Add or amend the following lines in the "/etc/sysctl.conf" file.
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
* soft nproc 2047
* hard nproc 16384
* soft nofile 4096
* hard nofile 65536
* soft stack 10240
Install the following packages if they are not already present.
rpm -Uvh binutils-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh compat-libstdc++-33*.i386.rpm
rpm -Uvh elfutils-libelf*
rpm -Uvh gcc-4.*
rpm -Uvh gcc-c++-4.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh glibc-headers-2.*
rpm -Uvh ksh*
rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh libgomp-4.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh make-3.*
rpm -Uvh sysstat-7.*
rpm -Uvh unixODBC-2.*
rpm -Uvh unixODBC-devel-2.*
rpm -Uvh numactl-devel-*
Create the new groups and users.
groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin
useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
Note. We are not going to use the "asmadmin" group, since this installation will not use ASM.
Additional Setup
The following setup tasks must be performed regardless of which setup method you used previously.
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=disabled
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
Login as root and issue the following command.
xhost +
Login as the oracle user and add the following lines at the end of the ".bash_profile" file, remembering to adjust them for your specific installation.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=SHODB11G; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.
DISPLAY=
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
./runInstaller
Post Installation
Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
SHODB11G:/u01/app/oracle/product/11.2.0/db_1:Y
*************************************
rpm -qa | grep binutils-2.*
rpm -qa | grep compat-libstdc++-33*
rpm -qa | grep compat-libstdc++-33*
rpm -qa | grep elfutils-libelf*
rpm -qa | grep gcc-4.*
rpm -qa | grep gcc-c++-4.*
rpm -qa | grep glibc-2.*
rpm -qa | grep glibc-common-2.*
rpm -qa | grep glibc-devel-2.*
rpm -qa | grep glibc-headers-2.*
rpm -qa | grep ksh*
rpm -qa | grep libaio-0.*
rpm -qa | grep libaio-devel-0.*
rpm -qa | grep libgomp-4.*
rpm -qa | grep libgcc-4.*
rpm -qa | grep libstdc++-4.*
rpm -qa | grep libstdc++-devel-4.*
rpm -qa | grep make-3.*
rpm -qa | grep sysstat-7.*
rpm -qa | grep unixODBC-2.*
rpm -qa | grep unixODBC-devel-2.*
rpm -qa | grep numactl-devel-*
rpm -ivh binutils-2.*
rpm -ivh compat-libstdc++-33*
rpm -ivh elfutils-libelf*
rpm -ivh gcc-4.*
rpm -ivh gcc-c++-4.*
rpm -ivh glibc-2.*
rpm -ivh glibc-common-2.*
rpm -ivh kernel-headers-2.6.18-53.el5.i386.rpm
rpm -ivh glibc-headers-2.5-18.i386.rpm
rpm -ivh gcc-4.1.2-14.el5.i386.rpm
rpm -ivh gcc-c++-4.1.2-14.el5.i386.rpm
rpm -ivh --force compat-libstdc++-33*.i386.rpm
rpm -ivh --force glibc-devel-2.*
rpm -ivh --force glibc-headers-2.*
rpm -ivh ksh*
rpm -ivh libaio-0.*
rpm -ivh libaio-devel-0.*
rpm -ivh libgomp-4.*
rpm -ivh libgcc-4.*
rpm -ivh libstdc++-4.*
rpm -ivh libstdc++-devel-4.*
rpm -ivh make-3.*
rpm -ivh sysstat-7.*
rpm -ivh unixODBC-2.*
rpm -ivh unixODBC-devel-2.*
rpm -ivh numactl-devel-*
rpm -ivh --force elfutils-libelf-devel-*
Monday, June 11, 2012
oracle 10g database silent installation
[oracle@e1lab bin]$ ./dbca -silent -clonetemplate -responsefile /home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/shoaib21/shoaib21.log" for further details.
[oracle@e1lab bin]$ export ORACLE_SID=shoaib21
[oracle@e1lab bin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 26 14:31:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$database;
NAME
_ __ __ __ __
SHOAIB21
#############################################################################
#############################################################################
Few of the parameters of the response file:-
[GENERAL]
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "shoaib21"
SID = "shoaib21"
TEMPLATENAME = "General Purpose"
#SYSPASSWORD = "oracle"
#SYSTEMPASSWORD = "oracle"
#EMCONFIGURATION = "central"
#SYSMANPASSWORD = "oracle"
#DBSNMPPASSWORD = "oracle"
#EMAILADDRESS =
#DATAFILEDESTINATION =
#STORAGETYPE=FS
#DISKGROUPNAME=DATA
#REDUNDANCY=NORMAL
#CHARACTERSET = "US7ASCII"
#NATIONALCHARACTERSET= "UTF8"
#WALLETPASSWORD= "password"
#LISTENERS = "listener1 listener2"
#MEMORYPERCENTAGE = "40"
#-----------------------*** End of CREATEDATABASE section ***------------------------
SOURCEDB = "myhost:1521:shoaib21"
SYSDBAUSERNAME = "system"
#SYSDBAPASSWORD = "oracle"
TEMPLATENAME = "My Copy TEMPLATE"
#-----------------------*** End of createTemplateFromDB section ***------------------------
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
#-----------------------*** End of CONFIGUREDISKGROUPS section ***------------------------
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/shoaib21/shoaib21.log" for further details.
[oracle@e1lab bin]$ export ORACLE_SID=shoaib21
[oracle@e1lab bin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 26 14:31:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select name from v$database;
NAME
_ __ __ __ __
SHOAIB21
#############################################################################
#############################################################################
Few of the parameters of the response file:-
[GENERAL]
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "shoaib21"
SID = "shoaib21"
TEMPLATENAME = "General Purpose"
#SYSPASSWORD = "oracle"
#SYSTEMPASSWORD = "oracle"
#EMCONFIGURATION = "central"
#SYSMANPASSWORD = "oracle"
#DBSNMPPASSWORD = "oracle"
#EMAILADDRESS =
#DATAFILEDESTINATION =
#STORAGETYPE=FS
#DISKGROUPNAME=DATA
#REDUNDANCY=NORMAL
#CHARACTERSET = "US7ASCII"
#NATIONALCHARACTERSET= "UTF8"
#WALLETPASSWORD= "password"
#LISTENERS = "listener1 listener2"
#MEMORYPERCENTAGE = "40"
#-----------------------*** End of CREATEDATABASE section ***------------------------
SOURCEDB = "myhost:1521:shoaib21"
SYSDBAUSERNAME = "system"
#SYSDBAPASSWORD = "oracle"
TEMPLATENAME = "My Copy TEMPLATE"
#-----------------------*** End of createTemplateFromDB section ***------------------------
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
#-----------------------*** End of CONFIGUREDISKGROUPS section ***------------------------
Wednesday, June 6, 2012
Oracle 10g Release 2 Installation On RHEL5
Oracle Database 10g Release 2 Installation On Red Hat Enterprise Linux 5 (RHEL5)
In installation we require a minimum of 2G swap, secure Linux disabled and the following package groups installed.
GNOME Desktop Environment
Editors * Graphical Internet
Text-based Internet
Development Libraries
Development Tools
Legacy Software Development
Server Configuration Tools
Administration Tools
Base Legacy Software Support
System Tools
X Window System
Unzip the Installation files.
unzip 10201_database_linux32.zip
You should now have a single directory containing installation files within the "database" directory.
Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.
Set Kernel Parameters
Add the following lines to the "/etc/sysctl.conf" file.
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
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
Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Add the following line to the "/etc/pam.d/login" file, if it does not already exist.
session required pam_limits.so
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows. SELINUX=disabled
Alternatively, this alteration can be done using the GUI tool (System > Administration > Security Level and Firewall). Click on the SELinux tab and disable the feature.
Setup Install the following packages. cd /media/cdrom/Server
rpm -ivh setarch-2*
rpm -ivh make-3*
rpm -ivh glibc-2*
rpm -ivh libaio-0*
rpm -ivh compat-libstdc++-33-3*
rpm -ivh compat-gcc-34-3*
rpm -ivh compat-gcc-34-c++-3*
rpm -ivh gcc-4*
rpm -ivh libXp-1*
rpm -ivh openmotif-2*
rpm -ivh compat-db-4*
To check whether the package is already installed or not
rpm -qa | grep
Create the new groups and users.
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
Login as root and issue the following command. xhost +
Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 5 (Tikanga)) with the following: redhat-4
Login as the oracle user and add the following lines at the end of the ".bash_profile" file.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME ORACLE_SID=shoaib;
export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ];
then if [ $SHELL = "/bin/ksh" ];
then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384
ulimit -n 65536
fi
fi
Installation Log into the oracle user.
If you are using X emulation (Xmanager or VNC) then set the DISPLAY environmental variable. DISPLAY=:0.0; export DISPLAY
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
./runInstaller
Post Installation Edit the "/etc/redhat-release" file restoring the original release information. Red Hat Enterprise Linux Server release 5 (Tikanga) Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
shoaib:/u01/app/oracle/product/10.2.0/db_1:Y
In installation we require a minimum of 2G swap, secure Linux disabled and the following package groups installed.
GNOME Desktop Environment
Editors * Graphical Internet
Text-based Internet
Development Libraries
Development Tools
Legacy Software Development
Server Configuration Tools
Administration Tools
Base Legacy Software Support
System Tools
X Window System
Unzip the Installation files.
unzip 10201_database_linux32.zip
You should now have a single directory containing installation files within the "database" directory.
Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.
Add the following lines to the "/etc/sysctl.conf" file.
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
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
Run the following command to change the current kernel parameters.
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Add the following line to the "/etc/pam.d/login" file, if it does not already exist.
session required pam_limits.so
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows. SELINUX=disabled
Alternatively, this alteration can be done using the GUI tool (System > Administration > Security Level and Firewall). Click on the SELinux tab and disable the feature.
Setup Install the following packages. cd /media/cdrom/Server
rpm -ivh setarch-2*
rpm -ivh make-3*
rpm -ivh glibc-2*
rpm -ivh libaio-0*
rpm -ivh compat-libstdc++-33-3*
rpm -ivh compat-gcc-34-3*
rpm -ivh compat-gcc-34-c++-3*
rpm -ivh gcc-4*
rpm -ivh libXp-1*
rpm -ivh openmotif-2*
rpm -ivh compat-db-4*
To check whether the package is already installed or not
rpm -qa | grep
Create the new groups and users.
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
Login as root and issue the following command. xhost +
Edit the "/etc/redhat-release" file replacing the current release information (Red Hat Enterprise Linux Server release 5 (Tikanga)) with the following: redhat-4
Login as the oracle user and add the following lines at the end of the ".bash_profile" file.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME ORACLE_SID=shoaib;
export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ];
then if [ $SHELL = "/bin/ksh" ];
then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384
ulimit -n 65536
fi
fi
Installation Log into the oracle user.
If you are using X emulation (Xmanager or VNC) then set the DISPLAY environmental variable. DISPLAY=
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
./runInstaller
Post Installation Edit the "/etc/redhat-release" file restoring the original release information. Red Hat Enterprise Linux Server release 5 (Tikanga) Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
shoaib:/u01/app/oracle/product/10.2.0/db_1:Y
MANUAL INSTALLATION OF THE DATABASE
LEARN TO DO MANUAL INSTALLATION OF THE DATABASE IN JUST 6 STEPS
As oracle users I fired the following commands to make changes in oracle bashprofile.
echo "alias sid='echo "'$ORACLE_SID'"'" >> /home/oracle/.bash_profile
echo "alias bash='vi /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias ebash='. /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias pmon='ps -ef|grep pmon'" >> /home/oracle/.bash_profile
echo "alias conn='sqlplus "/ as sysdba"'" >> /home/oracle/.bash_profile
echo "alias cl='clear'" >> /home/oracle/.bash_profile
in my vmmachine i have the pre created database with name ORCL
and i will create a new database with name as “newdb”
1. First we will make the required necesaary folders.
we will copy all the folders present in the orcl folder to the new folder "newdb" at the same location and and empty all the folders except the pfile folder with the init file.
[oracle@localhost ~]$ cd /u01/app/oracle/admin/
]$ cp -R orcl/ newdb/
]$ cd newdb/
]$ cd udump/
]$ rm -rf *
]$ cd ../dpdump/
]$ rm -rf *
]$ cd ../cdump/
]$ rm -rf *
]$ cd ../bdump/
]$ rm -rf *
]$ cd ../adump/
]$ rm -rf * 2.
we will make the changes in the pfile. Replace the orcl word with newdb in the complete file.
[oracle@localhost ~]$ vi /u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834 3.
inside the oradata folder i created the new folder "newdb" where all my CDR files will be built.
[oracle@localhost ~]$ cd /u01/app/oracle/oradata/ mkdir newdb
4. we have just created the password file in the dbs folder.
[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/ orapwd file=orapwnewdb password=shoaib entries=5 force=y 5.
now we will create the database with the create database command.
]$ export ORACLE_SID=newdb
]$ sqlplus / as sysdba startup nomount pfile=/u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834
The create database script:
create database newdb
logfile group 1 ('/u01/app/oracle/oradata/newdb/redo1.log') size 100M,
group 2 ('/u01/app/oracle/oradata/newdb/redo2.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/u01/app/oracle/oradata/newdb/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/u01/app/oracle/oradata/newdb/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/newdb/undotbs1.dbf' size 100M default temporary tablespace temp tempfile '/u01/app/oracle/oradata/newdb/temp01.dbf' size 100M
6. here the database will be created, now we will execuete the catalog and catproc scripts.
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
hence the manual installation is complete.
© shoaibansari73@gmail.com
As oracle users I fired the following commands to make changes in oracle bashprofile.
echo "alias sid='echo "'$ORACLE_SID'"'" >> /home/oracle/.bash_profile
echo "alias bash='vi /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias ebash='. /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias pmon='ps -ef|grep pmon'" >> /home/oracle/.bash_profile
echo "alias conn='sqlplus "/ as sysdba"'" >> /home/oracle/.bash_profile
echo "alias cl='clear'" >> /home/oracle/.bash_profile
in my vmmachine i have the pre created database with name ORCL
and i will create a new database with name as “newdb”
1. First we will make the required necesaary folders.
we will copy all the folders present in the orcl folder to the new folder "newdb" at the same location and and empty all the folders except the pfile folder with the init file.
[oracle@localhost ~]$ cd /u01/app/oracle/admin/
]$ cp -R orcl/ newdb/
]$ cd newdb/
]$ cd udump/
]$ rm -rf *
]$ cd ../dpdump/
]$ rm -rf *
]$ cd ../cdump/
]$ rm -rf *
]$ cd ../bdump/
]$ rm -rf *
]$ cd ../adump/
]$ rm -rf * 2.
we will make the changes in the pfile. Replace the orcl word with newdb in the complete file.
[oracle@localhost ~]$ vi /u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834 3.
inside the oradata folder i created the new folder "newdb" where all my CDR files will be built.
[oracle@localhost ~]$ cd /u01/app/oracle/oradata/ mkdir newdb
4. we have just created the password file in the dbs folder.
[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/ orapwd file=orapwnewdb password=shoaib entries=5 force=y 5.
now we will create the database with the create database command.
]$ export ORACLE_SID=newdb
]$ sqlplus / as sysdba startup nomount pfile=/u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834
The create database script:
create database newdb
logfile group 1 ('/u01/app/oracle/oradata/newdb/redo1.log') size 100M,
group 2 ('/u01/app/oracle/oradata/newdb/redo2.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/u01/app/oracle/oradata/newdb/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/u01/app/oracle/oradata/newdb/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/newdb/undotbs1.dbf' size 100M default temporary tablespace temp tempfile '/u01/app/oracle/oradata/newdb/temp01.dbf' size 100M
6. here the database will be created, now we will execuete the catalog and catproc scripts.
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
hence the manual installation is complete.
© shoaibansari73@gmail.com
Wednesday, November 3, 2010
Oracle Installation errors
Some time it happens that we could not start our Xwindow terminal from oracle user window, if we have su(switch user) from root user.
Like if we execute the following command we get the error
Bash-3.00$ cd clusterware
Bash-3.00$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be 5.10. Actual 5.10 Passed
Checking Temp space: must be greater than 250 MB. Actual 1982 MB Passed
Checking swap space: must be greater than 500 MB. Actual 2348 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,at which time they will be rechecked.
Continue? (y/n) [n] n
The solution to this problem is
As root user
Bash-3.00# export DISPLAY=192.168.235.111:0.0
Bash-3.00# su – oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$ bash
Bash-3.00# export DISPLAY=192.168.235.111:0.0
Bash-3.00# echo $DISPLAY
192.168.235.111:0.0
Now run ./runInstaller as the oracle user and there will be no issue.
Like if we execute the following command we get the error
Bash-3.00$ cd clusterware
Bash-3.00$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be 5.10. Actual 5.10 Passed
Checking Temp space: must be greater than 250 MB. Actual 1982 MB Passed
Checking swap space: must be greater than 500 MB. Actual 2348 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,at which time they will be rechecked.
Continue? (y/n) [n] n
The solution to this problem is
As root user
Bash-3.00# export DISPLAY=192.168.235.111:0.0
Bash-3.00# su – oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$ bash
Bash-3.00# export DISPLAY=192.168.235.111:0.0
Bash-3.00# echo $DISPLAY
192.168.235.111:0.0
Now run ./runInstaller as the oracle user and there will be no issue.
Commentaires
Enregistrer un commentaire