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

book

Article ID: 160113

calendar_today

Updated On:

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.