sqlldr: Permission denied

PROBLEM DESCRIPTION:
====================

While running the Concurrent Request it has completed with the following Error.

Arguments
------------
/testapps/apps/apps_st/appl/doyen/12.0.0/Interfaces/DOYENINBOUND/doyen2.csv
------------
sqlldr: Permission denied
usdsop: exec failed during spawnusdsop cannot write to pipe
Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.
Action: Check the other process for abrupt termination. Check that you have sufficient resource: Broken pipe
usdsop cannot write to pipe
Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.


CAUSE:
======

Due to some reasons the permission has been changed or the binary may be correpted.


SOLUTION:
=========

1. Check the permission for sqlldr file in (ORACLE_HOME) ie) 10.1.2 ORACLE_HOME/bin directory


2. Check the ORACLE_HOME path is set correctly for apps.

Problem Description:


===================

While cloning the R12 instance apps Tier the following Error occurs at 3% after running adcfgclone.pl.



Error:


======


ouicli.pl INSTE8_APPLY -1



The following report lists errors AutoConfig encountered during each


phase of its execution. Errors are grouped by directory and phase.


The report format is:





[APPLY PHASE]


AutoConfig could not successfully execute the following scripts:


Directory: /testapps/apps/tech_st/10.1.3/perl/bin/perl -I /testapps/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /testapps/apps/tech_st/10.1.3/perl/lib/site_per


l/5.8.3 -I /testapps/apps/apps_st/appl/au/12.0.0/perl -I /testapps/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/aix-thread-multi /testapps/


apps/tech_st/10.1.2/appsutil/clone


ouicli.pl INSTE8_APPLY -1


AutoConfig is exiting with status 1



RC-50013: Fatal: Instantiate driver did not complete successfully.


/testapps/apps/tech_st/10.1.2/appsutil/driver/regclone.drv


Cause:


=======

During the Configuration of the APPS-Tier Technology Stack the opmn process tries to stop the Services. As opmn is not used in this case for the 10.1.2 ORACLE_HOME it should not have been started. The OUI (Oracle Universal Installer) is waiting for a failure or error of the opmn, which is not happening. As a result the OUI Cloning process is failing with a timeout, without touching the Technology Stack.


This issue is reported in unpublished Bug 5697740 - 'OPMN START FAILED DURING OH10.1.2 CLONING.'


Solution:

1. Open a dupicate session for apps tier


ps -ef|grep opmn

If there is any opmn the follow the below procedure


appltest 10879108 1 0 10:33:14 pts/1 0:00 /testapps/apps/tech_st/10.1.2/opmn/bin/opmn -a -q ping


appltest 30867490 40960050 0 10:40:40 - 0:00 /testapps/apps/tech_st/10.1.2/opmn/bin/opmn -a -q pingwait


appltest 40632488 17760288 0 10:40:50 pts/0 0:00 grep opmn


appltest 40960050 41812148 0 01:51:35 - 0:00 /bin/sh /testapps/apps/tech_st/10.1.2/opmn/bin/opmnctl start



$ kill -9 10879108 30867490 40960050






2. Now check the other window where the cloning process is running. It will start continue the cloning process.



Note : If the process still hangs, then check the opmn once again and kill it.


Reference :

R12 Cloning 'adcfgclone.pl appsTier' fails with error RC-50013: Fatal: Failed to instantiate driver .../regclone.drv [ID 725995.1]

REP-3000: Internal error starting Oracle Toolkit

Problem Summary:
================

All the PDF reports are completed with the following Error:

Error:
======

REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-3000: Internal error starting Oracle Toolkit.

Solution:
=========

As a root user run this in background:
=======================================

1.

ps -efgrep X11

if there is session running then no need to do the 1st step. If not do the following . You can run even from the putty session also.


nohup /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -- :1 -vfb -force -x abx -x dbe -x GLX &

export DISPLAY=:1.0
xhost +

2. As a applmgr user

cd $ORACLE_HOME ie)

Edit the following file and check for the display setting and put the correct host entry.

/testapps/apps/tech_st/10.1.2/bin/reports.sh

DISPLAY=doyensys:1.0; export DISPLAY
xhost +

3. Now Bounce the concurrent

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

Error:
=====

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application
to which the concurrent program executable &EXECUTABLE belongs.
Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=)Routine AFPEOT cannot construct the name of an executable file for your concurrent request 6945444.
Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager

+Executing request completion options... -- 1) PUBLISH -------------+Beginning post-processing of request 6945444 on node TESTSERVER at 19-JUL-2011 15:23:24.Post-processing of request 6988838 failed at 19-JUL-2011 15:33:24 with the error message:The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status.Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.+--------------------------------------+

Scenario:
=======

There is a Custom Top registered and that top is not set in the ENV while starting the conc.


Request Name :

XXTEST Daily Stock of PRODUCTS

Query to Check whether the Env is set for the Particular request :
===============================================

select variable_name,value from fnd_env_context e ,fnd_concurrent_processes p ,fnd_concurrent_requests r where p.concurrent_process_id =
e.concurrent_process_id and p.concurrent_process_id = r.controlling_manager and e.variable_name like '%CUSTOM_TOP%' and r.request_id = &request_id;

Solution :
=======

Add the respective Top in env file

ie) APPL_TOP/admin/adovars.env

so that while running autoconfig it wont remove every time.

XXTEST_TOP="/u01/apps/apps_st/appl/XXTEST/1.0.0" export XXTEST_TOP

Now Bounce the concurrent

Reference Note ID : 1050646.1

Scenario:

=========

When you are applying a Big patch which will take around 10 hrs. Now 5 hrs of the patch has been completed and now errored out due to some pre req patch. So now we can follow the steps given below and the resume the remaining part of the patch.

Solution:

1. Using the adctrl utility, shutdown the workers.

a. adctrl

b. Select option "Tell worker to shutdown/quit"

2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema

a. sqlplus applsys/

b. create table fnd_Install_processes_back as select * from fnd_Install_processes;

c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes_back; select count(*) from fnd_Install_processes;

3. Backup the AD_DEFERRED_JOBS table.

a. sqlplus applsys/

b. create table AD_DEFERRED_JOBS_back as select * from AD_DEFERRED_JOBS;

c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS;

4. Backup the .rf9 files located in $APPL_TOP/admin/restart directory.

At this point, the adpatch session should have ended and the cursor should be back at the Unix prompt.

a. cd $APPL_TOP/admin/

b. mv restart restart_back

c. mkdir restart

5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.

a. sqlplus applsys/

b. drop table FND_INSTALL_PROCESSES;

c. drop table AD_DEFERRED_JOBS;

6. Apply the new patch.

7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back directory.

a. cd $APPL_TOP/admin/

b. mv restart restart_

c. mv restart_back restart

8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema.

a. sqlplus applsys/

b. create table fnd_Install_processes as select * from fnd_Install_processes_back;

c. The 2 tables should have the same number of records. select count(*) from fnd_Install_processes; select count(*) from fnd_Install_processes_back;

9. Restore the AD_DEFERRED_JOBS table.

a. sqlplus applsys/passwd

b. create table AD_DEFERRED_JOBS as select * from AD_DEFERRED_JOBS_back;

c. The 2 tables should have the same number of records. select count(*) from AD_DEFERRED_JOBS_back; select count(*) from AD_DEFERRED_JOBS;

10. Re-create synonyms

a. sqlplus apps/apps

b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;

c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;

11. Start adpatch, it will resume where it stopped previously.

APP-FND-01542 : This Application Server is not authorized to access this system

Scenario:
=======
When you are trying to access the Front end URL it is not giving some error. So , you are using http://hostname:port/dev60cgi/f60cgi and trying to login to the server which gives the following error.

Error:
=====
“APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator. ”

Solution:
=======
Step 1 : Edit the Context file ie) $APPL_TOP/admin/SID_hostname.xml.
Step 2 : Change the Variable : s_appserverid_authentication to be OFF.Step
3 : Run Autoconfig $ cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME$ sh adautocfg.sh

Now, you can test the application login.

Note :
=====

There are three modes of authentication you can configure your applications by setting the parameter
s_appserverid_authentication to ON :
s_appserverid_authentication to Partial
s_appserverid_authentication to SECURE : activates full server security (SECURE mode)
s_appserverid_authentication to OFF : deactivates server security
By default in 11.5.10, this is set to SECURE. In previous 11i versions, this wasset to OFF.

MERGE PATCH USING ADMERGE UTILITY

MERGING THROUGH ADMERGE:
===========================
STEP 1 : Create a Source Directory for example : /home/applmgr/test_patch_ss
STEP 2 : Copy the udriver patches that we want to be merged inside the above directory.
STEP 3 : Create a Destination Directory for example : /home/applmgr/test_dest_ss
STEP 4 : Now Run the below command and at the end of the command give the driver file name that you want after the patch merged. example saravana
STEP 5 : See inside the Destination Location /home/applmgr/test_patch_ss. You will find u_saravana.drv file.

SYNTAX :

admrgpch -s /home/applmgr/test_patch_ss -d /home/applmgr/test_dest_ss -merge_name saravana

Executing the merge of the patch driversNo driver files exists in /home/applmgr/test_patch_ss/5498551.
-- Processing patch: /home/applmgr/test_patch_ss/7429271
-- Done processing patch: /home/applmgr/test_patch_ss/7429271
Copying files...
5% complete. Copied 45 files of 882...
10% complete. Copied 89 files of 882...
15% complete. Copied 133 files of 882...
20% complete. Copied 177 files of 882...
25% complete. Copied 221 files of 882...
30% complete. Copied 265 files of 882...
35% complete. Copied 309 files of 882...
40% complete. Copied 353 files of 882...
45% complete. Copied 397 files of 882...
50% complete. Copied 441 files of 882...
55% complete. Copied 486 files of 882...
60% complete. Copied 530 files of 882...
65% complete. Copied 574 files of 882...
70% complete. Copied 618 files of 882...
75% complete. Copied 662 files of 882...
80% complete. Copied 706 files of 882...
85% complete. Copied 750 files of 882...
90% complete. Copied 794 files of 882...
95% complete. Copied 838 files of 882...
100% complete. Copied 882 files of 882...
Character-set converting files...
2 unified drivers merged.
Patch merge completed successfully