Subscribe: Oracle DBA and Apps DBA blog
Added By: Feedage Forager Feedage Grade A rated
Language: English
blog  certification  database  file  linux  new  opatch  oracle  patch  release  sabdar syed  stby  time  unix linux  unix 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Oracle DBA and Apps DBA blog

Oracle DBA and Apps DBA blog

Important: The things, which are discussed here, are my own views and findings, please test them from your side too before you apply.

Updated: 2018-03-21T04:23:02.736-07:00


No Write Permission on ACFS Mount Point


Last night, I managed to create the ACFS Mount Point after resolving the issue "ACFS-9459: ASVM/ACFS is not supported on this os version". But, after creating the ACFS Mount Point, I'm unable to create or touch any files under this ACFS Mount Point.Though, I tried to touch a file to create files under this ACFS Mount Point using OS User Oracle and Root, it's failing with the following error:"touch: cannot touch `x': Permission denied"Here are the steps I tried and got the error:The ACFS Mount Point "/oracle/prd"  has been created on Linux 6.5 server using Oracle ASMCA tool, and this "/oracle/prd" mount point has 775 permission.As Oracle User:[oracle@Linux01 ~]# df -m|grep -i asm/dev/asm/oracle_prd-77   35840    148     35693   1% /oracle/prd[oracle@Linux01 ~]# cd /oracle/prd[oracle@Linux01 prd]# pwd/oracle/prd[oracle@Linux01 prd]# ls -ld /oracle/prddrwxrwxr-x. 4 oracle dba 4096 Sep 15 19:29 /oracle/prd[oracle@Linux01 prd]# lslost+found[oracle@Linux01 prd]# touch abctouch: cannot touch `abc': Permission denied[oracle@Linux01 prd]#As Root user:[root@Linux01 ~]# df -m|grep -i asm/dev/asm/oracle_prd-77   35840    148     35693   1% /oracle/prd[root@Linux01 ~]# cd /oracle/prd[root@Linux01 prd]# pwd/oracle/prd[root@Linux01 prd]# ls -ld /oracle/prddrwxrwxr-x. 4 oracle dba 4096 Sep 15 19:29 /oracle/prd[root@Linux01 prd]# lslost+found[root@Linux01 prd]# touch abctouch: cannot touch `abc': Permission denied[root@Linux01 prd]#The problem was the SELinux is enabled on the Linux System.To check, if SELinux is enable/disable on the system, cat the file "/etc/selinux/config"Note: Used the root login to do the following steps:[root@Linux01]# cat /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:#     enforcing - SELinux security policy is enforced.#     permissive - SELinux prints warnings instead of enforcing.#     disabled - No SELinux policy is loaded.SELINUX=enforcing# SELINUXTYPE= can take one of these two values:#     targeted - Targeted processes are protected,#     mls - Multi Level Security protection.SELINUXTYPE=targetedOr use the sestatus command to check the status.[root@geprdb850 prd]# sestatusSELinux status:                 enabledSELinuxfs mount:                /selinuxCurrent mode:                   enforcingMode from config file:          disabledPolicy version:                 28Policy from config file:        targetedHere is how to disable SElinux:Method 1- Edit "/etc/selinux/config" and set the SELINUX variable to 'disabled'Method 2- Use the setenforce command to disable on-the-flyIf you go with Method 1, then your changes are permanent but only effective if you reboot the machine.If you go with Method 2, then your changes are NOT permanent but effective immediately.Method 1: (Permanent Change)Take the backup of "/etc/selinux/config" file.[root@Linux01]# cp /etc/selinux/config /etc/selinux/config.bkpThen edit "/etc/selinux/config" the file and set the SELinux variable to 'disabled'[root@Linux01]# cat /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:#     enforcing - SELinux security policy is enforced.#     permissive - SELinux prints warnings instead of enforcing.#     disabled - No SELinux policy is loaded.SELINUX=disabled# SELINUXTYPE= can take one of these two values:#     targeted - Targeted processes are protected,#     mls - Multi Level Security protection.SELINUXTYPE=targetedThen reboot the server!!Method 2: (On-the-fly)[root@Linux01]# getenforceEnforcing[root@Linux01]# setenforceusage:  setenforce [ Enforcing | Permissive | 1 | 0 ][root@Linu[...]

ACFS-9459: ASVM/ACFS is not supported on this os version


After installing the Grid Infrastructure (GI) home on two Node RAC 11gR2 ( on Linux 6.5 servers, I tried to create the ACFS filesystem using ASMCA tool to have Oracle (RDBMS) Home. But, the option tabs "Volumes" and "ASM Cluster File Systems" in ASMCA toll were disabled, due to this we were unable to create volume and cluster filesystem and got the following error:"ACFS-9459: ASVM/ACFS is not supported on this os version: '3.8.13-16.2.1.el6uek.x86_64'"I had checked the "ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)" under the section "ACFS Supported Platforms" in Oracle Metalink.For our evnironment, Oracle Linux - Unbreakable Enterprise Kernel, it's defined as a bug and it suggested to apply the opatch "16318126".After download the suggested Opatch and while installing the opatch, the following errors were encountered:"The opatch minimum version  check for patch /16318126/custom failed  for The opatch minimum version  check for patch /16318126/etc failed  for The opatch minimum version  check for patch /16318126/files failed  for Opatch version check failed for oracle home  Opatch version  check failedupdate the opatch version for the failed homes and retry"Initially, I thought that the OPatch version ( is an older version, but the existing OPatch version ( is greater than the required version ( as per the opatch readme.txt file.Even though, I have downloaded the latest OPatch "Patch 6880880: OPatch patch of version for Oracle software releases 11.2.0.x" for Linux x86-64. One good thing was, I could generate the OCM response file (ocm.rsp) using "emocmrsp" file under $GI_HOME/OPatch/ocm/bin. Because, after installing GI_HOME for RAC, there was no "emocmrsp" file under $GI_HOME/OPatch/ocm/bin. The OCM response file (ocm.rsp) was needed to apply the patch in Auto mode.Well, I got the same error again even after downloading latest OPatch and while applying the patch "16318126":"Opatch version check failed for oracle home  "The commands used to apply the OPatch are as follows:$ cd /i.e. cd /u01/oracle/patch/16318126Note: This is where the patch 16318126, recommended in ""ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)", was unzipped.Login as root and executed the below opatch:# opatch auto /16318126 -oh -ocmrf /OPatch/ocm/bin/ocm.rsp# opatch auto /u01/oracle/patch/16318126 -oh -ocmrf /OPatch/ocm/bin/ocm.rspThis is wrong !! and this is why, the error "Opatch version  check failed" was encountered.The correct wahy of applying the patch is as follows:Login as root.Set the opatch path in the $PATH as follows:# export PATH=$PATH:$ORACLE_HOME/OPatch# opatch auto -oh -ocmrf /OPatch/ocm/bin/ocm.rspi.e.# opatch auto /u01/oracle/patch -oh -ocmrf /OPatch/ocm/bin/ocm.rspNote:No need to mention the patch number directory i.e "/u01/oracle/patch/16318126", just metion only the directory upto "/u01/oracle/patch/".And, Make sure under "/u01/oracle/patch" there won't be any other patch directores or files apart from the patch you need to apply i.e. "16318126"Then the patch was succeded as follows:===========================# opatch auto /u01/oracle/patch -oh /u01/oracle/app/ -ocmrf /u01/oracle/app/ /u01/oracle/app/ /u01/oracle/app/ -patchdir /u01/oracle -patchn patch -oh/u01/oracle/app/ -ocmrf/u01/oracle/app/ -paramfile /u01/oracle/app/ is the main log file: /u01/oracle/app/ file will show your detected configuration and all the steps that opatchauto attempted to do on your system:/u01/oracle/app/ 17:41:14: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/oracle/app/[...]

Oracle made a few changes in Oracle 11g OCM Exam Environment and Exam Topics


Exam Environment Current Environment(Till 12th May 2013) New Release Environment(From 13th May 2013 onwards) Oracle Linux Release 5.4 (64-bit) Oracle Linux Release 5.4 (32-bit) Oracle Database Enterprise Edition Release (64-bit) Oracle Database 11g Enterprise Edition Release (32-bit) Oracle Enterprise Management Grid Control 10g version (64-bit) with repository database Oracle Enterprise Manager 11g Grid Control Release 1 (  (32-bit) Following are the few changes in Exam Topics:Added in Server Configuration·         Use OPatch to install a patch·         Use Enterprise Manager Configuration Assistant (EMCA) utilityRemoved from Data Warehouse Management  * Note: The topic "Configure and manage Streams for capture, propagation and apply" will be retired in the new release of this exam from 13th May 2013.Fore more information on 11g OCM Exam, Click here.Regards,Sabdar Syed.[...]

"Warning: You are no longer connected to ORACLE" while converting database using DGMGRL.


As part of my OCM Exam preparation while practicing the Data Guard scenarios such as converting the database from physical standby to snapshot standby and from snapshot standby to physical standby using Data Guard Broker, the following warning messages were generated:Unable to connect to databaseORA-12514: TNS:listener does not currently know of service requested in connect descriptorFailed.Warning: You are no longer connected to ORACLE.Please complete the following steps and reissue the CONVERT command:        start up and mount instance "stby" of database "stby"Here is how, I was testing:DGMGRL> connect sys@orclPassword: Connected.Show the configuration:DGMGRL> show configuration;Configuration - DGConfig01  Protection Mode: MaxPerformance  Databases:    orcl - Primary database    stby - Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSConvert the Physical Standby Database to Snapshot Standby Database:DGMGRL> convert database 'stby' to snapshot standby;Converting database "stby" to a Snapshot Standby database, please wait...Database "stby" converted successfullyNote: Converting the database from Physical Standby to Snapshot Standby database was succeeded, but it failed while reverting from Snapshot Standby to Physical Standby.DGMGRL> convert database 'stby' to physical standby;Converting database "stby" to a Physical Standby database, please wait...Operation requires shutdown of instance "stby" on database "stby"Shutting down instance "stby"...Database closed.Database dismounted.ORACLE instance shut down.Operation requires startup of instance "stby" on database "stby"Starting instance "stby"...Unable to connect to databaseORA-12514: TNS:listener does not currently know of service requested in connect descriptorFailed.Warning: You are no longer connected to ORACLE.Please complete the following steps and reissue the CONVERT command:        start up and mount instance "stby" of database "stby"Solution A:First of all this is just a warning message, all you need to do is startup mount the database as instructed in the above warning message to resolve the issue.But, the issue is that the Data Guard Broker was attempting to connect to a service called < db_unique_name>_DGMGRL i.e. stby_DGMGRL. On the server, the service name in the listener.ora file was configured as followsSID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME =      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)      (SID_NAME = stby)    )To overcome from this warning message being generated and to fix the issue permanently,  add a static registration for stby_DGMGRL to your $ORACLE_HOME/network/admin/listener.ora. Below is an example.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = stby_DGMGRL)      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)      (SID_NAME = stby)    )  )Or Solution B:Check the value of StaticConnectIdentifier property for stby database:DGMGRL> show database 'stby' 'StaticConnectIdentifier';  StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)('Here the SERVICE_NAME is stby_DGMGRL (by default it was set like this when Data Guard Broker configured).Change the SERVICE_NAME from stby_DGMGRL to using Data Guard Broker DGMGRL> connect sys@stbyPassword: Connected.Show the current value for StaticConnectIdentifier propertyDGMGRL> show database 'stby' 'StaticConnectIdentifier';  StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS[...]

It's been quite a long time !


Dear Blog Viewers,

It’s been quite a long time that I had updated my blog. I could say, it’s been almost over two years that I haven’t updated my blog. Surely, this has made upset to my regular blog viewers.

Well, there were various reasons why I didn't update my blog.

To fill the huge gap occurred in updating the blog; I have now decided to update my blog with new concepts/my experience/views about Oracle DBA at least every now and then whenever time permits me from my busy schedules.

It’s been quite a long time that I had stopped preparing for Oracle 11g OCM Exam. Now the time has come to prepare and appear for 11g OCM Exam in a near future. Though, it’s not decided yet when I would be appearing for this exam, but surely it needs enormous practice and preparation before appearing the real exam.

However, I would be updating the blog with my preparation for 11g OCM and the concepts I’m going to practice.

I hope that I would be receiving the unchanged and continuous support & wishes from my blog viewers in my preparation for the exam.

Your valued suggestions and advises are always welcomed.

Sabdar Syed.

My Interview Published in the Peer-To-Peer Column of Oracle Magazine



This is to share with you all that Oracle Published my interview in the
peer-topeer column of Oracle Magazine (March - April 2010 Edition).


Sabdar Syed.

How we faster the process of converting a non-ASM single-instance database to RAC database with ASM using RCONFIG tool?


I have been given with a challenging task to convert one of our critical production databases, which is of 1 TB (Terabyte) in size, to Oracle 10g RAC with ASM storage option. Even though, there are many methods and tools available to perform this activity, I have preferred to use the RCONFIG tool.We prepared an input XML file required for RCONFIG tool, and run the RCONFIG utility as follows:$ cd /oracle/ora102/db_1/assistants/rconfig/sampleXMLs$ rconfig ConverToRAC.xmlWhen we start the RCONFIG tool to convert the database to RAC, the RCONFIG tool initially moves all the non-ASM database files to ASM disk files, for this RCONFIG tool internally invokes RMAN utility to backup the target database to the ASM disk groups, eventually the database is converted to RAC using RCONFIG.The conversion took almost 9 hours to complete the process, because during the conversion RMAN used only one channel per data file to backup to ASM disks. There was no chance of improving the RMAN copy process by allocating more channels in the input XML file, and also Oracle doesn’t recommend doing other changes in the input XML file.One thing was observed during the RMAN copy that RMAN is using target database control file instead of recovery catalog, and also using the RMAN default preconfigured settings for that database.To know the RMAN default preconfigured settings for the database:$ export ORACLE_SID=MYPROD$ rman target /Recovery Manager: Release - Production on Wed Aug 5 10:21:05 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: MYPROD (DBID=1131234567)RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora102/db_1/dbs/snapcf_T24MIG1.f'; # defaultHere we see that the PARALLELISM is 1 (default), that’s why the RMAN using only one channel during backing up the non-ASM datafiles to ASM Disk Groups, and were taking 9 hours to complete the backup.We have changed the PRALLELISM count to 6 (it depends upon number of CPUs you have in the server).Solution:RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 6;old RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters:CONFIGURE DEVICE TYPE DISK PARALLELISM 6 BACKUP TYPE TO BACKUPSET;new RMAN configuration parameters are successfully storedRMAN> show all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 6 BACKUP TYPE TO BACKUPSET;CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora102/db_1/dbs/snapcf_T24MIG1.f'; # defaultAfter changing the P[...]

Sand Storm in Saudi Arabia...Today.


Hello,Today, there was a huge sand storm in Saudi Arabia. This is the first time I have seen such real and live sand storm covering the Riyadh City in Saudi Arabia.Here are few pics shared in this blog. Regards,Sabdar Syed.[...]

ORA-27123: unable to attach to shared memory segment



Of late, in one of our test unix (Sun Solaris) boxes, a database user is trying to connect to the database, but getting an error ORA-27123: unable to attach to shared memory segment” with permission denied issue.

Initially we thought that there might be an issue with SGA memory area or may be an issue with the shared memory segments and semaphores for the instance allocated. But later we found that the permission on ORACLE_HOME directory got changed accidentally with the full permission.

Here are our findings:

$ sqlplus testusr/password@testdb

SQL*Plus: Release - Production on Tue Jan 27 20:53:44 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied
As per Oracle Error Messages:

Error: ORA-27123: unable to attach to shared memory segment
Cause: shmat() call failed
Action: check permissions on segment, contact Oracle support
Check the oracle executable file permission.

$ cd $ORACLE_HOME/bin
$ ls -l oracle
-rwxrwxr-x 1 oracle dba 119582976 Feb 3 2008 oracle
Here the oracle file permission has -rwxrwxr-x i.e. 775, but this file must have the permission -rwsr-s- -x i.e. 6751

Change the permissions for oracle file.

$ cd $ORACLE_HOME/bin
$ chmod 6751 oracle
$ ls -l oracle
-rwsr-s--x 1 oracle dba 119582976 Feb 3 2008 oracle
After changing the permissions on oracle executable file, all the users are now able to connect to the database without any errors.

Note: For further information refer the Oracle Metalink Note ID: 1011995.6 Subject: COMMON ORACLE PERMISSION PROBLEMS ON UNIX.

Sabdar Syed

How important is having Unix/Linux OS Knowledge for Oracle DBAs?


Hello,I wanna wish you all a very Happy New Year 2009 before being discussed on “How Important Having UNIX OS Knowledge for Oracle DBA?”The main reason for discussing this topic is to encourage the novice or junior DBAs to have command on Unix/Linux Operating System as part of Database Administration. Because, when they were asked how comfortable they are working as DBA on Unix/Linux environment, then their responses are as following.“They are pretty much comfortable working and administrating the databases on Windows Operating System as they were trained on administrating the database on Windows OS during their DBA Training”“They are not enough confident in using the Unix/Linux OS commands to administer the databases”“We didn’t get the chance yet to maintain the database on UNIX environment including Solaris, HP-Unix, IBM AIX, etc.”“Working on windows environment is easier than working on Unix/Linux environment as it’s only required, on Windows OS, to select the files physically/copy/cut & paste from one location to another, or delete the files, and stopping the services by simply clicking, where as in Unix/Linux, one should use commands manually for the same”…. and so on.If anyone is with the above impression about administrating databases on Unix/Linux OS, then here are my suggestions as follows.First of all, it’s not compulsory for DBAs to have operating system administration skills. But, working knowledge, on both the operating systems including Windows and Unix/Linux, is always value added to Oracle DBAsThe majority of the production database administration on Unix/Linux based operating systems is enormous in the globe, i.e. very large and mission critical databases are being maintained on Unix/LinuxOS.Obviously, all big companies require the database administrator who’s having good UNIX scripting knowledge and working knowledge of UNIX based environments. It means that the Oracle DBAs, having good working knowledge of UNIX, have demand in the IT market.Even though the DBAs intervention is manual in terms of creating directories, files, setting up environment variables, and starting/stopping the services in Unix environment, it’s very easy as good as maintaining in Windows environment. Administration and OS commands are more or less similar on any flavor of Unix/Linux Operating system i.e. Solaris, HP-Unix, IBM AIX, Red Hat, Fedora, Ubuntu, etc., So, start practicing Oracle database administration on Unix/Linux based systems.Probably, it may be difficult to have Unix OS installed in the personal computer for practical purpose. So, download the free/trail version of Linux (Oracle Unbreakable Linux) from Oracle, install and configure in the PC, and start practicing on Linux. To practice on different Unix/Linux OS flavors, get your pc installed with the VM Ware, where you can set up multiple and different flavors of Unix/Linux OS.Note: Of course, this post is not for showing the difference between Windows and Unix/Linux Operating Systems as every OS has its own significance, but to encourage the Oracle DBAs to learn the commands of Unix/Linux required administering the databases.Quick Links:Download: Enterprise Linux and Oracle VM Information: Oracle and Linux Installation Guides: Oracle 10g Instalaltion on Unix/Linux OS Books: Oracle9i UNIX Administration Handbook Linux Recipes for Oracle DBAs Training: Oracle Database 10g: Managing Oracle on Linux for DBAs Exam: Oracle Database 10g: Managing Oracle on Linux Certified Expert Oracle ** Your comemnts and inputs are welcomed to this post. ** Regards,Sabdar Syed[...]

I’m an Oracle ACE Award Winner now !


Dear All,

I’m pleased to inform you all that I have received an email from Oracle ACE Program Committee that I have been nominated for the prominent Oracle ACE Award. I’m honored to be the second person working in the Saudi Arabia to be an Oracle ACE.

Hope you are curious to know who the first person is working in the Saudi Arabia to be an Oracle ACE. Well, he is none other than my elder brother & mentor – Mr. Syed Jaffar Hussain . We are proud to be the Oracle ACE brothers from one family members and I can say, this kind of achievement is a unique combination, isn’t it?

Take a look at my Oracle ACE Profile – Sabdar Syed.

I would like to convey my sincere thanks to my elder brother, colleagues, ex-colleagues, blog viewers, friends and well-wishers for their support to aim this award.


Thanks to Mr. Mohan Dutt, OCP Advisor, for publishing about my achievement, Oracle ACE Award, in his blog - OCP Blog Community.

Take a look at - Featured Expert Wins Oracle ACE Award!

Your precious comments are welcomed!

Sabdar Syed.

Download Free Oracle Certification Dumps Here!!


This blog post is for them; those who are desperately looking for free Oracle Certification dumps.

Well, you might be surprised to see the message of the post is irrelevant to the subject. All my intension is to bring your attention towards How bad it is? Cheating the Oracle Certifications by simply reading the exam dumps”.

Mr. Paul Sorensen, Director of Oracle Certification, and other certification team members have launched the Oracle Certification Blog , where they blog about everything on Oracle Certification. Interestingly, there are a couple of blog posts on Cheating Hurts the Oracle Certification Program” and others.

For list of blog posts on Cheating, then take a look at – Cheating Oracle Certifications . Do not forget to read the comments of every post in the above link.

Quick Links to Prepare for Oracle Certification


OCA, OCP, OCE, Dumps, Brain dumps, Practice Questions, Sample Questions, Cheat sheet, Test papers.

Sabdar Syed.

Should I go for Oracle 10g OCA/OCP or 11g OCA/OCP Certification?


Hello All,Choosing whether to go for Oracle 10g OCA/OCP or 11g OCA/OCP Certification is becoming complex to the Novice or Newbie DBAs. And also, I have seen a couple of posts asking such similar certification doubts more frequently in the OTN Forums, when they are not really sure or confused.Well, this is ever been told by everyone that going for latest version certification is good and ideal. But, what I advise is, first go for Oracle 10g OCA and OCP, then upgrade to Oracle 11g OCP.Following are my views on why to go for Oracle 10g OCA/OCP initially rather than 11g OCA/OCP directly.As we all know that newer version (11g) does include older version features plus new features and bug fixes of older version issues.Retirement date for Oracle 10g Certification has not yet been announced by Oracle. Moreover, Oracle Database 11g: Administration I (OCA) exam is only on production i.e. regular and Oracle Database 11g: Administration II (OCP) exam is not yet gone for Production i.e. still Beta Exam.Oracle Database 10g is still being used as Production for the business in all most all the organizations in the globe. But very less companies are using the Oracle Database 11g for their business, as Oracle 11g is still a base release and yet to go for standard release 11g (11.2.X.X) shortly. This means that Oracle 11g is not fully deployed or used for Production purpose yet.Oracle Database 10g Release (10.2) still has Oracle primary and extended (Metalink) support for few more years from now, after that Oracle 10g will also be de-supported by Oracle.Both versioned (10g and 11g) certifications have two exams – Administration I (OCA) and Administration II (OCP). Each exam fees of them is $125 US i.e. there is no vary.It’s mandatory for the OCP candidates to undergo one approved course from the Approved list of Oracle University Courses for hands on course requirement. This applies to both Oracle 10g and 11g Certification takers.For Oracle 10g OCP Certification holders, there is only one exam 1Z0-050 - Oracle Database 11g: New Features for Administrators given to upgrade directly to the Oracle 11g OCP. No course or hands on course requirement form is to be submitted to achieve the Oracle 11g OCP (Upgrade) Certification.In this way, one will have both Oracle 10g and 11g Certifications in hand, and can show the same in their resume or CV. This also fulfills the requirement where the companies are looking for the candidates those are having enough experience with Oracle 10g and 11g, and holding multiple certifications in it.One can go for direct Oracle 11g Certification under the following circumstances.If you are forced, by your company or manager, to undergo Oracle 11g Course and take Oracle 11g Certification Exams, for their specific requirement on Oracle Database 11g related projects.When there is no Oracle 10g course listed in the training institute in your city, instead only Oracle 11g Courses are available.When unable to afford to take Oracle 11g Upgrade exam.If my above views are not Okay with you -:)Note: Folks, above are only my views, and need not to be the same with others. So, it’s left up you to decide whether to go for Oracle 10g OCA/OCP or 11g OCA/OCP Certification. For any information or doubts, then refer the Oracle Certification Program link and navigate yourself to the options to know more about Beta Exams, Retirements, List of Exams, Upgrade your Certification, Hands on Course Requirement etc.,Your comments are welcomed if this article information helps you.Regards,Sabdar Syed,[...]

Celebrating Second Year Anniversary of the Blog Launch


Dear My Blog Readers,

It's been two years that I have lanuched and updated my blog by today. The blog originally started on 12-Dec-2006.

During the last year, I wrote and published good articles. I would like to thank all of my blog viewrs who made my blog popular by reading the interesting posts in m blog.

I hope, I would write more and more good articles which my blog viwers definitely like them and definitely get benifit from them.

Feel free to give comments, suggestions, and advices to improve this blog with more articles.

Once again thank you all.


Sabdar Syed,

Oracle Approved Training Centers and Certification Test Sites & Address - Kingdom of Saudi Arabia


Hello All,Here is the list of Oracle University Approved Educational Training Partners/Centers, and the certification test taking sites in Saudi Arabia.Oracle University Approved Education Partners - Kingdom of Saudi ArabiaNew Horizons Jeddah - Oracle Approved Education CenterP.O. Box : 52171Telephone : 026642277Fax : 026642454Address : Al Rawda St, Jeddah ,KSANew Horizons Khobar - Oracle Approved Education CenterP.O. Box : 2060Telephone : 038588882Fax : 038584014Address : AL Khaleej Blg, Khobar, KSAAl-Khaleej Training and Education Co.(New Horizons Computer Learning Center,KSA)Al Wallan Building,Takhasusi Street,Riyadh,Kingdom of Saudi ArabiaContact: Louai Al-Amir Salem, PMPTitle: Platinum Center ManagerTel: 009661 416 0123 Ext. 400Prometric Test Sites and Address for taking Oracle Certifications OCA/OCP/OCERiyadh:=======NEW HORIZONS COMPUTER LEARNINGABOVE AL WALAN SHOW ROOMAL KHURAIS ROAD NEAR AL AZIZAPANDA TAKAHASSUI PO 295300RIYADH 11351Phone: 14160123 Site Code: SU7NEW HORIZONS COMPUTER LEARNINGOlya Main StreetBehind Jareer BookstoreAl Khaleej Ladies CenterNewhorizons P O Box 295300RIYADH 11351Phone: 1462 8393 Site Code: SU7M1ALFAISAL INTERNATIONAL ACADEMYIMAM SAUD BIN ABDULAZIZ ROADKING FAHED DISTRICTPO BOX 10202RIYADH 11433Phone: 14552444 Site Code: SU60ExecuTrain of RiyadhZero Floor, South Bldg.Khaledyah Business Centre ,Olaya St .Riyadh 11351Phone: 14621118 Site Code: SU74Jiddah:======NEW HORIZONS COMPUTER LEARNING CENTREAMIR ABDULLAH STREETAL RAWDAH DISTRICT 1ST FLOORPO BOX 52171JEDDAH 21563Phone: 966 2 6642277 Site Code: SU5ARABIAN COMPUTER PROJECTS CO.Ibrahim Juffali Road(P.O.Box 14730)Jeddah 21434Phone: 966 26678411 Site Code: SU59Others Cities:==========New Horizons Computer Learning CentreAl-Khaleej Training & Education CompanyAL-FAYHA, NEAR CENTRAL MARKETPO Box 10968JUBAIL INDUSTRIAL CITY 31961Phone: 966 3 348 1166 Site Code: SU52New Horizons Computer Learning CenterAl Khaleej Training and EducationDhahran StreetMubarazAl Ahsa 31982Phone: 966 3 5305007 Site Code: SU55New Horizons Computer Learning CenterKhalid Bin Walid StreetCircle Masjid QiblateinMadinah 1875Phone: 48223333 Site Code: SU48Philippine International School RuraydahPISBInformation Technology Dept.Faiziyah DistrictP.O. Box 27089Buraydah, Al Qasim 51331Phone: 966 63841975 Site Code: su120Al-Khaleej Training and Edu. Mens BranchNew Horizons CLCKSA - King Saud StreetBuridah, Al Qasim 51432Phone: 966 6 3827999 Site Code: SU54NEW HORIZONSAL-AHSA 31982DHARAN STREET MUBARAZPO BOX 5822HOFUFPhone: 966 530 5007 444 Site Code: SU17AL-KHALEEJ TRAINING AND EDUCATIONNEW HORIZONS CLCAL-DIYAFAH STREETP.O BOX 50991ETWIDKHAMIS MUSHAIT 61311Phone: 72375051 Site Code: SU57NEW HORIZONS TABUK BRANCH50 STREET NEW HORIZONS BLDTABUKPhone: 966 4424 8613 Site Code: SU39Note: Check the below URLs, if the details given above are found incorrect.,Sabdar Syed.[...]

How to find the particular Data Dictionary Table or Dynamic Performance View (V$)?


Dear Blog Readers,

Even though we use some of the important Data Dictionary Tables and Dynamic Performance (V$) views regularly, sometimes we fall short to recall a particular view, i.e. It’s not easy to remember all the dictionary views.

And also, many times, it’s been asked by novice in the OTN Forums that

What is the view to find the information about data files, tablespaces, etc.,?

What are the list of Data Dictionary and Dynamic Performance Views in so and so Oracle Version?

Well, I hope all of we know that there is a data dictionary view called “DICTIONARY”, using this DICTIONARY view, we can find the particular or list of pertinent views of any object in the database.

What is the DICTIONARY view?

The DICTIONARY view is a data dictionary view used to find the list of Data Dictionary and Dynamic Performance (V$) views, and it contains description of data dictionary tables and views. It has two columns, one is ‘TABLE_NAME’ – Name of the object and another column is ‘COMMENTS’ – Text comment on the object.


Name Null? Type
--------------------- -------- --------------


To find the list of data dictionary tables and dynamic performance views.


To find the particular data dictionary table or dynamic performance view.

SELECT * FROM dictionary
WHERE table_name LIKE ‘%Search String%’;


SELECT * FROM dictionary
WHERE table_name LIKE ‘%TABLESP%’;


SQL> SELECT * FROM dictionary
WHERE table_name='DICTIONARY';

Description of data dictionary tables and views

Note: While querying, either the complete word DICTIONARY or first four characters DICT, which is a synonym for DICTIONARY, can be used.

Reference: Oracle® Database Reference 10g Release 2 (10.2)


Sabdar Syed

Received the Certification Kit of Oracle 10g RAC Expert Exam.


Dear Friends,

After a long wait, I have received the Oracle 10g RAC Expert Certification Kit in my hands today, as I have already taken this exam (1Z0-048) in the month of August-2008. More or less it took more than three months to reach in my hands.

Best of luck everyone who is preparing for the Oracle 10g RAC Expert Exam – 1Z0-048.

Check my other blog post on “How to prepare for 1Z0-048 - Oracle 10g RAC Certified Expert Exam.”

Sabdar Syed,

How to Get/Gain Real Time Experience/Exposure as a DBA!


Dear Blog Readers,Every now and then I do receive e-mails from the novice DBAs saying that:“We could not perform well at the interview, as the questions were too technically based on real time requirements”“Due to not having real time experience, we failed at the interview to explain the steps/approach to resolve the issue asked”…… and so onWhen I asked them how they prepare and practice the DBA Activities, their response is as follows:“We brought the Oracle DBA Books written by so and so authors for reference.”“We only practiced the scenarios what was taught and given as drill in the training institute.”“We installed the Oracle Software with starter database and get started practicing.”…… and so onWell, here are my opinions/suggestions/advices, to them those who are preparing and practicing as above, to gain the real time experience/exposure.A lot of novice or junior DBAs are out there, who do not know that Oracle offers online documentations on Oracle Database Administration. Rather they simply purchase the available books in the market and get started preparing it. I would advice them to make a habit of reading the Oracle online documentations daily whenever they have time.As far as I know, in the training institutes, the trainers will only cover the basic and required information up to some level, and discussed the scenarios which are common and basic. I suggest them to not to treat those scenarios as real time questions. The trainers will give you or left up to you to practice and do the drill at your own.In my opinion, the real time issues are not different from the issues you face while practicing. i.e. fixing the ORA-Errors generated. My strong advice is not to create the database while installing the database, instead create the database manually with very minimal size of SGA and data files. Then, put more load i.e. Insert/Updates/Deletes and look forward for errors and the slowness of database, then fix them and tune the database accordingly. This will not be possible where you have a database with good size of SGA and enough size of data files.As a real time requirement, install and set up the Oracle Server on Linux Operating System, this confidence will help you in stalling the same on any flavor of the Unix/Linux operating system i.e. Sun Solaris, IBM AIX, HP-UX, Red Hat, Fedora etc, All you need to know that the commands which are specific to OS during the installation.Never just be satisfied by simply reading the solutions given over the web for such problem which are treated as real time scenarios, rather try to reproduce the problem in your database system, if you can, and do apply the different solutions for that issue.Do not mug up the procedural steps of any major activity in the database i.e. Upgrade, Migration, Installation, etc.., Even though these are not regular tasks or not possible to do it in the practice systems, I still insist to feel the taste of doing such activities. I can say these are the real time scenarios asked in the interviews.There are many a lot to say…but at the end what all I can say is…..Instead of waiting for not having the proper resource to practice the database real time scenarios or activities, at least try to search over the web to get to know what are other real time scenarios, I would strongly advice one to make a habit of regularly visiting OTN Database General Forums, where all kind of basic, advanced, real time, scenarios are questioned and answered by top experts with different and different solutions.Forum: Database - General Another good habit is referring the good Oracle Rel[...]

Oracle Metalink Notes for Oracle Apps DBAs.


Dear Friends,Here are the list of Oracle Metalink Notes, I do refer regularly. Moreover, these are very informative. So, I thought of sharing those note ids here with you.Note: You have to have an account in Oracle Metalink to access notes.Installation Note: 452120.1 - How to locate the log files and troubleshoot RapidWiz for R12Note: 329985.1 - How to locate the Rapid Wizard Installation log files for Oracle Applications 11.5.8 and higherNote: 362135.1 - Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage ManagementNote: 312731.1 - Configuring Oracle Applications Release 11i with 10g RAC and 10g ASMNote: 216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)Note: 279956.1 - Oracle E-Business Suite Release 11i with 9i RAC: Installation and Configuration using AutoConfigNote: 294932.1 - Recommendations to Install Oracle Applications 11iNote: 403339.1 - Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 UpgradeNote: 455398.1 - Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11iNote: 402311.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft WindowsNote: 405565.1 - Oracle Applications Release 12 Installation GuidelinesAD UtilitiesNote: 178722.1 - How to Generate a Specific Form Through AD utility ADADMINNote: 109667.1 - What is AD Administration on APPS 11.0.x ?Note: 112327.1 - How Does ADADMIN Know Which Forms Files To Regenerate?Note: 136342.1 - How To Apply a Patch in a Multi-Server EnvironmentNote: 109666.1 - Release 10.7 to 11.0.3 : What is adpatch ?Note: 152306.1 - How to Restart Failed AutoInstall JobNote: 356878.1 - How to relink an Applications Installation of Release 11i and Release 12Note: 218089.1 - Autoconfig FAQNote: 125922.1 - How To Find Oracle Application File VersionsCloning Note: 419475.1 - Removing Credentials from a Cloned EBS Production DatabaseNote: 398619.1 - Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)Note: 230672.1 - Cloning Oracle Applications Release 11i with Rapid CloneNote: 406982.1 - Cloning Oracle Applications Release 12 with Rapid CloneNote: 364565.1 - Troubleshooting RapidClone issues with Oracle Applications 11iNote: 603104.1 - Troubleshooting RapidClone issues with Oracle Applications R12Note: 435550.1 - R12 Login issue on target after cloningNote: 559518.1 - Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid CloneNote: 216664.1 - FAQ: Cloning Oracle Applications Release 11iPatchingNote: 225165.1 - Patching Best Practices and Reducing DowntimeNote: 62418.1 - PATCHING/PATCHSET FREQUENTLY ASKED QUESTIONSNote: 181665.1 - Release 11i Adpatch BasicsNote: 443761.1 - How to check if a certain Patch was applied to Oracle Applications instance?Note: 231701.1 - How to Find Patching History (10.7, 11.0, 11i)Note: 60766.1 - 11.0.x : Patch Installation Frequently Asked QuestionsNote: 459156.1 - Oracle Applications Patching FAQ for Release 12Note: 130608.1 - AdPatch BasicsNote::60766.1 - Patch Installation FAQ (Part 1)UpgradeNote: 461709.1 - Oracle E-Business Suite Upgrade Guide - PlanNote: 293166.1 - Previous Versions of e-Business 11i Upgrade Assistant FAQNote: 224875.1 - Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)Note: 224814.1 - Installation, Patching & Upgrade Current IssuesNote: 225088.1 - Installation, Patching & Upgrade Patches GuideNote: 225813.1 - Installation, Patching & Upgrade Setup and Usa[...]

My Blog Feedback Page


Dear Blog Readers,

I wanted to have a feedback page as a post in my blog where my blog viewers can post their valuable comments and suggestion about my blog and articles.

In order to serve you better with required information in my blog, please leave your comments/suggestions/doubts/questions/requirements/ etc.

Link for comments here - Feedback Page !

Please check the comments submitted in the comments item below.

Thanks & Regards,
Sabdar Syed.

How I Changed My Blog with 3 Column Template and Right & Left Sidebars?


I have been looking for the steps/code to prepare my blog with 3 column template, but couldn’t get a proper reference for that. Luckily, today I came across a wonder full blog for “3 Column Templates Step by Step Guides”, which will fit to my blog template.

It’s as easy as simple.

Step -1: Before going to change the original template, I gave a try on the test template by creating a new blogspot for testing perpose ( This Step-1 is optional)

Step -2: Take the backup of template before trying out any customization that requires direct modification of the HTML code of original template.

Step -3: Follow the below link.

3 Column Templates : Rounders : Left and Right Sidebars

For other type of templates, then check this

3 Column Templates: Step by Step Guides


Sabdar Syed.

How We Resolved the Account Locked (Timed) issue?


An application user account, in one of our Oracle 10g Databases, is being locked every time. Below are our findings and solution to resolve the issue.Details:Oracle Database Version: 10g R2 ( User: APPUSRError: ORA-28000: the account is lockedLogin as SYSDBASQL> conn /as sysdbaCheck the APPSUSR account status.SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;USERNAME ACCOUNT_STATUS PROFILE-------------------- -------------------- ---------------APPUSR LOCKED(TIMED) DEFAULTHere we can see the account status is LOCKED (TIMED) and the default user’s profile is DEFAULT.Check the resource limits of DEFAULT profile.SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';RESOURCE_NAME RESOURCE LIMIT-------------------------------- -------- ----------COMPOSITE_LIMIT KERNEL UNLIMITEDSESSIONS_PER_USER KERNEL UNLIMITEDCPU_PER_SESSION KERNEL UNLIMITEDCPU_PER_CALL KERNEL UNLIMITEDLOGICAL_READS_PER_SESSION KERNEL UNLIMITEDLOGICAL_READS_PER_CALL KERNEL UNLIMITEDIDLE_TIME KERNEL UNLIMITEDCONNECT_TIME KERNEL UNLIMITEDPRIVATE_SGA KERNEL UNLIMITEDFAILED_LOGIN_ATTEMPTS PASSWORD 10PASSWORD_LIFE_TIME PASSWORD UNLIMITEDPASSWORD_REUSE_TIME PASSWORD UNLIMITEDPASSWORD_REUSE_MAX PASSWORD UNLIMITEDPASSWORD_VERIFY_FUNCTION PASSWORD NULLPASSWORD_LOCK_TIME PASSWORD UNLIMITEDPASSWORD_GRACE_TIME PASSWORD UNLIMITEDAll resource limits for DEFAULT profile is set to UNLIMITED, but only for FAILED_LOGIN_ATTEPTS attribute, it’s set to some value (10). Due to this the user account keeps getting locked(timed).When we check in the Oracle Documentations, it’s stated that FAILED_LOGIN_ATTEPTS attribute for DEFAULT profile has been changed from from UNLIMITED to 10.What we can do is, either we may need to change the resource limit for FAILED_LOGIN_ATTEPTS attribute in DEFAULT profile, or create a new profile for that user with FAILED_LOGIN_ATTEPTS attribute value set to UNLIMITED. But for security reasons, we will not tamper the DEFAULT profile, which is not recommended too. Then let’s go for creating a new profile and assign that profile to the user.Create a profile.SQL> CREATE PROFILE APPUSR_DEFAULT LIMIT2 COMPOSITE_LIMIT UNLIMITED3 SESSIONS_PER_USER UNLIMITED4 CPU_PER_SESSION UNLIMITED5 CPU_PER_CALL UNLIMITED6 LOGICAL_READS_PER_SESSION UNLIMITED7 LOGICAL_READS_PER_CALL UNLIMITED8 IDLE_TIME UNLIMITED9 CONNECT_TIME UNLIMITED10 PRIVATE_SGA UNLIMITED11 FAILED_LOGIN_ATTEMPTS UNLIMITED12 PASSWORD_LIFE_TIME UNLIMITED13 PASSWORD_REUSE_TIME UNLIMITED14 PASSWORD_REUSE_MAX UNLIMITED15 PASSWORD_VERIFY_FUNCTION NULL16 PASSWORD_LOCK_TIME UNLIMITED17 PASSWORD_GRACE_TIME UNLIMITED;Profile created.Assign the newly created profile to the user as default profile.SQL> ALTER USER appusr PROFILE appusr_default;User altered.Unlock the user account:SQL> ALTER USER appusr ACCOUNT UNLOCK;User altered.Now check again the status of APPUSR user.SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;USERNAME ACCOUNT_STATUS PROFILE-------------------- -------------------- ---------------APPUSR OPEN APPUSR_DEFAULTRegards,Sabdar Syed,[...]

My Mentor is an Oracle Certified Master in Oracle 10g now!


Dear All,

I’m pleased to say that my elder brother, Mr. Syed Jaffar Hussain, is an Oracle Certified Master in Oracle 10g now. He is truly deserved for it. In addition to this, he is already an Oracle Certified Professional in multiple tracks such as Oracle 10g/9i/8i, RAC DBA Expert, and also an Oracle ACE Award winner.

He is my mentor and motivator. So, I will have to gear up for Oracle Certified Master Program, and get trained under his guidance for the same.

Sabdar Syed,

Metalink is now My Oracle Support!


Yesterday, when I logged in to Oracle Metalink, I saw a new look of Metalink, and also Oracle Metalink Support has now been renamed to


As per My Oracle Support:

“Introducing My Oracle Support, the next generation MetaLink experience. My Oracle Support offers you secure, real-time access to Oracle experts on the complete Oracle software stack. It also provides groundbreaking personalized & proactive support capabilities that help reduce unplanned down time and improve system stability. Leverage the Internet for immediate access to 24/7 support and get the critical and timely information you need for running your usiness.”

A new look of My Oracle Support



Important Blog on new look of My Oracle Support.

Introducing... My Oracle Support!

Classic MetaLink vs. New MetaLink — What’s the Difference?

Sabdar Syed,

How to make a Link to be opened in a New Browser Window?


It's as easy as follows:

To get a link or URL, you specified or referred in your blogs, to be opened in a separate New Browser Window, what you need to do is add the target="_blank" attribute to your link tag i.e. in in the HTML code.

For Example:

  <a href="" target="_blank">  This is My BlogSpot!</a>
This will give you the following link:

This is My BlogSpot!

This is useful when you do not want to open a link, you specified or referred in your blog, to open in the same window, rather it should open in a new browser window, by keeping original post open.

Sabdar Syed,