Page 1 of 1
accessing a Oracle Database on a differnet server
Posted: Tue Nov 23, 2004 11:42 pm
by Pavan_Yelugula
hi all
we are trying to access a oracle database loaded on a different unix box.
we have our datastage on a differnt server and oracle database on a different database.
Any pointers how this can be done
Thanx and Regards
Pavan
Posted: Wed Nov 24, 2004 12:22 am
by davidnemirovsky
Install the Oracle Client on the Datastage server.
Make sure your "tnsnames.ora" file on the Datastage server has the entry for the Oracle Database on the Oracle DB Server.
Posted: Wed Nov 24, 2004 12:30 am
by Amos.Rosmarin
Make sure you can connect ot the desired database from the etl server with sqlplus.
If so there is no reason datastage will not connect.
we are able to connect to the other database with sqlplus
Posted: Wed Nov 24, 2004 12:45 am
by Pavan_Yelugula
we are able to get through with sqlplus.should we be changing something to import the table definitions in datastage manager.
Posted: Wed Nov 24, 2004 12:55 am
by davidnemirovsky
You should be using the exact same credentials as you've used for SQL Plus.
Make sure you're using the correct 'Plug-in Metadata Definitions' in the Manager ie. Ora8i for Oracle8i, Ora9i for Oracle9i etc.