網頁

2012年5月6日 星期日

Install 64-bit Oracle Client on 64-bit Windows 7

Last time, I install 32-bit PowerPivot 2012 on 32-bit Windows 7 to replace PowerPivot 2010. When I open Excel 2010 and select PowerPivot item, the remind message show up and ask me whether want to upgrade the workbook.
ScreenHunter_02 May. 06 11.50Of course, you have to press “OK” button so that the PowerPivot workbook will be showed up. In the moment, I follow the previous activity to execute refresh worksheet for retrieving Oracle Data but the result fail.
ScreenHunter_01 May. 06 11.46In this Error Message, it give me a suggestion either upgrading to 64-bit version or increasing memory. I choose upgrading to 64-bit version because the original 32-bit environment before replace PowerPivot version is normal so that it will be not enough memory.

For 64-bit environment, I need to install 64-bit OS, Office 2010, PowerPivot and hotfix with up-to-date. When finish the related Microsoft Prerequisite, the Oracle Client need to be installed then.
ScreenHunter_05 May. 06 13.50Download “Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) from Oracle Website and extract “win64_11gR2_client” compressed file to the selected folder. The extracted path will be “\client” and its setup file is under this path.
Executing "setup.exe” to begin the installation process of Oracle Client.
ScreenHunter_03 May. 06 13.21In Select Installation Type,select “Administrator” option next to click “Next>” button
ScreenHunter_06 May. 06 14.29Click “Next> “ button if we don’t need to select another language.
ScreenHunter_07 May. 06 14.29Keep the default Oracle Base and Software Location next to click “Next> “ button
ScreenHunter_08 May. 06 14.29If no any problem in Perform Prerequisite Checks, click “Finish” button to begin to install Oracle Client Software now.
ScreenHunter_09 May. 06 14.30The installation of Oracle Client almost is successful if no any surprise.
ScreenHunter_10 May. 06 14.52
In the moment, we need to add a “tnsnames.oRA” file under the installation path as “c:\app\davidwa_wang\product\11.2.0\client_1\network\admin\” for creating an entry in this file to allows the ODBC driver to establish network connections to an Oracle Database.
ScreenHunter_11 May. 06 14.54In this file content, need to define “Data Source Name”, "Host” (by FQDN or NETBIOS name or IP), “Port” (default = 1521) and “Service Name”
ScreenHunter_12 May. 06 14.55After saving this file and opening Excel 2010 to execute PowerPivot Data Refresh, its function will be normal now.
ScreenHunter_13 May. 06 15.15

沒有留言:

張貼留言

Since 2010 Design by Davidwa
©Copyright Davidwa Inc. All rights reserved.