I'm trying to setup connection to the Oracle database in Datastage 8.7. It's throwing up ORA-12203 (unable to connect to destination).
I tried installing Oracle in Datastage Server top check if it is resolving the issue but it's not.
Please help in figuring out if i'm missing out anything from my side?
Connectivity to Oracle Database
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 24
- Joined: Wed Sep 10, 2008 7:27 am
- Location: Houston
- Contact:
Connectivity to Oracle Database
Sambit Samantray
"Throwing up" is an unusual verb to use with an error message.
Before you configure DataStage to connect to Oracle, setup the database connection and test it from the Oracle client on the DataStage server. Once you confirm it's working outside of DataStage, then it's time to configure the DataStage server with Oracle environment variables.
Before you configure DataStage to connect to Oracle, setup the database connection and test it from the Oracle client on the DataStage server. Once you confirm it's working outside of DataStage, then it's time to configure the DataStage server with Oracle environment variables.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 24
- Joined: Wed Sep 10, 2008 7:27 am
- Location: Houston
- Contact: