SQL to monitor (check status) of Workflow Notification Mailer (Java)
SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;
Read MoreSteps / How to Migrate Non ASM Instance Database to ASM Instance
NOTE: Always Do Exercise on Test Environment, First. Assumptions : 1. ASM Instance is already Created and Ready to Use. 2. DB Instance was Started using ‘spfile’ 3. Disk Group Name : ‘+DGDATA’ – Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’ alter system set db_create_file_dest=’+DGDATA’ scope=spfile; – Set the Parameter ‘control_file’ to the destination in ASM […]
Read MoreJVM Tuning (Garbage Collection) in Oracle Apps 11i
There are some good notes on JVM tuning from Mike Shaw on Steven Chan’s blog here , here and here and some good Metalink notes at end of this post. Important thing missing from all these notes (for some one like me who is new to Java) is basics of Garbage Collection, Generation and how to […]
Read MoreError: ORA-00354 – (Oracle Hidden Parameter : _allow_resetlogs_corruption)
NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support. You are trying to start your DATABASE, you found the aforementioned error i.e. ORA-00354. . Required Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but […]
Read MoreOracle WebCenter Interaction / BEA AquaLogic User Interaction (ALUI)
Oracle WebCenter Interaction earlier known as BEA Aqualogic User Interaction (ALUI) is now part of Oracle WebCenter Suite. 1) On 14th Nov 2008, Oracle released WebCenter Interaction 10gR3/10.3.0 (First Oracle branded AquaLogic Interaction product) . 2) Release prior to WebCenter Interaction 10gR3 is AquaLogic Interaction 6.5 MP1 (Maintenance Pack 1) 3) Oracle WebCenter 10g R3 (10.3.0) […]
Read MoreStarting Concurent Managers
While teaching in class students told me that they have posted journal entries and the transaction still remains pending even though i have run script ‘./adstrall.sh’ which by default start all the application tier. drilling down i notice that some concurent managers were not started. to solve this ask my student to Alternatively try the […]
Read MorePatch Application Assistant (admsi.pl) in Oracle Apps R12
PAA (Patch Application Assistant) is tool/Perl script to generate customized installation instructions for a patch in Oracle Applications R12 which helps user to track and perform manual steps during patching. 1. admsi.pl is under $AD_TOP/bin 2. You can run admsi.pl (Patch Application Assistant) in two mode i) GUI (Graphical User Interface) ii) CLI (Command Line […]
Read MoreOracle 12.0.6 R12 RUP6 is Out now
Oracle released 12.0.6 on Nov 7, 2008. Here is quick snapshot of 12.0.6 for DBA’s & System Administrators. . 1. Patch Number for 12.0.6 is 6728000 2. Prereq. patch for 12.0.6 (6728000) is R12.AD.A.delta.6 (7305220) & optional online help patch (7109200) 3. As with other ad patches, You CAN’T merge 12.0.6 (6728000) with R12.AD.A.delta.6 (7305220) […]
Read More
WebLogic Server JDBC for Database connection : Step by Step
This is in continuation of my last post on Database Connectivity (JDBC) in WebLogic Server here , In today’s post I am going to cover step by step JDBC configuration using Administration Console. 1. Login to WebLogic Server Administration console (default port 7001) http://hostname:port/console 2. Select Data Sources under JDBC in Services section . . 3. Click on New […]
Read MoreClient System Analyzer for Oracle E-Business Suit
In my last post i did not cover about this tool(CSA) , i found this tool is very interseting and trying to share some of the points. Performance issues and other problems can arise if your computer is not optimally configured. To enable the diagnosis (and prevention) of such problems, the Client System Analyzer allows […]
Read More