Oracle 10g Download 64 Bit

5/25/2021admin

Oracle Xe 10g Download 64-bit
Oracle 10g Download 64-bit
Oracle 10g Download 64 Bit Windows 10
Oracle 10g Express Edition Download 64 Bit
Oracle Client 10g Download 64 Bit

By: Tim Ford Updated: 2008-02-13 Comments (29) Related: 1 2 3 More >Linked Servers

Problem

In the 64-bit world the process is slightly more difficult - and in the case of one critical step it impacts any existing users on the instance! Process Creating Oracle Linked Server on a 64-bit SQL Instance: Install Oracle 10g Release 2 64-bit client software (available from Oracle website). Provides instructions about installing and configuring Oracle Database for Microsoft Windows (64-Bit) on Intel Itanium. Only the features of Oracle Database for Microsoft Windows (64-Bit) on Intel Itanium software installed on the Windows Server 2003 operating system are discussed in this guide. Oracle Database Express 10g Edition XE for Windows 32 bit free download. Windows 8.1 Pro 64-bit free downloa.

We have two SQL 64-bit clusters in our organization: a four-node productioncluster and a two-node dev/test cluster. We recently migrated a database fromSQL that relied on an Oracle linked server for some of it's computations. No big deal, right? Install the Oracle client software and create the linkedserver just like in the other SQL version right? Be sure to repeat the processon both nodes for failover-sake, right? Wrong. In the case of 64-bitSQL instances we have a few extra steps we need to take to get an Oracle linkedserver configured and working properly.

Solution

64-bit computing is coming of age. In most cases, our installation andconfiguration processes do not change from 32-bit to 64-bit: setting up logins,creating SQL Agent jobs; nothing inherently different there. Inconsistenciesdo exist however. Take for example linked servers - more specifically linkedservers to Oracle databases. In 32-bit environments we simply install theOracle client software, create the linked server, add remote logins and move onto the next project. In the 64-bit world the process is slightly more difficult- and in the case of one critical step it impacts any existing users on the instance!

Process Creating Oracle Linked Server on a 64-bit SQL Instance:

Install Oracle 10g Release 2 64-bit client software (available from Oraclewebsite)
Install Oracle 10g Release 2 64-bit ODAC software (available from Oraclewebsite)
Restart SQL services
Configure OraOLEDB.Oracle provider
Create linked server
Add remote logins for linked server

The complete process is presented below:

Step One: Installation of the Oracle 10g Release 2 64-bit client software

I will leave it up to you to secure the software by either download from theirsite or media available via any licensing agreements you may have with Oracle. The important steps are outlined below. You only need the barest install ofthe client. Simply go ahead and select the InstantClient option from the openingdialog form and click Next.

The following screens simply require you to click Next when enabled. Theseare in place to present the internal checks and summaries of work to be completedonce you accept the install parameters. Proceed through the screens, clickInstall, and then Finish once the installation is complete.

Step Two: Installation Oracle 10g Release 2 64-bit ODAC software

Once you have an installed 64-bit Oracle Home you can proceed with installingthe ODAC drivers for a 64-bit environment. The OraOLEDB.Oracle driver installedin this step is what you need to set up your linked server. You'll find thesetup.exe for this installation located in the unzipped Install folder. Istrongly suggest you review your previous installation of the client software viaselecting the Installed Products button. You want to verify that you havea valid 64-bit Oracle Home that you'll be installing against during this process. We would not be DBAs if we were not overly cautious. It's quite Darwinian: the brash and risky don't last long as Database Administrators.

If you accepted the defaults during the client installation, your 'InstalledProducts' Inventory should appear as follows. If so, then close the dialogand click Next to continue. If not, then I suggest you revisit your installationof the client software, possibly de-installing and performing all steps presentedpreviously once again.

We will be installing the OraOLEDB.Oracle driver that is included in the OracleData Access Components option below. Select Next to continue.

Using the drop-down box provided, select the existing Oracle Home you just verifiedwas created as a part of your 64-bit Oracle client installation. The Pathwill automatically change accordingly. Gta offline game download for android. Continue by clicking Next.

You will be presented with the following sub-components. I've selectedall three (you never know when these items may be useful and they are extremelylightweight) though you only really need to install the first two items.

Recovery Essentials For Windows free download - Windows Essentials Media Codec Pack, Windows 10, Microsoft Security Essentials, and many more programs. Easy Recovery Essentials is compatible with all Windows ® PCs and laptops, and is guaranteed to work with your computer. It's the only repair solution that natively supports UEFI, and the latest update. Easy recovery essentials for windows. Easy Recovery Essentials Pro Windows 10 Free Download Latest Setup for Windows. Its full offline installer standalone setup of Easy Recovery Essentials Pro. Easy Recovery Essentials Pro Windows 10 Overview. Easy Recovery Pro Essentials.

If you do decide to install the Oracle Services for Microsoft Transaction Servercomponent, you'll be prompted for the port number to use. The default is 2030.

Click Next and you'll be presented with the familiar summary screen, listingall components to be installed. Review, make changes if necessary and thenclick Install. Once completed we can move back to familiar territory: SQL Server Management Studio.

Step Three: Restart SQL Service

This is the most unfortunate step in the entire process. This is usuallythe last thing a DBA wants to do. It is the option of last resort wheneverthere is an issue on a SQL Server instance. However, it is necessary in thiscase, so be sure to follow your corporate procedures for downtime notificationsand process. That being said, let's move past this horrid step!

Step Four: Configure OraOLEDB.Oracle provider

Oracle 10g express edition download 64 bit

I confess. I was not aware of this process existing until I had to do thisthe first time. In Object Explorer, navigate down the tree of the SQL instancewe've been working with until you're able to view the list of Providers under LinkedServers. Select OraOLEDB.Oracle and right-click.

The Provider Options dialog box appears. Enable the 'Allow inprocess' optionand close the dialog. Now ask yourself: 'Self, what did I just do? Some Internet Guy said click this and it will work.' Let's take a quick lookat exactly what enabling this option does for a provider. By default, OLEDB providers are instantiated outside of the SQL Server process. While thisprotects SQL from any OLE DB errors, Microsoft SQL Server requires that the OLEDB provider run in-process for handling BLOB-ish data types (text and images).

Step 5: Create Linked Server and Add Logins

Oracle Xe 10g Download 64-bit

Finally, something we're all familiar with. The T-SQL is simple, and identicalto the 32-bit platform.

A quick explanation about the @datasrc parameter. Since our environmentis clustered I do not like relying on an Oracle TNSname.ora file for our connectioninformation. It is far cleaner to specify the data source in terms of theSERVER:PORT/DB_NAME format.

As for creating an associated login the format is:

Briefly, the @useself parameter determines whether the current user in connectsto the linked server source under its current context or via impersonation. By setting the value to FALSE you're stating that you wish to connect to the linkedserver with a supplied login/password combination that is being identified in the@rmtuser and @rmtpassword parameters respectively. A value of TRUE would suggestthat a login will use it's own (current) credentials to connect to the linked server.

Creating a login for the LK_TIPS linked server we just created with a login of'sa' and a password set to 'password'would look like this:

Before you get any crazy ideas, I don't suggest using sa/password as a combinationfor any system!