Sep 29, 2012
ORA-01940: cannot drop a user that is currently connected
513

ORA-01940: cannot drop a user that is currently connected

ORA-01940: cannot drop a user that is currently connected: Whenever you get an error like this, just use the below query: SQL> select sid, serial# from v$session where username = ‘USER’; SID SERIAL# ———- ———- 1826 56756 SQL> alter system kill session ‘1826,56756’; System altered. SQL> drop user USER cascade;...
Sep 25, 2012
Scenario-Patch fails because of missing prerequisite
1.5K

Scenario-Patch fails because of missing prerequisite

// // Adpatch is running and fails on one of the workers.To fix this worker and continue with the patch installation, a new patch (Prerequisite) needs to be applied. Considering that only 1 adpatch session can run on an instance at any given time,how can a patch be applied when...
Sep 25, 2012
adbldxml.pl in Oracle Apps
4.5K

adbldxml.pl in Oracle Apps

// // How to rebuild context file in Oracle Apps and how to create a context file in oracle apps 11i and R12 11i application Tier Context File Creation For the appsTier Under $AD_TOP/bin perl adbldxml.pl tier=apps appsuser=apps appspass=apps template=/u01/apps/prodappl/ad/11.5.0/admin/template/adxmlctx.tmp log=/home/applmgr/adbldxml.log out=/u01/apps/prodappl/admin/PROD_apps.xml servername=apps.oracle.com jtop=/u01/apps/prodcomn/util R12 application Tier Context File Creation:...
Sep 17, 2012
Oracle Apps Workflow Tables
603

Oracle Apps Workflow Tables

// // Oracle Apps Workflow Tables… WF_ACTIVITIES table stores the definition of an activity. Activities can be processes, notifications, functions or folders. A process activity is a modelled workflow process, which can be included as an activity in other processes to represent a subprocess. A notification activity sends a message...
Sep 17, 2012
Oracle Apps Output Post Processor (OPP)
500

Oracle Apps Output Post Processor (OPP)

The Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the...
Sep 17, 2012
How to check which modules are installed on e-business suite
1.1K

How to check which modules are installed on e-business suite

How to check which modules are installed on e-business suite?? select b.application_name, c.meaning From FND_PRODUCT_INSTALLATIONS a, fnd_application_tl b,fnd_lookup_values c where a.application_id = b.application_id and a.status = c.lookup_code and c.lookup_Type = ‘FND_PRODUCT_STATUS’;
Sep 15, 2012
ORA-20100: File l5234004.tmp creation for FND_FILE failed
907

ORA-20100: File l5234004.tmp creation for FND_FILE failed

// // ORA-20100: File l5234004.tmp creation for FND_FILE failed 1. The $APPLTMP, $APPLPTMP variables and UTL_FILE_DIR database parameter should point to the same location and should have  enough space and oracle and applmgr users have written permission on that directory. 2. FND_FILE.PUT_LINE is able to create new files in the...
Sep 13, 2012
Oracle 11g Active Dataguard
1.2K

Oracle 11g Active Dataguard

// // Difference between Oracle 10g Dataguard and Oracle 11g Dataguard Active Data Guard is a new option for Oracle Database 11g Enterprise Edition An Active Data Guard standby database is an exact copy of the primary that is open read-only while it continuously applies changes transmitted by the primary...
Sep 12, 2012
How to unlock admin user in Weblogic
1.1K

How to unlock admin user in Weblogic

// // How to unlock admin user in Weblogic: Admin user will be locked if you access multiple times with wrong password, you will get below error in this scenario: [SimpleSchedulerThread] [ERROR] com.deacos.cxx.server.masterejb.MasterEjbBean: com.deacos.cxx.server.datalayer.repository.security.AccessException: SIP-09070: No more logins allowed User “admin” is locked (exceeded max logins allowed)” [SimpleSchedulerThread] [ERROR] com.deacos.cxx.server.masterejb.MasterEjbBean: com.deacos.cxx.server.datalayer.repository.security.AccessException: SIP-09070:...
Sep 08, 2012
ORA-01555 Snapshot too old error
424

ORA-01555 Snapshot too old error

ORA-01555 Snapshot too old error The ORA-01555 is caused by Oracle read consistency mechanism.  If you have a long running SQL that starts at 11:00 AM, Oracle ensures that all rows are as they appeared at 11:00 AM, even if the query runs until noon.