Question

Unable to connect to Oracle database, because the database environment could not be initialized

  • 18 November 2013
  • 3 replies
  • 6 views
S
Hello All,

 

 

We have built a new server on a Windows 2008 R2 (64bit) system and and I have:

 

1. FME 32bit installed 2. Oracle Client 32 bit installed 3. Oracle client BIN folder in PATH 4. TNS_ADMIN environmental variable set to point to folder containing tnsnames.ora

 

5. ORACLE_HOME environment variable set

 

 

The issue is very similar to this

 

 

I can connect to our DB via third party and SQL*Plus. I've modified security setting to give required access. I'm running out of ideas. Any input please?

 

 

2013-11-18 11:23:15|   0.6|  0.0|INFORM|ORACLE Reader: Using Oracle 8 SC Reader Version 1.2 (Jul. 04, 2000) to read tables from database `', server type `ORACLE8i', server name `pri1', user name `fme_ro', password `***'

 

2013-11-18 11:23:15|   0.6|  0.0|INFORM|ORACLE Reader: Using Classic geometry.

 

2013-11-18 11:23:15|   0.6|  0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'

 

2013-11-18 11:23:15|   0.6|  0.0|ERROR |Unable to connect to Oracle database, because the database environment could not be initialized.

 

2013-11-18 11:23:15|   0.6|  0.0|INFORM|FME Session Duration: 0.6 seconds. (CPU: 0.2s user, 0.1s system)

3 replies

R
Hi,

 

 

I'm running my Oracle FME scripts in the same environment as above, without any problems

 

My settings below:

 

I don't have oracle_home set

 

Path=C:\\oracle\\11.2.0\\client_1\\bin;

 

TNS_ADMIN=C:\\oracle\\11.2.0\\client_1\\network\\admin

 

 

 

Note: Do have more than one client installed, and is the 32-bit client installed (x86) directory?

 

Oracle have isues with spaces in the directory name, therefore we have installed the base in its own Directory.

 

Rudy

 

S
One thing I noticed from an old successful log below was this, right after the OCI Loaded the next INFORM gives the environment variable but in my failed version the error occurs before this. The environment variable IS definitely defined. It seems to be erroring out after the OCI load but I cannot figure out why.....for two days now.

 

 

2013-09-23 08:53:44|   1.0|  0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'

 

2013-09-23 08:53:44|   1.2|  0.1|INFORM|Environment variable ORACLE_HOME has value `E:/app/cipsadmin/product/11.2.0/client/'

 

2013-09-23 08:53:44|   1.2|  0.0|INFORM|Connecting to ORACLE database `pri1' with user name of `FME_RO' and password of `***'
M
Badge +2

@sdlas This question might help you resolve this.

Reply


Community Stats

28,670
Posts
109,365
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.