Miscellaneous Issues

In this series we’ll post some of the common issues faced by DBAs in their day-to-day journey.

Idea is to build a repository where resolution of most of the errors can be found, we would continue to expand the repository.

We request the users to comment with any issues they want us to cover OR if they need any assistance from us in assisting them in their scenario.

  1. Resolving ORA-00845: MEMORY_TARGET not supported on this system
  2. Install & Configure Oracle XE on Linux/CentOS in less than a minute.
  3. Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514
  4. Troubleshooting Listener Startup or Connection Hang issues in 11g.
  5. Resolving tablespace issues (ORA-01650 / ORA-01652 / ORA-01653 / ORA-01654 and ORA-01658)
  6. Resizing Redo Log file
  7. ORA-28040: No matching authentication protocol exception
  8. Troubleshooting TNS-12519 TNS-12516 ORA-12519 ORA-12516
  9. Dead Connection Detection
  10. Installing Oracle Linux 6 on VirtualBox VM
  11. Installing Linux 7 on Oracle VirtualBox VM
  12. How to change the SID using DBNEWID utility
  13. ORA-12547: TNS:lost contact