Oracle Enterprise stage(urgent!)
Posted: Mon Jan 19, 2004 5:53 am
Hi,
I have just installed Oracle 9i and Datastage PX on Solaris.I have made all the necessary configurations required.I am able to connect via ODBC to oracle in a server job.I am also able to run a parallel job using sequential access stage.
I imported a schema from the oracle server.But while developing a parallel job using the Oracle Enterprise database stage, i encounter the following error when i try to view data after supplying the username/password and the username.oracle table:
##W TCOS 000049 07:08:40(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TDOR 000008 07:08:43(001) <Oracle_Enterprise_0> Missing server name. Can't connect
>##E TDOR 000140 07:08:43(002) <Oracle_Enterprise_0> APT_OraReadOperator: connect failed.
Please reply ASAP !!!..
Regards
I have just installed Oracle 9i and Datastage PX on Solaris.I have made all the necessary configurations required.I am able to connect via ODBC to oracle in a server job.I am also able to run a parallel job using sequential access stage.
I imported a schema from the oracle server.But while developing a parallel job using the Oracle Enterprise database stage, i encounter the following error when i try to view data after supplying the username/password and the username.oracle table:
##W TCOS 000049 07:08:40(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TDOR 000008 07:08:43(001) <Oracle_Enterprise_0> Missing server name. Can't connect
>##E TDOR 000140 07:08:43(002) <Oracle_Enterprise_0> APT_OraReadOperator: connect failed.
Please reply ASAP !!!..
Regards