AppSync: Unable to discover Oracle database on AIX host
Summary: Re-discovery also failed with Unable to discover Oracle database. Filesystem discovery works fine.
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
New AIX client install
GUI ERROR
Application discovery was not completed successfully.
Check AppSync logs for errors, correct them and re-discover the host.
Below are the errors found in the AppSync logs:
AppSync Server Log
<DATE> 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
<Client-Host-Name>.
<DATE> 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.
<DATE> DEBUG [default task-37] [com.emc.archway.commands.application.oracle.DiscoverOracleCommandBean]
5d30882f-66c5-4989-975c-52e1f5302d12->>> Got no response from agent
<DATE> 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
<Client-Host-Name>.
AppSync Client Logs
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Connected to:
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
<DATE> 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'
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ERROR at line 1:
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-00604: error occurred at recursive SQL level 3
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-01116: error in opening database file 1
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-01110: data file 1: '/ahsprod/ctmhrprd/u02/oradata/CTMHRPRD/system01.dbf'
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-27092: size of file exceeds file size limit of the process
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Additional information: 131071
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Additional information: 384001
GUI ERROR
Application discovery was not completed successfully.
Check AppSync logs for errors, correct them and re-discover the host.
Below are the errors found in the AppSync logs:
AppSync Server Log
<DATE> 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
<Client-Host-Name>.
<DATE> 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.
<DATE> DEBUG [default task-37] [com.emc.archway.commands.application.oracle.DiscoverOracleCommandBean]
5d30882f-66c5-4989-975c-52e1f5302d12->>> Got no response from agent
<DATE> 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
<Client-Host-Name>.
AppSync Client Logs
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Connected to:
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
<DATE> 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'
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ERROR at line 1:
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-00604: error occurred at recursive SQL level 3
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-01116: error in opening database file 1
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-01110: data file 1: '/ahsprod/ctmhrprd/u02/oradata/CTMHRPRD/system01.dbf'
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > ORA-27092: size of file exceeds file size limit of the process
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Additional information: 131071
<DATE> oracle.py[4146]:_sqlQuery() SQL*plus > Additional information: 384001
Cause
Default ulimit file size to small.
Resolution
Please change /etc/security/limits file
default: fsize = 2097151 (Changed to -1)
default: fsize = 2097151 (Changed to -1)
Affected Products
AppSyncProducts
AppSyncArticle Properties
Article Number: 000168176
Article Type: Solution
Last Modified: 18 Sep 2025
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.