Grid Infrastructure Post Upgrade Steps Fails with INS-20802 and DBT-00007 (文档 ID 2469221.1)

admin管理员组

文章数量:1627760

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

SYMPTOMS

Grid Infrastructure upgrade from 11.2.0.4 to 12.2.0.1 fails at post upgrade steps when dbca creates the Grid Infrastructure Management Repository (GIMR) with below error from OUI:

[INS-20802] creating container database for Oracle Grid Infrastructure Management Repository Failed

gridSetupActions<timesatamp>.log inside <central inventory>/logs have the following errors:

INFO:  [Oct 26, 2018 5:41:19 PM] Command /u01/12.2.0.1/grid/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName DATA -datafileJarLocation /u01/12.2.0.1/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck -oui_internal 
INFO:  [Oct 26, 2018 5:41:19 PM] ... GenericInternalPlugIn.handleProcess() entered.
INFO:  [Oct 26, 2018 5:41:19 PM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO:  [Oct 26, 2018 5:41:19 PM] ... GenericInternalPlugIn: checking secretArguments.
INFO:  [Oct 26, 2018 5:41:19 PM] No arguments to pass to stdin
INFO:  [Oct 26, 2018 5:41:19 PM] ... GenericInternalPlugIn: starting read loop.
INFO:  [Oct 26, 2018 5:41:23 PM] Read: [FATAL] [DBT-00007] User does not have the appropiate write privileges.
..
..

INFO:  [Oct 26, 2018 5:41:23 PM] Read:        - [DBT-00007] User does not have the appropiate write privileges.
INFO:  [Oct 26, 2018 5:41:23 PM]        - [DBT-00007] User does not have the appropiate write privileges.
WARNING:  [Oct 26, 2018 5:41:23 PM] Skipping line:        - [DBT-00007] User does not have the appropiate write privileges.
INFO:  [Oct 26, 2018 5:41:23 PM] Completed Plugin named: Creating Container Database for Oracle Grid Infrastructure Management Repository
INFO:  [Oct 26, 2018 5:43:25 PM] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.
INFO:  [Oct 26, 2018 5:43:25 PM] Creating Container Database for Oracle Grid Infrastructure Management Repository failed.

..
..
INFO:  [Oct 26, 2018 5:44:02 PM] ... GenericInternalPlugIn: starting read loop.
INFO:  [Oct 26, 2018 5:44:04 PM] Read: MGTCA-1105 : Grid Infrastructure Management Repository is not running in the cluster.
INFO:  [Oct 26, 2018 5:44:04 PM] MGTCA-1105 : Grid Infrastructure Management Repository is not running in the cluster.
INFO:  [Oct 26, 2018 5:44:04 PM] Completed Plugin named: GIMR Configuration Assistant
INFO:  [Oct 26, 2018 5:44:55 PM] GIMR Configuration Assistant failed.

CAUSE

Grid Infrastructure (GI) home user not have permission to write to $ORACLE_BASE/cfgtoollogs/dbca directory and $ORACLE_BASE/cfgtoollogs/dbca owned by database home user (oracle).

Here the  GI user is grid .

$ id -a grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper)

$ echo $ORACLE_BASE

/u01/app/grid

$ ls -la $ORACLE_BASE/cfgtoollogs
drwxr-x---. 3 oracle oinstall 4096 Oct 8 17:19 dbca

SOLUTION

Change $ORACLE_BASE/cfgtoollogs/dbca folder ownership to GI user (in the given example, 'grid' user) and retry the post upgrade steps at OUI.

$ ls -la $ORACLE_BASE/cfgtoollogs
drwxr-x---. 3 grid oinstall 4096 Oct 8 17:19 dbca

本文标签： 文档upgradefailsstepsgrid