September 24, 2013 at 8:52 am
Win 2008 server 64 bit
Bids 2008
SQL Server 2008 R2
Driver: Oracle 11.02.00.01
So I've done the following
installed the 32 bit client (11.2.0.1)
installed the 64 bit client
added oracle_home TNS_ADMIN keys to the registery
added the entry for the server in the tnsnames.ora
Did the batchscript referring to program files without the (x86)
But in the end both ssis as sqlplus give the error ORA-12154: TNS:can not resolve givven connection-ID
It's been 3 years since I've worked with oracle can someone point me to a solution or give me an idea what I've done wrong
txn
September 24, 2013 at 8:23 pm
This link has info to resolve ORA-12154
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
September 25, 2013 at 1:37 am
prvmine (9/24/2013)
This link has info to resolve ORA-12154http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
ok ,lets for the sake of argument say I've already tried those & to no avail.
I can't find tnsping
The 32 bit of the ODAC's has a Oracle Universal Installer while the 64 bit only has a batch file to install.
Trying to connect via sqlplus with both the tnsnames entry or directly on the address both fail.
It's a connection over a vpn
OK I can connect/tnsping to the database but not via tnsnames only directly
September 25, 2013 at 12:14 pm
Resender (9/25/2013)OK I can connect/tnsping to the database but not via tnsnames only directly
Many possible reasons for it...
1) Syntax errors on tnsnames file
2) Wrong parameters on tnsnames file
3) Multiple tnsnames files
4) ORACLE_HOME not correcty set
Make sure TNSNAMES file is correct then set TNS_ADMIN variable pointing to it - that way you are sure Oracle is using the rignt tnsnames one.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply