Thursday, June 29, 2023

Applications Listener Fails To Start On Cloned Instance With TNS-12533: TNS:illegal ADDRESS parameters

 NONPROD [***@KHITTTpap02 scripts]$ ./adalnctl.sh start

adalnctl.sh version 120.3.12020000.4

Checking for FNDFS executable.

Starting listener process APPS_KHTT.

adalnctl.sh: exiting with status 1


from log

======

*****************/admin/log/adalnctl.txt


TNSLSNR for Linux: Version 10.1.0.5.0 - Production

System parameter file is /u01-KHTT/app/apptc/KHTT/fs1/inst/apps/KHTT_KHITTTpap02/ora/10.1.2/network/admin/listener.ora

Log messages written to /u01-KHTT/app/apptc/KHTT/fs1/inst/apps/KHTT_KHITTTpap02/logs/ora/10.1.2/network/apps_KHTT.log

Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=KHITTTpap02)(Port=1628))

TNS-12533: TNS:illegal ADDRESS parameters

 TNS-12560: TNS:protocol adapter error

  TNS-00503: Illegal ADDRESS parameters


Fix

===

cd /var/tmp

created directory .oracle 

drwxrwxrwx   2 root root 4096 Jun 30 01:18 .oracle

Now listener is up and running.

NONPROD [****@KHITTTpap02 scripts]$ ./adalnctl.sh start

adalnctl.sh version 120.3.12020000.4

Checking for FNDFS executable.

Starting listener process APPS_KHTT.

adalnctl.sh: exiting with status 0..


Thursday, June 8, 2023

Click on Help button returning "TOPIC NOT FOUND"

 Hi Folks,

Recently one of our customers reported in the 12.1.3 EBS environment when he clicks on the help button doesn't show anything. It shows "TOPIC NOT FOUND". 

Fix

Though you have TLS enable, Applications Help Web Base URL should be as follows. 

http://<physicalhostname>.<domainname>:port(httpport)/OA_HTML/


Thanks.

Sunday, June 4, 2023

ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.220719 1.7) does not match that of the oracle executable (12.1.0.2.220719 1.6)

We are getting the below error while changing APPLSYS password using FNDCPASS.

NONPROD [******* ~]$ FNDCPASS apps/****** 0 Y system/**** SYSTEM APPLSYS *******

   FNDCPASS system/***** SYSTEM APPLSYS *****

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

Working...

Oracle error -29548: ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.220719 1.7) 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.

Concurrent request completed

Current system time is 04-JUN-2023 23:54:51

 Fix : ( This should be done in CDB and PDB)

2905337.1

SQL> 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 classes.bin in the databasedoes not match that of the oracle executable.

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

SQL> SET FEEDBACK 1

SQL> SET NUMWIDTH 10

SQL> SET LINESIZE 80

SQL> SET TRIMSPOOL ON

SQL> SET TAB OFF

SQL> SET PAGESIZE 100

SQL>SQL> alter session set "_ORACLE_SCRIPT"=true;

Session altered.

SQL>

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

SQL>

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

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

SQL> call initjvmaux.drop_sros();

Call completed.

SQL>SQL> create or replace java system;

2 /

Java created.

SQL>

SQL> 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.

SQL>

SQL> commit;

Commit complete.

SQL>

SQL> alter session set "_ORACLE_SCRIPT"=false;

Session altered.

SQL>

Now check again.

SQL> select dbms_java.get_jdk_version() from dual;

DBMS_JAVA.GET_JDK_VERSION(

1.7.0_351





Thursday, December 29, 2022

[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

Wednesday, November 23, 2022

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.

Wednesday, November 9, 2022

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.






Tuesday, September 13, 2022

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.