知识库文章：000531480

 

AppSync：无法在 AIX 主机上发现 Oracle 数据库 (000531480)

 

主要产品：AppSync 产品：AppSync、AppSync 3.8

 

版本：3          文章类型：中断修复

 

目标受众：级别 30 = 客户

 

上次发布时间：2019 年 7 月 18 日星期四 09:39:20

（格林威治标准时间）

 

摘要：            重新发现也失败，无法发现 Oracle 数据库。

文件系统发现正常运行。

 

问题：      GUI 错误

应用程序发现未成功完成。

检查 AppSync 日志是否存在错误、纠正这些错误并重新发现主机。 以下是 AppSync 日志中发现的错误：

AppSync 服务器日志

INFO [default task-37] [com.emc.archway.service.eventservice.EventServiceBean] 5d30882f-66c5-4989-975c-52e1f5302d12->>> EVENT [GENL_000055]:

An error occurred while running getInitfileParameters on host

.

     INFO [default task-37] [com.emc.archway.service.eventservice.EventServiceBean] 5d30882f-66c5-4989-975c-52e1f5302d12->>> EVENT [GENL_000023]:

An error occurred while communicating with the AppSync Host Plug-in.

Check to see if agent service is running, and restart if necessary.

     DEBUG [default task-37] [com.emc.archway.commands.application.oracle. DiscoverOracleCommandBean]

5d30882f-66c5-4989-975c-52e1f5302d12->>> Got no response from agent

 

ERROR [default task-37] [com.emc.archway.commands.application. DiscoverApplicationsCommandBean]

5d30882f-66c5-4989-975c-52e1f5302d12->>> Exception Occurred: EmptyResponseFromAgentException, Message: An error occurred while running getInitfileParameters on host

.

 

AppSync 客户端日志

oracle.py[4146]:_sqlQuery() SQL*plus > Connected to:

oracle.py[4146]:_sqlQuery() SQL*plus > Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

     oracle.py[4146]:_sqlQuery() SQL*plus > With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

oracle.py[4146]:_sqlQuery() SQL*plus > SQL> SQL> SQL> SQL> SQL>

select 'AppSync_entry:'|| name||'////'|| value from v$spparameter where ISSPECIFIED='TRUE'

and name not like 'instance_mode' and     name not like 'INSTANCE_MODE'

oracle.py[4146]:_sqlQuery() SQL*plus > ERROR at line 1:

oracle.py[4146]:_sqlQuery() SQL*plus > ORA-00604: error occurred at recursive SQL level 3

oracle.py[4146]:_sqlQuery() SQL*plus > ORA-01116: error in opening database file 1

oracle.py[4146]:_sqlQuery() SQL*plus > ORA-01110: data file 1: '/ahsprod/ctmhrprd/u02/oradata/CTMHRPRD/system01.dbf'

oracle.py[4146]:_sqlQuery() SQL*plus > ORA-27092: size of file exceeds file size limit of the process

oracle.py[4146]:_sqlQuery() SQL*plus > Additional information: 131071

oracle.py[4146]:_sqlQuery() SQL*plus > Additional information: 384001

 

原因：      默认 ulimit 文件大小为小。

 

变更：      新 AIX 客户端安装

 

解决方法：    请更改 /etc/security/limits 文件

default:       fsize = 2097151            (Changed to -1)

 

 

主要产品：

 

AppSync

 

产品：       AppSync、AppSync 3.8