Should You Use “@” in Oracle Passwords? Risks, Errors & Fixes
When setting strong passwords in Oracle, it’s tempting to use special characters like @. But in Oracle’s world, @ isn’t just another…
Category: Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
How to Fix ORA-19687: SPFILE Not Found in Backup Set
If you’re working with Oracle RMAN and trying to restore the SPFILE, running into the ORA-19687 error can be frustrating. This error…
How to Disable AutoTask in Oracle
Sometimes you may want to stop Oracle’s AutoTask jobs temporarily — for example, to troubleshoot performance issues or avoid conflicts with important…
How to Fix ORA-00054: Resource Busy and Acquire with NOWAIT Specified or Timeout Expired
While working with Oracle databases, you might encounter: If you’re wondering: This post will clarify these questions simply so you can handle…
ORA-00020: Maximum Number of Processes Exceeded — What It Means and How to Fix It
Oracle error ORA-00020: maximum number of processes (string) exceeded indicates that your database has hit its process limit, as defined by the…
How to Fix ORA-00059: Maximum Number of DB_FILES Exceeded in Oracle
If you’re working with Oracle databases and hit this error: Don’t worry — this just means your database has reached its configured…
How to Fix ORA-00959: Tablespace ‘TEST_TBS’ Does Not Exist
If you’re working with Oracle and see this error: It means you’re trying to use a tablespace that hasn’t been created in…
How to Fix ORA-39142: Incompatible Dump File Version in impdp
While working with Oracle Data Pump (expdp/impdp) to export and import data between different database versions, you may encounter this error during…
How to Delete Multiple Lines in vi Editor
When you’re editing a file in vi (or vim) and come across a large block of unnecessary lines—such as logs, commented code,…
How to Fix “ORA-28011: the account will expire soon; change your password now”
If you’ve logged into your Oracle database and seen this message: don’t panic. It’s not an error that stops you from working—it’s…