How to manage two Client Oracle

[valentina]

Hi all,
we need to install two Oracle client on DataStage Server to implement a secure connection. How can we manage the double configuration??
I thoght to act as follow:

- Remove Oracle setting from dsenv file
- Add User Define Environment Variables

We will set those variable for each project.
Before to implement I need to write some guidelines for the Unix support.
Any suggestion??

Thanks!

Valentina

[valentina]

In the Ascential Server we have both server and Parallel projects.
Do I have to move anyway??

[chulett]

In the meantime, while we wait - can you please explain what you mean by this?

we need to install two Oracle client on DataStage Server to implement a secure connection.

What do you mean by 'secure connection'? And are you saying that some jobs will need to use one client and some jobs will need to use the other? Or any given job may need to switch back and forth between clients? Something completely different?

[valentina]

For Data Privacy needs, we have to use Oracle Advanced Security connection toward a Data Server. To use this connection we need to install a Client dedicated. Is it possible to use different client for different projects??Is even possible to set this for a single job??

[ray.wurlod]

Two in one job might be tricky, since environment variables such as ORACLE_HOME can only have one value at a time. But you should be able to run different clients from different jobs, by making the Oracle environment variables job parameters. Just make sure you account for all the variables needed, such as NLS_LANG, not just the ones with ORACLE... names.