Category: oracle troubleshooting
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
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
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
Achieve Goal of Oracle Performance Tuning of Oracle database server
Read More
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
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