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…
A Day in the Life of an Enterprise DBA With systems-management tools such as Oracle Enterprise Manager, DBA s can manage the enterprise from home. Sit in on a day with OEM. Thanks for coming over to the office. We’ll go through a typical day of database administration. Today’s to-do list covers a variety of…
Top Five Cool Features of Oracle9i 1 Flashback Query Ever wanted to run a query against your data as it appeared last month? You can, and much more, using Oracle9i Flashback Query. 2 Access External Files No more work-arounds for accessing data not in your database. Now you can query data that’s kept in files…