DBCO connection test error

[Former Member]

Hi, All

I defined db connection with DBCO and I configured tnsname.ora.

I test tnsping and logon remote DB using sqlplus.

both are OK.

but!!

I check DBconnection with DB02 and then occured error.

next test connection is OK.

so the CBO program use the DBCO is failed at first time and the next execute is OK.

we use ECC 6.0 , Oracle 10.2.0.4, kernel 185

I attach dev_w log

==================================================

B Connect to EBIZPRO as kbizpro with EBIZPRO:KO16KSC5601

C *** ERROR => Characterset 'KO16KSC5601' not supported.

http://dboci.c 2371

C *** ERROR => OCI-call 'OCIErrorGet' failed with rc=100

==================================================

we use characterset 8500

how can I do?/

thanks

[markus_doehr2]

The Oracle 10g client - which you must use for ERP 6.0 - does no more support multibyte codepages.

See Note 858869 - Desupport of multibyte character sets as of Oracle 10g

You will need to convert the multibyte system to Unicode.

Markus

[Former Member]

Hi, Markus

Thanks for ur reply.

as you sad, only correction is unicode conversion?

but I wonder, next test is conneting using DBCO

test in DB02

-- MESSAGE Database connection EBIZPRO established successfully

and program using DBCO is working well.

only first connention is fail cause of above error.

I checked NLS_CHARACTERSET in Database

SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

value --> WE8DEC

how can I do except unicode conversion ?

thanks again

[markus_doehr2]

Are both database codepages WE8DEC? Or only the source or only the target?

Markus

[Former Member]

Hi, Markus

source is WE8DEC and target is KO16KSC5601

how can I do ??

[markus_doehr2]

Even if it works technically - transferring multi-byte data with Oracle 10g is not supported. You may corrupt data.

Markus