Asif's Oracle Repository

  Recently  encountered a situation, wherein end users where not able to get the R12.2 login page and it just hangs, but all the opmn processess were up and running – adopmnctl.sh status gives status as alive for all the components viz., HTTP, oafm, oacore & forms. The same environment was available and end users were able to access without any isuses 15 minutes before. This error happens only when multiple people login to the same page and perform simillar activity like employee self service form etc. So where and what exactly could be the problem. This is how we approached and resolved the issue. First we checked apache error log. The following error was reported in the error log. ============================================================== [warn] [client IP Address ] oc4j_socket_recvfull timed out [error] [client IP Address ] mod_oc4j: There is no oc4j process (for destination: application://oacore) available to service request. [error] [client  IP...

Select b.user_name, c .responsibility_name, a.START_DATE, a.END_DATE from apps.fnd_user_resp_groups_direct a, apps.fnd_user b, apps.fnd_responsibility_tl c where a.user_id = b.user_id and a.responsibility_id = c .responsibility_id and b.user_name= '&username' ; output: USER_NAME  RESPONSIBILITY_NAME            START_DATE         END_DATE ---------- ------------------------------ ------------------ ------------------ AUSER              Mycompany Move Order                16-JAN-17          25-JAN-17

Use of Kill -9 form letter Don't use kill -9. It doesn't give the process a chance to cleanly: 1) shut down socket connections 2) clean up temp files 3) inform its children that it is going away 4) reset its terminal characteristics and so on and so on and so on. Generally, send 15, and wait a second or two, and if that doesn't work, send 2, and if that doesn't work, send 1.  If that doesn't, REMOVE THE BINARY because the program is badly behaved!** Don't use kill -9.  Don't bring out the combine harvester just to tidy up the flower pot. I hope you found that useful. I know I did. But what do the numbers mean? Well, they are increasingly violent ways to ask the program to stop itself. The command kill -9 isn’t asking the program to stop, it’s asking the O/S to stop running the program now, regardless of what it’s doing. Run order of kills: kill -15 : this is the equivalent of kill -sigterm and it the default. The program should t...

 Concurrent Processing - How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1] Cause Tried to Cancel a concurrent request. Used the "Cancel Request" button from the Administer > Concurrent > Manager form. Got the following message: Request xxxxxx can no longer be cancelled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with error.  Solution Manually cancel the request out of the queue with the following SQL against the offending request id(s). This can be safely done while managers are up and running: SQL> UPDATE fnd_concurrent_requests      SET phase_code = 'C', status_code = 'X'      WHERE request_id = ' ';       commit; Note:  To obtain request details prior to cancelling the request, use Note 134035.1 ANALYZEREQ.SQL - Detailed Analysis of One Concurrent Request. When prompted, provide the request...

Concurrent Processing - How to Find Database Session & Process Associated with a Concurrent Program Which is Currently Running Goal 1. How to find database session and process associated with a concurrent program which is currently running. 2. How to cancel a concurrent request from database side. Solution A concurrent program can be canceled either from "Submit Request Submission" form or from database side also. In case of custom concurrent programs, sometimes concurrent program do not release database session and process even though it has canceled from "Submit Request Submission" form. Active database process can be seen in running status. In those cases there is a need to manually kill those process to release CPU memory. 1. Take the "request_id" of a Concurrent Program which is currently running or which is to be canceled from the database side. 2. Connect to SQLPLUS as APPS User : SQL> SELECT ses.sid, ses.serial# ...

How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g 1. Create Temporary Tablespace Temp CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE  ‘/u01/app/oradata/temp01′ SIZE 2000M, ‘/u01/app/oradata/temp02′ SIZE 2000M'; 2. Move Default Database temp tablespace ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2; 3. Make sure No sessions are using your Old Temp tablespace    a.  Find Session Number from V$SORT_USAGE:        SELECT USERNAME, SESSION_NUM, SESSION_ADDR FROM V$SORT_USAGE;    b.  Find Session ID from V$SESSION:        If the resultset contains any tows then your next step will be to find the SID from the V$SESSION view. You can find session id by using SESSION_NUM or SESSION_ADDR from previous resultset.        SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE SERIAL#=SESSION_NUM;        OR     ...

Logical Volume Management (LVM) creates a layer of abstraction over physical storage, allowing you to create logical storage volumes. With LVM in place, you are not bothered with physical disk sizes because the hardware storage is hidden from the software so it can be resized and moved without stopping applications or unmounting file systems. You can think of LVM as dynamic partitions. For example, if you are running out of disk space on your server, you can just add another disk and extend the logical volume on the fly. Below are some advantages of using Logical volumes over using physical storage directly: •Resize storage pools: You can extend the logical space as well as reduce it without reformatting the disks. •Flexible storage capacity: You can add more space by adding more disks and adding them to the pool of physical storage, thus you have a flexible storage capacity. •Use of striped, mirrored and snapshot volumes: Striped logical volume that stripes data across two or ...