Category Archives: Oracle DBA

How to Multiplex Redo Log Files in Oracle

multiplex redo log files

As a DBA, it’s your responsibility to multiplex redo log files just like multiplexing control files to protect your organization data loss due to media failure or redo log file corruption. Follow below steps to multiplex redo log files. Step-1: Connect to a database Connect to SQL*Plus as the system/manager@yourdb user. SQL> CONNECT system/manager@testdb AS

How to Multiplex Control Files in Oracle

multiplex control file

As a DBA, you know that control files play a very important role in oracle database. If the control files are corrupt, can you start your database? No, you can’t do it. So what should be done to avoid such type of corruption? As a DBA, it’s your responsibility to multiplex control files to protect

Oracle 11g Security Features: ORA-28001: The Password Has Expired

Oracle 11g Security

My friend called me today and told about Ora-28001: The password has expired. He told how it is possible.  How password can be expired in Oracle? He was not aware about this security feature in Oracle 11g. He was treating it as an error message while it is a security feature of Oracle 11g. Many

Oracle DBA Tips

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 client connection error. Now what action is to be taken to get rid of above error? Follow below steps to resolve the issue. Connect with oracle database: C:\>sqlplus / as sysdba SQL>conn testuser/test@mydb And you got the ERROR: ORA-12518: TNS:

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 sys/sys@xe as sysdba It gives an error message ORA-12528: TNS listener- all appropriate instances are blocking new connections. Just follow the steps to resolve ORA-12528:TNS:listener issue. XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA

Resolved ORA-12541: TNS no listener error

N no. of articles you will find on the internet about “ORA-12541 TNS no listener error” but still finding an effective solution. Don’t worry this solution helped me a lot and I hope it will help you too. I got the same issue while working on Oracle 10g database then I decided to share my

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 XE. If you want to change your existing SID from XE to your SID, follow below steps to get it done. Take backup of your oracle database before doing all such things. I have tested this on Oracle database 11g

Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error

Oracle Error

Oracle Error Description: When you try to startup your database and it fails with the error code ORA-16038, ORA-19809, ORA-00312. Just follow the below mentioned procedure to get the solution of above problem. SQL> startup ORACLE instance started. Total System Global Area 178792260 bytes Fixed Size 2116288 bytes Variable Size 218440552 bytes Database Buffers 42943340

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)