Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for April, 2010

Video Tutorial – Installing OEL and Oracle 10gR2

Posted by Kamran Agayev A. on 25th April 2010

In this video tutorial I demonstrate the installation of OEL (Oracle Enterprise Linux) and Oracle Database 10gR2 on the virtual machine

 

To download the .mp4 format of the video tutorial, use the following link:

http://www.kamranagayev.com/Video_Tutorials/OEL_installation.mp4

Posted in Video Tutorials | 38 Comments »

Starting review the book "Oracle Database 11g – Underground Advice for Database Administrators" for Packt Publishing

Posted by Kamran Agayev A. on 24th April 2010

Today I’ve got an e-mail from Packt Publishing asking me to review the book “Oracle Database 11g – Underground Advice for Database Administrators” for April Sims

It’s an honour for me to review the mentioned book. The book consists of eight chapters and near 350 pages. I hope I will finish the review for the next month and will post my opinions for each chapter of the book

Posted in Administration | 2 Comments »

DBMS_UTILITY.GET_PARAMETER_VALUE

Posted by Kamran Agayev A. on 23rd April 2010

There’re different ways to get the values of the parameter file using PL/SQL. One of them is using DBMS_UTILITY.GET_PARAMETER_VALUE function. In the following example, I print the value of the compatible parameter of the parameter file:

[sourcecode language="css"] 

SQL>set serveroutput on;
 declare
    id number;
    str varchar2(40);
 begin
    id:=dbms_utility.get_parameter_value(‘compatible’,id,str);
    dbms_output.put_line(str);
 end;
 /
SQL>   10.2.0.2.0
PL/SQL procedure successfully completed. [/sourcecode]

Posted in DBA scripts | 2 Comments »

Exclusive Interview with Porus Homi Havewala

Posted by Kamran Agayev A. on 22nd April 2010

  Porus Homi Havewala is a Principal Consultant with extensive experience in Oracle technology since 1994, including being a Senior Production DBA, Senior Database Consultant, Database Architect, E-Business Technical DBA, Development DBA, and Database Designer Modeller (using Oracle Designer of course). He has worked in Oracle India and is an enthusiast for Oracle technology, especially Grid Control and RMAN, on which he has conducted seminars for various large corporates and their management, and helped them to implement these powerful enterprise tools. Porus has worked for a number of years with the first production Grid Control site in the world, Telstra in Australia. He has published a number of articles on Grid Control and RMAN on OTN, and created the first blog in the world fully dedicated to Grid Control, showcasing podcasts exclusively based on this technology.

Could you please provide answer to the following questions as follows:

  • Brief information about yourself and your family

I am a Parsi Zoroastrian, proudly born in India.  My ancestors migrated from Iran to tolerant India about 1200 years ago after the Arabic conquest of Pre-Islamic Zoroastrian Iran, in order to preserve our ancient religion of Zoroastrianism. We are a small and highly respected minority in India, in which we have been given full freedom of worship for the last 1200 years.  I am a happily married man, married to a fine lady of my own Parsi community.

  • Your education

Bachelor of Science, Post-Graduate Diplomas in Computer languages, Two Oracle Education Masters (Designer and Developer) from Oracle Education Australia, 10g/11g OCP, RAC certified expert, Performance certified expert.

 

  • Your experience with Oracle. When you started first? Has it been interest of your side or just a coincidence?

I started my computing career as a Turbo C (Borland) developer, then moved to dBASE the PC database as a way to fast develop applications. In the early 1990s, the invoicing, profit/loss, export documentation dBASE applications I had wriiten for a Japanese beef export company in Australia were straining under an increasing volume of data and users. I started to investigate the client-server RDBMS world, where I was very impressed with Oracle’s Multi-version Read Consistency and multi-platform support at the database level, and Oracle CASE (Computer Aided Software Engineering) 5.1 at the development and design level – CASE 5.1 was the forefather of Oracle Designer. No other database vendor had anything like Oracle CASE at that time, which was years ahead of its time. I was hooked and convinced my boss to go for Oracle. This was in 1993-1994.

 

  • What was the motive behind to prefer Oracle? Who you have been influenced by?

Oracle’s leading edge technology, even then, even now. Oracle’s enthusiasm for technology.

 

  • What would your preference of profession if not Oracle?

 A biomedical researcher into old age geriatics. But I didnt want to sacrifice animal lives in research.  So I entered the computer field.

  • What motivates you in your job?

Oracle technology, and the desire to further it’s use in the world. For example, not many people know how Oracle Audit Vault can help them in their auditing requirements. Not many people know how powerful Oracle Enterprise Manager Grid Control is, and how useful it can be.

  

  • Do you give lectures on Oracle?

 Yes, I have conducted a number of successful Oracle technical seminars in Singapore.

 In late 2008 as part of business development activities, I conceptualized and conducted an extremely popular Oracle workshop series based on Oracle Enterprise Manager Grid Control:  http://www.si-asia.com/marketing/gridcontrol/

 From July 2009 onwards, I conducted another series of extremely successful Oracle workshops every month jointly with Oracle. The first was on Oracle RAC with Enterprise Manager Grid Control, the second on Active Dataguard and other options such as Streams and Oracle Data Integrator, the third on Patch management using Grid Control, and the fourth on the Diagnostic and Tuning Packs:

http://www.si-asia.com/marketing/oracleworkshops2009/

From February 2010 onwards, I started to conduct another monthly series of Oracle workshops jointly with Oracle. The first was on Oracle Active Data Guard 11g with Enterprise Manager Grid Control and Oracle GoldenGate. Details of the latest workshops are on :

http://www.si-asia.com/marketing/oracleworkshops2010/  

  • Have you authored any book in Oracle?

I am pleased to announce that my new book “Oracle Enterprise Manager Grid Control: Advanced OEM Techniques for the Real World” is getting ready to be published soon (Fall 2010) by Rampant Techpress.  Please do recommend to all your friends and colleagues, it is a great handy book if you really want to make best use of Oracle Enterprise Manager Grid Control.

I have based it on a lot of practical experience and I am sure it will be useful to a lot of you.

These are my Published Articles on The Oracle Technology Network (OTN): 

 Using Grid Control with Filer Snapshotting

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites

Oracle RMAN Backups: Pushing the “Easy” Button

Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control

Easy Disaster Proof Production with Grid Control

Using Oracle GoldenGate for Real-Time Data Integration

 

In December 2009, the Oracle Technology Network (OTN) published the list of Most Popular OTN articles in 2009 and two of my articles on Enterprise Manager are in the list:

http://blogs.oracle.com/otn/2009/11/the_most_popular_articles_and.html

The OTN is the world’s largest online community of Developers, DBAs and Architects.

The two articles of mine in the top 10 are:

Oracle RMAN Backups: Pushing the “Easy” Button

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites

  • Do you manage with your time as to read books on Oracle? What is the name of the book that you read recently?

 I read Oracle books ocassionally. I recently reviewed “Oracle SQL Developer 2.1″ by Oracle’s product manager, Sue Harper.

 

  • What do you think on OTN forums?

 I try to help and advise, based on my knowledge and experience. Of course there are many other experts who know more than me.

  • Do you refer to the documentation? And how often does it happen?

 Oracle 10g/11g Documentation is my bible. I refer to documentation whenever I want to verify a technical point.

  • What is the biggest mistake you have ever made during your DBA career?

I stopped a production listener by mistake from another server. We password protected it after that after we realized the vulnerability.

 

  • What was your greatest achivement as an Oracle DBA?

 In 2008 I was awarded the “Oracle ACE” title followed by the prestigious “Oracle ACE Director” title by Oracle Corporation USA. These titles are the FIRST such awarded in Singapore.

  • What is you priority to manage the challenges you face?

Humanity first and foremost. A human being is the greatest thing on earth. There is a verse in in the Taittiriya Upanishad (Indian scripture) that says “Matru devo bhava, Pitru devo bhava, Acharya devo bhava, Atithi devo bhava” = One should treat their Mother, Father, Teacher and Guests as God.

  • How would you describe the essence of your success? According to your definition of success, how successful have you been so far?

Moderately successful – by God’s Grace.

 

  • What are your best skills which make you differ from others?

Enthusiasm for technology and an interest in writing.

 

  • What’s your major weakness?

At times, a lack of patience.

 

  • Have you ever lost your spirit? If so, what has been the reason and how have you overcome it?

Everyone has that phase. Just think positive – tomorrow is a new day.

 

  • What is the next success you would like to attain and your efforts to this end?

 Make the world a better place to live in.

 

  • How do you balance your daily life with your career?

Life is life and career is career, draw a clear line.

 

  • Please describe your one day summary of activities?

Work. Do something good. Help someone.

Learn. Learn something nice. Teach someone.

Eat simple. Think of God. Sleep.

 

  • How many hours do you work and sleep in a day?

 I try to sleep at least 6 hours.

  • Where and how do you spend your daily, weekly and annual holidays?

At home or shopping.

  • Do you think about Oracle during vacations?  

Vacations are for thinking of my family.

  • Do you have time or motivation to go in for any sports? If yes, which kind of sport do you go in for?  

Only walking, which was Mahatma Gandhi’s favourite exercise.

 

  • What’s your favorite meal and non-alcoholic drink?

 Parsi dishes made from the fresh food in India is delicious.

Sugarcane and Mango juice – the sweetest is in India.

  • What foreign languages do you know?

 English, Hindi, Gujarati (my mother tongue).

  • What’s your average typing speed?

 I am a one-finger typist.

  • Have you ever get involved in politics?

 No.

  • What are your hobbies? 

 Blogging. Writing. Technical as well as spiritual topics.

The popular blog I maintain is http://enterprise-manager.blogspot.com with Oracle Press credentials, and has received more than 8,000 visits since 2008 from all over the world.

I am also the author of a Zoroastrian book, “Saga of the Aryans” (http://saga.zoroastrianism.com)

  • How do you spend your free time?

Watch movies, Indian and English, also documentaries. Read Wikipedia.

  • What’s your biggest ambition?  

To help humanity.

  • What would be your advice to the beginners in Oracle?

 Have patience. You become a DBA only after years of experience.

  • Would you like your children to follow in your footsteps or take a different path in life?

 First and foremost, they should never forget humanity.

  • Do you have any followers of you?

 I have friends not followers.

  • What is your vision on the future of Oracle?

 Oracle has an awesome future.

  • Could you please take a photo in your office near to your desktop?

This is me conducting the most recent “Oracle Database Security” Seminar for Oracle and S&I Systems (Platinum  Partner) at the Sun Solution centre auditorium in Singapore.

Posted in Expert Interviews | 2 Comments »

Exclusive Interview with Ittichai Chammavanijakul

Posted by Kamran Agayev A. on 14th April 2010

Ittichai  Chammavanijakul has started working with Oracle database since 2000, he has been involved in about all aspects of Oracle database technologies including RAC, ASM, Data Guard and Streams. He has designed and implemented many different varieties of high available database environments using RAC on ASM and Veritas Cluster File System. He enjoys database and SQL tuning. Recently he has also been interested in web development using Oracle APEX.

In his current role as data warehouse architect with Motorola, he has architected and implemented many business-driven solutions using Oracle and other vendor products to meet critical business needs especially in warehousing area.

He is Oracle Certified Master, OCP (8i,9i,10g), CCNA, SCSA and MCP

Could u please provide answer to the following questions as follows:

  • Brief information about yourself and your family

 I’m married to the most beautiful, charming, funny and talented woman on earth (who is also watching my screen as I’m typing this). We live in Chicago, Illinois with our daughter and a dog who thinks he’s a cat. 

  • Your education

 I did my Bachelor Degree in Electrical Engineering with the emphasis on Telecommunications. My Master Degree is also in the same field with the same emphasis. 

  • Your experience with Oracle. When you started first? Has it been interest of your side or just a coincidence? 

I started my career as a wireless engineer, but later switched into IT as a system administrator. Then one thing led to another and I got into Oracle. I’ve been working with Oracle since version 8.0. 

  • What was the motive behind to prefer Oracle? Who you have been influenced by?

Whatever I say here will bore you to tears. I was interested in Oracle because it has the largest market share in RDBMS, and I found its technology to be very challenging. So I motivated myself to learn and become better at it. I’ve had fun along the way.  

  • What would your preference of profession if not Oracle? 

  In the alternate universe, I would be a professional golf player. 

  • What motivates you in your job?

I’m a troubleshooter by nature. I like to solve problems the way I do puzzles or riddles. And in this field, problem is something you never run out of. 

  • Do you give lectures on Oracle?  

  I do internal workshops and trainings all the time.  

  • Have you authored any book in Oracle?

  No, but I’d love to someday. 

  • Do you manage with your time as to read books on Oracle? What is the name of the book that you read recently?  

Yes, definitely. Currently I’m reading the “Oracle PL/SQL Programming” by Steven Feuerstein. There are many tips and tricks I’ve never known before.  

  • What do you think on OTN forums?  

It is interesting place where you can interact directly with Oracle experts. I believe what makes Oracle great is its community and contributions, especially in the OTN forums, from all Oracle technologists worldwide. 

  • Do you refer to the documentation? And how often does it happen?  

All the time. I always go to tahiti.oracle.com for Oracle documentation if I would like to research for any topics. 

  • What was your greatest achievement as an Oracle DBA?  

Besides the OCM certification, the fact that I’m still able to balance my technical and management roles at work is my personal achievement. 

  • What is you priority to manage the challenges you face?  

Plan ahead as much as you can, but expect the unexpected. 

  • How would you describe the essence of your success? According to your definition of success, how successful have you been so far?

In addition to dedication and hard working, I love what I’m doing. That will drive you to accomplish anything. 

  • What are your best skills which make you differ from others?

Seeing the big picture to connect the dots.  

  • What’s your major weakness?

  I can’t say no to ice cream. :)  

  • Have you ever lost your spirit? If so, what has been the reason and how have you overcome it?

Have I lost my spirit? I would say no. Occasional discouragement, perhaps. But doesn’t that happen to everybody? 

  • What is the next success you would like to attain and your efforts to this end?

I’d like to find more time to blog more consistently. Ideas abound, but time is scarce. 

  • How do you balance your daily life with your career?

It hasn’t been a challenge, really. I love my job and I enjoy goofing off with my family. I’ve been blessed to have a good balance between the two while making time for myself as well. 

  • Please describe your one day summary of activities?

I work 8-10 hours a day with occasional breaks in between and lots of phone calls and (back-to-back) meetings. In the evening, I walk the dog, play with my daughter, and cook up something with my wife in the kitchen. We love to cook. 

  • How many hours do you work and sleep in a day?

It is varied. Usually I work about 8-10 hours a day. I also sleep 8-10 hours a day. :)  

  • Where and how do you spend your daily, weekly and annual holidays?  

At home, we relax in the kitchen a lot, cooking up new dishes. On weekends, my family and I like to visit a new restaurant to try their food. Each year, we make a point to travel to a new overseas destination. 

  • Do you think about Oracle during vacations?

  Uh, heck, no.  

  • Do you have time or motivation to go in for any sports? If yes, which kind of sport do you go in for?  

  I play golf. It relaxes me and helps increase my ability to focus at the same time. Golf is about figuring out creative solutions to problems. You practice a lot disciplines in this game. You compete with yourself because, unlike other sports, it has no referee or umpire. 

  • What’s your favorite meal and non-alcoholic drink?  

I love Thai street foods: Khao Man Gai, Pad Thai, etc. I’m a fan of foie gras torchon, artisan cheeses and all those things, but the truth remains — the best foods in the world are made street-side and sold on carts. 

  • What foreign languages do you know? 

English (foreign to me as my mother tongue is Thai). I also speak some Mandarin and read Attic Greek and Classical Hebrew. 

  • What’s your average typing speed?  

 63 WPM last time I checked when playing SpongeBob SquarePants Typing game at Apple Store. 

  • Have you ever get involved in politics? 

No. Never. 

  • What are your hobbies?   

Golf, photography and reading.

  • How do you spend your free time?

We’re a family of foodies, so we’re always going out to eat different types of food at different places. 

  • What’s your biggest ambition?  

I’d like to start a nonprofit organization that deals with education for the underprivileged. 

  • What would be your advice to the beginners in Oracle?

Read a lot especially Oracle documentations and/or blogs. Ask questions on forums or blogs. Test everything you read or you are told. Understanding basic concepts is the key. It is tempting to jump into more advanced concepts like RAC, ASM, etc. But without a solid foundation, it may be difficult to grasp the whole. 

  • Would you like your children to follow in your footsteps or take a different path in life? 

I just want my daughter to be a happy person. That’s all I ever want for her in life. If happiness means she follows my footsteps, then so be it. 

  • Do you have any followers of you?  

You mean stalkers? :)  

  • What is your vision on the future of Oracle? 

Oracle will continue to expand its product portfolios by acquiring more companies. Oracle solutions will be more complete covering more aspects of technologies. 

  • Could you please take a photo in your office near to your desktop?  

Unfortunately, this is against the company’s policy to take picture in the office.

Posted in Expert Interviews | 5 Comments »