ORA-12737: Instant Client Light: unsupported server characte

[Former Member]

Hello,

I'm running BW 3.5 on Windows 32bit's WAS 6.40 and I've upgraded Oracle database from 9.2.0.8 to 10.2.0.4.

Now SAP system seems to work correctly except when I try to connect to an Oracle source system in RSA1.

I'm getting this error :

Operating system call SiPeekPendConn failed (error no. 10060)

Communication error, CPIC return code 020, SAP return code 236

> CPI-C function: CMINIT(SAP)

I tried to patch Kernel to patch number 274 and install Oracle Instant Client 10232 and i'm still getting this error.

Do you have an idea ?

Thanks in advance,

Alexandre

[markus_doehr2 · Accepted solution]

> I'm running BW 3.5 on Windows 32bit's WAS 6.40 and I've upgraded Oracle database from 9.2.0.8 to 10.2.0.4.

> I tried to patch Kernel to patch number 274 and install Oracle Instant Client 10232 and i'm still getting this error.

Kernel 640 and 640_EXT use the 9.2.x client, no matter if you install the instantclient. If you want to use the 10g client you have to update your kernel to 640_EX2.

> Now SAP system seems to work correctly except when I try to connect to an Oracle source system in RSA1.

What do you mean with that - to "an Oracle system"? Of which version? What do you see in the dev_w* traces when this error occurs?

Markus

[fidel_vales · Accepted solution]

Markus,

In UNIX you are correct.

In windows the oracle client matches the RDBMS version. A little exception to the rule.

BTW, the issue reported will never happen in UNIX, as the instantclient delivered for WUNIX is the full one.

But in Windows it was decided to release the "light" one, that does not support all charactersets.

I assume the OP is trying to connect to a DB with a characterset different from WE8DEC or UTF8.

The mentioned note address this issue

[Former Member · Accepted solution]

Here is the content of dev_w* log :

C Starting user session (con_hdl=1,svchp=227FBEAC,srvhp=228F8EE4,usrhp=228234D8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12737

[dboci.c 4481]

C Detaching from DB Server (con_hdl=1,svchp=227FBEAC,srvhp=228F8EE4)

C *** ERROR => CONNECT failed with sql error 12737.

[dbsloci.c 11461]

B ***LOG BY2=> sql error 12737 performing CON [dbds#3 @ 1044] [dbds 1044 ]

B ***LOG BY0=> ORA-12737: Instant Client Light: unsupported server character set WE8ISO8859P15 [dbds#3 @ 1044] [dbds 1044 ]

I try to connect to an external 10.2.0.4 Oracle database.

Thanks

[Former Member · Accepted solution]

I think problem doesn't concern SAP Kernel but the upgrade from 9i to 10g.

When I installed the Management Agent to manage Oracle from Entreprise Manager I get this error :

Failed to connect to database instance: ORA-12705: Cannot access NLS data files or invalid environment specified (DBD ERROR: OCISessionBegin).

Last Known State

Thanks

[markus_doehr2 · Accepted solution]

Check

Note 808505 - Secondary connection to Oracle DB w/ different character set

Markus

[fidel_vales · Accepted solution]

I am a bit "stubborn", sorry.

Have you read the note

SAP Note [998399 |http://service.sap.com/sap/support/notes/998399] "Changing the Oracle Instance Client from Lite to Full"

?????

Have you upgraded your oracle client from Lite (that does not support character set WE8ISO8859P15) to FULL (that supports it)?

[Former Member · Accepted solution]

I had already applied both notes before posting that thread.

Note 998399 Changing the Oracle Instance Client from Lite to Full

Note 808505 - Secondary connection to Oracle DB w/ different character set

As I told you I think problem is at dbms level, don't you think ?

[fidel_vales · Accepted solution]

>

> I had already applied both notes before posting that thread.

In that case I assume that there is an old library somewhere in your path.

could you check if you have somewhere in your system the following files:

• oraociei10.dll

• oraociicus10.dll

and tell us where and the sizes?

[Former Member · Accepted solution]

D:\usr\SAP\<sid>\SYS\exe\run\full\oraociei10.dll 89,448kb 04/07/2008

D:\usr\SAP\<sid>\SYS\exe\run\oraociicus10.dll 17,848kb 03/08/2008

[fidel_vales · Accepted solution]

>

> D:\usr\SAP\<sid>\SYS\exe\run\full\oraociei10.dll 89,448kb 04/07/2008
> 
> D:\usr\SAP\<sid>\SYS\exe\run\oraociicus10.dll 17,848kb 03/08/2008

Hi,

I do not have the instructions at hand but it seems that you didn't install properly the full client.

on the kernel directory (D:\usr\SAP\<sid>\SYS\exe\run) it is the light one and probably the one being used.

for that reason you get the error.

Tomorrow i'll check how is in my system

[fidel_vales · Accepted solution]

Hi,

Well, I do not have a 32 bit system and I can't upgrade the client in my system, but I have followed the instructions on the note 998399.

If you follow the instructions, on the point f you are instructed to Unpack the instant client archive. I did so:

C:\work\content>sapcar -xvf ..\OCL10264_lite.sar
    SAPCAR: processing archive ..\OCL10264_lite.sar (version 2.01)
    x classes12.jar
    x dbclient.lst
    x full
    x full/oraociei10.dll
    x heteroxa10.dll
    x lite
    x lite/oraociicus10.dll
    x oci.dll
    x ocijdbc10.dll
    x ociw32.dll
    x ojdbc14.jar
    x orannzsbb10.dll
    x oraocci10.dll
    x oraociicus10.dll
    x orasqlplusic10.dll
    x sqlplus.exe
    SAPCAR: 16 file(s) extracted

on the point i you are instructed to "Copy the Instant Client Full DLL into the current directory":

C:\work\content>copy full
full\oraociei10.dll
        1 file(s) copied.

You see that the full client is called oraociei10.dll and it is copied to the "current" directory.

Afterwards you have to "pack" the current directory (point k) and use that pack to install the client as indicated on the point 2 of note 998004.

I asked you to search for the file oraociei10.dll.

You found the file on:

> D:\usr\SAP\<sid>\SYS\exe\run\full\oraociei10.dll 89,448kb 04/07/2008

If you would have follow the instructions on the mentioned note the file would be on the "full" directory AND on the current directory as the instruction on the point K would have pack both.

As I mentioned, I'm a bit stubborn and I think you have not installed properly the full client and I still think it will solve your problem.

[Former Member]

thank you all for your help

[fidel_vales]

Hi,

Yes, the first idea is to search for notes.

You know, it is soooooo easy that you can even get the correct answer in less time it takes you to post your question:

SAP Note 998399 Changing the Oracle Instance Client from Lite to Full