Connectivity to Oracle Database

sambitsamantray · Post by **sambitsamantray** » Thu Feb 23, 2012 4:00 pm

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?

qt_ky · Post by **qt_ky** » Thu Feb 23, 2012 5:43 pm

"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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 23, 2012 6:33 pm

qt_ky wrote:"Throwing up" is an unusual verb to use with an error message.

It's a Texan thang.

sambitsamantray · Post by **sambitsamantray** » Tue Feb 28, 2012 10:19 am

The Oracle database was a source to our dataware house and it was supported by an external business unit. They had given us incorrect host name and port number. When they provided us the correct ones it was easily configured.