Announcement

Collapse
No announcement yet.

[SOLVED] Oracle Connection Error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Oracle Connection Error

    Failed to connect to the oracle9i of ScriptCase error.

    ”Connection Error ocilogon(): ORA-12735: Instant Client Light: unsupported client character set NA”

    Can you help?

    hata.JPG

    Oracle9i language features ;
    NLS_LANGUAGE = TURKISH
    NLS_TERRITORY = TURKEY
    NLS_CHARACTERSET = TR8MSWIN1254

    Oracle 9i runtime installed on my computer.

    oracle install.jpg

    Oracle Connection Test ;

    oracle connection successful.JPG


    “My Computer (right button)--> Properties---> tab “Advanced --> Environment Variables”
    ORACLE_HOME = C:\oracle\ora92
    Path = C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;
    TNS_ADMIN = C:\oracle\ora92\network\admin
    NLS_LANG = TURKISH_TURKEY.TR8MSWIN1254

    lines activated in php.ini
    extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
    extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
    extension=php_pdo_oci.dll
    extension=php_pdo_odbc.dll


    Scriptcase diagnosis.php ;

    diagnosis.JPG

  • #2
    mmm, we're running on Oracle. Will ask 'rr' tomorrow to respond.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Scriptcase uses the oracle instant client by default. Yet the oracle instant client basic lite does NOT support all character sets.
      See: http://docs.oracle.com/cd/B19306_01/...b14357/ape.htm
      You should use the full oracle instant client basic, not the basic lite one.
      oracle clients: http://www.oracle.com/technetwork/da...ex-097480.html
      Alternatively you can also use the normal oracle client which is what I do.
      Be very aware of the fact that if you are on windows your oracle instant client should be reachable via the path variable (also for services) and that on your development server that the oci.dll and the ociw32.dll may need to be renamed to _oci.dll and _ociw32.dll to force the instant client versions to load. And remember to restart your service for netmake after you have done the rename.
      Of course I assumed you use windows....

      Comment


      • #4
        I solved the problem by changing registry settings.
        Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.

        Thank you for your help.

        Comment

        Working...
        X