Category Archives: Oracle DBA

How to Enable/Disable Archive Log Mode in Oracle 10g/11g

Enable Archive Log Mode

It’s a prime responsibility of Oracle DBA to keep database up 24×7 but there may be some chances when your database gets crash. If your database gets crash and you want to recover it using archive log files then your database must be in archive mode. If your database is in archive made then you

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

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