alert4

HTML Alerts in EBS

For some unknown reason Alerts have not been kept up-to-date with regards to being able to send messages with a bit more customization. There is no HTML format so some form of customization is required. Setup Custom Email The first thing you need to do is to create the custom method for sending emails. This […]


Clean out /tmp

I was looking for something to clean out the temp directory on the application server. find /tmp -maxdepth 1 -type f -mtime +7 -and -not -exec fuser -s {} ‘;’ -and -exec rm {} ‘;’ -maxdepth 1 Only top directory as I don’t want to do anything with folders as I can deal with these […]


4-Verify

Hugepages in Linux

Set memlock Set the value for memlock in /etc/security/limits.conf to a value slightly smaller than RAM. First find the size of the RAM if you don’t know it off hand. good to check just to be on the safe side and then set the value to a little under this according to Oracle. [root@oracle ~]# […]


R12 Application Tier Size Continuously Increases

An issue on a customer site popped up. There was an increase is size usage on the Application Tier without reason. I checked the $INST_TOP and the concurrent programs did not seem to indicate anything out of the ordinary although I did see a few issues but that is for a future post. I decided […]

core1

0_1_Startup

Oracle Applications Table Migration

Setup OATM Script for a before and after check of the tablespaces. I run this into a file before and after to check the changes made. I use the tablespace info script. The first time the script is run it will ask you to create a log directory during the first run so you may […]


Submit Request Set in PL/SQL

PL/SQL to be able to submit a request set from a program if required: declare req_id number := 0; vresult boolean; l_user_id number := 123; l_resp_id number := 1; l_resp_appl_id number := 1; begin fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id) ; vresult := fnd_submit.set_request_set (‘XXCUS’, ‘FNDRSSUB2583′) ; if (vresult) then dbms_output.put_line (‘Set Request Set’) ; else dbms_output.put_line […]


scripts

Tablespace Info 1

Query for basic tablespace info: select nvl (b.tablespace_name, nvl (a.tablespace_name, ‘UNKNOWN’)) “Tablespace” , kbytes_alloc “Allocated MB” , kbytes_alloc – nvl (kbytes_free, 0) “Used MB” , nvl (kbytes_free, 0) “Free MB” , (kbytes_alloc – nvl (kbytes_free, 0)) / kbytes_alloc * 100 “Used” , data_files “Data Files” from ( select sum (bytes) / 1024 / 1024 kbytes_free […]


SQL Developer Freezes with Connection Information 2

Not nice when any program freezes and doesn’t want to open, esspecially when suddenly you have to do something urgent. Well came across this problem today when trying to open SQL Developer 4 it froze. I’d have to go to task manager to kill it and not really sure what the problem is. I will […]

SQL_Developer_Freeze_fix

OPPRestart

QUEUE APPLSYS.FND_CP_GSM_OPP_AQ does not Exist

Found this weird error in the OPP Log file: [5/18/14 11:43:46 AM] [EXCEPTION] [OPPAQMON:73338] ORA-24010: QUEUE APPLSYS.FND_CP_GSM_OPP_AQ does not exist [5/18/14 11:43:46 AM] [EXCEPTION] [OPPAQMON:73338] ORA-25226: dequeue failed, queue APPLSYS.FND_CP_GSM_OPP_AQ is not enabled for dequeue Solution basically involves restarting the queues: SQL> select OBJECT_NAME, OBJECT_TYPE, STATUS, OWNER from DBA_OBJECTS where OBJECT_NAME like ‘%FND_CP_GSM_OPP_AQ%’; OBJECT_NAME OBJECT_TYPE […]