In the following image, a bit version of Power BI Desktop is installed:. For instance, ODAC Choose the Windows installer of the Oracle Client. NET at machine-wide level by selecting the corresponding checkbox during the setup wizard.
Some versions of the Oracle client wizard selects the checkbox by default, others do not. Make sure that checkbox is selected so that Power BI can connect to your Oracle database. After you install the matching Oracle client driver, you can connect to an Oracle database.
To connect to an Oracle database with the on-premises data gateway , the correct Oracle client software must be installed on the computer running the gateway. The Oracle client software you use depends on the Oracle server version, but will always match the bit gateway. For more information, go to Manage your data source - Oracle. Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation.
These steps assume you've installed the ODAC Follow these steps to register Unmanaged ODP. However, you can also use Oracle Universal Installer to complete silent or response file installations, without using the GUI. This method is particularly useful if you need to perform multiple installations of Oracle Database Client.
Do not use Oracle Universal Installer from an earlier Oracle product release to install components from this release. Use the same installation media to install Oracle Database Client on all supported Windows platforms. If you reinstall Oracle software into an Oracle home directory where Oracle Database Client is already installed, then you must reinstall any components that were installed before you began the reinstallation.
My Oracle Support note The Oracle Database software is available as a zip file. Ensure that you extract the zip file to the same directory. When you have extracted all of the required installation files, see "Installing the Oracle Database Client Software" section. When you have copied the required installation files, see the "Installing the Oracle Database Client Software" section.
However, you can also use Oracle Universal Installer to complete silent installations using a response file, without using the GUI. This method is particularly useful if you need to perform multiple installations of Oracle Database Client. As you install Oracle Database Client, follow these guidelines:.
Do not use Oracle Universal Installer from an earlier Oracle product release to install components from this release. Use the same installation media to install Oracle Database Client on all supported Windows platforms.
If you reinstall Oracle software into an Oracle home directory where Oracle Database Client is already installed, you must reinstall any components that were installed before you began the reinstallation. This version is required to run Oracle Universal Installer and several Oracle assistants. To install Oracle Database Client perform the following steps:. Insert the Oracle Database Client installation media and navigate to the client directory.
Alternatively, navigate to the directory where you downloaded or copied the installation files. Starting with Oracle Database 11 g Release 2 To start Oracle Universal Installer to download updates, enter the following command:. Provide the My Oracle Support user name and password, and provide proxy settings if needed on the Provide My Oracle Support credentials screen.
Then, enter the Download location and click Download on the Download software updates screen. If updates are available, then they are downloaded in the location provided. The Finish Updates screen shows the successful download of the updates. Click Close. After you download updates, transfer the update file to a directory on the server where you plan to run the installation.
If you have an existing Oracle Database Client 11 g Release 2 In the Download Software Updates screen, select one of the following options, and click Next :. Use My Oracle Support credentials for download to download and apply the latest software updates. Provide the proxy server information for your site, along with a user account that has access to the local area network through which the server is connecting.
The proxy realm information is case-sensitive. If you do not have a proxy realm, then you do not need to provide an entry for the Proxy Username, Proxy Password, and Proxy Realm fields. Click Test Connection to ensure that your proxy settings are correctly entered, and the installer can download the updates.
The Apply Software Updates screen is displayed if you select to download the software updates or provide the pre-downloaded software downloads location. If you selected Use My Oracle Support credentials for download in the previous screen, then select Download and apply all updates , and click Next.
If you selected Use pre-downloaded software updates, then select Apply all updates , and click Next. The Select Product Languages screen enables you to select the language in which you want to run the product. Select the product language from the Available Languages list, transfer it to the Selected Languages list.
Click Next. This screen is not displayed if you select Instant Client as the type of installation in step 5. Oracle Base : This path appears by default. You can change the path based on your requirement. The Oracle Base section is not displayed if you select Instant Client as the type of installation in step 5. In the Software Location section, accept the default value or enter the Oracle home directory path in which you want to install Oracle components.
For information about creating TNS service names, see the Oracle documentation. Make certain that a current version of the Oracle client code is installed at the distributor. For an Oracle 10g client install, the name of this executable is sqlplus. In the Environment Variables dialog box, in the System variables list, select the Path variable, and then click Edit.
In the Edit System Variable dialog box: if the path to the folder that contains sqlplus. If you cannot locate sqlplus. If you are connecting to an Oracle database earlier than version 8. If you are connecting to an Oracle database that is version 8.
If it is not, the following error message is shown:. If you have multiple versions of the Oracle client software installed on the Distributor, make sure that the most current version is at least version 9 and that the system path variable refers first to this version references to other versions can appear as long as the most recent appears first. For more information about editing the system path variable, see the section 'SQL Server Error is Raised' earlier in this topic. If the provider is not installed and registered, one or both of the following error messages is shown:.
Oracle, has been registered is not present at the distributor. To verify that the Oracle publishing environment is configured properly, SQL Server tries to connect to the Oracle Publisher with the login credentials you specified during configuration. If there is a problem reading or writing this registry entry, the following error message is shown:. Oracle to run in process with SQL Server.
Make certain that current login is authorized to modify SQL Server owned registry keys. Oracle publishing requires the registry entry to exist and to be set to 1 for 64 bit Distributors.
If the entry does not exist, SQL Server will attempt to create it. If the entry exists, but is set to 0 , the setting will not be changed; the configuration of the Oracle Publisher will fail. In the Run dialog box, type regedit , and then click OK.
0コメント