I have installed Datastage PX server 7.0 on Sun Sparc Solaris 2.8. The Oracle client 9i is installed on the same box. I am trying to connect to a remote Oracle server on WinNT.
I have done the necessary configurations in the files as detailed down in the Install doc as well as in Orchestrate Operator ref/admin docs.
I can import the Plugin Oraoci9 definitions using the Datastage Manager successfully.
But when I drag the Oracle Enterprise stage on the parallel canvas using the designer and try to preview the data after filling parameters like table name,username,password and remote server name it is giving me the following error.
Oracle error -2127, Connect failed for env,username and password
Any answers of how to make it workable?
Not connecting to Oracle 9i server
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 1
- Joined: Mon Dec 08, 2003 2:38 am