Autoconfig failed with invalid login

Posted by satish on May 09, 2022; 8:29am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Autoconfig-failed-with-invalid-login-tp10891.html

Dear erman,


We  have applied below patches in R12.1.3 instance. DB is 11.1.0.7

 

Latest AD patch 23569686 R12.AD.B.delta.8

Latest Autoconfig Patch 27135427 R12.TXK.B.delta.4

Latest Rapid Clone consolidated patch 27102203 OAM

 

After applying patches and while running autoconfig.

 

---------------------------------------------------------------

ADX Database Utility

---------------------------------------------------------------

 

getConnectionUsingAppsJDBCConnector() -->

APPS_JDBC_URL='jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ssshostname.ssst.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SSSEBSTR)))'

Trying to connect using APPS_JDBC_URL

Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

 

Trying to get connection using SID based connect descriptor

getConnection() -->

sDbHost : ssshostname

sDbDomain : ssst.org

sDbPort : 1521

sDbSid : SSSEBSTR

sDbUser : APPS

Trying to connect using SID...

getConnectionUsingSID() -->

JDBC URL: jdbc:oracle:thin:@ssshostname.ssst.org:1521:SSSEBSTR

Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

 

Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ssshostname.ssst.org)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SSSEBSTR)))

Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

 

Trying to connect using SID as ServiceName.DomainName

getConnectionUsingServiceName() -->

JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ssshostname.ssst.org)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SSSEBSTR.ssst.org)))

Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

 

Connection could not be obtained; returning null

 

-------------------ADX Database Utility Finished---------------

 

Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database

 

 

StackTrace:

java.sql.SQLException: Could not get connection to the database

at oracle.apps.ad.tools.configuration.CVMHelper.processNewContextFile(CVMHelper.java:935)

at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1825)

at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1620)

at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763)

 


Apps Jdbc url poiting to : (ADDRESS=(PROTOCOL=tcp)(HOST=ssshostname.ssst.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SSSEBSTR) connection sting.

 

1)checked service name : SERVICE_NAME=SSSEBSTR is running in DB node and accepting connections.

 

SSSEBSTR is running on dbnode. We are able to connect with apps user to db from apps and db node.

 
Database service and listener is working fine.

 

And once again restarted listener and retested the issue. Still, we are getting the same error

 

[oracrp@ssshostname ~]$ lsnrctl status SSSEBSTR

 

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 06-MAY-2022 11:38:12

 

Copyright (c) 1991, 2008, Oracle. All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ssshostname.ssst.org)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias SSSEBSTR

Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production

Start Date 06-MAY-2022 11:29:58

Uptime 0 days 0 hr. 8 min. 14 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u02/TEST/db/tech_st/11.1.0/network/admin/SSSEBSTR_ssshostname/listener.ora

Listener Log File /u02/TEST/db/tech_st/11.1.0/admin/SSSEBSTR_ssshostname/diag/tnslsnr/ssshostname/sssebstr/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ssshostname.SSST.ORG)(PORT=1521)))

Services Summary...

Service "SSSEBSTR" has 2 instance(s).

Instance "SSSEBSTR", status UNKNOWN, has 1 handler(s) for this service...

Instance "SSSEBSTR", status READY, has 1 handler(s) for this service...

Service "SSSEBSTR_XPT" has 1 instance(s).

Instance "SSSEBSTR", status READY, has 1 handler(s) for this service...

The command completed successfully



[oracrp@ssshostname ~]$ sqlplus apps/******@SSSEBSTR

 

SQL*Plus: Release 11.1.0.7.0 - Production on Fri May 6 11:38:56 2022



Any suggestions please

=====-----=====-----=====