Query - DBA Audit Trail

Query - DBA Audit Trail


col USERNAME for a10
col OS_USERNAME for a10
col USERHOST for a15
col ACTION_NAME for a11
set pages 200 lines 100
alter session set nls_date_format='DD-MON-YY HH24:MI:SS';
select USERNAME,OS_USERNAME,USERHOST,TIMESTAMP,ACTION_NAME, LOGOFF_TIME from dba_audit_trail where username=''USERNAME" order by USERHOST;

Query - Checking RMAN Backup Status

Query - Checking RMAN Backup Status

set linesize 150
col INSTANCE for a9
col ELAPSED for a30
 SELECT      (  SELECT   instance_name FROM v$instance)
              || ' '
              || (  SELECT   instance_number FROM v$instance)
                 instance,
            --  TO_CHAR (start_time, 'yyyy-mm-dd hh24:mi') start_time,
       to_date (start_time, 'dd-mm-yyyy hh24:mi:ss') start_time,
              TO_CHAR (output_bytes / 1048576, '999,999,999.9') output_mb,
              TO_CHAR (output_bytes_per_sec / 1048576, '999,999.9') mb_S,
              time_taken_display elapsed,input_type,
            status
     FROM   v$rman_backup_job_details
     where start_time >= sysdate - &Days
 ORDER BY   start_time;

Query - User Information

USER INFORMATION

set lines 100 pages 999

set verify off

set feedback off

undefine user

accept userid prompt 'Enter username:'

select username,default_tablespace,temporary_tablespace from dba_users where username = '&userid'

/

select tablespace_name,decode(max_bytes,-1,'unlimited',ceil(max_bytes / 1024 / 1024) || 'M' ) "QUOTA" from dba_ts_quotas where  username = upper('&&userid')

/

select granted_role || ' ' || decode(admin_option, 'NO', '', 'YES', 'with admin option') "ROLE" from dba_role_privs where grantee = upper('&&userid')

/

select privilege || ' ' || decode(admin_option, 'NO', '', 'YES', 'with admin option') "PRIV" from dba_sys_privs where  grantee = upper('&&userid')

/

undefine user

set verify on

set feedback on

Concurrent Request History Info

Concurrent Requests history:

alter session set NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI';

select REQUESTOR,REQUEST_ID,ACTUAL_START_DATE,ACTUAL_COMPLETION_DATE,(ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24*60 time,USER_CONCURRENT_PROGRAM_NAME,PHASE_CODE,STATUS_CODE from apps.fnd_conc_req_summary_v
where ACTUAL_START_DATE >= '27-APR-2012 01:00'
and  ACTUAL_START_DATE <= '27-APR-2012 04:00'
order by ACTUAL_START_DATE asc

select REQUESTOR,count(1) from apps.fnd_conc_req_summary_v  
where ACTUAL_START_DATE >= '27-APR-2012 01:00'  
and  ACTUAL_START_DATE <= '27-APR-2012 04:00'  
group by REQUESTOR


select REQUESTOR,USER_CONCURRENT_PROGRAM_NAME,ARGUMENT_TEXT from apps.fnd_conc_req_summary_v  
where ACTUAL_START_DATE >= '27-APR-2012 01:00'  
and  ACTUAL_START_DATE <= '27-APR-2012 04:00'
order by REQUESTOR

UR's Key Run ;-) 

DBA Queries

Query to find out Command fired by Currently Connected Users

SELECT SUBSTR(s.username,1,15) USERNAME,
SUBSTR(s.status,1,8) STATUS,
SUBSTR(s.server,1,10) SERVER,
SUBSTR(s.type,1,10) TYPE,
SUBSTR(s.event,1,20) "WAIT EVENT",
DECODE(s.command,
       1,'Create Table',
       2,'Insert',
       3,'Select',
       6,'Update',
       7,'Delete',
       8,'Drop',
       9,'Create Index',
      10,'Drop Index',
      12,'Drop Table',
      17,'Grant',
      26,'Lock Table',
      42,'Alter Session',
      43,'Alter User',
      44,'Commit',
      45,'Rollback',
      s.command) COMMAND
FROM v_$session s, v_$session_wait w
WHERE (s.sid = w.sid)
AND s.username != 'SYS'
ORDER BY s.username;

Query to know Tablespace Usage by Users
a. Tablespace usage grouped by Owner and Tablespace.
COLUMN "Used MB" FORMAT 9,999,9999

BREAK ON REPORT ON Owner SKIP 1
COMPUTE SUM OF "Used MB" ON REPORT
COMPUTE SUM OF "Used MB" ON OWNER
SELECT ROWNUM AS Rank,
       Segments.*
FROM
       ( SELECT  Owner         ,
                Tablespace_Name,
                SUM ( Bytes ) / 1024 / 1024 "Used MB"
       FROM     DBA_SEGMENTS
       WHERE    Owner NOT IN ( 'SYS', 'SYSTEM', 'SYSAUX' )
       GROUP BY Owner,
                Tablespace_Name
       ORDER BY 3 DESC
       ) Segments
WHERE  ROWNUM <= 10;
CLEAR BREAKS
CLEAR COMPUTES


b.Space usage by each tablespace.

COMPUTE SUM OF "Used MB"ON Report
COMPUTE SUM OF "Used MB"ON Tablespace_Name
COLUMN "Used MB" FORMAT 9,999,990.99
SELECT ROWNUM AS Rank,
       Segments.*
FROM
       ( SELECT  Tablespace_Name,
                Owner           ,
                SUM ( Bytes ) / ( 1024 * 1024 ) "Used MB"
       FROM     DBA_SEGMENTS
       WHERE    Owner NOT IN ( 'SYS', 'SYSTEM', 'SYSAUX' )
       GROUP BY Tablespace_Name,
                Owner
       ORDER BY 3 DESC
       ) Segments
WHERE  ROWNUM <= 10;
CLEAR BREAKS
CLEAR COMPUTES


Basic Oracle queries/commands which might turn out extremely helpful to the beginners of Oracle database:

1. To check the name of the database:
SQL> select name from v$database;

2. To check the version of a database:
SQL> select * from v$version;

3. To check the size of the database.
SQL> select (select sum(bytes/1024/1024/1024) from dba_data_files)+(select sum(bytes/1024/1024/1024) from dba_temp_files) “Database Size in GB” from dual;

4. To check the current size of a tablespace:
SQL> select sum(bytes/1024/1024/1024) ” Size in GB” from dba_data_files where tablespace_name=’<TABLESPACE_NAME>’;

5. To check the free space of a tablespace:
SQL> select sum(bytes/1024/1024/1024) from dba_free_space where tablespace_name=’<TABLESPACE_NAME>’;

6. To check the size of a table:
SQL> Select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’<TABLE_NAME>’ and segment_type=’TABLE’;

7. To list all the tablespaces in the database:
SQL> select tablespace_name from dba_tablespaces;

8. To list all the users in the database:
SQL> select username from dba_users;

9. To check the default tablespace of a user:
SQL> select default_tablespace from dba_users where username=’<USERNAME>’;

10. To create a user:
SQL> create user <USERNAME> identified by <PASSWORD> default tablespace <DEFAULT_TABLESPACE_NAME> temporary tablespace <TEMP>;

11. To change the password of a user:
SQL> Alter user USERNAME identified by PASSWORD;

12. To drop a user along with its objects:
SQL> Drop user <USERNAME> cascade;

13. To list the details of the sessions currently connected to the database:
SQL> select sid,serial#,username,status from v$session;

14. To kill/terminate a user’s session:
Get the SID and SERIAL# of the session
SQL> select sid,serial#,username,status from v$session where username=’<USERNAME>’
Substitute the values for SID and SERIAL# in the below query.
SQL> Alter system kill session ‘SID,SERIAL#’;

15. To list all the objects of a user:
SQL> Select object_name,object_type from dba_objects where owner=’USERNAME’;

Websites List

www.shutdownabort.com
http://psoug.org/library.html
http://tahiti.oracle.com/
http://arjudba.blogspot.in/search/label/https://netfiles.uiuc.edu/jstrode/www/oscript/index.html
http://newappsdba.blogspot.in/2009/11/setting-em-blackouts-from-gui-and.html
http://nimishgarg.blogspot.in/search/label/Oracle%20DBA
http://shahiddba.blogspot.in/2012/04/oracle-dba-daily-checklist.html
http://shahiddba.blogspot.in/search/label/Scripts
http://nimishgarg.blogspot.in/2010/12/some-routine-db-checklist-queries.html
http://www.oracle.com/technetwork/indexes/documentation/index.html
http://yathishksdba.wordpress.com/2011/09/18/important-querys-to-dba/
http://beginapps.blogspot.in/2008/05/database-important-scripts.html
http://www.think-forward.com/sql_scripts.htm
http://www.pragnum.com/Resources.htm
http://www.orafaq.com/wiki/Oracle_database_FAQ
http://rafioracledba.blogspot.in/2010/08/useful-queries-for-dba.html
http://orachat.com/oracle-dba-performance-queries/
http://www.oracle-base.com/dba/scripts.php
http://www.idevelopment.info/cgi/ORACLE_dba_scripts.cgi
http://www.dbapool.com/scripts.php
http://www.dbatutor.com/2010/12/oracle-database-useful-queries-scripts.html

http://www.folkstalk.com/2011/12/101-examples-of-using-find-command-in.html
http://www.devdaily.com/blog/post/linux-unix/linux-find-command
http://www.thegeekstuff.com/2009/03/15-practical-linux-find-command-examples/
http://sattia.blogspot.in/2012/05/learn-linuxunix-find-command-with-60.html

Database Theory

Delaying the application of logs to a physical standby

A standby database automatically applies redo logs when they arrive from the primary database. But in some cases, we want to create a time lag between the archiving of a redo log at the primary site, and the application of the log at the standby site.

Modify the LOG_ARCHIVE_DEST_n initialization parameter on the primary database to set a delay for the standby database.

The following is an example of how to add a 1-hour delay:

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=stdby_srvc DELAY=60';

The DELAY attribute is expressed in minutes.

The archived redo logs are still automatically copied from the primary site to the standby site, but the logs are not immediately applied to the standby database. The logs are applied when the specified time interval expires.
 
11g Snapshot Standby Database

Oracle 11g introduces the Snapshot Standby database which essentially is an updateable standby database which has been created from a physical standby database.

We can convert a physical standby database to a snapshot standby database, do some kind of testing on a database which is a read write copy of the current primary or production database and then finally revert it to it’s earlier state as a physical standby database.

While the snapshot standby database is open in read-write mode, redo is being received from the primary database, but is not applied.

After converting it back to a physical standby database, it is resynchronized with the primary by applying the accumalated redo data which was earlier shipped from the primary database but not applied.

Using a snapshot standby, we are able to do real time application testing using near real time production data. Very often we are required to do production clones for the purpose of testing. But using snapshot standby databases we can meet the same requirement sparing the effort,time,resources and disk space.

Reference:

http://gavinsoorma.com/2009/07/11g-snapshot-standby-database/

11g Oracle Active Data Guard

Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, web-based access, etc., while continuously applying changes received from the production database. 


Oracle Active Data Guard also enables the use of fast incremental backups when offloading backups to a standby database, and can provide additional benefits of high availability and disaster protection against planned or unplanned outages at the production site.

   

AutoPatch is verifying your username/password....Unable to connect.

Adpatch Issue:

Even though giving correct 'apps' password, adpatch again and again prompts for 'apps' password saying unable to connect.

Error:


Enter the ORACLE password of Application Object Library [APPS] :

AutoPatch is verifying your username/password....Unable to connect.

Error: The given ORACLE password is not the correct password.
Please re-enter the ORACLE username and password.

Enter the ORACLE password of Application Object Library [APPS] :

Fix:

Issue could be 'applsys' account got locked. Check for it.

SQL> select username,ACCOUNT_STATUS, LOCK_DATE from dba_users where USERNAME in ('APPS','APPLSYS','SYSTEM');

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE

------------------------------ -------------------------------- ---------------

SYSTEM                         OPEN

APPLSYS                        LOCKED(TIMED)                    29-MAY-12

APPS                           OPEN

SQL> alter user APPLSYS account unlock;

User altered.

UR's Key Run ;-) 

oracle.apps.fnd.framework.OAException: Could not load application module

After cloning EBS application, able to login home page

Navingating to XML Publisher Administrator -> Home/Adminstration  throws error page

Error Page:

You have encountered an unexpected error. Please contact the System Administrator for assistance.


Error Details:

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.xdo.oa.admin.server.AdminAM'.
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:279)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1183)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
at _oa__html._OA._jspService(_OA.java:85)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._RF._jspService(_RF.java:102)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
JBO-30003: The application pool (usashlorcdbd03.lyv.livenation.comDEV21526oracle.apps.xdo.oa.admin.server.AdminAM) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.NoDefException, msg=JBO-25002: Definition oracle.apps.xdo.oa.admin.server.AdminAM of type ApplicationModule not found
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1619)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2366)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:427)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:214)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:491)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:398)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1183)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
at _oa__html._OA._jspService(_OA.java:85)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._RF._jspService(_RF.java:102)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.xdo.oa.admin.server.AdminAM of type ApplicationModule not found
at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:329)
at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:269)
at oracle.jbo.server.MetaObjectManager.findMetaObject(MetaObjectManager.java:649)
at oracle.jbo.server.ApplicationModuleDefImpl.findDefObject(ApplicationModuleDefImpl.java:232)
at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:359)
at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:91)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:135)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:76)
at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:1993)
at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:361)
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1552)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2366)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:427)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:214)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:491)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:398)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1183)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
at _oa__html._OA._jspService(_OA.java:85)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._RF._jspService(_RF.java:102)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
JBO-30003: The application pool (usashlorcdbd03.lyv.livenation.comDEV21526oracle.apps.xdo.oa.admin.server.AdminAM) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.NoDefException, msg=JBO-25002: Definition oracle.apps.xdo.oa.admin.server.AdminAM of type ApplicationModule not found
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1619)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2366)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:427)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:214)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:491)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:398)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1183)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
at _oa__html._OA._jspService(_OA.java:85)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._RF._jspService(_RF.java:102)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.xdo.oa.admin.server.AdminAM of type ApplicationModule not found
at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:329)
at oracle.jbo.mom.DefinitionManager.findDefinitionObject(DefinitionManager.java:269)
at oracle.jbo.server.MetaObjectManager.findMetaObject(MetaObjectManager.java:649)
at oracle.jbo.server.ApplicationModuleDefImpl.findDefObject(ApplicationModuleDefImpl.java:232)
at oracle.jbo.server.ApplicationModuleImpl.createRootApplicationModule(ApplicationModuleImpl.java:359)
at oracle.jbo.server.ApplicationModuleHomeImpl.create(ApplicationModuleHomeImpl.java:91)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:135)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.createApplicationModule(DefaultConnectionStrategy.java:76)
at oracle.jbo.common.ampool.ApplicationPoolImpl.instantiateResource(ApplicationPoolImpl.java:1993)
at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:361)
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:1552)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:2366)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:427)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:214)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:491)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:398)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1183)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
at _oa__html._OA._jspService(_OA.java:85)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._RF._jspService(_RF.java:102)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)

Fix :

Checking 1st line of the Error

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.xdo.oa.admin.server.AdminAM'.

- Need to check is this existing in Application - 'oracle.apps.xdo.oa.admin.server.AdminAM'

- Do
  ls -l $JAVA_TOP/oracle/apps/xdo/oa/admin/server/AdminAM*

  In our case path from admin not existing. It was missed while copying $COMMON_TOP from Source to Target.
  Copied the missing directory (in our case admin directory)recursively from Source. Issue got fixed :)

  To copy a directory recursively:

  [applmgr01@oraplayers01]scp -r admin applmgr09@oraplayers09:<Target Path>/


UR's Key Run ;-) 

SCP

SCP #

Copy directory recursively:

[applmgr01@oraplayers01]scp -r admin applmgr09@oraplayers09:<Target Path>/

UR's Key Run ;-)