Tuesday, September 28, 2010

Interview Guide


These are general guidelines for any interview. Always, prepare for interview and Practice, Practice and Practice 

Disclaimer : These question are not in any order or importance

General

Q. Tell us about yourself
     Prepare to speak up for at least 3 minutes
Q. Tell us why you are interested in this job –
     Do the research about the company and prepare your answer
Q. Do you read any Oracle Magazine/blogs/papers
Q. Are you member of any User Group
Q. Last Question of Interview is always, Do you have question 
    Prepare your question in advance

Technical

There are two types of technical questions
a) Similar to what is what is being asked at OCA/OCP – terms etc
b) Situation based, such as,
User is getting password expired, what action you are going to take

Cron format - crontab


# +---------------- minute (0 - 59)
# |  +------------- hour (0 - 23)
# |  |  +---------- day of month (1 - 31)
# |  |  |  +------- month (1 - 12)
# |  |  |  |   +---- day of week (0 - 6) (Sunday=0 or 7)
# |  |  |  |    |
   *  *  *  *  *  command to be executed

 Examples:

00 23 * * 0,2,4,6 /bin/ksh /home/rupam/rman_hot_backup.sh orcl 1> /home/rupam/BACKUP/backup.log 1<&1

20 30 * * * /bin/ksh /home/rupam/collect_partition_stats.sh 1> /dev/null 2>&1


Monday, September 27, 2010

Google is celebrating its 12th birthday this September

Google is 12  this September,2010. Here is an interesting article on Google, which walks down the memory lane, enjoy!

Click here

Sunday, September 26, 2010

Oracle Active Data Guard

How Oracle Active Data Guard can help your organization ?

Thursday, September 23, 2010

OCP ORACLE CERTIFICATION PROGRAM


Database Administration
    Oracle Certified Associate (OCA)
    Oracle Certified Professional (OCP)
    Oracle Certified Master (OCM)
    Oracle Database 11g: Performance Tuning
    Oracle Database: SQL Certified Expert

Application Development
    Oracle Application Express Developer Certified Expert

Oracle 11g Upgrade Paths

An Oracle10g OCP can upgrade to 11g certification by passing the 1Z0-050 Oracle
Database 11g: New Features for Administrators exam.

An Oracle9i OCP can upgrade to 11g certification by passing the 1Z0-055 Oracle
Database 11g: New Features for 9i OCPs exam.

An Oracle8i OCP can upgrade to 10g by passing the 1Z0-045 Oracle Database 10g
DBA New Features for Oracle8i OCPs exam, then separately passing the 10g to 11g
upgrade exam.

Oracle 7.3 and Oracle 8 DBAs must first upgrade to an Oracle9i certification with the 1Z0-035 Oracle9i DBA New Features for Oracle 7.3 and Oracle 8 OCPs exam and then upgrade the 9i certification to 11g with the 1Z0-055 Oracle Database 11g: New

For the latest information on all of Oracle’s certification paths, along with Oracle’s training resources.   





Wednesday, September 22, 2010

Duplicate Database Using RMAN Active Database

New Feature in Oracle 11g

Overview

Oracle Database 11g RMAN introduces the FROM ACTIVE DATABASE capability to the DUPLICATE command.

TOAD - Privileges required for Debugging Oracle Procedure

The following privileges are required for debugger:
1. GRANT ALTER SESSION TO user_name;
2. GRANT CREATE SESSION TO user_name;
3. GRANT EXECUTE ON DBMS_DEBUG to user_name;

Minimum requirements to debug other than your own procedures, functions, and packages:
1. GRANT ALTER ANY PROCEDURE TO user_name; (compile)
2. GRANT CREATE ANY PROCEDURE TO user_name; (edit / save)

The following additional privileges are required for debugger inversion 10g and any version released after that:
1. GRANT DEBUG ANY PROCEDURE TO user_name;
2. GRANT DEBUG CONNECT SESSION TO user_name;

Also, verify that the DBMS_DEBUG package in the sys schema is valid.
After the above, EXIT and RESTART Toad.