Unable to apply roll up patches as DB screen is giving error "Cannot connect to Oracle server".

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Issue:

Unable to apply roll-up patches on 17.3 with Oracle as DB as getting the error "Cannot connect to Oracle server. Check the details provided" and in install.log gives ERROR [AWT-EventQueue-0] [MDBValidator] SU2048

Environment

Release : 17.3

Component : SDM - Install/Upgrade/Configuration

Resolution

The current problem occurs while validating the connection via the Oracle JDBC driver.  Need to validate Oracle connectivity as per below KB's "https://knowledge.broadcom.com/external/article/106561/how-to-test-jdbc-connection-to-an-oracle.html"/ "https://knowledge.broadcom.com/external/article/221075/testing-oracle-jdbc-connection-with-jdbc.html".

If the test is not successful then this needs to be solved by Oracle DBA, once it's solved and the connection is successful can proceed with patch installation.