My Oracle Support Banner

E-Business Suite Applications Management Plugin Installation And Deployment Of The AMP Plugin Locks The APPS Daily With Error 'ORA-01017: invalid username/password; logon denied' For Method txkGetDBParameter (Doc ID 2354387.1)

Last updated on OCTOBER 02, 2020

Applies to:

Application Management Pack for Oracle E-Business Suite - Version and later
Information in this document applies to any platform.


E-Business Suite Applications Management Plugin (AMP), Installation Issues

 After deploying AMP plugin, the APPS account gets locked daily with the following error:

'ORA-01017: invalid username/password; logon denied'

The following entries are reported in the audit trail:

Nov 10 15:00:00  journal: Oracle Audit[22]: LENGTH: "34" SESSIONID:[9] "2000000" ENTRYID:[1] "1" STATEMENT:[1] "1" USERID:[4] "APPS" USERHOST:[23] "host.domain" TERMINAL:[7] "unknown" ACTION:[3] "100" RETURNCODE:[4] "1017" COMMENT$TEXT:[99] "Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=" OS$USERID:[6] "oracle" DBID:[10] "200000"

Checking the /<directory path>/log/ebs_inventory.log:

TXK:Validate:ProcessActions: Executing action method - txkGetDBParameter
Error invoking : *******FATAL ERROR*******
PROGRAM : /<directory path>/<SID>/appsutil/bin/<directory path>/<SID>/appsutil/bin/
TIME : Tue Nov 10 20:00:00 2017
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
Invalid Connect string - cannot connect to database
ORA-01017: invalid username/password; logon denied

at /<directory path>/<SID>/appsutil/perl/TXK/ line 167
TXK::Error::abort('TXK::Error', 'HASH(0x4a3fd10)') called at /<directory path>/<SID>/appsutil/perl/TXK/ line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x4854c50)', 'Invalid Connect string - cannot connect to database\x{a}ERROR:\x{a}OR...', undef) called at /<directory path>/<SID>/appsutil/perl/TXK/ line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x4854c50)', 'Invalid Connect string - cannot connect to database\x{a}ERROR:\x{a}OR...') called at /<directory path>/<SID>/appsutil/perl/TXK/ line 741

The issue can be reproduced at will with the following steps:
1. Installed AMP plugin.
2. Confirm the apps account gets locked




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.