Category: oracle troubleshooting

Exception:TNS-04414: file error in DBCA or NETMGR

Exception:TNS-04414: file error in DBCA or NETMGR

November 29, 2012 | By | Add a Comment

Hi Friends, Today we are discussing about error “Exception:TNS-04414: file error”. Generally TNS-04414 errors occurred with exception message using GUI tools like DBCA or NETMGR. Cause of TNS-04414 error: Due to found some mysterious character in network file. While DBCA or NETMGR utility is trying to save network file like sqlnet.ora, tnsnames.ora or listener.ora that […]

Read More

ORA-00600 Errors and Database DBA

ORA-00600 Errors and Database DBA

January 31, 2012 | By | Add a Comment

Hi Friends, ORA-00600 is always annoying Oracle DBA. Of course, it does. Because always it has different symptoms with different version of Oracle. Some time it occurs due to Oracle bug and some time it occurs due to database corruption. It doesn’t have same reason, cause or resolution for different version of Oracle databases. ORA-00600 […]

Read More

Oracle Installation Guide

Oracle Installation Guide

September 27, 2011 | By | Add a Comment

Hi Friends, Installation of Oracle is dam easy right? Just in couple of clicks, and Oracle would be installed. Actually we need to consider so many things before proceeding for Installation of Oracle. Optimal Flexible Architecture of Oracle helps easy management of Oracle databases. But in most of cases, expert DBA also ignores this thing […]

Read More

Oracle Performance Tuning Skills

Oracle Performance Tuning Skills

February 21, 2011 | By | Add a Comment

Achieve Goal of Oracle Performance Tuning of Oracle database server

Read More

Tuning of gc current block 3-way wait in RAC Oracle Database

Tuning of gc current block 3-way wait in RAC Oracle Database

November 30, 2010 | By | 1 Comment

Hi Friends, What is the gc current block 3-way wait or gc current block 2-way wait event. Following article is explaining the more detail of gc current block 3-way wait secret with performance tuning of wait event in RAC Oracle Database. So many times oracle rac database wait event gc current block 3-way wait logs […]

Read More

How can perform Expdp with consistent=y

How can perform Expdp with consistent=y

October 22, 2010 | By | Add a Comment

Hi Friends, After introducing DATAPUMP, there are lot of confusion occurring. One of those confusion is how to perform export using EXPDP (datapump) like exp consistent=y. Because in export when we are using consistent=y, there would be very chance to get ORA-01555 snapshot too old error in live database. In 24*7 running database active DML […]

Read More