签到成功

知道了

CNDBA社区CNDBA社区

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

2022-01-09 22:27 1392 0 原创 oracle
作者: hbhe0316

Rehdat 8.5安装oracle 19.3 grid的时候遇到问题INS-20802,
MOS解决如下:
APPLIES TO:http://www.cndba.cn/hbhe0316/article/103918

http://www.cndba.cn/hbhe0316/article/103918
http://www.cndba.cn/hbhe0316/article/103918

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 <GRID_HOME>/bin/dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName DATA -datafileJarLocation <GRID_HOME>/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.

CHANGEShttp://www.cndba.cn/hbhe0316/article/103918

http://www.cndba.cn/hbhe0316/article/103918
http://www.cndba.cn/hbhe0316/article/103918

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).

http://www.cndba.cn/hbhe0316/article/103918
http://www.cndba.cn/hbhe0316/article/103918

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

<ORACLE_BASE>
$ 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.

http://www.cndba.cn/hbhe0316/article/103918
http://www.cndba.cn/hbhe0316/article/103918

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

版权声明:本文为博主原创文章,未经博主允许不得转载。

Linux,oracle

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知,才能装下新的东西; 2.进步来自一点点滴滴的积累; 3.广博让你更优秀,而专业让你无法替代; 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问:1039996次
  • 积分:1523
  • 等级:核心会员
  • 排名:第6名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ