Shulou(Shulou.com)06/01 Report--

This issue of the content of the editor will bring you about how to achieve Oracle Database RAC 11.2.0.3 for AIX6.1TL7 installation, the article is rich in content and professional analysis and description for you, I hope you can get something after reading this article.

Installing Oracle RAC on the AIX platform is a hoax, which has been verified again today, just because there are too many bug! Record problems only because there are too many bug! Strongly recommend and value the development of Oracle RAC in the Linux platform. The following is a record of the problem:

> server: IBM Power 740

> Storage: IBM DS 5020

> operating system:

Mzrac2@ root [/ oracle] oslevel-s

6100-07-00-0000

> Oracle Grid&Database:11.2.0.3

one。 The following problems occurred during the installation process:

1. The following alarm appears during the inspection:

After checking, these two patches are not needed on AIX6.1TL7, so they can be ignored directly.

two。 The following error occurred while installing Grid:

Click "Retry" and then pass smoothly.

After that, the installation of Database software went smoothly.

3. There is another problem when using dbca to create a database. An error in ORA-03113 is always reported during the creation process, as shown below:

Although the error is reported, the database can continue to be created until it is successfully created! Bullshit, who dares to use the database created like this!

4. Create * dump directory and files to burst your $ORACLE_HOME/dbs directory.

The database created in this case will generate a large number of core_* dump directories and files in the $ORACLE_HOME/dbs directory until the file system is burst!

two。 The following is the troubleshooting record:

1. Find the following article on METALINK that illustrates ORA-03113 's error:

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

Modification time 27-JUN-2012 type PROBLEM status 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.1SP3 (7100.00.03.1115), TL 1 (7100-01-01-1141) and above

Fail with following relink errors:

Ld: 0711-783WARNING: 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: Redtoc; 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: Redtoc; 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: Redtoc; 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: Redtoc; 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: Redtoc; 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: Redtoc; 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: Redtoc; 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. KSMPF PVA 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.1IFIX 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//

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

It is not difficult to see from the above that the ORA-03113 error is caused by the bug of the AIX operating system, and you need to upgrade the operating system to version 6.1.7.1 of AIX, or apply the emergency patch iv09580.

Description of iv09580 emergency patch: https://www-304.ibm.com/support/docview.wss?uid=isg1IV09580

Download the emergency patch for iv09580: ftp://public.dhe.ibm.com/aix/efixes/iv09580

two。 Use the operating system's emgr command to apply the iv09580 patch:

Download the iv09580 emergency patch from the address above and perform the steps below to apply the emergency patch.

1)。 Emergency patch installation preview command:

# emgr-p-e IV09580.epkg.Z

The following installation commands can only be executed in the case of INSTALL PREVIEW or SUCCESS.

2)。 Apply emergency patches:

# emgr-e IV09580.epkg.Z

3)。 Check the patch status:

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

After applying this patch, you need to reinstall Grid and Database before creating the database. When reinstalling Grid, there was no problem of compiling ins_rdbms.mk files, and later the creation of the database was very smooth, so the problem was finally solved!

Two other articles were referenced throughout the problem resolution process, where installation 11.2.0.3 on AIX7.1 encountered almost exactly the same problem as described above.

The above is the editor for you to share how to achieve Oracle Database RAC 11.2.0.3 for AIX6.1TL7 installation, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.