Oracle EBS R12.2.4 Installation on Linux

Single node multi user installation steps with Web-logic database configuration.
This is a step by step detailed article for Installing Oracle EBS R12.2.4.0.0 on OEL5.8(64-bit). I have used oracle virtual box for Installing Linux.

Note:- I am not explain here how to install OVM on OEL OS...

Virtual Machine configuration:

CPU    = 2 core
RAM   = 16 GB
HDD   =  1 TB


Software's Required

1) Oracle Virtual Box
2) Oracle Enterprise Linux 5.8 (64-bit)
3) Oracle E-Business suite R12.2.4.0.0 for LinuxX86-64-bit

Installation Steps
  1. Hardware requirements
  2. Create virtual machine and Install operating system
  3. Operating System pre-requisites
  4. Prepare Stage Area
  5. Install Oracle EBS R12.2.4.0.0 software
  6. Verify Installation
Directory structure 

Base Directory:- /u01
Stage Area:- /u01/Stage
DB_User:- Oracle
Apps_User:- Applmgr
Group:- dba
Weblogic user_id/Password:- weblogic/patna@123
Database_ID:- PROD
Inventory location:- /u01/db/oraInventory

Step:-1

First we need to download Oracle E-Business Suite Release 12.2.4.0.0 Media Pack for Linux x86-64-bit
Download software Link :- 
 https://edelivery.oracle.com/EPD/Search/handle_go


Oracle E-Business Suite (12.2.4) v1, Linux x86-64
Readme  View Digest 
SelectNamePart NumberSize (Bytes)
Download Oracle E-Business Suite Release 12.2 Supplemental Documentation - REVIEW FIRSTV46139-017.7M
Download Oracle E-Business Suite Release 12.2 Supplemental MediaV46140-01380M
Download Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here (Part 1 of 3)V46243-01 Part 1 of 33.1G
Download Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here (Part 2 of 3)V46243-01 Part 2 of 381M
Download Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here (Part 3 of 3)V46243-01 Part 3 of 397M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 1 of 5)V35231-01 Part 1 of 5933M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 2 of 5)V35231-01 Part 2 of 5628M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 3 of 5)V35231-01 Part 3 of 5587M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 4 of 5)V35231-01 Part 4 of 5457M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 5 of 5)V35231-01 Part 5 of 5108M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 1 (Part 1 of 2)V35230-01 Part 1 of 21.3G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 1 (Part 2 of 2)V35230-01 Part 2 of 21.1G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6V35812-012.3G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5V35811-012.6G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4V35810-012.8G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3V35809-012.9G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2V35808-012.9G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1V35807-013.2G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 (Part 1 of 3)V35806-01 Part 1 of 31.4G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 (Part 2 of 3)V35806-01 Part 2 of 31.1G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 (Part 3 of 3)V35806-01 Part 3 of 31.0G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 (Part 1 of 2)V35805-01 Part 1 of 21.4G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 (Part 2 of 2)V35805-01 Part 2 of 21.3G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install AS10.1.2V35802-01711M
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 (Part 1 of 2)V35804-01 Part 1 of 21.2G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 (Part 2 of 2)V35804-01 Part 2 of 21.6G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 (Part 1 of 3)V35803-01 Part 1 of 31.2G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 (Part 2 of 3)V35803-01 Part 2 of 31.0G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 (Part 3 of 3)V35803-01 Part 3 of 31.4G
Download Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Technology one-off PatchesV35813-01730M
Download Oracle WebLogic Server 11gR1 (10.3.6) Generic and CoherenceV29856-011.0G
Download Oracle Fusion Middleware Web Tier Utilities 11g Patch Set 5 (11.1.1.6.0) for Linux x86-64V29764-011.6G
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 1 of 9)V46241-01 Part 1 of 9402M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 2 of 9)V46241-01 Part 2 of 9498M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 3 of 9)V46241-01 Part 3 of 9485M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 4 of 9)V46241-01 Part 4 of 9520M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 5 of 9)V46241-01 Part 5 of 9573M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 6 of 9)V46241-01 Part 6 of 9564M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 7 of 9)V46241-01 Part 7 of 9498M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 8 of 9)V46241-01 Part 8 of 9544M
Download Oracle E-Business Suite Release 12.2.4 Update Pack for Linux x86-64 (Part 9 of 9)V46241-01 Part 9 of 997M
Download Oracle E-Business Suite Release 12.2.4 Documentation LibraryV46499-01663M
Download Oracle Database Lite 10g Release 3 (10.3.0.3.0) for Linux x86V20223-01518M
Download Oracle Data Integrator 11g (11.1.1.6.0) for Generic (Part 1 of 2)V29762-01 Part 1 of 22.0G
Download Oracle Data Integrator 11g (11.1.1.6.0) for Generic (Part 2 of 2)V29762-01 Part 2 of 2520M
Download Oracle SOA Suite 11g Patch Set 5 (11.1.1.6.0) (Part 1 of 2)V29672-01 Part 1 of 21.6G
Download Oracle SOA Suite 11g Patch Set 5 (11.1.1.6.0) (Part 2 of 2)V29672-01 Part 2 of 21.2G

Step:-2

 Operating System pre-requisites:

 configure kernel parameters (Edit /etc/sysctl.conf file):

#All below kernel parameters are related to oracle EBS - R12.2#################kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
:wq

[root@erpnode2 Server]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304

[root@apps Server]# tail -8 /etc/security/limits.conf 
#ftp             hard    nproc           0
#@student        -       maxlogins       4

# End of file
*       hard    nofile 65536
*       soft    nofile 4096
*       hard    nproc  16384
*       soft    nproc  2047

[root@apps Server]#

 Make sure all OS packages exists on the system

If packages are selected as listed with OS Installation then you need to Install only listed below rpm's:      

[root@apps Server]# rpm -ivh glibc-2.5-65.x86_64.rpm
warning: glibc-2.5-65.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
        package glibc-2.5-65.x86_64 is already installed

[root@apps Server]# ls -l libstdc++-devel-*
-rw-r--r-- 1 root root 2962660 Jun 14  2011 libstdc++-devel-4.1.2-51.el5.i386.rpm
-rw-r--r-- 1 root root 2943747 Jun 14  2011 libstdc++-devel-4.1.2-51.el5.x86_64.rpm

[root@apps Server]# rpm -ivh devel-4.1.2-51.el5.x86_64.rpm
error: open of devel-4.1.2-51.el5.x86_64.rpm failed: No such file or directory

[root@apps Server]# rpm -ivh libstdc++-devel-4.1.2-51.el5.x86_64.rpm
warning: libstdc++-devel-4.1.2-51.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
        package libstdc++-devel-4.1.2-51.el5.x86_64 is already installed

[root@apps Server]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:libXp                  ########################################### [100%]

[root@apps Server]# rpm -ivh libXp-1.0.0-8.1.el5.x86_64.rpm
warning: libXp-1.0.0-8.1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:libXp                  ########################################### [100%]

[root@apps Server]# ls -lrt sysstat-7*
-rw-r--r-- 1 root root 191268 Jul 26  2011 sysstat-7.0.2-11.el5.x86_64.rpm

[root@apps Server]# rpm -ivh sysstat-7.0.2-11.el5.x86_64.rpm
warning: sysstat-7.0.2-11.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:sysstat                ########################################### [100%]

[root@apps Server]# ls -l libaio-devel-*
-rw-r--r-- 1 root root 11790 Nov 17  2010 libaio-devel-0.3.106-5.i386.rpm
-rw-r--r-- 1 root root 11675 Nov 17  2010 libaio-devel-0.3.106-5.x86_64.rpm

[root@apps Server]# rpm -ivh libaio-devel-0.3.106-5.i386.rpm
warning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:libaio-devel           ########################################### [100%]

[root@apps Server]# rpm -ivh libaio-devel-0.3.106-5.x86_64.rpm
warning: libaio-devel-0.3.106-5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:libaio-devel           ########################################### [100%]

[root@apps Server]# rpm -ivh unixODBC-2.2.11-7.1.x86_64.rpm
warning: unixODBC-2.2.11-7.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
        package unixODBC-2.2.11-7.1.x86_64 is already installed

[root@apps Server]# rpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm
warning: unixODBC-devel-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:unixODBC-devel         ########################################### [100%]

[root@apps Server]# rpm -ivh unixODBC-2.2.11-7.1.i386.rpm
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
        package unixODBC-2.2.11-7.1.i386 is already installed

[root@apps Server]# rpm -ivh unixODBC-devel-2.2.11-7.1.x86_64.rpm
warning: unixODBC-devel-2.2.11-7.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:unixODBC-devel         ########################################### [100%]

[root@apps Server]# 

 The following packages should exists on system for a successful Installation.

openmotif21-2.1.30-11.EL5.i3861
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

The following packages must be installed from the Oracle Linux 5 or RHEL 5 distribution media:

compat-libstdc++-296-2.96-138.i386
compat-libstdc++-33-3.2.3-61.i386
gcc-4.1.2-48.el5.x86_64
gcc-c++-4.1.2-48.el5.x86_64
glibc-2.5-49.i686 (32-bit)
glibc-2.5-49.x86_64
glibc-common-2.5-49.x86_64
glibc-devel-2.5-49.i386 (32-bit)
glibc-devel-2.5-49.x86_64
libgcc-4.1.2-48.el5.i386
libgcc-4.1.2-48.el5.x86_64
libstdc++-devel-4.1.2-48.el5.i386
libstdc++-devel-4.1.2-48.el5.x86_64
libstdc++-4.1.2-48.el5.i386
libstdc++-4.1.2-48.el5.x86_64
libXi-1.0.1-4.1.i386
libXp-1.0.0-8.1.el5.i386
libXp-1.0.0-8.1.el5.x86_64
libaio-0.3.106-5.i386
libaio-0.3.106-5.x86_64
libgomp-4.4.0-6.el5.x86_64
make-3.81-3.el5.x86_64
gdbm-1.8.0-26.2.1.i386
gdbm-1.8.0-26.2.1.x86_64
redhat-lsb-3.1-12.3.EL.0.2.x86_64 (on Red Hat/Oracle Linux 5 Update 7 or 5.7 only)
sysstat-7.0.2-3.el5.x86_64
util-linux-2.13-0.52.el5_4.1.x86_64

Additionally, the following RPMs are required for the database tier (running Oracle Database 11gR2):

compat-libstdc++-33-3.2.3-61.x86_64
elfutils-libelf-0.137-3.el5.x86_64
elfutils-libelf-devel-0.137-3.el5.x86_64
elfutils-libelf-devel-static-0.137-3.el5.x86_64
libaio-devel-0.3.106-5.i386
libaio-devel-0.3.106-5.x86_64
unixODBC-2.2.11-7.1.i386
unixODBC-devel-2.2.11-7.1.i386

swap memory should be 16GB or more (20GB is configured)

[root@apps ~]# grep SwapTotal /proc/meminfo
SwapTotal:      20482864 kB
[root@erpnode2 ~]# 


Verify /etc/hosts file. It should be configured with fully qualified domain name

[root@apps ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
192.168.1.144          apps.weblogic.com   apps

 Verify that the /etc/sysconfig/network file is formatted as follows:

[root@apps Server]# more /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=apps.weblogic.com


As per the documentation its recommended to use 4GB Memory for database Tier and 6GB for Application Tier (0 -10 users). So if you are performing a single node Installation in PRODUCTION then min. of 10g RAM is recommended.

Table Displays Recommended hardware requirements based on number of users:



Step:-3
create OS group, user:
[root@apps ~]# groupadd dba
[root@apps ~]# useradd  -g dba oracle
[root@apps ~]# useradd  -g dba applmgr
Step:-4
Create the Directory structure as following:
[root@apps ~]# mkdir /u01/db
[root@apps ~]# chown -R oralce:dba /u01/db
 We need to copy the all above zip files into /u01/Stage/ and change the permission to oracle:dba and change the mode(chmod 775 /u01/zipfiles)
Step:-5
Create the oraInventory Directory as following:
[root@apps ~]# mkdir /u01/db/oraInventory
[root@apps ~]# chown -R oralce:dba /u01/db/ oraInventory
[root@apps ~]# chmod -R 775 /u01/db/ oraInventory
goto /etc and edit the oraInst.loc file and set the oraInventory location as following:
[root@apps etc]# vi oraInst.loc
inventory_loc=/u01/db/oraInventory
[root@apps etc]# cat oraInst.loc
inventory_loc=/u01/db/oraInventory
Step:-6
Create Stage Area
Goto the zip files location through root user and unzip the following zip file only
[root@apps Stage]#unzip V35215-01_1of3.zip
after unzip the above zip file, you need to follow the below steps:
[root@apps bin]# pwd
/u01/Stage/startCD/Disk1/rapidwiz/bin
[root@apps bin]# sh buildStage.sh
Build Stage Menu
——————————————————
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu
Enter your choice [4]: 1
Rapid Install Platform Menu
——————————————————
1.    Oracle Solaris SPARC (64-bit)
2.    Linux x86-64
3.    IBM AIX on Power Systems (64-bit)
4.    HP-UX Itanium
5.    Exit Menu
Enter your choice [5]: 2
/u01/Stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/Stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u01/Stage/startCD/Disk1/rapidwiz/bin
Please enter the directory containing the zipped installation media:
/u01/Stage
Unzipping V29856-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35231-01_2of5.zip
Unzipping V35804-01_1of2.zip
 After unzip all the files Stage is shown below:
Verifying stage area…

Directory /u01/Stage/TechInstallMedia is valid
Directory /u01/Stage/TechPatches/DB is valid
Directory /u01/Stage/TechPatches/MiddleTier is valid
Directory /u01/Stage/EBSInstallMedia/AppDB is valid
Directory /u01/Stage/EBSInstallMedia/Apps is valid
Directory /u01/Stage/EBSInstallMedia/AS10.1.2 is valid
Directory /u01/Stage/TechInstallMedia/database is valid
Directory /u01/Stage/TechInstallMedia/ohs11116 is valid
Directory /u01/TechInstallMedia/wls1036_generic is valid
Stage area verified.
Press enter to continue…

Build Stage Menu
——————————————————
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu

Enter your choice [4]: 4
Step:-7
Installation Part
Installation star through root user 
Go to stage location & run rapidwiz as follow 
[root@apps ~]# cd /u01/Stage/startCD/Disk1/rapidwiz
[root@apps rapidwiz]# ./rapidwiz

apps 1










Click Next
apps 2










Click Next 
apps 3










Click Next 
apps 4










Click Yes
apps 5










Click Next
apps 6










Enter the Database configurations and Click Next
apps 7










Select suite licensing and Click Next
apps 8










Click Next
apps 9










Click Next
apps 10










Select the Language and character set as following
apps 11










Enter the Application configurations and Click Next as following
apps 12










Enter the Weblogic username & password as following: (password like patna123)
apps 13










Click Next
apps 14










After Validate the system configurations Click Next 
apps 15











Rapid Install wizard will now install Oracle E-Business Suite. It will take 3-4 hours time to Install.
apps 16










apps 18










After Validate the complete Installation Click Next
apps 19

apps 20



















Installation has completed successfully….
Click in Finish button
Access applications R12.2.4 home page:-
Example
http://<host name>.<domain name>:<HTTP port>/OA_HTML/AppsLogin
For example:-
http://apps.weblogic.com:8000/OA_HTML/AppsLogin

apps 21








Login username/password to access the applications
username/Password=sysadmin/sysadmin

apps 22







Access weblogic console home page as following
URL:-
http://<host name>.<domain name>:<HTTP port>/console
For example:-
http://apps.weblogic.com:7001/console
username=weblogic
password=patna123

apps 23







Now, we see the servers details as following
apps 24







Here we can see following Mange servers in web-logic:
1.forms-c4ws_server1
2.forms_server1
3.oacore_server1
4.osfm_server1
Reference from oracle note:

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

Oracle Database 12c Certification Path

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage page_id=653&get_params=p_id:248#tabs-1

Oracle Database 12c: Installation and Administration
New & Upcoming Releases   Print this Exam
Exam Number: 1Z0-062
Associated Certifications:Oracle Database 12c Administrator Certified Associate ,
ORACLE MASTER Silver Oracle Database 12c (Available only in Japan)
Exam Product Version: Oracle Database 12c,
Exam Price: Rs 9604 More on exam pricing
Duration: 150 minutes
Number of Questions: 95
Passing Score: 67% View passing score policy
Validated Against:This exam has been validated against Oracle Database 12.1.0.1.0.
format: Multiple Choice


Oracle Database 12c - Certification Path

Oracle Certified Associate

Step 1 - Pass this exam.

Pass one SQL Exam:

Oracle Database 12c: SQL Fundamentals 1Z0-061 or
Oracle Database 11g: SQL Fundamentals I 1Z0-051 or
Oracle Database SQL Expert 1Z0-047

Step 2 - Pass Exam

Exam

Oracle Database 12c: Installation and Administration 1Z0-062


Oracle Certified Professional

Step 1 - Prior Certification Requirements

Oracle Database 12c Administrator Certified Associate

Step 2 - Complete one of these courses.

Candidates must complete one of the courses below.

Show Courses

Step 3 - Pass Exam

Exam

Oracle Database 12c: Advanced Administration 1Z0-063

Step 4 - Complete this form.

Complete the course submission form


Complete the above steps to earn the Oracle Database 12c Administrator Certified Professional Certification.


View Upgrade Path

Oracle Database 12c Administrator Certified Professional - upgrade from 7.3, 8, 8i, 9i, 10g, 11g

Step 1 - Pass Exam

Exam

Upgrade to Oracle Database 12c 1Z0-060

View Upgrade Path
Oracle Database 12c Administrator OCP - upgrade from Oracle9i, Oracle Database 10g or 11g DBA OCA


Step 1 - Prior Certification Requirements
Oracle Database Administrator Certified Associate Oracle9i, Oracle Database 10g or 11g
Step 2 - Complete one of these courses.
Candidates must complete one of the courses below.
Step 3 - Pass Exam
Exam
Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP 1Z0-067

Step 4 - Complete this form.
Complete the course submission form

ORACLE APPS DBA TRAINING

ORACLE APPS DBA TRAINING TOC
Duration: 6 Days  
ORACLE APPS DBA TRAINING COURSE CONTAIN

DAY-1

ORACLE APPLICATIONS OVERVIEW 

R12 ORACLE E-BUSINESS SUITE ARCHITECTURE

Oracle Applications Technology
Oracle Applications Environment Files, Server Process Scripts, and Languages
Oracle Applications File System
Oracle Applications Database


ORACLE E-BUSINESS SUITE MULTI-TIER ARCHITECTURE

Desktop Tier
Application Tier
Database Tier
Oracle Homes Architecture

RELEASE R12 INSTALLATION

Single-node Installation
Multi-node Installation

HANDS-ON INSTALLATION OF E-BUSINESS SUITE R12


DAY-2

R12 PATCH AND MAINTAIN ORACLE APPLICATIONS

Patching and the AutoPatch Process
Patch Advisor
Running AutoPatch
Other Patching Topics
Patch History Database

ONLINE PATCHING CONCEPTS 

Patch Types, Terminology, and Components
Patch Creation and Patching Order
Patching Utilities
Introduction to Online Patching
Architectural Changes to Support Online Patching
Database Implementation
Editioning Views and the Application Data Model
Phases of the Online Patching Cycle

RUNNING THE AD ONLINE PATCHING UTILITY 

AD Online Patching Utility
Running the adop Utility
adop Commands
Executing the Patching Cycle
Status of a Patching Cycle
Patching in Multi-Node Environments
adop Remote Invocation
Hotpatch Mode

DAY-3

FILE SYSTEM

Oracle Applications Technology
Oracle Applications Environment Files and Server Process Scripts
Oracle Applications Entire File System
The Applications and Database Context Files

R12 USE ORACLE APPLICATIONS AD UTILITIES 

What are the AD Utilities?
AD Administration
Special Utilities
Context Editor
AutoConfig
License Manager
Reporting Utilities
Configuration Utilities


CONCURRENT

Managing Concurrent Programs and Reports
Administering Concurrent Managers
Managing Profile Options
Incorporating a Custom Program

Day-4

AUTOCONFIG AND CONFIGURATION CHANGES

Reduced Role for AutoConfig
Configuration Tools
New AutoConfig Tools for System Configuration
Service Groups and Services in Release R12.1.3/12.2.3
AutoConfig Managed Service Groups and Services
Managing Oracle HTTP Server Configurations
Web Applications
Summary of Configuration Changes
Autoconfig Template and Driver files Concepts

PRINTERS

Managing Printers
Registering Printers
Troubleshooting Printer Issues
Details of Autoconfig. What exactly happens while running autoconfig
Release R12 Autoconfig Lab
Running Autoconfig on the existing Oracle Application.

DAY-5

R12 ORACLE APPLICATIONS ADVANCED TOPICS 

CLONING CONCEPTS (MANUAL/RMAN COLD & HOT BACKUP)

Rapidclone Concepts
Cloning From Single node to Single node
Cloning From Multi-Node to Multi-Node
Cloning From Multi-Node to Single-Node
Database Refresh
Post-Clone Procedures


SECURITY

Creating Users
Assigning Responsibilities
FNDCPASS Concepts
Changing User Passwords using FNDCPASS


WORKFLOW

Introduction to Oracle Workflow
Workflow Configuration
Workflow Troubleshooting

Day-6

R12 SYSTEM ADMINISTRATOR FUNDAMENTALS
SYSTEM ADMINISTRATION

Creating Users
Assigning Responsibilities
Setting Up Printers
Changing Profile Options


TROUBLESHOOTING & PERFORMANCE TUNING

User connectivity issues Troubleshooting
Apache Troubleshooting
Jserv Troubleshooting
OC4J Troubleshooting
Forms & Concurrent Processing Troubleshooting
Autoconfig related issues Troubleshooting
Long-Running Jobs Troubleshooting
Java Memory Settings and Tuning
Troubleshooting Cloning Issues
Apps Health Monitoring


************************END*************************************

ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'

 This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...