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 .
Oracle Enterprise stage issue - Migration to 8.7
Moderators: chulett, rschirm, roy
Re: Oracle Enterprise stage issue - Migration to 8.7
Is this resolved? What version of oracle client is used in DS8.7 version?
Datastage is the best thing that happened to ETL
Re: Oracle Enterprise stage issue - Migration to 8.7
Yes tha was resolved , Its Oracle 11g .Niv0599 wrote:Is this resolved? What version of oracle client is used in DS8.7 version?
The issue was so simple , There was an ORCAKE_HOME declared at project level whoch is pointing to old DS Insallation Server .
Vivek
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: