Oracle 12.2 client: Cant't initialize OCI. Error -1

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Agamemnon
Posts: 4
Joined: Thu 25 Jun 2009 13:43
Location: Kall / Germany

Oracle 12.2 client: Cant't initialize OCI. Error -1

Post by Agamemnon » Tue 20 Mar 2018 09:59

Hello,

I get this error when trying to open a query via ORACLE 12.2 client (32 bit). Connecting of TOraSession works, additionally I can see the session in the database. But when I try to open a query, the message appears.

When I use an ORACLE 11.2 Client (32 bit) on a different machine, everything works fine.

System information:
C++ Builder 10.1 Berlin
ODAC version 10.1.4 for RAD Studio 10.1
Oracle Call Interface 12.2.0.0
Microsoft Windows Server 2016 Standard Version 10.0.14393

Nothing special in TOraSession:

object ODAC_Session: TOraSession
Options.UseUnicode = True
Options.DateFormat = 'YYYY-MM-DD'
Options.DateLanguage = 'GERMAN'
Options.EnableIntegers = False
Username = 'sysadm'
Server = 'deoratest2'
LoginPrompt = False
AfterConnect = ODAC_SessionAfterConnect
BeforeConnect = ODAC_SessionBeforeConnect
AfterDisconnect = ODAC_SessionAfterDisconnect
Left = 64
end

Has anybody an idea what is wrong here?

Tobias

inigojoseph
Posts: 1
Joined: Tue 20 Mar 2018 11:18

Re: Oracle 12.2 client: Cant't initialize OCI. Error -1

Post by inigojoseph » Tue 20 Mar 2018 11:28

I am trying to connect Oracle 10g database server from my client PC using toad 10 Commercial. I have Oracle 10g installed in my PC. When I try to connect, it gives error Can't initialize OCI.Error -1 . So far I am able to perform tnsping to the oracle server. I have all the settings working in my tnsnames.ora.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle 12.2 client: Cant't initialize OCI. Error -1

Post by MaximG » Tue 20 Mar 2018 14:31

Please make sure that the Oracle Client you are using is configured correctly. For this, configure it to use
the server you are interested in and check the correctness of the used parameters using any convenient Oracle utility (for example, SQL*Plus or Oracle SQL Developer). In addition, make sure that the bitness of the application you are developing and the Oracle Client that you are using are the same

Post Reply