Autoconfig failed, Non supported character set

[raiq1]

Hi Erman sir,

Autoconfig is failed in dbside with Non supported character set, followed the document Doc ID 2158450.1 but not be able to fix the issue.

please check the autoconfig log file and advice to fix the issue.

Regards,
Raiqadconfig.log

[ErmanArslansOracleBlog]

1)Did you do proper change in adconfig.pl as instructed in 2158450.1 ?
2)Do you have orai18n.jar in your Oracle Home?
**in :<Actual path for $ORACLE_HOME>/jlib/orai18n.jar" ? and in $ORACLE_HOME/appsutil/jre/lib/ext?

[raiq1]

Hi sir,


As per your query, below are the output of adconfig.pl , i have added oracle home in the $classpath,

is it a correct way to added , kindly confirm.

sub setClassPath {
        ($classpath,$ret) = $javaOps->getClassPath();
        $ENV{'CLASSPATH'} = $classpath.":/u02/oracle/TEST/19.0.0/jlib/orai18n.jar" ;
        print2logStdio("\tClasspath                   : $ENV{'CLASSPATH'}\n\n");
    # remove classpath from javaCmd

For your second query,

file are available in the respective directory.

/u02/oracle/TEST/19.0.0/appsutil/jre/lib/ext

[oracle@proddb01 ext]$ ls -ltr ora*
-rwxrwxr-x 1 oracle oinstall 1661488 Mar 25 10:19 orai18n.jar

Also file are also available in

/u02/oracle/TEST/19.0.0/jlib

ls -ltr orai18*

-rwxrwxr-x 1 oracle oinstall 1661488 Mar  4  2019 orai18n.jar

Kindly advise.

Regards,
Raiq

[ErmanArslansOracleBlog]

I guess, we need to modify the adgentns.pl as well..

There is no orai18n.jar in the classpath that is set by adgentns.pl and actually adgentns.pl is the one that is failing..


See adgentns.pl's classpath ;

Classpath                   : :/u02/oracle/TEST/19.0.0/jdbc/lib/ojdbc8.jar:/u02/oracle/TEST/19.0.0/appsutil/java/xmlparserv2.jar:/u02/oracle/TEST/19.0.0/appsutil/java:/u02/oracle/TEST/19.0.0/jlib/netcfg.jar:/u02/oracle/TEST/19.0.0/jlib/ldapjclnt19.jar

See how it is failing;

Loading ORACLE_HOME environment from /u02/oracle/TEST/19.0.0
Logfile: /u02/oracle/TEST/19.0.0/appsutil/log/TEST_proddb01/03250225/NetServiceHandler.log
AC-50480: Internal error occurred: java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): AR8ISO8859P6
java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): AR8ISO8859P


**So it seems we need to update adgentns.pl with the same logic...

[raiq1]

Hi sir,

As per your advice, i have set the classpath in adgentns.pl but still the same error.

For you investigation, sending adgentns.pl & autoconfig.log for your review.

please check & advice.

Regards,
Raiqadconfig.log_newadgentns.pl

[ErmanArslansOracleBlog]

Hi Raiq,

The same thing happened to me earlier. We fixed the issue by modifiying the adgentns.pl and adconfig.pl.. we added the ora18in.jar in to the classpaths defined there in those perl scripts.. Those perls script execute java and we modified their classpath (added ora18in.jar) used for executing those java .. With this action, the issue is fixed! So we can continue at the moment..

I even wrote a blog post about it -> https://ermanarslan.blogspot.com/2021/10/ebs-rdbms-19c-upgrade-post-upgrade.html

1.) In adconfig.pl we added orai18n.jar path to classpath TO line 933

-->> $ENV{'CLASSPATH'} = $classpath.":/u01/app/oracle/product/19.0.0.0/dbhome_1/jlib/orai18n.jar";


2.) In adgentns.pl file we added following line (between 173 and 174 )

-->> $classpath=$classpath.":/u01/app/oracle/product/19.0.0.0/dbhome_1/jlib/orai18n.jar";

[raiq1]

Hi erman sir,

Issue has been resolved, I have opened the SR and oracle has sent me a new Java.pm file.

cd $ORACLE_HOME/appsutil/perl/ADX/util/Java.pm

after replaced the higher version of Java.pm file, autoconfig got successfully completed.

Good learning to handle that type of issue.

Thanks for your support Erman sir.

Regards,
Raiq

[ErmanArslansOracleBlog]

Hı Raiq,

Interesting and good :)
So probably, that version of Java.pm doesn't support the use of orai18n.jar.. (our NLS support)

Just for the record -> What is the version of your current(higher version) Java.pm and the older (lower version) one?

[raiq1]

Hi sir,

Lower verion of Java.pm are

$Header: Java.pm 120.7.12010000.5 2019/05/10 12:10:46 lmanda ship $


Current verion of Java.pm are

# $Header: Java.pm 120.7.12010000.6 2020/04/14 09:12:16 sbandla ship $


Its good learning and will helpful for others , if they will face same issue.

Regards,

Raiq