ORA error

ORA-12514

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Quick fix

Cause: The listener is running, but no instance has registered the SERVICE_NAME used in the connect string: the database is down or not yet registered, the service name is wrong (for example missing the DB_DOMAIN suffix), or the instance registers with a different listener.
Fix: Run lsnrctl status and compare the services listed with SERVICE_NAME in tnsnames.ora. Use the full name including the domain, or register the instance: check LOCAL_LISTENER and run ALTER SYSTEM REGISTER. For a database in MOUNT/NOMOUNT (e.g. a standby) add a static SID_LIST entry.

lsnrctl status
sqlplus / as sysdba
SHOW PARAMETER service_names
SHOW PARAMETER local_listener
ALTER SYSTEM REGISTER;

Where it comes up

Oracle Data Guard Configuration on Oracle Linux 7.8 & Database 19c

The db_domain parameter is set to bracecoder, so the full service name includes the domain suffix. If you use just oradb without the domain, tnsping may succeed but sqlplus connections may fail with ORA-12514.

Database

Related error codes

All error codes Search articles for ORA-12514