Category Archives: Oracle Applications/Apps DBA

ORA-20001: Cannot PATCH table from Run Edition while Patch Edition exists, ORA-06512: at “APPS.AD_ZD”, line 26 (#12.2.4, #OracleApplications)

Issue: host1$ echo $FILE_EDITION patch host1$ sqlplus SQL*Plus: Release 10.1.0.5.0 – Production on Mon Mar 26 22:21:48 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: apps Enter password: SQL> EXEC AD_ZD_TABLE.PATCH(‘<owner>’,'<Table>’); * ERROR at line 1: ORA-20001: … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

Unable to connect to the mail account. Check the host, user name, password and connection security. in workflow (#OracleApplications #Workflow)

Issue: While bringing up the workflow services in Oracle Applications R12.2, the workflow was able to come up without Inbound being enabled. When trying to enable Inbound, after keying in all the WF server details, it was giving the below … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

sslSecureInit: SSL_CTX_use_certificate_chain_file(/u01/apps/config/PROD/inst/apps/PROD_prodserver1/certs//server.key): failed opmnctl: opmn start failed.

Issue: The services on Extranet server were not coming up and was giving the below error in adopmnctl.txt, while starting, sslSecureInit: SSL_CTX_use_certificate_chain_file(/u01/apps/config/PROD/inst/apps/PROD_prodserver1/certs/<Custom>/server.key): failed opmnctl: opmn start failed. Cause: Could be a certificates issue Fix: Noticed that certificates in the location … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

afcpctx.sh INSTE8_PRF 1 AutoConfig is exiting with status 1

Issue: Autoconfig run on 12.1.3 environment failed with the below message, [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory and phase. The report format is: <filename> <phase> … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

FDPSTP failed due to ORA-20100: ORA-20100: File o1751579.tmp creation failed

Issue: **SQL error and free**22-DEC-2017 01:59:51 ORACLE error 20100 in FDPSTP Cause: FDPSTP failed due to ORA-20100: ORA-20100: File o1751579.tmp creation failed. File could not be opened or operated on as requested. Action: Make sure the directory – /u01/app/oracle/apps/apps_st/comn/te22-DEC-2017 01:59:51 … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed. Directory &FILE_DIR is invalid, contact your system administrator

Issue: ERROR at line 1: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed. Directory &FILE_DIR is invalid, contact your system administrator. Action: Check that the directory is a valid directory with write permissions on the database server node and is … Continue reading

Posted in Oracle Applications/Apps DBA, Oracle Database | 1 Comment

FNDCPASS in Oracle Applications failing with “supply a different password”

Issue: FNDCPASS in Oracle Applications fails with below error, Must not reuse a recently used password. Please supply a different password. Unable to change the password for fnd_user TESTUSER. Resolution: Change the profile option “Signon Password No Reuse” (at user … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

APP-FND-01630 cannot open .dbc file for reading (#OracleApplicationForms)

Issue: After the clone of Oracle Applications (12.1.3), launching forms was failing with the below error message, APP-FND-01630: cannot open $FND_SECURE/*.dbc file for reading Cause: Configuration file reader encountered an error when attempting to open fileĀ $FND_SECURE/*.dbc file for reading Action: … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

com.sun.corba.se.impl.orb.ORBImpl checkShutdownState WARNING: “IOP01210228: (BAD_OPERATION) This ORB instance has been destroyed, so no operations can be performed on it” (#OracleApplications12.2, #Weblogic)

Issue: While running adcfgclone in Oracle Applications 12.2 with “addnode” command, the command was failing with the below error message, Cause: There must be some issue with the Admin server connectivity Resolution: The Admin server on Patch FS was down. … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment

ld.so.1: rwrun: fatal: librw.so: open failed: No such file or directory (#OracleApplications12.2, 12.1)

Issue: The concurrent program fails with below error, in Oracle Applications R12.2, R12.1 ld.so.1: rwrun: fatal: librw.so: open failed: No such file or directory Resolution: Export the LD_OPTIONS andĀ Run the “make -f ins_reports.mk install” command export LD_OPTIONS=-L/lib cd $ORACLE_HOME/reports/lib make … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment