Simple Solaris IP Multipathing IP multipathing consists of grouping two identical network cards together and having a live IP address be able to automatically fail over from one card to the other with no loss or degredation of service. The steps to accomplish this are as follows: 1. Ensure that both cards are seen by…
Media Recovery – Oracle Executive Overview: The media failure is the biggest threat for enterprise data management. A media failure is a physical problem that occurs when a computer unsuccessfully attempts to read from or write to a file necessary to operate the database. The technique you use to recover from media failure of a…
Introduction In this paper we will present a method for retrieving data from an Oracle database that cannot be opened normally because one or more datafiles is inconsistent with the others. An example of a scenario where you would find yourself in this situation is as follows: A disk failed on our server and we…
The topics covered in listener security management are straightforward, but there are special sqlnet.ora tricks for blocking access by IP address. Blocking Oracle Access by IP Address Now comes the fun part: keeping people out of your database! While IP-based blocking is not as suitable as a full firewall, you are able to block clients…
Oracle Technical Interview Questions Answered – Part1 The interview process can be quite stressful. Here is the first part of a two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position. Ever since I wrote the past article on the Oracle Technical Interview,…
Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) is an Oracle database security technology, enabling row level access control. With VPD we are able to control users access to data related to them only and preventing from them to access data they are not authorized…
HOW TO HIRE (OR BE HIRED AS) AN ORACLE DBA Over the last year I have interviewed several dozen candidates for Oracle related positions. The positions ranged from entry level developer to senior level DBA. Many of the interviews were for DBA level positions. In this period I learned that it is very difficult to…
Unix Command’s for DBA’s Basic File Navigation The “pwd” command displays the current directory: root> pwd /u01/app/oracle/product/9.2.0.1.0 The “ls” command lists all files and directories in the specified directory. If no location is defined it acts on the current directory: root> ls root> ls /u01 root> ls -al The “-a” flag lists hidden “.” files….
Normally recovery happens as follows: In the controlfile is recorded the current log sequence number the database is working with, and – I think_- the current scn. If one of the datafiles has an older seq# or scn in its header, that file must first be recovered up to the current scn before it can…