Login to Symantec Data Loss Prevention (DLP) Enforce with sqlplus fails with Oracle errors ORA-12514 and 12505.

Login fails with the following error:

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

You are able to login with lsnrctl status <SID> but unable to login with:

sqlplus <user>/<psswd>@<SID>
and
sqlplus <jdbc connect string>

Test to see if the database is down. Type the following at the prompt:

        sqlplus sys as sysdba

If you get a warning "cannot connect to idle instance", at the prompt type:

        startup

This will mount the database to allow login.

See also the options from Oracle for this error: https://docs.oracle.com/en/error-help/db/ora-12505/ NOTE: - non-Broadcom link