Page 1 of 1
Correct format for Remote Server string in Oracle Enterprise
Posted: Tue May 13, 2008 10:49 pm
by perfman
I am trying to get data from a remote Oracle database and insert it in my local Oracle database. I have created a job with an Oracle Enterprise stage and have selected the Remote Server variable. Now I need to tell Datastage how to access the data so it will need the server name, port and SID for the remote server.
What format should this be in?
Posted: Wed May 14, 2008 3:51 am
by ray.wurlod
Just the TNS name should suffice. The Oracle client can pick up everything else it needs from tnsnames.ora file.
Posted: Wed May 14, 2008 10:53 pm
by perfman
Very disappointing that an expensive GUI-driven application like DataStage doesn't provide a GUI to enter in the details of the database I want to connect to. I don't have permissions to update TNSNAMES.ORA on the server so I had to bug the sysadmin.
Posted: Fri May 16, 2008 4:50 am
by ray.wurlod
It would not have made any difference. It's Oracle that needs the entry in tnsnames.ora. If you, as a DataStage developer, had such a GUI, you would still not have permission to put it in to tnsnames.ora where Oracle insists on it being.