Tags
#oracle
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
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
Oracle "ORA-12541: no listener": start it, or connect to the address it really uses
Fix Oracle ORA-12541 "TNS:no listener" (or "Cannot connect. No listener at host"): start it with lsnrctl, check the host and port, listener.ora, firewalls and Docker.
Beginner · 4 min read
Oracle "ORA-00942: table or view does not exist": when the table is right there
Fix Oracle ORA-00942 "table or view does not exist": the table may exist. Check the schema, your privileges, quoted lowercase names, synonyms and roles inside PL/SQL.
Beginner · 3 min read
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