Category: technology

Solutions Associated With Oracle Backup and Recovery

Solutions Associated With Oracle Backup and Recovery

April 4, 2013 | By | Add a Comment

RMAN is only option for OMF and Oracle ASM as Backup and Recovery Tool In the field of Oracle backup and recovery, there exist many solutions that are used for applying various strategies. In this article we will introduce some of these solutions to make you familiar with the terms.   Recovery Manager (RMAN) There […]

Read More

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

How to Detect Block Corruption in Oracle?

How to Detect Block Corruption in Oracle?

April 12, 2012 | By | Add a Comment

Block Corruption in Oracle Analysis and Investigation of Corrupt Block in Oracle Database Oracle has four methods for detecting corruption. The analyze commend with the validate structure option can be used to verify the structure of a table, index, or cluster, and to confirm that a table and its indexes are in sync. The external […]

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

Oracle Utility – isqlplusctl

Oracle Utility – isqlplusctl

October 14, 2011 | By | Add a Comment

Hi Friends, Today we discuss about isqlplusctl utility of Oracle. Use isqlplusctl to start and top the iSQL*Plus application server. The iSQL*Plus application server requires to be started before you can use iSQL*Plus utility of Oracle. Syntax Isqlplusctl   [start/stop] Parameters: Start Starts the iSQL*Plus application Server. Stop Stops the iSQL*Plus application Server. Example: To start […]

Read More

select for update

select for update

August 30, 2011 | By | Add a Comment

select for update in Oracle

Read More