http://www.idevelopment.info/ is maintained by Jeffrey M. Hunter. He is a DBA and software engineer graduated from Stanislaus State University in Turlock California with a Bachelor’s degree in Computer Science. He is Oracle Certified Professional, Java Development Certified Professional, Read More

Here is the script I often used to find the sql script using oracle trace utility for oracle applications forms, reports. Change the user id, password and database name to suit your environment. Download TKprof shell script #!/bin/sh #*********************************************** # Script Read More

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: * The speed of Read More

Excerpts from OAUGNetDBA: FYI, I have been able to get the forms to work from my Linux workstation. After applying our 9iAS upgrade and 11.5.8 upgrade this spring, we found new settings in the appsweb.cfg file (namely, an sunplugin entry). If you have that set correctly, matching the version of Read More

Check first which JDK version your form server is Using . On form server execute env | grep FORMS60_WEB_CONFIG_FILE depending on your apps version you will see file like appsweb_$CONTEXT_NAME.cfg or appsweb.cfg Open this file & check for JDK version check for parameter sun_plugin_version Read More

In Oracle Applications professional Users can access professional forms via Appletin web browser.  This Form Applet must run with in Java Virtual Machine (JVM) and Oracle bundles its own JVM as Oracle Jinitiator.  This Jinitiator is available only for Windows Client and for Unix/Linux you Read More

The document is halfway through, imcomplete, but may help you and others. Jiltin This is posted by me at Oracle Forum: http://forums.oracle.com/forums/thread.jspa?forumID=169&messageID=661976&threadID=198714 Short notes ( for those who are comfortable with linux/unix shell, patches) (1 Read More

Just run this sample sql changing the patch number (3061831) in sqlplus or Toad. select distinct rpad(a.bug_number,11)|| rpad(e.patch_name,11)||rpad(trunc(c.end_date),12) ||rpad(b.applied_flag,4) from ad_bugs a, ad_patch_run_bugs b, ad_patch_runs c, ad_patch_drivers d, ad_applied_patches e where Read More

ORACLE_HOME/appsutil/scripts addbctl.sh - start or stop the database addlnctl.sh - start or stop the database listener COMMON_TOP/admin/scripts adalnctl.sh - start or stop the APPS listener adapcctl.sh - start or stop the Apache web listener adcmctl.sh - start or stop the concurrent Read More

# Firewall configuration written by Jayasankar # Manual customization of this file is not recommended. # Note: ifup-post will punch the current nameservers through the # firewall; such entries will *not* be listed here. *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT Read More

Oracle installation uses Rapidwiz Command.  Here is the simple help related to Rapidwiz Usage: rapidwiz [-editcontext]  | [-createcontext [CTX_FILE] [-servername HOSTNAME]] | [-techstack [-restart]]  | [-silent -config CONFIG_FILE [-restart]]| [-restart]  | [-version]  | [-help | Read More