Tuning task for specific SQL_ID can be created by SQLTRPT very easily.
Manual way is also documented below:
Leave a CommentExpert Oracle Posts
TO ACCPET A SQL PROFILE
SQL> execute dbms_sqltune.accept_sql_profile(task_name => ‘TASK_96’,replace => TRUE);
If you want the profile to be registered with a custom name use,
SQL> execute dbms_sqltune.accept_sql_profile(task_name => ‘TASK_96’,name => ‘CUSTOM_PROF_Query1’);Leave a Comment
Below are some of the useful workflow script that we use frequently in our 11i/R12 instances
VERIFY THE WORKFLOW IMAP SETTING
set pagesize 100 set linesize 132 set feedback off set verify off col value format a35 col component_name format a30 select c.component_id, c.component_name, p.parameter_id, p.parameter_name, v.parameter_value value from fnd_svc_comp_param_vals_v v, fnd_svc_comp_params_b p, fnd_svc_components c where c.component_type = 'WF_MAILER' and v.component_id = c.component_id and v.parameter_id = p.parameter_id and p.parameter_name in ( 'INBOUND_SERVER','ACCOUNT', 'REPLYTO') order by c.component_id, c.component_name,p.parameter_name;1 Comment
There are many places in Oracle EBS R12 where you can tweak the default Oracle look and feel and personalize it according to your client requirement. Below are five places where we change the default oracle branding for any EBS R12 (or 11i also) client.
Leave a CommentOnline patching is supported by the capability of storing multiple application editions in the database, and the provision of a dual application tier file system. At any given point in time, one of these file systems is designated as run (part of the running system) and the other as patch (either being patched or awaiting the start of the next patching cycle).
32 CommentsWe faced one clone issue in EBS R12. The login screen was blank and oacore log has the below error message
“javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE”
GUEST user validation was also failing.
Leave a CommentBelow are some of the simple but frequently used database tablespace related queries used by DBAs:
Queries Related to Temporary Tablespace
Check Temporary tablespace temp files size
set lines 132 col FILE_NAME format a60 select TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024,AUTOEXTENSIBLE,MAXBYTES/1024/1024 from dba_temp_files;Leave a Comment
In our EBS R12/ 11g database we have seen that apps database user login from SQLPLUS hangs after refresh.
Symptom:
During refresh process, after database recover/open and starting the database listener, apps login starts to hang. adconfig/adcfgclone.pl also hangs as it uses apps to connect to database
On checking alert log, there were continuous “inbound connection timed out (ORA-3136)” error.
On stopping the database listener, apps login was working fine.
Leave a Comment One of our EBS R12 was inaccessible and was throwing generic http-404 erorr for the login page. On the application side adopmnctl was showing status ACTIVE for all the required procesees.
Simple HTML file like http://<server_name>:<port>/OA_HTML/test.html was also not opening means it was Apache issue or Oacore issue since definition of OA_HTML in html link is given by OACORE.
Error message in the Browser was like below:
Not Found
The requested URL /OA_HTML/test.html was not found on this server.
In one of the Apache server log we were able to see that it is trying to find the file under portal directory which is not the correct place
</EXEC_CONTEXT_ID> </CORRELATION_DATA> <PAYLOAD> <MSG_TEXT>File does not exist: /fs01/<SID>/inst/apps/<CONTEXT_NAME>/portal/OA_HTML/test.html</MSG_TEXT> </PAYLOAD> </MESSAGE>1 Comment
If you need to add any new classpath to the $CLASSPATH variable in Oracle Apps 11i please see below example:
VERIFY:
$ echo $CLASSPATH /fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/jre/lib/rt.jar:/fh02/DBNAME/oraapps/common/util/ java/1.6/jdk1.6.0_45/lib/dt.jar:/fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/lib/tools.jar: /fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/jre/lib/charsets.jar:/fh02/DBNAME/oraapps/common/ java/appsborg2.zip:/fh02/DBNAME/oraapps/8.0.6/forms60/java:/fh02/DBNAME/oraapps/common/java $ echo $CONTEXT_FILE /fh02/DBNAME/oraapps/11iApp/admin/DBNAME_SERVER.xmlLeave a Comment