Hi All,
We are getting an error when we try to connect to Oracle using ODBC connector.
[IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor
I talked to DBA and the SID name is correct which we entered in odbc.ini.
I doubt whether '-' in the HostName field is creating problem.
We need to execute Oracle Stored Procedure from datastage and as far as I know we must make Oracle as an ODBC to execute stored procedures.Please let me know if I am wrong as well as suggest on the entry below from .odbc.ini
If It is giving an error from TNS, I think u may want to check if the TNS entry in the tnsnames.ora file in your oracle client's Network/Admin path is correct.
Also you can try tnsping <TNSEntry> to verify if the TNS entry is correct.
We have had lot of issues like these mainly because the TNS entry for that db had some problem.
Hi Norton,
We connect to that DB referring to Service Name but the ODBC Wire Protocol connection does not have the field to enter ServiceName in the list.Hence the SID.Please let me know if there is a way to make an ODBC connection using Oracle wire protocol entries for ServiceName
I doubt you enter either the actual SID or ServiceName there, have you tried using the name of the TNS entry there? It would then specify the actual connection information to use.
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:I doubt you enter either the actual SID or ServiceName there, have you tried using the name of the TNS entry there? It would then specify the actual connection information to use. ...
The connection issue is resolved and we are able to connect to database and import metadata of the stored procedure.But when executing it from job we are getting the error