Ошибка oracle initializing oci environment handle

I use the root user to install

# yum install oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 
# yum install oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm 

I use the report user which is the owner of the PG server.
I can use sqlplus to login to oracle server as user report.

here is my error:

report=> SELECT oracle_diag('server_ora_99');
ERROR:  error connecting to Oracle: OCIEnvCreate failed to create environment handle
DETAIL:  
report=> select oracle_diag();
                                             oracle_diag                                              
------------------------------------------------------------------------------------------------------
 oracle_fdw 2.0.0, PostgreSQL 9.5.12, Oracle client 11.2.0.4.0, ORACLE_HOME=/opt/oracle/instantclient
(1 row)

Stefan

unread,

Hi there,

i’m experiencing a strange Problem here.

I’ve developed an MS-Access-application in VBA that starts MiPro in the Background via 

Set objMapInfo = CreateObject(«Mapinfo.Application.x64»)

Now i’ve three Computers running that app, but it does so only on one machine, on the other two i get this error 

Oracle-Error: Allocating OCI Environment handle.

Searching the Internet i found a short article on the PB Website About that Problem with MiPro 32-Bit, explaining that the Problem may be solved by reinstalling the Oracle Client matching the MiPro-Version. In my case that would mean: reinstall the whole Oracle DB, — no way!

I checked the machines for differences.

All running Windows 10 Pro 64-Bit / 1803 / German / MiPro 15.03 DE / MiPro 17.01 Advanced / Oracle 12.2 32-Bit Instant Client / Oracle 12C Enterprise DB / same MS-Office Version.

Setup is the same, 32-bit MiPro can Access the Oracle db as well.

In the path on all machines the 64-bit Oracle bin-path Comes before the 32-bit instant Client path. The Oracle global variables are the same.

On all three machines it’s no Problem to load a spatial layer from the local Oracle instance in MiPro 17.01 when started regulary via Windows startmenu, but when i issue the vba-codeline above, on two machine i get that error message instantly, on one of the machine everything runs as expected.

After many Hours of searching i’m lost, and any thoughts are highly welcome.

Thanks and have a nice Weekend

Stefan

Eric Blasenheim

unread,

Stefan,

The key is that you need a 64-bit Oracle OCI client on every machine where Pro (or any other 64-bit client) is installed for us to talk to Oracle.  Those client dlls can just be the «instant client» but they need to be there and be accessible (via the system path) for MapInfo Pro to load.  This is not a MapInfo limitation, this is the way 32 and  64 bit machine software works on all systems.

It seems you have the Oracle database on the same machine but that should not matter other than the fact that the 64-bit client dlls may already be there. 

But what you need to do is:

Make sure the 64-bit version of oci.dll and its dependent dlls (what comes with the instant or full client) are on the machine. 

Make sure that location is on the system path when MI Pro is running. Since you are launching Pro via COM/VBA this may mean it needs to be on the true system level path as we are being launched by the system and not directly your VBA program.  You can see what path an executable truly has at run time via tools like Windows Process Explorer. 

Note that some people think there is an issue with having the 32 and 64 bit versions on the path. In general, this is not true. When MI Pro tries to load OCI via the Windows API, the 64-bit OS completely ignores any 32 bit DLLs that happen to have the name OCI.DLL.  So the order on the path does not matter.  (if you try programmatically to point a 64-bit program to a 32 bit dll with an explicit path, Windows tells you this is not an executable).

When the loading of a particular Oracle table uses a SSID whose description is in the tnsnames.ora file, for OCI to locate those and know what they mean., their code uses the TNS_ADMIN environment variable to locate that file.  So it should be set to the location of  the tnsnames.ora file. 

But really it is just making sure Pro can load the 64-bit OCI.DLL 

I hope this helps.

Eric Blasenheim

Pitney Bowes Software.

On Saturday, September 22, 2018 at 8:16:43 AM UTC-4, Stefan wrote:

Hi there,

i’m experiencing a strange Problem here.

I’ve developed an MS-Access-application in VBA that starts MiPro in the Background via 

Set objMapInfo = CreateObject(«Mapinfo.Application.x64»)

Now i’ve three Computers running that app, but it does so only on one machine, on the other two i get this error 

Oracle-Error: Allocating OCI Environment handle.

Searching the Internet i found a short article on the PB Website About that Problem with MiPro 32-Bit, explaining that the Problem may be solved by reinstalling the Oracle Client matching the MiPro-Version. In my case that would mean: reinstall the whole Oracle DB, — no way!

I checked the machines for differences.

All running Windows 10 Pro 64-Bit / 1803 / German / MiPro 15.03 DE / MiPro 17.01 Advanced / Oracle 12.2 32-Bit Instant Client / Oracle 12C Enterprise DB / same MS-Office Version.

Setup is the same, 32-bit MiPro can Access the Oracle db as well.

In the path on all machines the 64-bit Oracle bin-path Comes before the 32-bit instant Client path. The Oracle global variables are the same.

On all three machines it’s no Problem to load a spatial layer from the local Oracle instance in MiPro 17.01 when started regulary via Windows startmenu, but when i issue the vba-codeline above, on two machine i get that error message instantly, on one of the machine everything runs as expected.

The only difference i was able to find is, that the machine without Errors is running Oracle DB 12.1 while the other failing machines are running 12.2.

I would think that it’s quite unprobable that this is the source of this Problem, — but what else?

Stefan

unread,

Stefan

unread,

Sidhu Sidvester

unread,