11gR2-Installation Steps on Linux5.4


STEPS :-1.
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: Red Hat Enterprise Server

Description:    Red Hat Enterprise Linux Server release 5.4 (Tikanga)

Release:        5.4

Codename:       Tikanga

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


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


Check Physical Memory:-<RAM>
 [root@sujeet ~]$ grep MemTotal /proc/meminfo
MemTotal : 2036792 kB
Required :- physical Memory (RAM):-1GB
Check Swap Space :-
 [root@sujeet ~]# grep SwapTotal /proc/meminfo
SwapTotal: 4192956 kB
Required Swap Space:-1.5 GB
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 11gR2 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 /11gR2
[root@sujeet ~]# chown -R oracle:dba /11gR2
[root@sujeet ~]# chmod -R 777 /11gR2
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/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
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 = 1048576
ip_local_port_rang = 9000 65500
 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=/11R2g/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=idea; 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 /11R2g_setup
[root@sujeet ~]# chmod -R 777 /11gR2_setup
STEPS :-13.
Login as oracle :-
 Go to setup location :-
 [oracle@sujeet ~]#cd /11R2g_setup/database/
[oracle@sujeet ~]# ./runInstaller
 Open New Window :-



 Untick box and click NEXT



Click on NEXT....




 Click on yes button...

 

Click on NEXT...

 

 Click on NEXT button...








Change ORACLE_BASE = /11gR2/oracle
Global database name :- idea
password :- idea
Confirm password :- idea







Click on Yes button..







Click on finish button..






 Click on ok button


Default all Sample User accounts are lock ..




you Unlock User HR & SCOTT through manually only untick box
in-front of HR & SCOTT...



Root.sh Scripts run on root terminal :-(After that click on OK)

[oracle@sonu ~]$ su - root

Password:
[root@sonu ~]# /11g/oracle/product/11.1.0/db_1/root.sh
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.
[root@sonu ~]#





 Click on close tab..


***********************11gR2 Installation END********************************

How to uninstall Oracle database 11g

1. First of all uninstall the database and after grid:

To uninstall the database run as oracle user :

$ORACLE_HOME/deinstall/deinstall
This script will require at the end of process, to run other script as root user.


2. After uninstall the database uninstall the grid:
To uninstall the grid infrastructure, run as oracle user :
$ORACLE_HOME/deinstall/deinstall
This script will require at the end of process, to run other script as root user.

3. Remove trash’s :

3.1  TMP:
cd /tmp
rm -rf *


3.2 Oracle Base

cd $ORACLE_BASE
rm -rf *


3.3 ETC

cd /etc
rm -rf /etc/ora*

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&#...