ORA-12737: Instant Client Light: unsupported server character set WE8ISO8859P15

4,038 views

Skip to first unread message

crowndbt

unread,

Mar 23, 2010, 4:57:25 PM3/23/10

to Lab128 - Tools for advanced Oracle tuning, crow...@gmail.com

What is the fix for this error message:

03/23 16:52:12 - ORA-12737: Instant Client Light: unsupported server
character set WE8ISO8859P15
03/23 16:52:12 - End of connection detected
03/23 16:52:12 - Login attempts exhausted.
03/23 16:52:12 - Failed to connect to
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=10.16.100.83)
(PORT=1525))) (CONNECT_DATA=(SERVICE_NAME=FNTST)))

Thanks a lot

Sergei - Lab128

unread,

Mar 23, 2010, 5:31:53 PM3/23/10

to Lab128 - Tools for advanced Oracle tuning

Hi,

There are 3 types of Oracle client (for 10g and 11g): Full, Instant
Basic, and Instant Light. It seems that first two
support all character sets, Instant Light supports only:

* Single-byte character sets include US7ASCII, WE8DEC, WE8MSWIN1252,
and WE8ISO8859P1.
* Unicode character sets include UTF8, AL16UTF16, and AL32UTF8.

So, for WE8ISO8859P15 character set, Instant Basic client is needed.

Lab128 needs only two files from Instant Basic client, two DLL files:
oci.dll and oraociei10.dll
(10g); or oci.dll and oraociei11.dll (11g). These two files can be
extracted from the Instant "Client Package - Basic" zip files
downloaded from Oracle site:

http://www.google.com/url?sa=D&q=http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html&usg=AFQjCNHEmh9PXDjJ4YYtk2i9BvMOwICWNg

Put those two DLL files into Lab128 directory and it should work. If
you use this option, I will appreciate if you could confirm that it
worked or not.