11gR1 Database installation steps on linux5.4 OS.


  STEPS :-1.

a> Check System configure 
check OS version :-
[root@sonu ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)

[root@sonu ~]# uname -a
Linux sonu.oracle.com 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686

[root@sonu ~]# lsb_release -a
LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: RedHatEnterpriseServer
Description:    Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Release:        5.4
Codename:       Tikanga

b> Check OS 32 bit/64 bit :-
[root@sonu ~]# getconf WORD_BIT
32

[root@sonu ~]# file /usr/bin/file
/usr/bin/file: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, stripped

[root@sonu ~]# file /sbin/init
/sbin/init: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, stripped

3> Check CPU Info :-

[root@sonu ~]# cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Pentium(R) Dual-Core  CPU      E5300  @ 2.60GHz
stepping        : 10
cpu MHz         : 1200.000
cache size      : 2048 KB
physical id     : 0
siblings        : 2
core id         : 0
cpu cores       : 2
apicid          : 0
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5200.15

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Pentium(R) Dual-Core  CPU      E5300  @ 2.60GHz
stepping        : 10
cpu MHz         : 1200.000
cache size      : 2048 KB
physical id     : 0
siblings        : 2
core id         : 1
cpu cores       : 2
apicid          : 1
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips        : 5199.87

c> Check Physical Memory :-  <RAM>
 [root@sujeet ~]$ grep MemTotal /proc/meminfo
MemTotal : 2036792 kB
Required :- physical Memory (RAM):-1GB
d> Check Swap Space :-
 [root@sujeet ~]# grep SwapTotal /proc/meminfo
SwapTotal: 4192956 kB
Required Swap Space:-1.5 GB
e> Check free Space:-<Hard-Disk>
 [root@sujeet ~]# df -h
Filesystem            Size      Used     Avail     Use%    Mounted on
/dev/sda3            222G       99G     113G     47%       /
/dev/sda1            99M       12M     83M      12%      /boot
tmpfs                 995M     12K      995M      1%     /dev/shm
Required Hard_disk Space:-10 GB

STEPS :-2.
Download Oracle Database 11gR1 setup :-
URL :- http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen
STEPS :-3.
CHANGE HOSTNAME OR MACHINE NAME:-
 [root@sujeet ~]# vi /etc/hosts
 Make sure that there is an entry in /etc/hosts file for your 
machine like this:
 [IP-address]  [Fully-qualified-machine-name]  [Machine-name]
172.16.2.76         sujeet.oracle.com         sujeet
STEPS :-4.
 GUI Mode:-
Create User and Group:-
 System -> Administration -> Users and Groups ->
i) Add user oracle
ii) Add Group dba
iii) Assign user to that group
               OR
 COMMAND LINE:-
 [root@sujeet ~]# useradd -g dba -m oracle     <create user and assign as a pri-group that user >
 [root@sujeet ~]# passwd oracle  <change password for oracle User>
 Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
STEPS :-5.
Create directories where the Oracle Software and database will be installed.
 [root@sujeet ~]# Mkdir /11g
[root@sujeet ~]# chown -R oracle:dba /11g
[root@sujeet ~]# chmod -R 777 /11g
STEPS :-6.
Check SELINUX Setting :-
GUI :-
System -> Administration ->Security level & Firewall > root password>open new window
Click on Firewall options :-
Firewall > Disabled  <always disable>
Click on SELinux :-
SELinux Setting  > Disabled  <always disable>
 If you leave SELINUX=enforcing then you may get an error later 
while starting sqlplus:
sqlplus: error while loading shared libraries:
/usr/lib/oracle/default/client64/lib/libclntsh.so.11.1: 
cannot restore segment
prot after reloc: Permission denied
Command mode :-
[root@sonu ~]# /usr/sbin/sestatus
SELinux status:                 disabled
[root@sonu ~]# vi /etc/sysconfig/selinux
STEPS :-6.
Linux Kernel Parameters to support Oracle :-
 Open /etc/sysctl.conf and add the following lines:
 [root@sujeet ~]# vi /etc/sysconfig/network
 # Oracle settings
fs.file-max = 65536
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
 Make the kernel parameters changes effective immediately:
 [root@sujeet ~]# /sbin/sysctl -p
 [root@sujeet ~]# /sbin/sysctl -a | grep <name of kernel>
STEPS :-7.
RPM INSTALL: - (For Linux 32-bit)
 [root@sujeet ~]# cd /setup/rpms  <location of RPM dir>
 [root@sujeet newrpms]# ls
 binutils-2.17.50.0.6-6.0.1.el5.i386.rpm
binutils-2.17.50.0.6-9.0.1.el5.i386.rpm
compat-binutils215-2.15.92.0.2-24.i386.rpm
compat-libcwait-2.0-2.i386.rpm
compat-libstdc++-3.2-1.i386.rpm
compat-libstdc++-egcs-1.1.2-1.i386.rpm
compat-oracle-el5-1.0-5.i386.rpm
fonts-chinese-3.02-12.el5.noarch.rpm
openmotif21-2.1.30-11.EL5.i386.rpm
openmotif21-debuginfo-2.1.30-11.EL5.i386.rpm
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
 INSTALL RPM COMMAND:-
[root@sujeet ~]# rpm –ivh <rpmname>

[root@sujeet ~]# rpm –Uivh <rpmname>
 Install rpm check:-
[root@sujeet ~]# rpm -qa |grep <rpmname>

STEPS :-8.
Restart system:-
 [root@sujeet ~]# init 6 
STEPS :-9.
Permission to connect any HOST:-
[root@sujeet ~]# xhost +
access control disabled, clients can connect from any host
STEPS :-10.
Now switch to the user ORACLE
 [root@sujeet ~]# su oracle
STEPS :-11.
Set BASH_PROFILE:-
 [oracle@sujeet ~]# vi .bash_profile
 (Open file than copy inst parameter)
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/11g/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
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
STEPS :-12.
Permission grand Oracle SETUP: - (By root user)
[root@sujeet ~]# chown -R oracle:dba /11g_setup
[root@sujeet ~]# chmod -R 777 /11g_setup
STEPS :-13.
Login as oracle :-
 Go to setup location :-
 [oracle@sujeet ~]#cd /11g_setup/database/
[oracle@sujeet ~]# ./runInstaller
 Open New Window :-



1.Edit ORACLE_BASE Location :-
My Base location is = /11g/oracle <Just see 2nd screenshort>

2. Database password :-********
      Click on NEXT





Click on NEXT >>>>




Click on NEXT>>>






 



Click on OK  >>>>


      Open new terminal Login as ROOT user :-
      Run root.sh scripts...
     Root.sh Scripts run on root terminal :-

                        [oracle@sonu ~]$ su - root

Password:
[root@sonu ~]# /11g/oracle/product/11.1.0/db_1/root.sh  <Enter>
Running Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /11g/oracle/product/11.1.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: yes
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: yes
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: yes
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

      After that click on OK...

 
   Write this URL :-
    EM URL Show on Screen :-
    http://sonu.oracle.com:1158/em

 Click on EXIT Button...

 ****************************Installation END************************


No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...