What is ERP?
ERP stands for enterprise resource planning.
The package which contains application,software and database etc is said to ERP package.
ERP available in the market
===================
1)ORACLE APPS
2)SAP
3)PEOPLESOFT
4)JD EDWARDS
5)RAMCO
6)MARSHALL
7)STRAPUS
The most famous ones are ORACLE APPS(oracle applications from oracle corporation) and SAP.
Oracle apps is more used in finance side.
SAP is more used in manufacturing side.
Oracle apps is bug included and where as SAP bug free.
Single node:
=======
If the database and application services maintained on only one server ,then it is said to be single node.
Mutli node:
=======
If the database and application services are maintained on different servers,then it is said to be mutli node.
========
Difference Between Oracle apps 11i & R12
Difference Between Oracle apps 11i & R12
Summary of Changes
Component
|
Release 11i
|
Release 12
|
Database
|
9.2
|
10.2
|
Developer
|
6i
|
10i
|
Application Server
|
1.0
|
10.1
|
Client Plug-in
|
Jinitiator
|
SUN JRE
|
Java Containers
|
Jserv
|
OC4J
|
Changes in Detail
APPMGR
| ||
OLD
|
NEW
| |
APPL_TOP
|
$HOME/<SID>appl
|
$HOME/apps/apps_st/appl
|
COMMON_TOP
|
$HOME/<SID>comn
|
$HOME/apps/apps_st/comn
|
ORACLE_HOME
|
$HOME/<SID>ora/8.0.6
|
$HOME/apps/tech_st/10.1.2
|
IAS_ORACLE_HOME
|
$HOME/<SID>ora/iAS
|
$HOME/apps/tech_st/10.1.3
|
ORACLE
| ||
OLD
|
NEW
| |
ORACLE_HOME
|
$HOME/<SID>db/10.2.0
|
$HOME/db/tech_st/10.2.0
|
ORADATA
|
$HOME/<SID>data
|
$HOME/db/apps_st/data
|
INST_TOP (New Addition)
| ||
OLD
|
NEW
| |
INST_TOP
|
NA
|
$HOME/inst/apps/<context_name>
|
What’s new in Oracle Apps R12
Key points to Note:
- Oracle Applications Release 12 is the latest release in the chain of E-Business Suite Releases by Oracle.
- This release came up with the new file system model
- Autoconfig will not write anything in APPL_TOP, COMMON_TOP area in R12.
- All instance specific configurations, log files are written in INST_TOP area. This home provides the ability to share Applications and technology stack.
R12 new features
- Applications Server 9i is replaced by 10g (10.1.3.X)
- Forms & Reports Version 6i (8.0.6) are replaced by Forms & Reports Version 10g i.e. 10.1.2.X
- mod_jserv is replaced by oc4j
- Java/ JDK version 1.3.X or 1.4.X will be replaced by JDK 1.5.X
- Database (RDBMS_ORACLE_HOME) - 10.2.0.2
- FORMS ORACLE_HOME (8.0.6 ORACLE HOME equivalence) - 10.1.2
- OC4J_ORACLE_HOME (iAS ORACLE_HOME equivalence) - 10.1.3
- A new top INSTANCE_TOP is introduced in Release 12 for configuration and log files along with the other TOP's in existing in 11i.
- All instance specific configurations, log files are written in INST_TOP area.
- This home provides the ability to share Applications and technology stack.
- Instance home is the top-level directory for an applications instance which is known as Instance Home and is denoted the environment variable $INST_TOP.
- This contains all the config files, log files, SSL certificates etc.
- The additional Instance Home makes the middle tier easier to manage and organized since the data is kept separate from the config files.
- The Instance Home also has the ability to share the Applications and Technology stack code across multiple instances.
- Another advantage of the Instance Home is that the autoconfig writes only in INST_TOP so APPL_TOP and ORACLE_HOME can also be made read only file system if required.
All startup files are in $INST_TOP/admin/scripts .
While creating Share Appl Top we can keep all other tops as read only except INST_TOP.
If you want to install R12 on virtual host start rapidwiz as "rapidwiz -servername virtual"
Just change s_cphost to physical hostname and run autoconfig, otherwise ICM and WF Mailer
container components will have issue while starting.
All about OPMN
=============
In R12 services are managed by OPMN(Oracle process manager and notification server).
OPMN COMPONENTS
==============
OPMN consists of two main components
1) Oracle Process Manager
2) Oracle Notification Server
1)Oracle Process Manager is responsible for below things.
=======================================
1) starting
2) stopping
3) restarting
4) monitoring the services it manages (this includes death detection and automatic restart of the process).
2) Oracle Notification Server
Oracle Notification Server is the transport mechanism for failure, recovery, startup, and other related notifications between components in AS.
Single configuration file(opmn.xml) is used OPMN to manage the services.
Config file location is given as $ORA_CONFIG_HOME/10.1.3/opmn/conf/opmn.xml
To see more in details
========================
http://docs.oracle.com/cd/B13597_05/core.904/b12057/common.htm#CACHJAGG
http://otndnld.oracle.co.jp/document/products/as10g/101300/B25221_03/core.1013/b15976/opmnctl.htm
wonderful document on opmn
==========================
http://isu.ifmo.ru/docs/IAS904/core.904/b12057/intro.htm#1015088
http://otndnld.oracle.co.jp/document/products/as10g/101300/B25221_03/core.1013/b15976/opmnctl.htm
OPMN SERVICES
Services managed by opmn are (grep process-type opmn.xml)
1) HTTP_Server
2) oacore
3) forms
4) oafm
Starting OPMN managed Services
Starting Complete OC4J container
=================================
./adopmnctl.sh startproc ias-component=OC4J
Starting individual process-type(s)
./adopmnctl.sh startproc ias-component=OC4J process-type=oafm
./adopmnctl.sh startproc ias-component=OC4J process-type=forms
./adopmnctl.sh startproc ias-component=OC4J process-type=oacore
Starting HTTP Server (Apache)
./adopmnctl.sh startproc ias-component=HTTP_Server
Stoping OPMN managed Services
Stoping Complete OC4J container
./adopmnctl.sh stopproc ias-component=OC4J
Stoping individual process-type(s)
./adopmnctl.sh stopproc ias-component=OC4J process-type= oafm
./adopmnctl.sh stopproc ias-component=OC4J process-type= forms
./adopmnctl.sh stopproc ias-component=OC4J process-type= oacore
Stoping HTTP Server (Apache)
./adopmnctl.sh stopproc ias-component=HTTP_Server
Benefits of OPMN
OPMN detects the death of the process which it manages and brings up in almost no time.
1) OS process is checked by OPMN for every 2 seconds.
2) forward ping: periodically OPMN pings the process for every 20 seconds and expects response
3) reverse ping: every 20 seconds managed process sends OPMN a ping notification.
How to Find the Java Source Code Produced for a Translated JSP Page [ID 416590.1]
ReplyDeletehttp://knoworacleappsdba.blogspot.in/2013/05/adoafmctlsh-fails-after-1213-upgrade.html
ReplyDeleteasslam walikuam please give this answers
ReplyDeleteHow will you handle LONG RUNNING REQUESTS
How to find sql of long running request
How to find incompatibilities
Why it is long running
Tables involved with respect to the long running request
Data dictionaries you refer to find all the above
What type of cloning you did in your previous org
What type of cloning you know
EBS page is not opening after clone what is your approach
Forms are not opening
Don't have backup of XML file what is your approach
Diff b/w dbconfig and dbtier
Custom forms are not opening after cloning
Custom reports are going into error
Types of Mangers and their roles
How will you check CM logs and there location
CM Actual and Target are mismatching and your approach
CM Managers are not coming up
How to define custom manager and how to assign concurrent program to custom manager
Thanks for sharing Brother. Much appreciated...
ReplyDeleteHi,
ReplyDeleteIt's a very nice article on oracle ,At starting you mentioned ERP also you mentioned the categories in ERP ,and you mentioned he difference b/w 11i and R12 and new features in R12 etc.Those are ver informative and useful to the users ,keep posting this type of articles on oracle .
Thank you.
oracle R12 training
Sure , Thanks for visting my blog
DeleteHi Bro Please answer these questions and you have any questions in real time mail me .Its use full for me please .
ReplyDeleteHow will you handle LONG RUNNING REQUESTS
How to find sql of long running request
How to find incompatibilities
Why it is long running
Tables involved with respect to the long running request
Data dictionaries you refer to find all the above
What type of cloning you did in your previous org
What type of cloning you know
EBS page is not opening after clone what is your approach
Forms are not opening
Don't have backup of XML file what is your approach
Diff b/w dbconfig and dbtier
Custom forms are not opening after cloning
Custom reports are going into error
Types of Mangers and their roles
How will you check CM logs and there location
CM Actual and Target are mismatching and your approach
CM Managers are not coming up
How to define custom manager and how to assign concurrent program to custom manage.
DeleteHi Chinna,
Why it is long running
There are many reason for a sql to run for a long time.
Developers actually change the query from time to time and they will not inform us.
suppose they are extracting data from the tables for 1 week and gets complete in 10 mins.
when they run request next time they will give parameter/input for 2 weeks which obviously take more time roughly 20 mins or more and they say
last time it has completed in 10 mins.
To be honest with you ,its very difficult to say.it could be due to below reason.
1)Change in the parameters
2)More load on the server
3)suppose a query runs everytime outside business hours but they have submitted inside the business hours due to that it will run for long time.
4)Take out AWR report / sql query exectuion plan etc.
What type of cloning you did in your previous org
RMAN hot backup cloning and it differ from customer to customer and place to place .
What type of cloning you know
As a DBA , you should be knowing all cloning methods and procedures.
1) RMAN hot cloning or RMAN backup base ==> Mostly used
2)Cold backup or Tape backup
3)Active duplicate
How to find incompatibilities
You can find from SRS , front end.
Don't have backup of XML file what is your approach
you can rebuild xml file, check my blog.
How to retrive xml file post
Diff b/w dbconfig and dbtier
Check cloning interview question
EBS page is not opening after clone what is your approach
Forms are not opening
Types of Mangers and their roles
https://abduulwasiq.blogspot.com/p/concurrent-manager-issues.html
How will you check CM logs and there location
https://abduulwasiq.blogspot.com/p/concurrent-manager-issues.html
Custom forms are not opening after cloning
Custom reports are going into error
CM Actual and Target are mismatching and your approach
CM Managers are not coming up
How to define custom manager and how to assign concurrent program to custom manage.
Tables involved with respect to the long running request
Data dictionaries you refer to find all the above
How will you handle LONG RUNNING REQUESTS
How to find sql of long running request
Please check my blog for this