#sqlplus

Oracle "ORA-12514: listener does not currently know of service": check the name, then the registration

Fix Oracle ORA-12514: list the services the listener knows, use the right service name, open the PDB, register the database with the listener, and fix LOCAL_LISTENER.

Intermediate · 3 min read

ORA-01017

Databases

Oracle "ORA-01017: invalid username/password; logon denied": the real causes

Fix Oracle ORA-01017 "invalid username/password": case-sensitive passwords, the wrong service or PDB, expired and locked accounts, old clients, and getting in as SYSDBA.

Beginner · 4 min read

ORA-12154

Databases

Oracle "ORA-12154: TNS:could not resolve the connect identifier specified": how to fix it

Fix Oracle ORA-12154: the client can't find your connect identifier. Check tnsnames.ora, TNS_ADMIN and sqlnet.ora, an @ in the password, or use Easy Connect.

Intermediate · 4 min read