TNS:listener could not resolve SID
Posted: Wed Mar 12, 2014 3:07 am
Hi,
I have configured a DSN for DataIntDev project on dstaged1 server to connect to Oracle 11g server . While connecting to db using this DSN I am getting error on DataStage Designer, the following are the steps I have followed. Please let me know is there anything missing or needs to be added.
1) I have configured .odbc.ini , uvodbc.config file under the below path
/opt/DataStage/Ascential/DataStage/DSEngine>
2) uvodbc.config under the project path
/opt/DataStage/Ascential/DataStage/Projects/DataIntDev>
I am able to connect from UNIX server using SQLPLUS (Oracle 9i client) to the Oracle database 11g.
On UNIX box Oracle client is 9i connecting to Oracle 11 g database. the following is the error while connecting to Oracle 11g (RAC)
BCI Error:SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor
But from the same server when I connect to Oracle 10g (RAC) database I don't have any issues.
Thanks,
Chakrapani Dadam
[Note - Title modified to be more descriptive - Admin]
I have configured a DSN for DataIntDev project on dstaged1 server to connect to Oracle 11g server . While connecting to db using this DSN I am getting error on DataStage Designer, the following are the steps I have followed. Please let me know is there anything missing or needs to be added.
1) I have configured .odbc.ini , uvodbc.config file under the below path
/opt/DataStage/Ascential/DataStage/DSEngine>
2) uvodbc.config under the project path
/opt/DataStage/Ascential/DataStage/Projects/DataIntDev>
I am able to connect from UNIX server using SQLPLUS (Oracle 9i client) to the Oracle database 11g.
On UNIX box Oracle client is 9i connecting to Oracle 11 g database. the following is the error while connecting to Oracle 11g (RAC)
BCI Error:SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor
But from the same server when I connect to Oracle 10g (RAC) database I don't have any issues.
Thanks,
Chakrapani Dadam
[Note - Title modified to be more descriptive - Admin]