Oracle Application R12 Architecture

ORACLE EBS R12 ORACLE_HOMES 

 

TOP – STRUCTURE

In $INST_TOP à $APPS_BASE/inst/apps/$CONTEXT_NAME/

ü       /scripts à ADMIN_SCRIPTS_HOME: Find all AD scripts here

In $APPL_TOP :----

1. /appl : APPL_CONFIG_HOME. For standalone envs, this is set to

2.       /fnd/12.0.0/secure à FND_SECURE: dbc files here

3.       /admin à All Env Config files here

4.       /certs à SSL Certificates go here

5.       logs à LOG_HOME: Central log file location. All log files are placed here (except adconfig)

6. /ora à ORA_CONFIG_HOME
7. /10.1.2 à 'C' Oracle home config, Contains tnsnames and forms listener.
8. /10.1.3 à Apache & OC4J config home, Apache, OC4J and opmn This is the 'Java' oracle home configuration for OPMN, Apache and OC4J
9. /pids à Apache/Forms server PID files here
10. /portal à Apache's DocumentRoot folder

 

 

Author – Akash Pramanik

Write to me at – akash007.pramanik@gmail.com

Apps DBA Interview questions and Answers.

Find in my latest page:-
http://akashpramanik.blogspot.in/p/normal-0-false-false-false.html

Tackle RMAN Clone or Refresh Failures

Find my New page on
"Tackle RMAN Clone or Refresh Failures"

GET THE CURRENT SQL STATEMENT RUNNING FOR A CONCURRENT REQUEST in Oracle

-- GET THE CURRENT SQL STATEMENT RUNNING FOR A CONCURRENT REQUEST

SELECT A.REQUEST_ID, D.SID, D.SERIAL#, D.OSUSER, D.PROCESS, C.SPID,
       E.SQL_TEXT
  FROM APPS.FND_CONCURRENT_REQUESTS A,
       APPS.FND_CONCURRENT_PROCESSES B,
       V$PROCESS C,
       V$SESSION D,
       V$SQL E
WHERE A.CONTROLLING_MANAGER = B.CONCURRENT_PROCESS_ID
   AND C.PID = B.ORACLE_PROCESS_ID
   AND B.SESSION_ID = D.AUDSID
   AND D.SQL_ADDRESS = E.ADDRESS
   AND A.REQUEST_ID = &REQUEST_ID;

Find the sql running behind an SID in Oracle Database

select a.sid, a.serial#, b.sql_text
   from v$session a, v$sqlarea b
    where a.sql_address=b.address
     and a.sid = &sid;