July 7, 2012 at 8:25 am
prvmine (7/7/2012)
the error is expected when installing the 64 bit client second - just click continueI have step by step screen shots I can send via email
- it took me six tries to get it working
Hi,
If you could send the screen shorts or anything that would be helpful, I would greatly appreciate it.
Thanks!
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 7, 2012 at 8:40 am
I have downloaded Oracle Client 11.2, the article references 11.0.7.0.
What version did yo use?
Thanks.
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 7, 2012 at 10:25 am
prvmine (7/7/2012)
the error is expected when installing the 64 bit client second - just click continueI have step by step screen shots I can send via email
- it took me six tries to get it working
The Oracle Universal Installer (UI) did not remove the installations completely.
When I clicked on installed instances the UI only displayed one client instal.
When I started the install I was prompted to run the Uninstall of the other instance and this happened twice.
I had to remove the directories and registry entries manually.
I was expecting to see two Oracle Services running but there were no Oracle Services.
I just checked and I still have some Oracle entries in the registry.
Did you take notes on the uninstall as well?
Thanks.
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 7, 2012 at 10:56 am
These are the versions I installed
11g R1 32 bit
11g R2 64 bit
Yes, had to remove registry entries and directories during the process.
No notes on the uninstall or registry editing - sorry.
Attached is a word doc with the screen shots (just my notes) to repeat
on 5 additional servers - it's a bit rough and mostly a repeat of Rob Kerr
and Jorg Klein blogs.
July 7, 2012 at 11:18 am
If you had to repeat of 5 additional servers you would have to to be well versed with the process.
I need to install on 4 instances of two different servers.
Thanks again.
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 8, 2012 at 8:41 am
What should the sqlnet.ora look like?
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_1etwork\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= (NONE)
# Commented out the following line
#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
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 8, 2012 at 8:51 am
Welsh Corgi (7/7/2012)
prvmine (7/7/2012)
the error is expected when installing the 64 bit client second - just click continueI have step by step screen shots I can send via email
- it took me six tries to get it working
Didn't you have to specify in the PATH Variable the location of the installation for both the 32 bit & 64 bit install?
In the TNS_ADMIN Environmental Variable why do you create it for the 64 bit but not the 32 bit?
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 8, 2012 at 10:29 am
Didn't you have to specify in the PATH Variable the location of the installation for both the 32 bit & 64 bit install?
No - not on a Windows 2008 R2 64 bit server
The 32 bit client is for BIDS - SSIS to run interactively on that box or if you have to force SSIS to use 32 bit
In the TNS_ADMIN Environmental Variable why do you create it for the 64 bit but not the 32 bit?
You would enter both the 64 & 32 bit Oracle clients info
List 64 bit 1st 32 second
The SQLNET.ORA looks ok, but we did not use EZCONNECT.
Changes to the SQLNET.ORA should meet your shop protocols.
Your TNSNames.Ora entry also looks ok, however in our host name is like
HOST = servicexxxx@xxxxx.com
tnsping the oracle server via command line from your sql server to see how the alias is resolved.
July 8, 2012 at 10:42 am
With resect to the sqlnet.ora, etc we do not have Oracle. It is a 3rd party application. We own the data and I'm using it as on of the Data Sources to populate a Data Warehouse.
I never had to configure 11g and I do not recall having to configure a sqlnet.ora.
The people that manage the Oracle Servers are offshore. I have contacts with the company on-site but that is not their forte.
I will try the install tomorrow when I get back in the office.
Thanks!
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 9, 2012 at 6:31 am
prvmine (7/6/2012)
1st Install Oracle 11g R1 32 bit – Customchange Name to end with home2
Change path to end with client_32
2nd Install Oracle 11g R2 64 bit – Custom
By default 11gR2 uses home1 – there is no option to change this
Change software locations to end with client_64
Rob Kerr has a white paper you can down load
http://www.robkerr.com/2010/03/oracle-driver-configuration-for-ssis.html
The Oracle Universal Installer does not have a Drop Down Box where you can specify the Name (Home). I downloaded 11g 11.2:w00t:
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 9, 2012 at 6:41 am
May I please get Oracle Client 11g 11.1.0.7.0?
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 9, 2012 at 6:19 pm
Sorry, can check these during the day from work -- not allowed . . .
The Oracle Universal Installer does not have a Drop Down Box where you can specify the Name (Home). I downloaded 11g 11.2
Yes, that is correct and why Oracle client install are such a pain now.
the correct file name for the 32 bit 11g release 1 is win32_11gR1_client, which is version (11.1.0.6.0)
looks like you can get the client from here --
https://forums.oracle.com/forums/thread.jspa?threadID=944543
-- I don't have the exe/zip files anymore --
July 9, 2012 at 6:55 pm
gee golly - what has Oracle done -
Looks like they are pushing the "Oracle Data Access Components (ODAC) for Windows"
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
This might be an option, but I have not worked with this.
this thread might provide some help
http://www.sqlservercentral.com/Forums/Topic1077381-1044-1.aspx
July 10, 2012 at 7:52 am
prvmine (7/9/2012)
Sorry, can check these during the day from work -- not allowed . . .The Oracle Universal Installer does not have a Drop Down Box where you can specify the Name (Home). I downloaded 11g 11.2
Yes, that is correct and why Oracle client install are such a pain now.
the correct file name for the 32 bit 11g release 1 is win32_11gR1_client, which is version (11.1.0.6.0)
looks like you can get the client from here --
https://forums.oracle.com/forums/thread.jspa?threadID=944543
-- I don't have the exe/zip files anymore --
So that is supposed to be the 32 bit what about the 64 bit?:-)
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 10, 2012 at 6:17 pm
the correct file name for the 32 bit 11g release 1 is win32_11gR1_client, which is version (11.1.0.6.0)
Viewing 15 posts - 31 through 45 (of 54 total)
You must be logged in to reply to this topic. Login to reply