Oracle OCI Load stage gives fatal error

[kausmone]

Hi,

We are trying to load data to an Oracle 10g table using Oracle OCI Load stage in a server job but the jobs is failing as described below:

The job-log shows a warning as "ora_bulk..Oracle_OCI_Load_0: Internal Error: COracleOCI::Initialize failed"

and then a fatal error:

"ora_bulk..Oracle_OCI_Load_0: ORA-06401: NETCMN: invalid driver designator
Unable to initialize the connection to Oracle Server
ORA-06401: NETCMN: invalid driver designator"

Has anyone encountered this before, or knows how to fix this? I searched the forum and found a similar post, but that one was left unresolved.

Thanks,
Kaus

[kausmone]

Hi,

Managed to fix this. The "Service Name" was given incorrectly in the first case.

Rgds,
Kaus