I am trying to connecto to an Oracle client, that I think is 10g. I've used 10g 32-bit in the past and connected fine, but have a need to upgrade to 11g 64-bit Oracle Client. I do not adminstrate the Oracle Database, so I don't know all of the configurations there. I can still connect though with the 10g 32-bit connection, and have actually had the 11g 64-bit working, before I had to re-image a Windows 2008 server, now running SQL Server 2012 64-bit.
I have tried many of things. All of my variables are in order. My TNSNames and SQLNET files are in order. The error in the title is from tnsping.
My ultimate goal is to get a Linked Server created from SQL 2012 64-bit to this Oracle Server which is 32-bit. I have tried mofiying the Protocol settings with no luck. When I switch to TCP, it just times out.
When I try to create a Linked Server in SQL Server I get the following:
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "EPOC4DB".
OLE DB provider "OraOLEDB.Oracle" for linked server "EPOC4DB" returned message "ORA-28759: failure to open file". (Microsoft SQL Server, Error: 7303)
Here's what's in my TNSNAMES and SQLNET files:
SQLNET.AUTHENTICATION_SERVICES = (TCPS, BEQ)
SSL_VERSION = 0
SSL_CLIENT_AUTHENTICATION = TRUE
NAMES.DIRECTORY_PATH= (TNSNAMES)
SSL_SERVER_DN_MATCH = FALSE
SSL_CIPHER_SUITES = (SSL_RSA_EXPORT_WITH_RC4_40_MD5)
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =D:\Oracle11gR2\product\11.2.0\client_1\NETWORK)
)
)
EPOC4DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pdsepoc4)(PORT = 2484))
)
(CONNECT_DATA =
(SERVICE_NAME = orastd)
)
)
Any help or guidance is much appreciated. I will be working on this over the weekend! Thanks in advance!