Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for February, 2012

Exclusive Interview with Kai Yu

Posted by Kamran Agayev A. on 16th February 2012

Kai Yu is a senior engineer and solution architect in Dell Oracle Solutions Engineering Lab  .He has worked with Oracle Technology as an Oracle DBA, Oracle Apps DBA since 1995 and is specializing in Oracle RAC, Oracle E-Business Suite and Oracle VM.  Kai has published 16 technical whitepapers  and given more than 40 technical presentations at major oracle technology conferences worldwide including Oracle OpenWorld, UKOUG, Collaborates, OTN Latin America/APAC Tours, etc. Kai is an Oracle ACE Director and was selected for Oracle ACE spotlight in June 2011, and also was featured  in Oracle Magazine Sept/Oct 2010 issue. Kai has been the president and is the current board member of IOUG Oracle RAC SIG and co-founder and board member of  IOUG Virtualization SIG.  Kai was the winner of  the 2011 OAUG Innovator of Year award . Kai has been active in sharing his Oracle knowledge on his Oracle blog http://kyuoracleblog.wordpress.com/.

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

  • Brief information about yourself and your family

I work for Dell Oracle Solutions Engineering lab. I was originally from China. I live in Austin, Texas, USA with my wife Jin who also works in software industry, and my daughter Jessica who currently is a freshman in high school.


  • Your education:

I got my BS and MS degree in Computer science in China before I came to US. Then I got my second MS in Computer Science in US.


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

        My interest with database started with my Mater degree thesis research on relational database more    than 20 years ago. My Oracle database career started in 1995 shortly after when I took a database engineer position in a software company working on OCI and C++, PL/SQL and DBA. On that job, I really enjoyed learning and working on Oracle database technology on both applications development side as well as the database administration side. The technology really fascinated me and I decided to pursue my career in Oracle database.

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

  I was motivated by the great flexibility and power of the Oracle database and the strong technology behind it.  In my career with Oracle Technology, I have been really inspired by several people. My first mentor was the chief database architect Chip Young in my early career who taught me how to build a high performance application on Oracle Database. In 1997 I learned the Oracle Parallel server (OPS) technology from an Oracle parallel server architect from Oracle and started working  with Oracle cluster database technology. Since 2006, Nadia Bendjedou and Steven Chan and Erik Peterson at Oracle really inspired me to take my Oracle Technology career to the next level by contributing my efforts to the Oracle community (user groups) and Oracle conferences.  With their great inspiration, in April 2010 I reached a great highlight in my career when I was awarded the Oracle ACE Director rank by Oracle Technology Network


  • What would your preference of profession if not Oracle?

I would probably end up in software development work.

  • What motivates you in your job?

The appreciation and love of the technology always motivate me to learn and try new things in my job.


  • Do you give lectures on Oracle?

Not official Oracle University class. But I have done several seminars on Oracle RAC SIG, which were recorded and managed by Oracle University and are publically accessible. I also have spoken at several  IOUG web seminars and Oracle technology conferences worldwide such as Oracle OpenWorlds, IOUG/OAUG Collaborate conferences, UKOUG conference, Scotland conference, Ottawa  conference, OTN (Oracle Technology Network) Latin America conference tour and APAC conference tour.


  • Have you authored any book in Oracle?

I have not finished any book. Recently Syed Jaffar Hussain has been very kind to invite me to co-author his new Oracle RAC book with him


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

By working in an engineering lab, I usually work on very latest technology on which normally there are no many published books around. I spent more time reading Oracle documents, whitepapers, Oracle support notes and Oracle blogs of other colleagues and OTN forms. But I do find a great value to read various published Oracle books to learn the topics in details in a systematic ways.

Here is a list of books I found very useful:

  1.        Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard by  Scott Jesse, Bill Burton, Bryan Vongray
  2.        Oracle Backup & Recovery: Expert secrets for using RMAN and Data Pump, Kamran Agayev Agamehdi & Aman Sharma
  3.        Oracle 11g R1/R2 Real Application Clusters Essentials , by Ben Prusinski, Syed Jaffer Hussain
  4.        Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning  by Richmond Shee, Kirtikumar Deshpande and K. Gopalakrishnan
  5.        For Oracle Applications DBA, Oracle Applications DBA Field Guild  by  Elke Phelps, Paul Jackson     

  • What do you think on OTN forums?

Oracle Technology forums is really a great way for people to share the experience and help each other. A lot of time when I ran into issues, I was able to find some hints or even the answers to my problem. I also try to share my findings on the OTN whenever possible. 

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

I would say Oracle documentation is my primary resource to learn the new products. Many times I started with the beta version of the product as well as the beta version of the documentations. Last year when I involved  Oracle Enterprise Manager cloud control 12c beta and Oracle VM 3.0 beta, I have heavily relied on the beta documentations and the consultation of  the Oracle product managers, even the engineers from the development team.


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

Back to the late 90’s, on the third day after I just started working for a small company, the rented small data center had  some issue with its air conditioning, and I didn’t pay much attention and only forwarded the issue to the data center facility manager to fix it. But the fix was not done immediately. Next day, the database crashed, and I was not able to bring up the database as the database startup always crashed in middle of the instance recovery. After working with Oracle support, the root cause was identified that the data block corruption in the logs caused by the overheated storage pretended the instance recovery from completing. So we had to fix the storage issue and restored the database from the backup and recovered the database to the time right before this corrupted block was written. It was very painful and very time consuming process to get the main revenue generating database back online. Luckily I implemented the online database backup in the very first day when I joined the company.


  • What was your greatest achievement as an Oracle DBA?

In my 17 years Oracle DBA ad architect career, I have received many awards including three times awards from Dell Executive management, and the 2011 OAUG innovator of year award from OAUG.  But my greatest achievements were that I was able to catch up the latest technology and to be recognized by Oracle technology community with the Oracle ACE director rank and the privilege to get to know many industry leading experts in various areas of Oracle Technology.  

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

My priority is always the technology. My job requires me to research the technology and design and implement the Oracle engineering solutions for various IT organizations.


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

Hard working, appreciation and interest on technology are the essence of my success. I am pretty happy for what I am doing today.


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

I got a chance to work on the entire IT stack: server, storage, networking, virtualization, OS,  database, middleware, and applications. This allows me to look at the problems from a broad view

  • What’s your major weakness?

I prefer hand on technology work,  not much management type work.


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

Not really. But I found hard time working with the people that don’t appreciate technology and don’t appreciate technical skills.

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

 I would appreciate if I can get a higher technology ladder like a principle architect position or a technical director position as I have been in my current senior technical position for ten years. But I will continue to focus on my technology interest no matter what.


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

It has been a very challenge to balance my daily life and my career, as I like them both, but there is no enough time. But it may be possible to have both sometime. Last year, I took my daughter with me on my conference trip to England and Scotland, and she found it very interesting and very educational on the trip.


  • Please describe your one day summary of activities?

I normally get up around 7:30am, taking my daughter to school and get into office around 9:00am. I work in office until 7:00pm. And after dinner, I started working around 8:30pm to 12:30am.  During the night hours, I may also talk to my daughter for her school work or watch some piece of movies or TV on a break.

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

Around 6 hours a day, and depending on the workload or other activities.

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

I like to spend my holiday in travel around the world, also visiting my parents and brother and sister in China.

  • Do you think about Oracle during vacations?

No much, travel is my big favor. I would like to learn the different cultures and places on travel. I also travel to different places in the world for Oracle conferences as well as for vacations.


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

I swim and play Ping-Pong (table tennis) and also run sometime.


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

I don’t have any particular favorite food, but just prefer light taste food, not much non-alcoholic drink either.

  • What foreign languages do you know?

Beside of English, I speak standard Chinese, my native language.

  • What’s your average typing speed?

I can’t type very fast, as never had any special training on typing

  • Have you ever get involved in politics?

No. Not very interested.

  • What are your hobbies? 

Swimming, playing Ping-Pong, military/history.


  • How do you spend your free time?

Being with family, travelling, exercising, reading, watching  movies/TVs, house work etc. 

  • What’s your biggest ambition?

Visiting all the countries in the world.

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

          Learn the solid foundation of the major; Have a strong passion for the Oracle technology;  be ready for the life time learning.

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

That will depend on her interest. I don’t force anything. However, I see technology is a very good career.

  • Do you have any followers of you?

I have seen some followers in my blogs. But I found that people are easier to find the materials from my blog entries than from my whitepapers and conferences although my 16 whitepapers and more than 40 conferences presentations listed in my Oracle blog (http://kyuoracleblog.wordpress.com) have much richer materials than those on my blog entries. I plan to find some time to extract some materials from those whitepapers and conference presentations and put them on some the blog entries so that the search engine can pick up them.


  • What is your vision on the future of Oracle?

I think Oracle is a great company that produces the great Oracle Technology. I love to continue to work with Oracle Technology.


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

Posted in Expert Interviews | 3 Comments »

Getting “ORA-00959: tablespace ‘TBS01’ does not exist” during Data Pump import

Posted by Kamran Agayev A. on 14th February 2012

When importing data from different database, sometimes you get errors like:


ORA-39083: Object type TABLESPACE_QUOTA failed to create with error:
ORA-00959: tablespace ‘TBS01’ does not exist
Failing sql is:


This means that the tablespace “TBS01” doesn’t exist in the database where you’re importing the data. For this, you can use REMAP_TABLESPACE option. If you have more than one tablespace that doesn’t exist in the second database, use comma as follows:

[php]REMAP_TABLESPACE=db01_tbs01:db02_tbs,db_01_tbs02:db02_tbs [/php]


To get which remap script you need to create, check TABLESPACE_NAME column for the DBA_SEGMENTS view and find in which tablespaces your objects are reside

Posted in Administration | 4 Comments »

NOT IN with NULL values

Posted by Kamran Agayev A. on 13th February 2012

I strongly believe that you already know that NOT IN doesn’t take NULL values into account and those values are not displayed in the output

Check the following example:

[php]SQL> create table my_table (id number, name varchar2(10));

Table created.

SQL> insert into my_table values(1,’test1′);

1 row created.

SQL> insert into my_table values(2,null);

1 row created.

SQL> insert into my_table values(3,’test2′);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from my_table;

———- ———-
1 test1
3 test2

SQL> select * from my_table where name not in (‘test2’);

———- ———-
1 test1



For more information check the following links:



Posted in Administration | No Comments »

Regsiter for BIG Data online Forum

Posted by Kamran Agayev A. on 5th February 2012

There will be an online forum with interesting sessions on BIG Data at February 16th. If you’re interested on Big Data, don’t miss it. Here’s the registration link:



Posted in Uncategorized | No Comments »

Login operation failed in Grid Control

Posted by Kamran Agayev A. on 1st February 2012

Today, when I was trying to connect to the OEM Grid Control, I got “Login operation failed” error

The first file to be checked are the log and trace files at  Grid side. So I checked emoms.trc and emoms.log files under $OMS_HOME/sysman/log and didn’t find anything. I checked the repository database, it was up and running. After a while I realized that it’s a connection problem and checked $OMS_HOME/sysman/config/emoms.properties file and saw that it is trying to connect to the 2222 port  as a Repository Connection:

[php]oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=host03)(PORT\=2222)))( CONNECT_DATA\=(SID\=oemgrid)))[/php]

When I checked listener at the repository side, I saw that it wasn’t configured to accept connections from port 2222

I added the above port number to the non-default connection section at listener.ora file and started the listener

[php]second_listener =




SID_LIST_second_listener =






-bash-3.2$ lsnrctl  start second_listener
Listener Log File         /u01/oracle/product/10.2.0/db_1/network/log/second_listener.log
Listening Endpoints Summary…  
Services Summary…
Service "oemgrid" has 1 instance(s).  
Instance "oemgrid", status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully


I tried to connect to the Grid Control again, and succeeded. So if you got “Login operation failed” error and didn’t get any information from the Grid Control log files, the listener and port issues can be the reason

Posted in Administration | No Comments »