Page 2 of 2
Posted: Tue Mar 15, 2005 7:53 am
by Mike
If the Oracle install for the server also installs the client, then no (assuming the DS server and Oracle server are on the same linux machine). I was just trying to point out that your ability to connect to the Oracle server from your Windows Oracle client is irrelevant. The DS server is the client that needs to connect to Oracle. You need to make the connection to Oracle from the linux machine that is hosting the DS server.
Update: I just reread your last post. I think you might need to install the Oracle 9i client on your linux machine. I don't think the 10g client is supported yet.
Mike
Posted: Tue Mar 15, 2005 8:18 am
by Sainath.Srinivasan
As we have exhausted most of the options, you can try to load dsenv and bounce datastage instance to confirm that all the env parameters are loaded properly.
Posted: Tue Mar 15, 2005 8:47 am
by chulett
Mike wrote:I think you might need to install the Oracle 9i client on your linux machine. I don't think the 10g client is supported yet.
10g is supported in
7.5 (which the OP has) so that "shouldn't" be the problem.
Posted: Tue Mar 15, 2005 9:42 am
by kollurianu
what does bounce of datastage means?
thanks in advance
Posted: Tue Mar 15, 2005 9:44 am
by kcbland
"Bounce" means either reboot a server, shutdown software and restart its services, etc. "Bounce" like a ball, go down then come back up.
Posted: Tue Mar 15, 2005 9:54 am
by Sainath.Srinivasan
One more point, DataStage is a 32-bit application by default and expects a 32-bit Oracle lib. Can you please confirm that Oracle is 32 bit and not 64 bit.
If 64, then point DS to a 32 bit client, load dsenv and bounce.
Posted: Tue Mar 15, 2005 5:22 pm
by egosz
Hi Sainath
I have tried ot search for a directory callled lib32 at $ORACLE_HOME but couldn't find any. I am very much sure that all of the systems I am running (both Windows and Linux) are 32-bit.
Thanks everyone