on 11-07-2011 10:10 AM
Hi.
Is connecting by tnsnames.ora in a jdbc sender adapter channel with a Oracle Data Base possible?
What nomenclature I had to use in the adapter instead of jdbc:oracle:thin:@xxxxxxxxl:1521:orcl202 ?
Regards and thank u so much
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think probably this could be possible, but I'm not sure.
I think that you need only to replace the IP with the TNS name declared into your PI System.
Remember that you need to declare the TNS in both directory OS and Oracle/DB
Thanks a lot.
But, in which PI directory I had to put de tns file?
Regards
Ask to your basis team. file should be "hosts".
regards.
Mickael
You can refer to this link:
http://wiki.sdn.sap.com/wiki/display/Basis/SAPDBLinktoanExternalOracle+Database
In WinOS System, directories are:
Oracle -> C:\oracle\<SID>\102\network\admin\ tnsnames.ora
System Profile -> C:\usr\sap\<SID>\SYS\profile\oracle\ tnsnames.ora
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.