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