Tackle Archive Log failure in RAC Environment

Check out my new page to Tackle Archive Log failure in RAC Environment.

List the count of Objects schema wise in Oracle

select owner,
max( decode( object_type, 'TABLE', cnt, null ) ) Tables,
max( decode( object_type, 'VIEW', cnt, null ) ) Views,
max( decode( object_type, 'TRIGGER', cnt, null ) ) triggers,
max( decode( object_type, 'PACKAGE', cnt, null ) ) packages
from ( select owner, object_type, count(*) cnt
from dba_objects
group by owner, object_type )
group by owner
/

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