Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Can't connect to a remote Oracle server


Can't connect to a remote Oracle server

Author
Message
Resender
Resender
SSC-Addicted
SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)

Group: General Forum Members
Points: 473 Visits: 1564
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
prvmine
prvmine
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3200 Visits: 9447
This link has info to resolve ORA-12154
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
Resender
Resender
SSC-Addicted
SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)SSC-Addicted (473 reputation)

Group: General Forum Members
Points: 473 Visits: 1564
prvmine (9/24/2013)
This link has info to resolve ORA-12154
http://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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3093 Visits: 4639
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search