Hi, I have a oracle database connection on the FME Server, the fme script runs fine from FME server if the connection is used for reading but when I try to write to it, it does not work. From SQL plus on FME server do not have any problem reading or writing. See the error log below:

What could be the problem here?

Thanks,

Vijay

Using Oracle Writer to write tables to database `', server type `ORACLE8I', server name `TAMSPROD.WORLD', user name `GEOMEDIA', password `***'Oracle Writer: Starting at transaction 0 with a transaction interval of 1000Loaded module 'OCI' from file 'OCI.dll'Unable to connect to Oracle database, because the database environment could not be initialized.Unable to connect to Oracle database, because the database environment could not be initialized.Destination Feature Type Routing Correlator(RoutingFactory): Unable to connect to Oracle database, because the database environment could not be initialized.=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `ORACLE_NONSPATIAL' writer using keyword `ORACLE_NONSPATIAL_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-GEOMEDIA.A (GEOMEDIA.A) 1==============================================================================Total Features Written 1=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Oracle Writer: Abnormal channel cleanup required, likely due to previous errorUnable to connect to Oracle database, because the database environment could not be initialized.Translation FAILED with 4 error(s) and 1 warning(s) (1 feature(s) output)