Oracle Enterprise stage issue - Migration to 8.7

[allavivek]

Hi All ,

We are doing DataStage Code Migration from 7.5 to 8.7 . The old jobs in 7.5 are using oracle enterprise stage with client oracle 10 (32 bit installed ).

In new 8.7 we have oracle client 64 bit installed .

Issue was , we are able to connect to oracle databases using oracle connector stage but while testing jobs using oracle enterprise stage we are getting below error , All paths in dsenv are set correct and also server was restarted .

The only change was the Library path is pointing to 64 bit client .

1.) Do the enterprise stage compaible with 64 client insalled on DataStage server 8.7 ?
2.)Is there any thing we need to se for 8.7 inorder to make enterprise stage works ?


Error: main_program: (aptoci.C:54). Message: OCI_ERROR: Bad Oracle environment.
(aptoci.C:54). Message: OCI_ERROR: Bad Oracle environment.

ORA_u_pog: APT_OraReadOperator: connect failed.

ORA_Rms12_pog: APT_OraReadOperator: connect failed.

Thank you .

[Niv0599]

Is this resolved? What version of oracle client is used in DS8.7 version?

[allavivek]

Is this resolved? What version of oracle client is used in DS8.7 version?

Yes tha was resolved , Its Oracle 11g .

The issue was so simple , There was an ORCAKE_HOME declared at project level whoch is pointing to old DS Insallation Server .

Vivek

[chulett]

Yummm... ORCAKE.

[ray.wurlod]

Is this one of the ones you can both have and eat?