Oracle Database Discovery on Unix does not discover databases configured with TCPS protocol (port 2484)<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Issue The Oracle DB Unix discovery pattern does not discover databases that are configured exclusively with TCPS (SSL) protocol in tnsnames.ora. Only databases with TCP protocol entries are discovered. Symptoms Some Oracle databases are not appearing in Discovery results despite being active on the hostMissing databases use TCPS (port 2484) in tnsnames.ora instead of TCP (port 1521)Discovery payload shows fewer databases than expectedNo errors in Discovery logs — databases are silently skipped Cause The Oracle DB Unix discovery pattern enumerates databases using four methods: ps -ef | grep ora_pmon_ for running instancestnsnames.ora parsinglsnrctl statusspfile/init.ora discovery The tnsnames.ora parser only processes TCP protocol entries. TCPS entries (SSL, port 2484) are not supported and are silently ignored by the parser. Additionally, databases may be filtered if: The ora_pmon process is not running (offline databases)spfile or init.ora is not in the standard ${ORACLE_HOME}/dbs/ directory Resolution Verify which databases are missing by running on the host: ps -ef | grep ora_pmon_Check tnsnames.ora for the missing databases — if they use PROTOCOL = TCPS, this is expected behavior.As a workaround, add a TCP protocol entry alongside the TCPS entry in tnsnames.ora for each affected database. Discovery will use the TCP entry for enumeration while the application continues to use TCPS.Verify spfile or init.ora exists in the standard ${ORACLE_HOME}/dbs/ path for each missing database.If databases are offline (no ora_pmon process), they will not be discovered by design — only running instances are enumerated.