开启辅助访问

Bo's Oracle Station

Bo's Oracle Station › 博客首页 ›Oracle技术› Grid Control › 查看内容

【博客文章2023】Clould Control 13c的资料档案库字符集问题导致无法安装成功的可重试解决方案

2023-4-29 23:21| 发布者: admin| 查看: 95| 评论: 0|原作者: Bo Tang

摘要: Clould Control 13c的资料档案库字符集问题无法安装的可重试解决方案。在不重新启动Cloud Control安装的情况下，在安装进程的52%和54%时，本博客中连续处理了2个故障。
Clould Control 13c的资料档案库字符集问题导致无法安装成功的可重试解决方案

Author: Bo Tang

1. 故障描述：

  Cloud Control 13.5在安装到52%时发生错误，详细的遇到问题的安装过程如下：


2. 故障分析：


    分析安装过程中产生的日志/u01/app/oracle/product/13.5.0/middleware/cfgtoollogs/cfgfw/oracle.sysman.top.oms_2023-04-26_10-21-46-AM.log：


......
INFO: oracle.sysman.top.oms:Starting both repos upgrade and transx loading in parallel
INFO: oracle.sysman.top.oms:EMSCHEMA MANAGER: create oracle.sysman.emdrep.schemamanager.EMSchemaManager@7d38cfe
INFO: oracle.sysman.top.oms:create_process_id:d7wx3ukaj3nq
INFO: oracle.sysman.top.oms:The command run for transx is /u01/app/oracle/product/13.5.0/middleware/sysman/admin/emdrep/bin/RepManager -connect
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTO
COL=TCP)(HOST=cc.example.com)(PORT=1521)))(CONNECT_DATA=(SID=emrep))) -action transx  -repos_user SYSMAN -dbUser SYS -mwHome 
/u01/app/oracle/product/13.5.0/middleware -mwOraHome /u01/app
/oracle/product/13.5.0/middleware
INFO: oracle.sysman.top.oms:processing arguments
INFO: oracle.sysman.top.oms:compiling arguments for validation
INFO: oracle.sysman.top.oms:stty: 'standard input': Inappropriate ioctl for device
INFO: oracle.sysman.top.oms:stty: 'standard input': Inappropriate ioctl for device
INFO: oracle.sysman.top.oms: Enter SYSMAN user password   :
INFO: oracle.sysman.top.oms:stty: 'standard input': Inappropriate ioctl for device
INFO: oracle.sysman.top.oms:stty: 'standard input': Inappropriate ioctl for device
INFO: oracle.sysman.top.oms:Verify :
INFO: oracle.sysman.top.oms:Enter password for: SYSMAN
INFO: oracle.sysman.top.oms:^H ^Hprocess_id:ccehg8hixk1l
INFO: oracle.sysman.top.oms:[Initializing the EM RCU Runner, Failed Parameter Validation]
INFO: oracle.sysman.top.oms:File copied :: /u01/app/oracle/product/13.5.0/middleware/sysman/log/schemamanager/latest/emschema.log.TRANSX.lck
INFO: oracle.sysman.top.oms:File copied :: /u01/app/oracle/product/13.5.0/middleware/sysman/log/schemamanager/latest/emschema.log.TRANSX
INFO: oracle.sysman.top.oms:The transx command execution completed with the status 255.
INFO: oracle.sysman.top.oms:transx_retCode:255
INFO: oracle.sysman.top.oms:The transx action failed. Execute RepManager with -action transx.
INFO: oracle.sysman.top.oms:process_id:d7wx3ukaj3nq
INFO: oracle.sysman.top.oms:Failure...
INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action:
INFO: oracle.sysman.top.oms:1):
Exception was thrown.  Any Stack Trace?
 Non supported character set (add orai18n.jar in your classpath): ZHS16GBK

INFO: oracle.sysman.top.oms:The plug-in Repository Configuration has failed its perform method
INFO: oracle.sysman.top.oms:About to execute plug-in Repository Configuration
INFO: oracle.sysman.top.oms:The plug-in Repository Configuration is running
INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.RepositoryConfiguration
INFO: oracle.sysman.top.oms:Classpath = /u01/app/oracle/product/13.5.0/middleware/sysman/jlib/emConfig.jar:/u01/app/oracle/product/13.5.0/middleware/sysman
/jlib/emprereqkit.jar:/u01/app/
oracle/product/13.5.0/middleware/sysman/jlib/omsConfig.jar:/u01/app/oracle/product/13.5.0/middleware/oracle_common/modules/oracle.owasp/com-bea-core-apache-log4j.jar:
/u01/app/oracle/prod
uct/13.5.0/middleware/jlib/emConfigInstall.jar:/u01/app/oracle/product/13.5.0/middleware/sysman/jlib/emagentSDK.jar:/u01/app/oracle/product/13.5.0/middleware/
oracle_common/modules/oracle
.jdbc/ojdbc8dms.jar:/u01/app/oracle/product/13.5.0/middleware/oracle_common/jlib/rcu.jar:/u01/app/oracle/product/13.5.0/middleware/oracle_common/jlib
/rcucommon.jar:/u01/app/oracle/produc
t/13.5.0/middleware/sysman/jlib/emCORE.jar:/u01/app/oracle/product/13.5.0/middleware/sysman/jlib/emcore_client.jar:/u01/app/oracle/product/13.5.0/
middleware/oracle_common/modules/oracle.
dms/dms.jar:/u01/app/oracle/product/13.5.0/middleware/oracle_common/modules/oracle.odl/ojdl.jar:/u01/app/oracle/product/13.5.0/middleware/
oracle_common/modules/oracle.xdk/xmlparserv2.jar
:/u01/app/oracle/product/13.5.0/middleware/oracle_common/modules/oracle.jdbc/ojdbc8.jar
INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration  invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=2:microstep=0
INFO: oracle.sysman.top.oms:Inside perform method
INFO: oracle.sysman.top.oms:JUSTCHECK: Is_oneWaySSL has got a default value
INFO: oracle.sysman.top.oms:JUSTCHECK: Is_twoWaySSL has got a default value
INFO: oracle.sysman.top.oms:JUSTCHECK: b_upgrade131to132 has got a default value
INFO: oracle.sysman.top.oms:JUSTCHECK: b_stackUpgrade has got a default value
INFO: oracle.sysman.top.oms:Running the schema action . . .
INFO: oracle.sysman.top.oms:Setting required properties
INFO: oracle.sysman.top.oms:REPOS_USER: SYSMAN
INFO: oracle.sysman.top.oms:SYS_USER: SYS
INFO: oracle.sysman.top.oms:CONNECT_STRING: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=cc.example.com)(PORT=1521)))(CONNECT_DATA=(SID=emrep)))
INFO: oracle.sysman.top.oms:ORACLE_HOME: /u01/app/oracle/product/13.5.0/middleware
INFO: oracle.sysman.top.oms:mgmtTabLoc :
INFO: oracle.sysman.top.oms:confDataTabLoc :
INFO: oracle.sysman.top.oms:defaultDataFileLoc :
......


    日志中的“INFO: oracle.sysman.top.oms:The transx action failed. Execute RepManager with -action transx.”说明是创建资料档案库出错，具体的出错原因是“Non supported character set (add orai18n.jar in your classpath): ZHS16GBK”。这说明是资料档案库所在的数据库的字符集不被支持，而这个情况在Cloud Control安装的先决条件检查时并没有提前报错。

3. 解决办法：

    既然存在“重试”按钮能够解决问题，就不要取消安装。我们首先更改资料档案库所在的数据库的字符集为AL3UTF8：

[oracle@cc ~]$ . oraenv
ORACLE_SID = [oracle] ? emrep
The Oracle base has been set to /u01/app/oracle
[oracle@cc ~]$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 30 08:19:32 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount  restrict  
ORACLE instance started.
Total System Global Area 5083494680 bytes
Fixed Size     8907032 bytes
Variable Size  1090519040 bytes
Database Buffers  3976200192 bytes
Redo Buffers     7868416 bytes
Database mounted.
SQL> alter database open；
Database altered.
SQL> alter database character set internal_use AL32UTF8;
Database altered.
SQL> alter system  disable restricted session;
System altered.

  

4. 再次故障描述：

    点击“重试“”后，Cloud Control 13.5在安装到54%时又发生错误，详细的创建资料档案库的日志在/u01/app/oracle/product/13.5.0/middleware/sysman/log/schemamanager/latest/emschema.log.TRANSX：

SEVERE: Failed Parameter Validation
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.EMSchemaLogger error
SEVERE: NULL Exception was thrown!
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.EMSchemaLogger error
SEVERE: Failed Parameter Validation
                                                              848,1         Bot
Apr 30, 2023 5:36:20 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: executing: SELECT count(*) FROM all_objects WHERE object_name='MGMT_MESSAGES_IDX_01' AND owner='SYSMAN'
Apr 30, 2023 5:36:20 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: false on try: 190
Apr 30, 2023 5:36:26 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: true on try: 191
Apr 30, 2023 5:36:32 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: repos connection is not null, using old one
Apr 30, 2023 5:36:32 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: executing: SELECT count(*) FROM all_objects WHERE object_name='MGMT_MESSAGES_IDX_01' AND owner='SYSMAN'
Apr 30, 2023 5:36:32 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: false on try: 192
Apr 30, 2023 5:36:38 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: true on try: 193
Apr 30, 2023 5:36:44 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: repos connection is not null, using old one
Apr 30, 2023 5:36:44 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: executing: SELECT count(*) FROM all_objects WHERE object_name='MGMT_MESSAGES_IDX_01' AND owner='SYSMAN'
Apr 30, 2023 5:36:44 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: false on try: 194
Apr 30, 2023 5:36:50 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: true on try: 195
Apr 30, 2023 5:36:56 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: repos connection is not null, using old one
Apr 30, 2023 5:36:56 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: executing: SELECT count(*) FROM all_objects WHERE object_name='MGMT_MESSAGES_IDX_01' AND owner='SYSMAN'
Apr 30, 2023 5:36:56 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: false on try: 196
Apr 30, 2023 5:37:02 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: true on try: 197
Apr 30, 2023 5:37:08 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: repos connection is not null, using old one
Apr 30, 2023 5:37:08 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: executing: SELECT count(*) FROM all_objects WHERE object_name='MGMT_MESSAGES_IDX_01' AND owner='SYSMAN'
Apr 30, 2023 5:37:08 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: false on try: 198
Apr 30, 2023 5:37:14 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: index on mgmt_messages found: true on try: 199
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: not found index on mgmt_messages
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: error: not found index on mgmt_messages for transx repos user exists: true mgmt_messages exists: true; index on mgmt_messages exist: false; found connection for repos user: true
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.EMSchemaLogger error
SEVERE: Failed Parameter Validation
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.EMSchemaLogger error
SEVERE: NULL Exception was thrown!
Apr 30, 2023 5:37:20 AM oracle.sysman.emdrep.schemamanager.EMSchemaLogger error
SEVERE: Failed Parameter Validation


    说明是一些Cloud Control用户的会话已经存在造成的。

5. 解决办法：

   不要取消安装。删除数据库中的以下5个用户：

[oracle@cc ~]$ . oraenv
ORACLE_SID = [oracle] ? emrep
The Oracle base has been set to /u01/app/oracle
[oracle@cc ~]$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 30 08:19:32 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> drop user sysman cascade; 
User dropped.
SQL> drop user CLOUD_ENGINE_USER cascade; 
User dropped.
SQL> drop user CLOUD_SWLIB_USER cascade; 
User dropped.
SQL> drop user SYSMAN_RO cascade; 
User dropped.
SQL> drop user SYSMAN_TYPES cascade; 
User dropped.

  


   点击“重试”，最后会安装成功：


路过
雷人
握手
1

鲜花
鸡蛋

刚表态过的朋友 (1 人)

收藏 邀请
上一篇：【博客文章2022】Clould Control 12c无法挑选到主机进行Dataguard备库添加的解决方案

相关分类

QQ|手机版|Bo's Oracle Station   

GMT+8, 2023-5-1 09:19 , Processed in 0.053604 second(s), 21 queries .

返回顶部