Category: howto

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

Sub Query limitation in Oracle

Sub Query limitation in Oracle

October 26, 2011 | By | 1 Comment

Hi Friend, Do you know there is a limitation of sub-query in Oracle? If you don’t know then keep in mind following limitation. There is a limitation of Oracle for Subqueries. You can use unlimited sub-queries in FROM clause of main query. You can use maximum 255 sub-queries in WHERE clause of Oracle. This limitation […]

Read More

How to tune disk IO

How to tune disk IO

October 16, 2011 | By | Add a Comment

Hi Friends, How to decrease disk I/O contention and performance bottleneck of Oracle server. Make perfect action plan for reducing disk I/O of oracle server. Here you can find out some tips and techniques. There are lots of tips available in various articles and books. Proper techniques of decrease disk I/O contention and how to […]

Read More

Database character set conversion pre-checks Oracle utility

Database character set conversion pre-checks Oracle utility

December 6, 2010 | By | Add a Comment

Hi Friends, Conversion of Database character set is more difficult when large database involves. Database character set conversion is also very important procedure while we need or application needs change of character set. Oracle provides very good utility for pre-checking of database character set migration. It calls CSSCAN. Using CSSCAN we can check possible problems […]

Read More

Oracle DBA Scripts- PGA management and pga_aggregate_target

Oracle DBA Scripts- PGA management and pga_aggregate_target

November 10, 2010 | By | Add a Comment

Hi Friends, Here you can find out some useful and important Oracle DBA scripts for managing and administrating Database very easily. Oracle DBA Scripts-1: How to check hidden PGA parameter setting from Oracle hidden parameters. Following scripts are very useful to get hidden pga parameters. Kindly execute with SYSDBA privilege. select a.ksppinm name, b.ksppstvl value […]

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