Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't connect to a remote Oracle server Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 8:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 6:11 AM
Points: 338, Visits: 956
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
Post #1497923
Posted Tuesday, September 24, 2013 8:23 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:22 PM
Points: 2,205, Visits: 5,539
This link has info to resolve ORA-12154
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm
Post #1498105
Posted Wednesday, September 25, 2013 1:37 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 6:11 AM
Points: 338, Visits: 956
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
Post #1498163
Posted Wednesday, September 25, 2013 12:14 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #1498528
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse