Error: "ORA-12514" or "ORA-12505"

Products

• Data Loss Prevention Enforce

Issue/Introduction

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

Cause

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

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

Resolution

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