How to Multiplex Redo Log Files in Oracle
As a DBA, it’s your responsibility to multiplex redo log files just like multiplexing control …
Oracle DBA
Best Tips and Tutorials for Oracle DBA is available free on IT Blogger Tips. Tutorials are available from beginners to experienced level.
How to Multiplex Control Files in Oracle
As a DBA, you know that control files play a very important role in oracle …
Oracle 11g Security Features: ORA-28001: The Password Has Expired
My friend called me today and told about Ora-28001: The password has expired. He told …
Oracle 11g Security Features: ORA-28001: The Password Has Expired Read More »
Oracle DBA Tips
You will find here Oracle DBA tips and techniques which will help you to resolve your issues. If you want to learn about these tips then follow the links.
Fixed ORA-12518: TNS:listener could not hand off client connection
You try to connect with Oracle database and get Ora-12518 listener could not hand off …
Fixed ORA-12518: TNS:listener could not hand off client connection Read More »
Resolved ORA-12528: TNS:listener: all appropriate instances are blocking new connections error
I was getting ORA-12528:TNS:listener error while connecting with my Oracle XE 11g database. SQL> conn …
Resolved ORA-12541: TNS no listener error
N no. of articles you will find on the internet about “ORA-12541 TNS no listener …
How to change the SID of an Oracle XE instance
When you install oracle database 11g express, by default its SID name is set to …
Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error
Oracle Error Description: When you try to startup your database and it fails with the …
Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error Read More »