怎樣實(shí)現(xiàn)OracleDatabaseRAC11.2.0.3forAIX6.1TL7安裝

這期內(nèi)容當(dāng)中小編將會給大家?guī)碛嘘P(guān)怎樣實(shí)現(xiàn)Oracle Database RAC 11.2.0.3 for AIX6.1TL7安裝，文章內(nèi)容豐富且以專業(yè)的角度為大家分析和敘述，閱讀完這篇文章希望大家可以有所收獲。

我們提供的服務(wù)有：成都網(wǎng)站設(shè)計(jì)、網(wǎng)站建設(shè)、微信公眾號開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、昂仁ssl等。為成百上千企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的昂仁網(wǎng)站制作公司

 在AIX平臺安裝Oracle RAC就是個坑爹的事情，今日再次驗(yàn)證了這點(diǎn)，只因?yàn)閎ug太多！記錄問題也只因?yàn)閎ug太多！強(qiáng)烈推薦及看好Oracle RAC在Linux平臺的發(fā)展。下面對問題的記錄：

>服務(wù)器：IBM Power 740

>存儲：IBM DS 5020

> 操作系統(tǒng)：

mzrac2@root[/oracle]oslevel -s

6100-07-00-0000

> Oracle Grid&Database：11.2.0.3

一.安裝過程出現(xiàn)如下問題：

1.在檢查過程中出現(xiàn)如下的告警：

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

2.安裝Grid的時候出現(xiàn)如下的報(bào)錯：

點(diǎn)擊"Retry"之后又可以順利通過。

之后安裝Database軟件的時候比較順利。

3.使用dbca創(chuàng)建數(shù)據(jù)庫的時候問題又來了，創(chuàng)建過程中始終報(bào)ORA-03113的錯誤，如下圖：

       雖然報(bào)錯，但是數(shù)據(jù)庫又能繼續(xù)創(chuàng)建，直到創(chuàng)建成功！坑爹啊，這么創(chuàng)建的數(shù)據(jù)庫誰敢用?。。。?/p>

4.core_* dump目錄及文件撐爆你的$ORACLE_HOME/dbs目錄。

        在這種情況下創(chuàng)建的數(shù)據(jù)庫會在$ORACLE_HOME/dbs目錄下生成大量的core_* dump目錄及文件，直到文件系統(tǒng)被撐爆?。?！

二.下面是排錯記錄：

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

"ld: 0711-780 SEVERE ERROR: Symbol .ksmpclrpga" and "ORA-7445 [KSMPCLRPGA()+23248]" [ID 1379908.1]

  修改時間 27-JUN-2012     類型 PROBLEM     狀態(tài) 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

       從上面的內(nèi)容不難看出，出現(xiàn)ORA-03113的錯誤是由于AIX操作系統(tǒng)的bug所致，需要將操作系統(tǒng)升級到AIX 6.1.7.1的版本，或者應(yīng)用緊急補(bǔ)丁iv09580。

iv09580緊急補(bǔ)丁的描述：https://www-304.ibm.com/support/docview.wss?uid=isg1IV09580

iv09580緊急補(bǔ)丁的下載：ftp://public.dhe.ibm.com/aix/efixes/iv09580

2.使用操作系統(tǒng)的emgr命令應(yīng)用iv09580補(bǔ)丁 ：

        從上面的地址下載iv09580緊急補(bǔ)丁，執(zhí)行下面的步驟應(yīng)用緊急補(bǔ)丁。

1).緊急補(bǔ)丁安裝預(yù)覽命令：

#emgr -p -e IV09580.epkg.Z

出現(xiàn)INSTALL PREVIEW ,SUCCESS的情況下才能執(zhí)行后面的安裝命令。

2).應(yīng)用緊急補(bǔ)?。?/p>

#emgr -e IV09580.epkg.Z

3).查看補(bǔ)丁情況：

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

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

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

上述就是小編為大家分享的怎樣實(shí)現(xiàn)Oracle Database RAC 11.2.0.3 for AIX6.1TL7安裝了，如果剛好有類似的疑惑，不妨參照上述分析進(jìn)行理解。如果想知道更多相關(guān)知識，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道。

網(wǎng)頁題目：怎樣實(shí)現(xiàn)OracleDatabaseRAC11.2.0.3forAIX6.1TL7安裝
當(dāng)前地址：http://muchs.cn/article30/ijsdso.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供營銷型網(wǎng)站建設(shè)、搜索引擎優(yōu)化、網(wǎng)站設(shè)計(jì)公司、靜態(tài)網(wǎng)站、全網(wǎng)營銷推廣、網(wǎng)站制作

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)