[ons-connect] Local connection 853e,127.0.0.1,6100 invalid form factor - RCV: No such file or directory

 Hi Folks,

Recently we had an issue with OPMN where oacore went on "INIT" state and couldn't able to bring it up in PROD.

OC4JGroup:default_group          | OC4J:oacore        |     891 | Init

OC4JGroup:default_group          | OC4J:oacore        |       0 | NONE

PROD [****@servername scripts]$ ./adopmnctl.sh stopall

You are running adopmnctl.sh version 120.6.12010000.5

RCV: No such file or directory

Communication error with the OPMN server local port.

Check the OPMN log files

We have verified OPMN log file and found below errors.

by looking /u01/app/****/KIPCI/inst/apps/KIPCI_servername/logs/ora/10.1.3/opmn/opmn.log file

22/12/28 10:43:36 [ons-connect] Local connection 853e,127.0.0.1,6100 invalid form factor

java; Home=/u01/app/***/KIPCI/inst/apps/KIPCI_servername/ora/10.1.3

Solution :-

"Communication error with the OPMN server local port" When Starting OPMN (Doc ID 2104078.1)

Can't Start OPMN In EBS12.1.3 By "Communication error with the OPMN server local port" (Doc ID 2454711.1)

Killed all process related to 6100 . netstat -anp|grep -i 6100 . Make sure no processes for 6100 port.

Now start opmn. It will be up.

Thanks.

Sreeharsha

FNDCPASS Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.201020 1.6) does not match that of the oracle executable (12.1.0.2.220719 1.6) - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE

 Changing apps password with FNDCPASS failed with below error.Working...

Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.201020 1.6) does not match that of the oracle executable (12.1.0.2.220719 1.6) - USER ( APPS ) has been detected in FND_WEB_SEC.GET_OP_VALUE.

Fix

===

 sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 23 21:13:41 2022

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

INSTANCE_NAME> select dbms_java.get_jdk_version() from dual;

select dbms_java.get_jdk_version() from dual

                                        *

ERROR at line 1:

ORA-29548: Java system class reported: release of Java system classes in the

database (12.1.0.2.201020 1.6) does not match that of the oracle executable

(12.1.0.2.220719 1.6)

INSTANCE_NAME> spool javaissue.txt

INSTANCE_NAME> @?/javavm/install/update_javavm_db.sql

INSTANCE_NAME> SET FEEDBACK 1

INSTANCE_NAME> SET NUMWIDTH 10

INSTANCE_NAME> SET LINESIZE 80

INSTANCE_NAME> SET TRIMSPOOL ON

INSTANCE_NAME> SET TAB OFF

INSTANCE_NAME> SET PAGESIZE 100

INSTANCE_NAME>

INSTANCE_NAME> alter session set "_ORACLE_SCRIPT"=true;

Session altered.

INSTANCE_NAME>

INSTANCE_NAME> -- If Java is installed, do CJS.

INSTANCE_NAME>

INSTANCE_NAME> -- If CJS can deal with the SROs inconsistent with the new JDK,

INSTANCE_NAME> -- the drop_sros() call here can be removed.

INSTANCE_NAME> call initjvmaux.drop_sros();

Call completed.

INSTANCE_NAME>

INSTANCE_NAME> create or replace java system;

  2  /

Java created.

INSTANCE_NAME>

INSTANCE_NAME> update dependency$

  2    set p_timestamp=(select stime from obj$ where obj#=p_obj#)

  3    where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and

  4          (select type# from obj$ where obj#=p_obj#)=29  and

  5          (select owner# from obj$ where obj#=p_obj#)=0;

0 rows updated.

INSTANCE_NAME>

INSTANCE_NAME> commit;

Commit complete.

INSTANCE_NAME>

INSTANCE_NAME> alter session set "_ORACLE_SCRIPT"=false;

Session altered.

INSTANCE_NAME>

INSTANCE_NAME> select dbms_java.get_jdk_version() from dual;

DBMS_JAVA.GET_JDK_VERSION()

--------------------------------------------------------------------------------

1.6.0_211

1 row selected.

Thanks.

Segmentation fault (core dumped) Autoconfig failing with adgendbc.sh: line 248: 149435 Done & ORA-12154: TNS:could not resolve the connect identifier specified

 Dear Folks,

Recently, we had an issue with the adcfgclone failed with below error on external node.

Creating the DBC file...

ADD call failed with exit code 139

Updating Server Security Authentication

Updating Server Security Authentication failed with exit code 139

RestoringDBC file from backed up location /u01-BUHJI/app/**/BUHJI/inst/apps/BUHJI_servername/appltmp/TXK/BUHJI_Wed_Nov_09_04_32_2022.dbc

adgendbc.sh endd at Wed Nov  9 04:32:27 EST 2022

adgendbc.sh exiting with status 139

ERRORCODE = 139 ERRORCODE_END

.end std out.

/u01-BUHJ/app/****/BUHJI/inst/apps/BUHJI_servername/admin/install/adgendbc.sh: line 248: 149435 Done                    { echo $USERNAME/$PASSWORD$ADMIN_ALIAS; }

     149436 Segmentation fault      (core dumped) | /u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java -classpath "/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/lib/appsborg.zip:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java/frmall.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/jlib/ewt3.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/classes" oracle.apps.fnd.security.AdminAppServer ADD FNDNAM=$USERNAME GWYUID=APPLSYSPUB/PUB "$DBC_CONNECT_ID" TWO_TASK=BUHJI GUEST_USER_PWD=GUEST/ORACLE SECURE_PATH=/u01-BUHJI/app/****/BUHJI/inst/apps/BUHJI_servername/appl/fnd/12.0.0/secure APPS_JDBC_DRIVER_TYPE=THIN DB_PORT=1522 DB_HOST=narmtjta01.jtafl.com NODE_NAME=servername JDBC\:processEscapes=true JDBC\:oracle.jdbc.maxCachedBufferSize=358400 FND_MAX_JDBC_CONNECTIONS=500 FND_JDBC_STMT_CACHE_SIZE=100 $ALL_PARAMS -nopromptmsg

/u01-BUHJI/app/****/BUHJI/inst/apps/BUHJI_servername/admin/install/adgendbc.sh: line 248: 149438 Done                    { echo $USERNAME/$PASSWORD$ADMIN_ALIAS; }

     149439 Segmentation fault      (core dumped) | /u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java -classpath "/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/lib/appsborg.zip:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/forms/java/frmall.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/jlib/ewt3.jar:/u01-BUHJI/app/****/BUHJI/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u01-BUHJI/app/****/BUHJI/apps/apps_st/comn/java/classes" oracle.apps.fnd.security.AdminAppServer AUTHENTICATION SECURE DBC=/u01-BUHJI/app/****/BUHJI/inst/apps/BUHJI_ServerName>/appl/fnd/12.0.0/secure/BUHJI.dbc -nopromptmsg

Upon checking, we have identify issue with the JDK version which has been corrupted.

****@kardtbhya04 bin]$ ./java -version

Segmentation fault (core dumped)

Fix

====

Hence we have restored JDK version from second node application tier and run AC. Then it was completed successfull.

Thanks.

APP-FND-02704: Unable to alter user APPLSYSPUB to change password

 Dear Folks,

Recently we have faced an issue in EBS 12.2 instance where we weren't able to change APPLSYSPUB password and ended up with below error.

APP-FND-02704: Unable to alter user APPLSYSPUB to change password.

Oracle error 28003: `n▒ 8 has been detected in alterpassword2.

Unable to change the password for Oracle user APPLSYSPUB.

Fix

Check APPLSYSPUB belongs to which profile.

SQL>    col USERNAME for a10;

        col ACCOUNT_STATUS for a20;

        col EXPIRY_DATE for a10;

        col PROFILE for a20;

        select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from dba_users where USERNAME in ('APPLSYSPUB');SQL> SQL> SQL> SQL>

USERNAME   ACCOUNT_STATUS       EXPIRY_DAT PROFILE

---------- -------------------- ---------- --------------------

APPLSYSPUB OPEN                            APPS_USER_PROFILE

Verify "PASSWORD_VERIFY_FUNCTION" RESOURCE_NAME for the above profile.

SQL> select * from dba_profiles where PROFILE='APPS_USER_PROFILE' and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';

PROFILE              RESOURCE_NAME                  RESOURCE_TYPE                  LIMIT                                    COM

-------------------- ------------------------------ ------------------------------ ---------------------------------------- ---

APPS_USER_PROFILE    PASSWORD_VERIFY_FUNCTION       PASSWORD                       VERIFY_FUNCTION_11G                      NO

Alter it to NULL.

SQL> alter profile APPS_USER_PROFILE LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Profile altered.

and change the APPLSSYPUB password and now it works.

Working...

Password is changed successfully for user APPLSYSPUB.

FNDCPASS completed successfully.

+---------------------------------------------------------------------------+

Concurrent request completed successfully

Rervert back the profile.

SQL> alter profile APPS_USER_PROFILE LIMIT PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G;

Profile altered.

Thanks.

lp: Too many active jobs. Pasta: Error: Print failed. Command=lp -c -dPRNUS104 APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1

 Dear Folks.

Recently, we have an issue with one of concurrent program completed warning with below message.

Printing output file.

               Request ID : 122747775

         Number of copies : 1

                  Printer : PRNUS104 

lp: Too many active jobs.

Pasta: Error: Print failed. Command=lp -c -dPRNUS104  /u03/app/***/KIAGI/fs2/inst/apps/KIAGI_korladrbs02/appltmp/pasta117306_0.tmp

Pasta: Error: Check printCommand/ntPrintCommand in pasta.cfg

Pasta: Error: Preprocess or Print command failed!!!

APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1

Cause: AFPPRN received a return code of failure from the OSD routine FDUPRN. Program exited with status 1.

Action: Review your concurrent request log file for more detailed information.

We have reviewed the printer on OS level and shows it was enabled.

 lpstat -t |grep PRNUS104

device for PRNUS104: lpd://grprint1/PRNUS_104

PRNUS104 accepting requests since Wed Sep  1 13:46:57 2021

Fix - Printing Stopped Working Error: " Ip: Too many active jobs " (Doc ID 2003436.1)

Edit the MaxJobs setting under /etc/cups/cupsd.conf.

        vi  etc/cups/cupsd.conf

Increase to desired value (By default MaxJobs is set to 500) 

        MaxJobs 700

Cups service needs to be restarted to apply changes.

        /etc/rc.d/init.d/cups restart

If you have already maxjobs is set to high. Just check if you have pending jobs under CPUS and cleared them all and submit the program. It will completed.

In our case, we didn't chang maxjobs. Simply we have cleared old jobs under CPUS.

NONPROD [root@******02 ~]# lpstat -o | wc -l

500

Cleared all 500 pending jobs.

Thanks.

APP-FND-00668: The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = CMP and Structure number = 101 (APPID=800)

 Dear DBAS,

While we were applying R12.ATG_PF.C.delta.8 - 28840844 on 12.2.8 instance. It failed with below error.

from patch log file

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

ATTENTION: All workers either have failed or are waiting:

           FAILED: file fdfcmp       on worker  1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

From worker1 log file

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

Application Id: 800

    Short Name: PER

          Name: Human Resources

Flexfield Code: CMP

          Name: Competence Flexfield

 Structure Num: 101

          Code: COMPETENCE_FLEXFIELD

          Name: Competence Flexfield

Compilation aborted for current key flexfield...

APP-FND-00668: The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = CMP and Structure number = 101 (APPID=800)

FDFBKS: REQUIRED constraint specified for the Default Attribute qualifier is not satisfied

Since there wasn't direct steps mentioned in ML. We have raised an Sr and suggested to have below steps.

Go to 1. System Administrator >> Application > Flexfield>> Key> On Flex Filed title - Competence Flexfield and Unfreeze flexfiled definition then Go to segments and click on Flex field qualifiers. 

Enable check box for Default attribute and save it.

Then come to main form and enable check box for freeze flexfield definition and click on compile.

Now it compiles successfully

Continue with the patch using the below command.

adop phase=apply patches=28840844 workers=12 patchtop=/u01/app/****/Patch/220419-08028 abondon=no restart=yes