July 5, 2012 at 6:08 pm
I get the error when testing a connection from SSIS:
ORA-12154 Error when attempting to configure Oracle OLE DB Connection
I also get an error from SQL Plus:
SQL Plus errors out:
ORA12560: TNS: Proptocol Adapter Error
I use TNSPing and it works fine.
I use TNS in my configuration of SQL Developer and that is fine.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2012 at 7:13 pm
Welsh
I don't have Oracle installed on my environment, so I am Googling tracing possible reasons, I agree, it is an Oracle's configuration.
I am not sure if you found this article at blogs.msdn: “ORA-12154: TNS: could not resolve the connect identifier specified” error while creating a linked server to Oracle it seems to have a lot of troubleshooting info.
Cheers,
Hope this helps,
Rock from VbCity
July 6, 2012 at 6:18 am
I'm thinking that it might be the sqlnet.ora?
#TNSNames.Ora
XXXXXX_RDB_QA=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.CC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XXXXXXqa)
)
)
------------------------------------------------------------------------
#SQLNet.ora
# sqlnet.ora Network Configuration File: D:\Oracle\product\11.2.0\client_2etwork\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2012 at 7:42 am
I did some checking on things.
It appears that the problem that I'm having is related to the fact that I have two installations although that should not be a problem for I have had more than two although it was not with 11g and it was not with a 32 bit and 64 bit installation.
I noticed that the environmental ORACLE_HOME does not have a value.
In the registry named HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1
The ORACLE_HOME entry contains the first installation which is the 64 bit installation: D:\Oracle\product\11.2.0\client_1
I had to install the 64 bit version first due to a bug because when I installed the 32 bit version first, when I tried installing the 64 bit version the architecture test failed and it detected the machine as 32 bit.
There are no entries for the second installation which is the 32 bit version and that is what BIDS and SQL Pluse use. SQL Server Agent uses the 64 bit version.
Any ideas? Has anoyone experienced anything like this?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2012 at 8:25 am
I saw this on a blog:
Need to run installer from command line to set ORACLE_HOME_NAME when installing clients 11g.
setup.exe ORCALE_HOME_NAME="oracle_home_name"
Otherwise the second client takes the home of the first client.
What do you set the value of the ORACLE_HOME_NAME?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply