Follow this structured approach. Perform the checks to isolate the failure point.
Check if the database has reached max_connections :
The error code is a generic connectivity error typically associated with Java Database Connectivity (JDBC). It indicates that the application attempting to access the database failed to establish a link to the database server. Follow this structured approach
Typos in the hostname, incorrect database instance names, or a change in standard port numbers (such as switching from a non-SSL port to an SSL encrypted port). The Fix: Log into Cognos Analytics with administrative privileges.
javax.net.ssl.SSLHandshakeException (Indicates a certificate mismatch or missing truststore). It indicates that the application attempting to access
(Or use Test-NetConnection -ComputerName 192.168.1.50 -Port 1433 in Windows PowerShell) .
: For users with non-English locale settings (such as those using OpenPages), the connection may fail because the engine cannot correctly parse session-level parameters. : Check the IBM Support Guide for OpenPages to adjust locale settings for impacted users. Connection String and Ports incorrect database instance names
: Open a command prompt on the Cognos server and ping the database server IP.
For Windows servers, use PowerShell: Test-NetConnection -ComputerName [DB_Host] -Port [DB_Port] For Linux environments: nc -zv [DB_Host] [DB_Port] Step-by-Step Diagnostic Framework
If you are still experiencing issues, sharing the specific JDBC driver version you are using or the full error log, I can provide a more tailored solution.
jdbc:oracle:thin:@hostname:1521/service_name