RSS

Category Archives: apps_dba

R12 disable all users script

regulatory after clone, you asked to close “disable/ end date/ deactivate” application “end” users

use the following script

declare cursor x is
select user_name from apps.fnd_user where LOWER(user_name) Not IN ('list some users you don't want to close');
begin
for all_user in x loop
apps.fnd_user_pkg.DisableUser(all_user.user_name);
commit;
end loop;
End;
 

Tags: ,

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

 

Review the HTTP log file. The error is very clear about the missing soft link. It would show this error:

<physical Path>/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
<physical Path>/10.1.3/Apache/Apache/bin/httpd: error while loading shared
libraries: libdb.so.2: cannot open shared object file: No such file or directory

cd $INST_TOP/logs/ora/10.1.3/opmn

vi HTTP_Server~1.log
--------
14/03/04 00:54:51 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 00:54:53 Start process
--------
/d01/oracle/VIS/inst/apps/VIS_r12/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/d01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
--------
14/03/04 10:22:12 Start process

Case:

missing prerequisite step

Solution ::

To implement the solution, please execute the following steps:

1. Shut down all Oracle Application Services.

2. As the unix root user, create a soft link as follows:

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

3. Start up all Oracle Application Services.

 

Tags: , , , , ,

After R12 Clone: Consult the OPP service log for details

After make a clone of R12, the new instance gave “Completed, Warning” for all XML output requests the request log show the following:

Post-processing of request 509561 failed at <timestamp> with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

you can review the OPP log file from the following query to find the location and file name for the OPP log:

SELECT 
fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name 
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp 
WHERE fcpp.processor_id = fcp.concurrent_process_id
 AND fcpp.action_type = 6
 AND fcpp.concurrent_request_id = &request_id;

the OPP log file will be in the $APPLCSF/$APPLLOG with an name of “FNDOPP*.txt”

now the log file shows the error:

[UNEXPECTED] [50032:RT509560] oracle.apps.xdo.XDOException: Unable to create font cache directory: /u01/SID/instapps/CONTEXT_NAME/temp/xdofonts/SID

Solution:

1. Navigation Path:

(Responsibility) XML Publisher Administrator > (Menu) Home > (Tab) Administration > (SubTab) Configuration > Properties > General > Temporary directory

2. Provide a valid value to ‘Temporary directory’, and click button ‘Save’.

3. Re-test the issue.
 

Tags: , , , ,

Bad Performance in R12 Online AP Create Accounting

According to the helpful Oracle Support DocId:791049.1 ::R12 SLA/FAH: How to Improve Performance in Subledger Accounting & Financials Accounting Hub
in the 4th FAQ which explain how to capturing trace and/or tkprof.

1. Enable tracing using the profile option – ‘Initialization SQL Statement – Custom’
Set this at the user level with the following string:
BEGIN FND_CTL.FND_SESS_CTL(”,”, ”, ‘TRUE’,”,’ALTER SESSION SET TRACEFILE_IDENTIFIER=’||””||’XXXTEST’||””||’ EVENTS =’||””||’ 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 ‘||””); END;
2. Login using the user for which you set the profile option.
3. Reproduce the issue.
4. Reset the profile option to its prior value.
5. Locate the generated trace, using the query:
select name, value from v$parameter where name like ‘user_dump_dest’;
6. Convert the trace file into tkprof format using the command:
tkprof <filename.trc> <output_filename_SORT.txt> explain=apps/<password> sort='(prsela,exeela,fchela)’

in the 5Th FAQ witch explain basic points to check before logging a performance bug. and one of these basic step is to stop the Debug logging”if it;s not nessessary, Or you can make it on USER level not SITE level”

Do you have any of the following profiles set to Yes at the User Level?
If so, then please disable them (i.e., set them to No) and re-run Create Accounting:

When running Create Accounting, the profile values should be set as follows:

FND: Debug Log Enabled = No
SLA: Enable Diagnostics = No
AR: Enable Debug Message Output = No — If it is for Receivables.

 

 

 

Tags: , , , , , ,

Oracle 11i / R12 – How To : How To Disable The Personal Profiles Form

Oracle 11i / R12 – How To : How To Disable The Personal Profiles Form.

 

Tags: , ,

BIB-7000 Cannot access X Server

Subject: ATTEMPING TO VIEW GRAPHICS OR TRYING TO CONFIGURE THE JAVA MAILER HANGS
Doc ID: Note:351839.1 Type: PROBLEM
Last Revision Date: 31-MAY-2006 Status: PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution

Applies to:
Oracle Applications Manager – Version: 11.5.9 to 11.5.10
This problem can occur on any platform.
Symptoms

On entering Oracle Applications Manager (OAM) to check on the status of workflow components (Workflow Manager, “Go” button), under Workflow Metrics, both Work Items and Agent Activity displayed the message

“BIB-7000 Cannot access X Server”

Navigating to OAM to view Activity Monitors or other Graphics also reflect the same error.

Also, Configuring the Java Mailer in OAM – the page hangs and then displays Page Cannot be Displayed
Changes
OAM requires the jserv.properties “wrapper.env=DISPLAY” setting to be consistent throughout the application environment and also it needs to correspond to the correct server where xhost is enabled.
Cause

The DISPLAY setting is not consistent throughout the environment or xhost has not been enabled on the server where the DISPLAY setting is directed to.

If DISPLAY is set and xhost was enabled, another cause is, that the xhost session was not left running on the Xserver machine.
Solution

As ROOT on the Console machine with the Graphics Display

1) $ uname -n

> record the exact value returned

2) – For LINUX:

$ cd /usr/X11/bin
or
$ cd /usr/X11R6/bin

– For SOLARIS:

$ cd /usr/openwin/bin

– For AIX & HP-UX see Note: 361535.1 to setup ‘Headless’ support for xServers

3) $ xhost +

> LEAVE THIS SESSION OPEN ON CONSOLE — DO NOT “SU APPLMGR”

4) Open a New Session and signon as APPLMGR

$ adstpall.sh apps/apps

> Stop all the services on all nodes in the environment

5) Open a New Session and signon as APPLMGR or clear the env of the previous APPLMGR session

$ DISPLAY=<same value as #1>:0.0; export DISPLAY

> See the “:0.0” , make sure that is specified

6) $ echo $DISPLAY

> ex:

$ <hostname from #1>:0.0

7) On all the Nodes in this environment — if this is a multiple node, then repeat on cp, forms/web & admin nodes

$ cd $IAS_ORACLE_HOME/Apache/Jserv/etc

$ cp jserv.properties jserv.properties.bak

8) $ vi jserv.properties

> Search down for “wrapper.env=DISPLAY”

9) Reassure or change the setting to match the following syntax ( repeat on cp, forms/web & admin nodes)

wrapper.env=DISPLAY=<hostname from #1>:0.0

> The hostname value in the DISPLAY must be the same in all nodes, it must be set to the value of “uname -n”
from step #1

> Setting this in OAM > AutoConfig > Edit Parameters and then running AutoConfig on all nodes
with accomplish the same thing

10) Restart all the services in the same APPLMGR sessions

 

Tags: , , ,

SQL to get profile option values list using specific criteria