Print Page - Config CMOD V9 with Oracle 11G

Title: Config CMOD V9 with Oracle 11G
Post by: Vinothkumar_ve on July 02, 2014, 03:40:48 PM

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.

Title: Re: Config CMOD V9 with Oracle 11G
Post by: Justin Derrick on July 02, 2014, 10:23:52 PM

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

-JD.

Title: Re: Config CMOD V9 with Oracle 11G
Post by: Vinothkumar_ve on July 03, 2014, 09:25:43 AM

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.

Title: Re: Config CMOD V9 with Oracle 11G
Post by: Vinothkumar_ve on July 03, 2014, 11:31:48 AM

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.

Title: Re: Config CMOD V9 with Oracle 11G
Post by: Vinothkumar_ve on July 08, 2014, 02:22:54 PM

Hi all,

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

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: Vinothkumar_ve on July 02, 2014, 03:40:48 PM