[PCA 3.x] Unable ssh Admin CLI Interface due to MySQL Credential Out of Sync (Doc ID 2859723.1)

Last updated on APRIL 07, 2022

Applies to:

Symptoms

In the stage of Pre-day0, found ssh access to the admin service failed, along with many pods restart repeatedly.

[root@pcamn01 ~]# ssh admin@pcamn01 -p 30006
ssh: connect to host pcamn01 port 30006: Connection refused 

The admin pod logs shows database server connection errors:

[root@pcamn01 ~]# kubectl exec -it admin-6dfd6cddf9-rdspq -c admin -- cat /var/log/admin/admin.log.0
23-Mar-2022 06:49:42.916 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Started initializing AdminService.
***Exception connecting to DB: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
***DB is not initialized, set to bad health.
Exception creating admin lock object: PCA_GENERAL_000001: An exception occurred during processing: Failed to connect to the database.Could not create connection to database server. Attempted reconnect 3 times. Giving up.
***Exception connecting to DB: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
***DB is not initialized, set to bad health.
***Exception connecting to DB: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
***DB is not initialized, set to bad health.
23-Mar-2022 06:49:55.976 SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [com.oracle.pca.AdminService]
com.oracle.pca.middle.exception.OmsException: PCA_GENERAL_000001: An exception occurred during processing: Failed to connect to the database.Could not create connection to database server. Attempted reconnect 3 times. Giving up

Cause

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