Oracle Database RAC 11.2.0.3 for AIX6.1TL7安裝記錄

Oracle Database RAC 11.2.0.3 for AIX6.1TL7安裝記錄

在AIX平台安裝Oracle RAC就是個坑爹的事情，今日再次驗證了這點，只因為bug太多！記錄問題也只因為bug太多！強烈推薦及看好Oracle RAC在Linux平台的發展。下面對問題的記錄：
>伺服器：IBM Power 740

 >儲存：IBM DS 5020
> 作業系統：
mzrac2@root[/oracle]oslevel -s6100-07-00-0000
> Oracle Grid&Database：11.2.0.3

一.安裝過程出現如下問題：

1.在檢查過程中出現如下的警示：

經過檢查，在AIX6.1TL7上是不需要這兩個補丁的，因此可以直接忽略。

2.安裝Grid的時候出現如下的報錯：

點擊"Retry"之後又可以順利通過。

之後安裝Database軟體的時候比較順利。

3.使用dbca建立資料庫的時候問題又來了，建立過程中始終報ORA-03113的錯誤，如：

雖然報錯，但是資料庫又能繼續建立，直到建立成功！坑爹啊，這麼建立的資料庫誰敢用啊！！！

4.core_* dump目錄及檔案撐爆你的$ORACLE_HOME/dbs目錄。
在這種情況下建立的資料庫會在$ORACLE_HOME/dbs目錄下產生大量的core_* dump目錄及檔案，直到檔案系統被撐爆！！！--------------------------------------------------------------------------------Linux-6-64下安裝Oracle 12C筆記 在CentOS 6.4下安裝Oracle 11gR2(x64) Oracle 11gR2 在VMWare虛擬機器中安裝步驟 Debian 下 安裝 Oracle 11g XE R2 --------------------------------------------------------------------------------


二.下面是排錯記錄：

1.在METALINK上找到如下的文章說明了ORA-03113的錯誤：

"ld: 0711-780 SEVERE ERROR: Symbol .ksmpclrpga" and "ORA-7445 [KSMPCLRPGA()+23248]" [ID 1379908.1]
		修改時間 27-JUN-2012 類型 PROBLEM 狀態 PUBLISHED

In this Document

Symptoms

Changes

Cause

Solution

References

 

Applies to:Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
IBM AIX on POWER Systems (64-bit)Symptoms

Installation / Relink of 11.2.0.x on AIX with following version
AIX 5.3 TL 8 and above
AIX 6.1 TL 6 and above
AIX 7.1 SP3 (7100.00.03.1115), TL 1 (7100-01-01-1141) and above

Fail with following relink errors :

ld: 0711-783 WARNING: TOC overflow. TOC size: 225720 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkea_prm_rate_ (entry 8601)
Address: 0x00008056; RLD type: R_TOC; RLD length: 16
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkea_prm_rtl_ (entry 8603)
Address: 0x0000805e; RLD type: R_TOC; RLD length: 16
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkea_prm_ctl_ (entry 8605)
Address: 0x00008062; RLD type: R_TOC; RLD length: 16
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkehackflg_ (entry 8607)
Address: 0x0000806a; RLD type: R_TOC; RLD length: 16
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkedPix_ (entry 8609)
Address: 0x00008076; RLD type: R_TOC; RLD length: 16
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkehackprm_ (entry 8611)
Address: 0x0000807e; RLD type: R_TOC; RLD length: 16
ld: 0711-780 SEVERE ERROR: Symbol .ksmpfpva (entry 58964) in object /oracle/lib//libserver11.a[ksmp.o]:
Relocation overflow in reference to: dbkeddmper_ (entry 8613)
Address: 0x00008082; RLD type: R_TOC; RLD length: 16

Further, if the above relink error is ignored while installation and database is created OR upgraded, then following error is noticed while shutting down the database.

ORA-03113: end-of-file on communication channelChanges

AIX O.S. was installed / upgraded to a new TL level

Cause

This is due to the
"Bug 13342637: 0711-780 SEVERE ERROR: SYMBOL .KSMPFPVA AND .KSMPCLRPGA"

Other bugs referenced / raised for similar issue

Unpublished Bug 10380509: ORACLE LINK ISSUE
Bug 13354044: LINK ERROR - LD: 0711-780 SYMBOL .KSMPFPVA IN OBJECT LIBSERVER11.A[KSMP.O]

BUG 13384572 - ORA-7445 [KSMPCLRPGA()+23248]

Solution

Please work with IBM to get a fix for your OS Version, as you look to be running into AIX O.S. issue, you need to provide your current O.S. level to IBM to get the appropriate fix.

Following are the iFixes need to be applied

- Note that you need to download the right ifix for your OS version and Technology level

For 5.3 -- IV10538 FILE.ATION OVERFLOW REPORTED IN ERROR WHILE LINKING LARGE" (for v5.3)
https://www-304.ibm.com/support/docview.wss?uid=isg1IV10538

For AIX 6.1 -- IV09580: FILE.ATION OVERFLOW REPORTED IN ERROR WHILE LINKING LARGE (for v6.1)
https://www-304.ibm.com/support/docview.wss?uid=isg1IV09580

For 7.1 IFIX IV09541 -- IV09541: FILE.ATION OVERFLOW REPORTED IN ERROR WHILE LINKING LARGE (for v7.1)
https://www-304.ibm.com/support/docview.wss?uid=isg1IV09541

Below are the locations of the prebuilt iFixes.

ftp://public.dhe.ibm.com/aix/efixes/<apar#>/

where the APAR numbers are:

5.3 TL11 - iv10538
5.3 TL12 - iv11158
6.1 TL4 - iv11167
6.1 TL5 - iv10576
6.1 TL6 - iv10539
6.1 TL7 - iv09580
7.1 TL0 - unaffected
7.1 TL1 - iv09541

For example:

ftp://public.dhe.ibm.com/aix/efixes/iv09541/

Note : Confirm with IBM, before applying the fixes



After installing these fixes, execute "relink all" again, verify that there is no "ld: 0711-780" in the log. You may get some "ld" warnings

ld: 0711-224
ld: 0711-345
ld: 0711-773
ld: 0711-783
ld: 0711-301
ld: 0711-415
ld: 0711-319

These warnings can be safely ignored, refer to following documents

Note 1189533.1 Relinking causes many warning on AIX
Note 245372.1 TOC overflow Warning Can Safely Be Ignored
Note 809153.1 "Relink All" On AIX Raises Many Warnings And "ld: 0706-032 Linking mode is not specified" for Liborasdk

從上面的內容不難看出，出現ORA-03113的錯誤是由於AIX作業系統的bug所致，需要將作業系統升級到AIX 6.1.7.1的版本，或者應用緊急補丁iv09580。
iv09580緊急補丁的描述：https://www-304.ibm.com/support/docview.wss?uid=isg1IV09580
iv09580緊急補丁的下載：ftp://public.dhe.ibm.com/aix/efixes/iv09580

2.使用作業系統的emgr命令應用iv09580補丁 ：

從上面的地址下載iv09580緊急補丁，執行下面的步驟應用緊急補丁。
1).緊急補丁安裝預覽命令：#emgr -p -e IV09580.epkg.Z出現INSTALL PREVIEW ,SUCCESS的情況下才能執行後面的安裝命令。

2).應用緊急補丁：#emgr -e IV09580.epkg.Z
3).查看補丁情況：mzrac1@root[/]emgr -l ID STATE LABEL INSTALL TIME UPDATED BY ABSTRACT=== ===== ========== ================= ========== ======================================1 S IV09580s01 06/27/12 21:55:58 Ifix for IV09580@6.1TL7SP1 STATE codes:S = STABLEM = MOUNTEDU = UNMOUNTEDQ = REBOOT REQUIREDB = BROKENI = INSTALLINGR = REMOVINGT = TESTEDP = PATCHEDN = NOT PATCHEDSP = STABLE + PATCHEDSN = STABLE + NOT PATCHEDQP = BOOT IMAGE MODIFIED + PATCHEDQN = BOOT IMAGE MODIFIED + NOT PATCHEDRQ = REMOVING + REBOOT REQUIRED
應用了此補丁之後，需要重新安裝Grid和Database，之後再建立資料庫。在重新安裝Grid的時候再沒出現編譯ins_rdbms.mk檔案的問題，且後來建立資料庫也非常的順利，至此問題得到最終解決！

在整個問題解決的過程中還參考了另外兩篇文章，是在AIX7.1上安裝11.2.0.3遇到跟上面描述幾乎完全相同的問題。http://blogdaprima.com/tag/11-2-0-3/
http://blogdaprima.com/tag/7-1/
以上的兩篇文章需要翻牆查看。  

更多詳情見請繼續閱讀下一頁的精彩內容：

1 2 3 4 5 下一頁