EASY SIMPLE STEPS TO INSTALL ORACLE11G ON LINUX64 BIT.
How much memory:
results: should be at least 1GB
How much swap:
results:
- should be 1.5 the size of memtotal if memtotal < 2GB
- should be equal to memtotal if memtotal is between 2GB and 8GB
- should be .75 the size of memtotal if memtotal > 8GB
What processor type:
results: informational
How much available RAM and swap:
results: informational
How much shared memory available:
results: informational
purpose: The shared memory should be sized to be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on the computer.
How much disk space in /tmp:
results: should have at least 400MB available
How much disk space for Oracle binaries:
results: Depending on installation type you should have between 1.5GB and 3.5GB
What distribution and version of Linux is installed:
(gcc version 4.4.6 20110731 (Red Hat 4.4.6-3) (GCC) )
#1 SMP Fri Dec 23 02:21:33 CST 2011
What version of the kernel is installed:
Ensure that the following packages are installed:
Install the following packages if they are not already present.
also install unzip package:
$ sudo nano /etc/pam.d/login
and add the following depending on the architecture:
Create the new groups and users.
If you have the Linux firewall enabled, you will need to disable or configure it,
Create the directories in which the Oracle software will be installed.
Select only database Software installation option ,later you can create the database using DBCA.
Issues i have faced during installation can be fixed:
During oralle installation kernel parameters error
[root@canopus ~]# /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh
Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.enable
Log file location: /tmp/CVU_11.2.0.1.0_oracle/orarun.log
Setting Kernel Parameters...
kernel.shmmax = 536870912
DURING INSTALLATION OF ORACLE LAUNCH SQLPLUS FAILS
[oracle@~]$ sqlplus
-bash: sqlplus: command not found
Solution:
Go to ORACLE_HOME (Path oracle is installed)
[oracle@~]$ cd /opt/oracle/product/11.2.0/dbhome_1/
[oracle@ dbhome_1]$ export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
[oracle@dbhome_1]$ cd bin/
[oracle@ bin]$ ./sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 11 20:53:19 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
To permanent fix this add following entries into .bash_profile file at /home/oracle location.
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH
to set the display
So as my_login execute in shell:
xhost +
As oracle execute:
export DISPLAY=:0
./runInstaller
If this don't help then as root execute:
# gdmconfig
Go to "Security" section and there is something like "Always disallow TCP ..." this checkbox must be unchecked.
Sqlplus
sexport ORACLE_BASE=/u01/home export ORACLE_HOME=/u01/9i export PATH=$PATH:$ORACLE_HOME/bin ALternate ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH ORACLE_SID=ora11 export ORACLE_SID xhost + su - oracle dbca
Refrence:
http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6.php
http://eduardo-lago.blogspot.in/2012/01/how-to-install-oracle-11g-database.html
Hardware Requirements
To check out your recommended hardware requirements, login to the Linux serverHow much memory:
$ grep -i memtotal /proc/meminfo
results: should be at least 1GB
How much swap:
$ grep -i swaptotal /proc/meminfo
results:
- should be 1.5 the size of memtotal if memtotal < 2GB
- should be equal to memtotal if memtotal is between 2GB and 8GB
- should be .75 the size of memtotal if memtotal > 8GB
What processor type:
$ grep "model name" /proc/cpuinfo
results: informational
How much available RAM and swap:
$ free
results: informational
How much shared memory available:
$ df -k /dev/shm
results: informational
purpose: The shared memory should be sized to be at least the greater of MEMORY_MAX_TARGET and MEMORY_TARGET for each Oracle instance on the computer.
How much disk space in /tmp:
$ df -k /tmp
results: should have at least 400MB available
How much disk space for Oracle binaries:
$ df -k
results: Depending on installation type you should have between 1.5GB and 3.5GB
Software Requirements
To check out your recommended software requirements,login to linux server.What distribution and version of Linux is installed:
results: Linux version 2.6.32-220.2.1.el6.x86_64 (mockbuild@c6-x8664-build.centos.org)$ cat /proc/version
(gcc version 4.4.6 20110731 (Red Hat 4.4.6-3) (GCC) )
#1 SMP Fri Dec 23 02:21:33 CST 2011
What version of the kernel is installed:
results: 2.6.32-220.2.1.el6.x86_64$ uname -r
Ensure that the following packages are installed:
if some of this packages are missing then install them$ rpm -q compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel $ rpm -q glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio-devel $ rpm -q libaio libgcc libstdc++ libstdc++ make sysstat unixODBC unixODBC-devel
$ sudo yum install compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel $ sudo yum install glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio-devel $ sudo yum install libaio libgcc libstdc++ libstdc++ make sysstat unixODBC unixODBC-devel
Install the following packages if they are not already present.
# From Oracle Linux 6 DVD cd /media/cdrom/Server/Packages rpm -Uvh binutils-2*x86_64* rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64* rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686* rpm -Uvh compat-libstdc++-33*x86_64* rpm -Uvh glibc-common-2*x86_64* rpm -Uvh glibc-devel-2*x86_64* rpm -Uvh glibc-devel-2*i686* rpm -Uvh glibc-headers-2*x86_64* rpm -Uvh elfutils-libelf-0*x86_64* rpm -Uvh elfutils-libelf-devel-0*x86_64* rpm -Uvh gcc-4*x86_64* rpm -Uvh gcc-c++-4*x86_64* rpm -Uvh ksh-*x86_64* rpm -Uvh libaio-0*x86_64* rpm -Uvh libaio-devel-0*x86_64* rpm -Uvh libaio-0*i686* rpm -Uvh libaio-devel-0*i686* rpm -Uvh libgcc-4*x86_64* rpm -Uvh libgcc-4*i686* rpm -Uvh libstdc++-4*x86_64* rpm -Uvh libstdc++-4*i686* rpm -Uvh libstdc++-devel-4*x86_64* rpm -Uvh make-3.81*x86_64* rpm -Uvh numactl-devel-2*x86_64* rpm -Uvh sysstat-9*x86_64* rpm -Uvh compat-libstdc++-33*i686* rpm -Uvh compat-libcap* cd / eject
also install unzip package:
$ sudo yum install unzip
Install Steps
Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server.For example.<IP-address> <fully-qualified-machine-name> <machine-name>
127.0.0.1 localhost.localdomain localhost 192.168.0.181 ol6-112.localdomain ol6-112
Manual Setup
Oracle recommend the following minimum parameter settings.The current values can be tested using the following command.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
Add or amend the following lines in the "/etc/sysctl.conf" file./sbin/sysctl -a | grep <param-name>
Run the following command to change the current kernel parameters.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
Add the following lines to the "/etc/security/limits.conf" file./sbin/sysctl -p
Edit /etc/pam.d/login:oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240
$ sudo nano /etc/pam.d/login
and add the following depending on the architecture:
session required /lib64/security/pam_limits.so session required pam_limits.so
Create the new groups and users.
Note. We are not going to use the "asm" groups, since this installation will not use ASM.groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 503 oper groupadd -g 504 asmadmin groupadd -g 506 asmdba groupadd -g 505 asmoper useradd -u 502 -g oinstall -G dba,asmdba,oper oracle passwd oracle
Additional Setup
Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.Once the change is complete, restart the server.SELINUX=permissive
If you have the Linux firewall enabled, you will need to disable or configure it,
Create the directories in which the Oracle software will be installed.
Login as root and issue the following command.mkdir -p /u01/app/oracle/product/11.2.0/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01
Login as the oracle user and add the following lines at the end of the ".bash_profile" file.xhost +<machine-name>
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=canopus.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=orcl; 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.Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.DISPLAY=<machine-name>:0.0; export DISPLAY
Note:./runInstaller
Select only database Software installation option ,later you can create the database using DBCA.
Issues i have faced during installation can be fixed:
During oralle installation kernel parameters error
[root@canopus ~]# /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh
Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.enable
Log file location: /tmp/CVU_11.2.0.1.0_oracle/orarun.log
Setting Kernel Parameters...
kernel.shmmax = 536870912
DURING INSTALLATION OF ORACLE LAUNCH SQLPLUS FAILS
[oracle@~]$ sqlplus
-bash: sqlplus: command not found
Solution:
Go to ORACLE_HOME (Path oracle is installed)
[oracle@~]$ cd /opt/oracle/product/11.2.0/dbhome_1/
[oracle@ dbhome_1]$ export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
[oracle@dbhome_1]$ cd bin/
[oracle@ bin]$ ./sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 11 20:53:19 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
To permanent fix this add following entries into .bash_profile file at /home/oracle location.
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH
to set the display
So as my_login execute in shell:
xhost +
As oracle execute:
export DISPLAY=:0
./runInstaller
If this don't help then as root execute:
# gdmconfig
Go to "Security" section and there is something like "Always disallow TCP ..." this checkbox must be unchecked.
Sqlplus
sexport ORACLE_BASE=/u01/home export ORACLE_HOME=/u01/9i export PATH=$PATH:$ORACLE_HOME/bin ALternate ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH ORACLE_SID=ora11 export ORACLE_SID xhost + su - oracle dbca
Refrence:
http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6.php
http://eduardo-lago.blogspot.in/2012/01/how-to-install-oracle-11g-database.html
No comments:
Post a Comment