Config CMOD V9 with Oracle 11G

[Vinothkumar_ve]

Hi All,

We are deploying the CMOD V9 into the Linux 6.2 and trying to configure the Oracle 11G(using DaaS) as per our company standard. We have managed to install and configure the instance. but when we are trying to run ARSDB -I <instance_name> -rtv program to initialize the DB. we are getting ORA error "ORA - 24508 - Buffer is not aligned correctly". As our Oracle is using AL16UTF16 character set, we have already tried to run the ARSDB program with ARS_ORIGINAL_CODEPAGE as 0 & 1028, but no luck. can anyone please advise us which is the correct ARS_ORIGINAL_CODEPAGE for this Oracle character set.

[Justin Derrick]

I believe that if it's a new database, the only acceptable value for ARS_ORIGINAL_CODEPAGE is 0.

-JD.

[Vinothkumar_ve]

Thanks for ur reply JD,

We have already tried with ARS_ORIGINAL_CODEPAGE as 0 and 1028 as well. but still getting the same issue. Please share me if you have any other view in this case.

[Vinothkumar_ve]

i would like to add some more info. as checked at oracle end, value NLS_NCHAR_CHARACTERSET = AL16UTF16 and NLS_CHARACTERSET = AL32UTF8. which character set have to be considerred for the CMOD. if NLS_NCHAR_CHARACTERSET should be considerred, Please advise for the correct ARS_ORIGINAL_CODEPAGE to be used for it.

[Vinothkumar_ve]

Hi all,

the correct ORIGINAL_PAGECODE for this character set of the Oracle 11g is 923. Thanks to IBM CMOD support team.