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:
This will mount the database to allow login.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.