How to Fix ORA-28001: The Password Has Expired in Oracle
Change an expired password at logon or as an administrator, and check the profile limits that make passwords expire.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Fix ORA-28000: The Account Is Locked in Oracle
Reproduce an account lock from failed logins, read LOCKED and LOCKED(TIMED) in DBA_USERS, and unlock the account.
How to Fix ORA-01017: Invalid Username/Password; Logon Denied in Oracle
Find why a logon is denied, from case-sensitive passwords to the wrong pluggable database, and reset the password as an administrator.
How to Fix ORA-12514: Listener Does Not Currently Know of Service Requested in Oracle
List the services the listener knows, connect to the pluggable database's service, and get a database registered again.
How to Fix ORA-12541: TNS No Listener in Oracle
Find where the listener really listens with lsnrctl status, start it when it is down, and check ports, Docker, and firewalls.
How to Fix ORA-12154: TNS Could Not Resolve the Connect Identifier in Oracle
Connect with an Easy Connect string, or add the alias to the tnsnames.ora the client really reads, with tested examples.
How to Handle ORA-01476: Divisor Is Equal to Zero in PL/SQL Loops
Keep a PL/SQL batch running when one row divides by zero, by handling ZERO_DIVIDE per row or using NULLIF in SQL.
How to Fix ORA-04098: Trigger Is Invalid and Failed Re-Validation in Oracle
Find why a trigger is invalid in USER_ERRORS, fix it so statements on the table work again, or disable it until it is fixed.
How to Fix ORA-06519: Active Autonomous Transaction Detected and Rolled Back in Oracle
End autonomous transactions with COMMIT or ROLLBACK before the routine returns, and see why the logged row survives the caller's rollback.
How to Fix ORA-14551: Cannot Perform a DML Operation Inside a Query in Oracle
Call functions that change data from PL/SQL, split reading from writing, or log with an autonomous transaction when needed.
How to Fix ORA-06504: PL/SQL: Return Types of Result Set Variables or Query Do Not Match in Oracle
Match the columns of a ref cursor's query to the record it is fetched into, and let strong cursor types catch mismatches early.
How to Fix ORA-04068: Existing State of Packages Has Been Discarded in Oracle
Reproduce ORA-04068 with two sessions, see why package state is discarded after a recompile, and design packages that avoid it.
How to Fix ORA-06508: PL/SQL: Could Not Find Program Unit Being Called in Oracle
Read the error that comes with ORA-06508, such as ORA-04067, and restore or recompile the program unit that could not be run.
How to Fix ORA-04063: Package Body Has Errors in Oracle
Find the compile errors behind ORA-04063 in USER_ERRORS, fix the package body, and catch invalid objects at deploy time.
How to Fix PLS-00905: Object Is Invalid in Oracle
Find why a stored procedure became invalid, read its compile errors in USER_ERRORS, and recompile it once the cause is fixed.
How to Fix PLS-00302: Component Must Be Declared in Oracle
Find why a record field or package subprogram is not visible, from misspellings to procedures missing from the package spec.
How to Fix PLS-00306: Wrong Number or Types of Arguments in Call in Oracle
Match procedure and function calls to their parameter lists with USER_ARGUMENTS, and make calls clearer with named notation.
How to Fix PLS-00103: Encountered the Symbol When Expecting One of the Following in Oracle
Read the PLS-00103 message, find the real mistake just before the reported position, and fix the common PL/SQL syntax slips.