EBS 11i/ R12


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


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:
  1. Oracle Applications Release 12 is the latest release in the chain of E-Business Suite Releases by Oracle.
  2. This release came up with the new file system model
  3. Autoconfig will not write anything in APPL_TOP, COMMON_TOP area in R12.
  4. 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
  1. Applications Server 9i is replaced by 10g (10.1.3.X)
  2. Forms & Reports Version 6i (8.0.6) are replaced by Forms & Reports Version 10g i.e. 10.1.2.X
  3. mod_jserv is replaced by oc4j
  4. Java/ JDK version 1.3.X or 1.4.X will be replaced by JDK 1.5.X
Techstack Components Changes
  • 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
File system level changes
  • 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.
What is INSTANCE TOP 

  • 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.
Advantages of new INSTANCE HOME

  • 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.
      if you change apps password  it does not require to change apps password  in any configuratoin file.
      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.




8 comments:

  1. How to Find the Java Source Code Produced for a Translated JSP Page [ID 416590.1]

    ReplyDelete
  2. http://knoworacleappsdba.blogspot.in/2013/05/adoafmctlsh-fails-after-1213-upgrade.html

    ReplyDelete
  3. asslam walikuam please give this answers

    How 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


    ReplyDelete
  4. Thanks for sharing Brother. Much appreciated...

    ReplyDelete
  5. Hi,
    It'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

    ReplyDelete
  6. Hi Bro Please answer these questions and you have any questions in real time mail me .Its use full for me please .

    How 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.

    ReplyDelete
    Replies




    1. Hi 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

      Delete