Category Archives: Oracle Applications/Apps DBA

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 | Leave a 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

make: Fatal error: Command failed for target `libnmemso’ while running “adlnkoh.sh” to relink Oracle Home

Issue: make: Fatal error: Command failed for target `/u01/app/oracle/product/KING/11204/sysman/lib/libnmemso.so’ Current working directory /u01/app/oracle/product/KING/11204/sysman/lib *** Error code 1 make: Fatal error: Command failed for target `libnmemso’ Failed linking targets agent /u01/app/oracle/product/KING/11204/sysman/lib Resolution: Try to relink the OH after performing “clone.pl”. cd /u01/app/oracle/product/KING/11204/clone/bin … Continue reading

Posted in Oracle Applications/Apps DBA, Oracle Database | Leave a comment

ORA-06550: line 6, column 23: PL/SQL: ORA-00936: missing expression (#adop -status)

Issue: After the fresh install of Vision Instance (12.2.0), the below error can be seen if we try to check the status of adop. This generally happens where the adop_session_id is not created yet. [oracle@oracle patch]$ adop -status Enter the … Continue reading

Posted in Oracle Applications/Apps DBA | Leave a comment