怎樣實現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 -s

6100-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目錄及文件，直到文件系統被撐爆！！！

二.下面是排錯記錄：

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 channel

Changes

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 = STABLE

 M = MOUNTED

 U = UNMOUNTED

 Q = REBOOT REQUIRED

 B = BROKEN

 I = INSTALLING

 R = REMOVING

 T = TESTED

 P = PATCHED

 N = NOT PATCHED

 SP = STABLE + PATCHED

 SN = STABLE + NOT PATCHED

 QP = BOOT IMAGE MODIFIED + PATCHED

 QN = BOOT IMAGE MODIFIED + NOT PATCHED

 RQ = REMOVING + REBOOT REQUIRED

         應用了此補丁之后，需要重新安裝Grid和Database，之后再創建數據庫。在重新安裝Grid的時候再沒出現編譯ins_rdbms.mk文件的問題，且后來創建數據庫也非常的順利，至此問題得到最終解決！

       在整個問題解決的過程中還參考了另外兩篇文章，是在AIX7.1上安裝11.2.0.3遇到跟上面描述幾乎完全相同的問題。

上述就是小編為大家分享的怎樣實現Oracle Database RAC 11.2.0.3 for AIX6.1TL7安裝了，如果剛好有類似的疑惑，不妨參照上述分析進行理解。如果想知道更多相關知識，歡迎關注億速云行業資訊頻道。