[node-oracledb-v6.3.0] SSL connection with .pem file

[AshwamedhPB]

Hi Team,

I am trying to make a secure SSL connection to the Oracle DB instance in thick mode with the below configuration

{
    ssl: { ca: '...' },
    connectString: '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=TEMP)(PORT=5500))(CONNECT_DATA=(SERVICE_NAME=ORASSL))(security=(SSL_SERVER_DN_MATCH=NO)))',
    connectTimeout: 60000,
    requestTimeout: 300000,
    ...rest,
}

I always get error "ORA-29024: Certificate validation failure" even if I am passing a valid cert.pem file.

Do I need to pass the .pem file differently or need some additional configuration to make this work?

Thanks in advance.

[AshwamedhPB]

We are trying to connect to on-prem oracledb is it all possible to connect to on-prem, the documents have details about could but onprem details are missing

https://node-oracledb.readthedocs.io/en/latest/user_guide/connection_handling.html#one-way-tls-connection-to-oracle-autonomous-database