tag:blogger.com,1999:blog-47772972530910211822024-03-07T15:23:41.507-08:00Oracle DBA and Apps DBA blogImportant: The things, which are discussed here, are my own views and findings, please test them from your side too before you apply.Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.comBlogger92125tag:blogger.com,1999:blog-4777297253091021182.post-65442739662394427442014-09-17T14:24:00.002-07:002014-09-17T14:24:30.764-07:00No Write Permission on ACFS Mount Point<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
Last night, I managed to create the ACFS Mount Point after resolving the issue <a href="http://sabdarsyed.blogspot.com/2014/09/acfs-9459-asvmacfs-is-not-supported-on.html" target="_blank"><i><span style="color: blue;">"ACFS-9459: ASVM/ACFS is not supported on this os version"</span></i></a>. But, after creating the ACFS Mount Point, I'm unable to create or touch any files under this ACFS Mount Point.<br />
<br />
Though, I tried to touch a file to create files under this ACFS Mount Point using OS User <i>Oracle </i>and <i>Root</i>, it's failing with the following error:<br />
<br />
<span style="color: red;"><b><i>"touch: cannot touch `x': Permission denied"</i></b></span><br />
<br />
<u>Here are the steps I tried and got the error:</u><br />
<br />
The ACFS Mount Point "<span style="font-family: Courier New, Courier, monospace;">/oracle/prd</span>" has been created on <i>Linux 6.5</i> server using Oracle <i>ASMCA </i>tool, and this "<span style="font-family: Courier New, Courier, monospace;">/oracle/prd</span>" mount point has <i><span style="font-family: Courier New, Courier, monospace; font-size: x-small;">775 </span></i>permission.<br />
<br />
<u><i><b>As Oracle User:</b></i></u><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[oracle@Linux01 ~]# <span style="color: blue;">df -m|grep -i asm</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">/dev/asm/oracle_prd-77 35840 148 35693 1% /oracle/prd</span><br />
<span style="font-family: Courier New, Courier, monospace;">[</span><span style="font-family: 'Courier New', Courier, monospace;">oracle</span><span style="font-family: Courier New, Courier, monospace;">@Linux01 ~]# <span style="color: blue;">cd /oracle/prd</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">[</span><span style="font-family: 'Courier New', Courier, monospace;">oracle</span><span style="font-family: Courier New, Courier, monospace;">@Linux01 prd]# <span style="color: blue;">pwd</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">/oracle/prd</span><br />
<span style="font-family: Courier New, Courier, monospace;">[</span><span style="font-family: 'Courier New', Courier, monospace;">oracle</span><span style="font-family: Courier New, Courier, monospace;">@Linux01 prd]# <span style="color: blue;">ls -ld /oracle/prd</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">drwxrwxr-x. 4 oracle dba 4096 Sep 15 19:29 /oracle/prd</span><br />
<span style="font-family: Courier New, Courier, monospace;">[</span><span style="font-family: 'Courier New', Courier, monospace;">oracle</span><span style="font-family: Courier New, Courier, monospace;">@Linux01 prd]# <span style="color: blue;">ls</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">lost+found</span><br />
<span style="font-family: Courier New, Courier, monospace;">[</span><span style="font-family: 'Courier New', Courier, monospace;">oracle</span><span style="font-family: Courier New, Courier, monospace;">@Linux01 prd]# <span style="color: blue;">touch abc</span></span><br />
<span style="color: red; font-family: Courier New, Courier, monospace;">touch: cannot touch `abc': Permission denied</span><br />
<span style="font-family: Courier New, Courier, monospace;">[</span><span style="font-family: 'Courier New', Courier, monospace;">oracle</span><span style="font-family: Courier New, Courier, monospace;">@Linux01 prd]#</span><br />
<br />
<u><i><b>As Root user:</b></i></u><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 ~]# <span style="color: blue;">df -m|grep -i asm</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">/dev/asm/oracle_prd-77 35840 148 35693 1% /oracle/prd</span><br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 ~]# <span style="color: blue;">cd /oracle/prd</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]# <span style="color: blue;">pwd</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">/oracle/prd</span><br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]# <span style="color: blue;">ls -ld /oracle/prd</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">drwxrwxr-x. 4 oracle dba 4096 Sep 15 19:29 /oracle/prd</span><br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]# <span style="color: blue;">ls</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">lost+found</span><br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]# <span style="color: blue;">touch abc</span></span><br />
<span style="color: red; font-family: Courier New, Courier, monospace;">touch: cannot touch `abc': Permission denied</span><br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]#</span><br />
<br />
The problem was the SELinux is <i>enabled </i>on the Linux System.<br />
<br />
To check, if SELinux is enable/disable on the system, cat the file <span style="font-family: Courier New, Courier, monospace;">"/etc/selinux/config"</span><br />
<u><i><b>Note:</b></i></u> Used the <i>root </i>login to do the following steps:<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01]# <span style="color: blue;">cat /etc/selinux/config</span></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;"># This file controls the state of SELinux on the system.</span><br />
<span style="font-family: Courier New, Courier, monospace;"># SELINUX= can take one of these three values:</span><br />
<span style="font-family: Courier New, Courier, monospace;"># <span style="color: red;">enforcing </span>- SELinux security policy is enforced.</span><br />
<span style="font-family: Courier New, Courier, monospace;"># permissive - SELinux prints warnings instead of enforcing.</span><br />
<span style="font-family: Courier New, Courier, monospace;"># disabled - No SELinux policy is loaded.</span><br />
<span style="font-family: Courier New, Courier, monospace;"><b>SELINUX=<span style="color: red;">enforcing</span></b></span><br />
<span style="font-family: Courier New, Courier, monospace;"># SELINUXTYPE= can take one of these two values:</span><br />
<span style="font-family: Courier New, Courier, monospace;"># targeted - Targeted processes are protected,</span><br />
<span style="font-family: Courier New, Courier, monospace;"># mls - Multi Level Security protection.</span><br />
<span style="font-family: Courier New, Courier, monospace;">SELINUXTYPE=targeted</span><br />
<br />
Or use the <i><u><span style="font-family: Courier New, Courier, monospace; font-size: x-small;">sestatus </span></u></i>command to check the status.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[root@geprdb850 prd]# sestatus</span><br />
<span style="font-family: Courier New, Courier, monospace;">SELinux status: enabled</span><br />
<span style="font-family: Courier New, Courier, monospace;">SELinuxfs mount: /selinux</span><br />
<span style="font-family: Courier New, Courier, monospace;">Current mode: <span style="color: red;">enforcing</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">Mode from config file: disabled</span><br />
<span style="font-family: Courier New, Courier, monospace;">Policy version: 28</span><br />
<span style="font-family: Courier New, Courier, monospace;">Policy from config file: targeted</span><br />
<br />
<b><u>Here is how to disable SElinux:</u></b><br />
<br />
<u><i>Method 1</i></u>- Edit <span style="font-family: Courier New, Courier, monospace;">"/etc/selinux/config"</span> and set the SELINUX variable to 'disabled'<br />
<u><i>Method 2</i></u>- Use the <i><span style="font-family: Courier New, Courier, monospace;">setenforce </span></i>command to disable on-the-fly<br />
<br />
If you go with Method 1, then your changes are permanent but only effective if you reboot the machine.<br />
<br />
If you go with Method 2, then your changes are NOT permanent but effective immediately.<br />
<br />
<u><i><b>Method 1: (Permanent Change)</b></i></u><br />
<br />
Take the backup of <span style="font-family: 'Courier New', Courier, monospace;">"/etc/selinux/config"</span> file.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01]# <span style="color: blue;">cp /etc/selinux/config /etc/selinux/config.bkp</span></span><br />
<br />
Then edit <span style="font-family: 'Courier New', Courier, monospace;">"/etc/selinux/config"</span> the file and set the SELinux variable to '<i>disabled</i>'<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01]# <span style="color: blue;">cat /etc/selinux/config</span></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;"># This file controls the state of SELinux on the system.</span><br />
<span style="font-family: Courier New, Courier, monospace;"># SELINUX= can take one of these three values:</span><br />
<span style="font-family: Courier New, Courier, monospace;"># enforcing - SELinux security policy is enforced.</span><br />
<span style="font-family: Courier New, Courier, monospace;"># permissive - SELinux prints warnings instead of enforcing.</span><br />
<span style="font-family: Courier New, Courier, monospace;"># <span style="color: red;">disabled </span>- No SELinux policy is loaded.</span><br />
<span style="font-family: Courier New, Courier, monospace;"><b>SELINUX=<span style="color: red;">disabled</span></b></span><br />
<span style="font-family: Courier New, Courier, monospace;"># SELINUXTYPE= can take one of these two values:</span><br />
<span style="font-family: Courier New, Courier, monospace;"># targeted - Targeted processes are protected,</span><br />
<span style="font-family: Courier New, Courier, monospace;"># mls - Multi Level Security protection.</span><br />
<span style="font-family: Courier New, Courier, monospace;">SELINUXTYPE=targeted</span><br />
<br />
<b>Then reboot the server!!</b><br />
<br />
<u><i><b>Method 2: (On-the-fly)</b></i></u><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01]# <span style="color: blue;">getenforce</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">Enforcing</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01]# <span style="color: blue;">setenforce</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">usage: setenforce [ Enforcing | Permissive | 1 | 0 ]</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]# <span style="color: blue;">setenforce 0</span></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01 prd]# <span style="color: blue;">sestatus</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">SELinux status: enabled</span><br />
<span style="font-family: Courier New, Courier, monospace;">SELinuxfs mount: /selinux</span><br />
<span style="font-family: Courier New, Courier, monospace;">Current mode: permissive</span><br />
<span style="font-family: Courier New, Courier, monospace;">Mode from config file: disabled</span><br />
<span style="font-family: Courier New, Courier, monospace;">Policy version: 28</span><br />
<span style="font-family: Courier New, Courier, monospace;">Policy from config file: targeted</span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">[root@Linux01]# <span style="color: blue;">getenforce</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">Disabled</span><br />
<br />
After the SELinux is <i>disabled</i>, then creating the files under ACFS Mount Point is succeeded.<br />
<br />
<u><i><b><span style="background-color: #cccccc; color: red;">Note:</span></b></i></u> The above commands have to be completed by <i>root </i>user and do this under <i>system admin</i> supervision.<br />
<br />
<b>Regards,</b><br />
<b>Sabdar Syed.</b><br />
<b><br /></b>
<b><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com</a></b><br />
<br /></div>
Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-37734173140668459122014-09-16T13:50:00.000-07:002014-09-17T14:24:55.893-07:00ACFS-9459: ASVM/ACFS is not supported on this os version<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
After installing the Grid Infrastructure (GI) home on two Node RAC 11gR2 (11.2.0.4) on Linux 6.5 servers, I tried to create the ACFS filesystem using ASMCA tool to have Oracle (RDBMS) Home. But, the option tabs <i>"Volumes"</i> and <i>"ASM Cluster File Systems"</i> in ASMCA toll were disabled, due to this we were unable to create volume and cluster filesystem and got the following error:<br />
<br />
<b><span style="color: red;"><i>"ACFS-9459: ASVM/ACFS is not supported on this os version: '3.8.13-16.2.1.el6uek.x86_64'"</i></span></b><br />
<br />
I had checked the "ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)" under the section "ACFS 11.2.0.4 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".<br />
<br />
After download the suggested Opatch and while installing the opatch, the following errors were encountered:<br />
<br />
<i><span style="color: red;">"The opatch minimum version check for patch <patch_home>/16318126/custom failed for <gi_home></gi_home></patch_home></span></i><br />
<i><span style="color: red;">The opatch minimum version check for patch <patch_home>/16318126/etc failed for <gi_home></gi_home></patch_home></span></i><br />
<i><span style="color: red;">The opatch minimum version check for patch <patch_home>/16318126/files failed for <gi_home></gi_home></patch_home></span></i><br />
<i><span style="color: red;">Opatch version check failed for oracle home <gi_home></gi_home></span></i><br />
<i><span style="color: red;">Opatch version check failed</span></i><br />
<i><span style="color: red;">update the opatch version for the failed homes and retry"</span></i><br />
<br />
Initially, I thought that the OPatch version (11.2.0.3.4) is an older version, but the existing OPatch version (11.2.0.3.4) is greater than the required version (11.2.0.3.0) as per the opatch readme.txt file.<br />
<br />
Even though, I have downloaded the latest OPatch "Patch 6880880: OPatch patch of version 11.2.0.3.6 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.<br />
<br />
Well, I got the same error again even after downloading latest OPatch and while applying the patch "16318126":<br />
<br />
<i><span style="color: red;">"Opatch version check failed for oracle home <gi_home>"</gi_home></span></i><br />
<br />
The commands used to apply the OPatch are as follows:<br />
<br />
$ cd <patch_directory>/<patch_number></patch_number></patch_directory><br />
i.e. cd /u01/oracle/patch/16318126<br />
<br />
Note: This is where the patch 16318126, recommended in ""ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)", was unzipped.<br />
<br />
Login as root and executed the below opatch:<br />
<br />
# opatch auto <patch_directory>/16318126 -oh <grid_home> -ocmrf <grid_home>/OPatch/ocm/bin/ocm.rsp</grid_home></grid_home></patch_directory><br />
<br />
# <i><span style="color: red;">opatch auto /u01/oracle/patch/16318126 -oh <grid_home> -ocmrf <grid_home>/OPatch/ocm/bin/ocm.rsp</grid_home></grid_home></span></i><br />
<br />
This is wrong !! and this is why, the error <i>"Opatch version check failed"</i> was encountered.<br />
<br />
The correct wahy of applying the patch is as follows:<br />
<br />
Login as root.<br />
<br />
Set the opatch path in the $PATH as follows:<br />
<br />
# <i>export PATH=$PATH:$ORACLE_HOME/OPatch</i><br />
<br />
# opatch auto <patch_directory> -oh <grid_home> -ocmrf <grid_home>/OPatch/ocm/bin/ocm.rsp</grid_home></grid_home></patch_directory><br />
<br />
i.e.<br />
<br />
# <i>opatch auto /u01/oracle/patch -oh <grid_home> -ocmrf <grid_home>/OPatch/ocm/bin/ocm.rsp</grid_home></grid_home></i><br />
<br />
<u><i><b>Note:</b></i></u><br />
No need to mention the patch number directory i.e "/u01/oracle/patch/16318126", just metion only the directory upto "/u01/oracle/patch/".<br />
<br />
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"<br />
<br />
Then the patch was succeded as follows:<br />
<br />
===========================<br />
# <i><span style="color: blue;">opatch auto /u01/oracle/patch -oh /u01/oracle/app/11.2.0.4/grid -ocmrf /u01/oracle/app/11.2.0.4/grid/OPatch/ocm/bin/ocm.rsp</span></i><br />
<br />
Executing /u01/oracle/app/11.2.0.4/grid/perl/bin/perl /u01/oracle/app/11.2.0.4/grid/OPatch/crs/patch11203.pl -patchdir /u01/oracle -patchn patch -oh<br />
<br />
/u01/oracle/app/11.2.0.4/grid -ocmrf<br />
<br />
/u01/oracle/app/11.2.0.4/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/oracle/app/11.2.0.4/grid/crs/install/crsconfig_params<br />
<br />
This is the main log file: /u01/oracle/app/11.2.0.4/grid/cfgtoollogs/opatchauto2014-09-15_17-41-14.log<br />
<br />
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:<br />
/u01/oracle/app/11.2.0.4/grid/cfgtoollogs/opatchauto2014-09-15_17-41-14.report.log<br />
<br />
2014-09-15 17:41:14: Starting Clusterware Patch Setup<br />
Using configuration parameter file: /u01/oracle/app/11.2.0.4/grid/crs/install/crsconfig_params<br />
<br />
Stopping CRS...<br />
Stopped CRS successfully<br />
<br />
patch /u01/oracle/patch/16318126 apply successful for home /u01/oracle/app/11.2.0.4/grid<br />
<br />
Starting CRS...<br />
Installing Trace File Analyzer<br />
CRS-4123: Oracle High Availability Services has been started.<br />
<br />
<b><span style="color: #274e13;">opatch auto succeeded.</span></b><br />
<br />
===========================<br />
<div>
<br /></div>
Then the same procedure to apply the patch on another node has been repeated. After this, the option tabs <i>"Volumes"</i> and <i>"ASM Cluster File Systems"</i> in ASMCA tool are enabled and the main problem of creating the volume and asm cluster filesystem are solved.<br />
<br />
<u><i><b><span style="color: red;">Note:</span></b></i></u> This blog post is specific to one our testing environments, and need not to the same with you. So, please go through the following Oracle Metalink note for your environment.<br />
<br />
"ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)"<br />
<br />
<b>Regards,</b><br />
<b>Sabdar Syed.</b><br />
<b>http://sabdarsyed.blogspot.com/</b><br />
<br /></div>
Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com1tag:blogger.com,1999:blog-4777297253091021182.post-2242065194299218722013-04-27T12:53:00.000-07:002013-04-27T12:53:28.362-07:00Oracle made a few changes in Oracle 11g OCM Exam Environment and Exam Topics<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
</div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<b><u><span style="font-family: Arial, sans-serif; font-size: 10pt; line-height: 115%;">Exam Environment</span></u></b><u><span style="font-size: 10.0pt; line-height: 115%;"><o:p></o:p></span></u></div>
<div class="MsoNormal">
<b><u><span style="font-family: Arial, sans-serif; font-size: 10pt; line-height: 115%;"><br /></span></u></b></div>
<div class="MsoNormal">
<table border="1" cellpadding="0" cellspacing="1" class="MsoNormalTable" style="background: white; margin-left: 12.0pt; mso-cellspacing: .7pt; mso-yfti-tbllook: 1184; width: 389px;">
<tbody>
<tr>
<td style="padding: .75pt .75pt .75pt .75pt; width: 128.65pt;" width="172">
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 9pt;">Current Environment<o:p></o:p></span></b></div>
<div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 9pt;">(Till 12<sup>th</sup> May 2013)</span></b><span style="font-family: Arial, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
</td>
<td style="padding: .75pt .75pt .75pt .75pt; width: 160.95pt;" width="215">
<div align="center" class="MsoNormal" style="margin: 7.5pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 9pt;">New Release Environment</span></b><span style="font-family: Arial, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
<div align="center" class="MsoNormal" style="margin: 7.5pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 9pt;">(From 13<sup>th</sup> May 2013 onwards)</span></b><span style="font-family: Arial, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="padding: .75pt .75pt .75pt .75pt; width: 128.65pt;" width="172">
<div class="MsoNormal" style="margin: 7.5pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">Oracle Linux Release 5.4 (64-bit)<o:p></o:p></span></div>
</td>
<td style="padding: .75pt .75pt .75pt .75pt; width: 160.95pt;" width="215">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">Oracle Linux Release </span><span style="color: red; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">5.4 (32-bit)</span><span style="font-family: Arial, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="padding: .75pt .75pt .75pt .75pt; width: 128.65pt;" width="172">
<div class="MsoNormal" style="margin: 7.5pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">Oracle Database Enterprise Edition Release <o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 7.5pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">11.2.0.1.0 (64-bit)<o:p></o:p></span></div>
</td>
<td style="padding: .75pt .75pt .75pt .75pt; width: 160.95pt;" width="215">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">Oracle Database 11g
Enterprise Edition Release </span><span style="color: red; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">11.2.0.3.0
(32-bit)</span><span style="font-family: Arial, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="padding: .75pt .75pt .75pt .75pt; width: 128.65pt;" width="172">
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">Oracle Enterprise
Management Grid Control 10g version 10.2.0.5 (64-bit) with repository
database 11.1.0.6<o:p></o:p></span></div>
</td>
<td style="padding: .75pt .75pt .75pt .75pt; width: 160.95pt;" width="215">
<div class="MsoNormal" style="margin: 7.5pt;">
<span style="font-family: Arial, sans-serif; font-size: 9pt;">Oracle Enterprise Manager </span><span style="color: red; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">11g</span><span style="font-family: Arial, sans-serif; font-size: 9pt;"> Grid Control </span><span style="color: red; font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Release
1 (11.1.0.1.0) (32-bit)</span><span style="font-family: Arial, sans-serif; font-size: 9pt;"><o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
</div>
<div class="MsoNormal">
<b><u><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; line-height: 115%;"><br /></span></u></b></div>
<div class="MsoNormal">
<b><u><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; line-height: 115%;">Following
are the few changes in Exam Topics:<o:p></o:p></span></u></b></div>
<div class="MsoNormal">
<b><u><span style="font-family: "Arial","sans-serif"; font-size: 10.0pt; line-height: 115%;"><br /></span></u></b></div>
<div class="MsoNormal">
<strong><i><span style="background: white; color: red; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Added in</span></i></strong><strong><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;"> Server Configuration</span></strong></div>
<div class="MsoNormal">
<strong><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;"><br /></span></strong></div>
<div class="MsoNoSpacing" style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><span style="background: white; font-family: "Arial","sans-serif"; font-size: 9.0pt;">Use OPatch to install a patch</span><o:p></o:p></div>
<div class="MsoNoSpacing" style="margin-left: .5in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 9.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><span style="background: white; font-family: "Arial","sans-serif"; font-size: 9.0pt;">Use Enterprise Manager Configuration Assistant (EMCA) utility</span><o:p></o:p></div>
<div class="MsoNoSpacing" style="margin-left: .5in;">
<br /></div>
<div class="MsoNormal">
<strong><i><span style="background: white; color: red; font-family: "Arial","sans-serif"; font-size: 12.0pt; line-height: 115%;">Removed from</span></i></strong><strong><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;"> Data Warehouse Management <o:p></o:p></span></strong></div>
<div class="MsoNormal">
<strong><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;"><br /></span></strong></div>
<div class="MsoNormal">
<span style="background: white; color: red; font-family: "Arial","sans-serif"; font-size: 9.0pt; line-height: 115%;">*<span class="apple-converted-space"> </span></span><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;">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.</span></div>
<div class="MsoNormal">
<span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;">Fore more information on 11g OCM Exam, Click <b><i><a href="http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM&p_org_id=&lang=" target="_blank">here.</a></i></b></span></div>
<div class="MsoNormal">
<span style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: Arial, sans-serif; font-size: 9pt; line-height: 115%;"><b><br /></b></span></div>
<div class="MsoNormal">
<span style="background-color: white; font-size: 9pt; line-height: 115%;"><b><span style="font-family: Arial, Helvetica, sans-serif;">Regards,</span></b></span></div>
<div class="MsoNormal">
<b style="font-size: 9pt; line-height: 115%;"><span style="font-family: Arial, Helvetica, sans-serif;">Sabdar Syed.</span></b></div>
<div class="MsoNormal">
</div>
<div style="background-color: #eeeecc; color: #333333; font-size: 13px; line-height: 18.90625px;">
<strong style="color: #223344;"><span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.c<span id="goog_1576407422"></span><span id="goog_1576407423"></span>om/</a></span></strong></div>
<br />
<br />
<br />
</div>
Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-1379535374514803962013-04-10T14:49:00.000-07:002013-04-10T14:57:34.228-07:00"Warning: You are no longer connected to ORACLE" while converting database using DGMGRL.<div dir="ltr" style="text-align: left;" trbidi="on">
As part of my OCM Exam preparation while practicing the Data Guard scenarios such as converting the database from <i>physical standby</i> to <i>snapshot standby </i>and from <i>snapshot standby</i> to <i>physical standby </i>using Data Guard Broker, the following warning messages were generated:<br />
<br />
<i><span style="color: red;">Unable to connect to database</span></i><br />
<i><span style="color: red;">ORA-12514: TNS:listener does not currently know of service requested in connect descriptor</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">Failed.</span></i><br />
<i><span style="color: red;">Warning: You are no longer connected to ORACLE.</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">Please complete the following steps and reissue the CONVERT command:</span></i><br />
<i><span style="color: red;"> start up and mount instance "stby" of database "stby"</span></i><br />
<br />
<b>Here is how, I was testing:</b><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">connect sys@orcl</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">Password:</span> <<i>enter the password here></i><br />
Connected.<br />
<br />
<b><u>Show the configuration:</u></b><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">show configuration;</span></span><br />
<br />
Configuration - DGConfig01<br />
<br />
Protection Mode: MaxPerformance<br />
Databases:<br />
orcl - Primary database<br />
stby - Physical standby database<br />
<br />
Fast-Start Failover: DISABLED<br />
<br />
Configuration Status:<br />
SUCCESS<br />
<br />
<b><u>Convert the Physical Standby Database to Snapshot Standby Database:</u></b><br />
<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">convert database 'stby' to snapshot standby;</span></span><br />
Converting database "stby" to a Snapshot Standby database, please wait...<br />
Database "stby" converted successfully<br />
<br />
<i><b>Note:</b></i> <i>Converting the database from Physical Standby to Snapshot Standby database was succeeded, but it failed while reverting from Snapshot Standby to Physical Standby.</i><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">convert database 'stby' to physical standby;</span></span><br />
Converting database "stby" to a Physical Standby database, please wait...<br />
Operation requires shutdown of instance "stby" on database "stby"<br />
Shutting down instance "stby"...<br />
Database closed.<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
Operation requires startup of instance "stby" on database "stby"<br />
Starting instance "stby"...<br />
Unable to connect to database<br />
<span style="color: red;">ORA-12514: TNS:listener does not currently know of service requested in connect descriptor</span><br />
<span style="color: red;"><br /></span>
<span style="color: red;">Failed.</span><br />
<span style="color: red;">Warning: You are no longer connected to ORACLE.</span><br />
<span style="color: red;"><br /></span>
<span style="color: red;">Please complete the following steps and reissue the CONVERT command:</span><br />
<span style="color: red;"> start up and mount instance "stby" of database "stby"</span><br />
<br />
<b><u>Solution A:</u></b><br />
<b><br /></b>
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.<br />
<br />
But, the issue is that the Data Guard Broker was attempting to connect to a service called < db_unique_name>_DGMGRL i.e. <i>stby_DGMGRL</i>. On the server, the service name <i>stby_DGMGRL.sabdar.com</i> in the listener.ora file was configured as follows<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">SID_LIST_LISTENER =</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (SID_LIST =</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (SID_DESC =</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (GLOBAL_DBNAME = stby_DGMGRL<span style="color: red;">.sabdar.com</span>)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (SID_NAME = stby)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> )</span><br />
<br />
To overcome from this warning message being generated and to fix the issue permanently, add a static registration for<i> <span style="color: red;">stby_DGMGRL</span></i> to your <i>$ORACLE_HOME/network/admin/<span style="color: red;">listener.ora</span></i>. Below is an example.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">SID_LIST_LISTENER =</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (SID_LIST =</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (SID_DESC =</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (GLOBAL_DBNAME = <span style="color: red;">stby_DGMGRL</span>)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> (SID_NAME = stby)</span><br />
<span style="font-family: Courier New, Courier, monospace;"> )</span><br />
<span style="font-family: Courier New, Courier, monospace;"> )</span><br />
<br />
<b><u>Or Solution B:</u></b><br />
<b><u><br /></u></b>
<i><b><u>Check the value of StaticConnectIdentifier property for stby database</u>:</b></i><br />
<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">show database 'stby' 'StaticConnectIdentifier';</span></span><br />
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm01.sabdar.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<span style="color: red;">stby_DGMGRL</span>)(INSTANCE_NAME=stby)(SERVER=DEDICATED)))'<br />
<br />
Here the SERVICE_NAME is <i><span style="color: red;">stby_DGMGRL</span></i> (by default it was set like this when Data Guard Broker configured).<br />
<br />
<b><u><i>Change the SERVICE_NAME from stby_DGMGRL to stby_DGMGRL.sabdar.com using Data Guard Broker </i></u></b><br />
<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">connect sys@stby</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">Password: </span><<i>enter the password here></i><br />
Connected.<br />
<br />
<u><i><b>Show the current value for StaticConnectIdentifier property</b></i></u><br />
<u><i><b><br /></b></i></u>
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">show database 'stby' 'StaticConnectIdentifier';</span></span><br />
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm01.sabdar.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<i><span style="color: red;">stby_DGMGRL</span></i>)(INSTANCE_NAME=stby)(SERVER=DEDICATED)))'<br />
<br />
<u><i><b>Edit the value for StaticConnectIdentifier property</b></i></u><br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">edit database 'stby' set property 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm01.sabdar.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=</span><span style="color: red;">stby_DGMGRL.sabdar.com</span><span style="color: blue;">)(INSTANCE_NAME=stby)(SERVER=DEDICATED)))';</span></span><br />
Property "StaticConnectIdentifier" updated<br />
<br />
<i><b>Note:</b></i> Above is a one line command<br />
<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">show database 'stby' 'StaticConnectIdentifier';</span></span><br />
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm01.sabdar.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<i><span style="color: red;">stby_DGMGRL.sabdar.com</span></i>)(INSTANCE_NAME=stby)(SERVER=DEDICATED)))'<br />
<br />
<br />
<i><u><b>Now start conversion:</b></u></i><br />
<br />
<span style="color: blue; font-family: Courier New, Courier, monospace;">DGMGRL> convert database 'stby' to physical standby;</span><br />
Converting database "stby" to a Physical Standby database, please wait...<br />
Error: ORA-16541: database is not enabled<br />
<br />
Failed.<br />
Failed to convert database "stby"<br />
<br />
<b style="font-style: italic; text-decoration: underline;">Note:</b> Here we have to first start the standby database in mount mode. Then try the '<i>convert database'</i> command.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">[oracle@ocm01 ~]$ <span style="color: blue;">export ORACLE_SID=stby</span></span><br />
<span style="font-family: Courier New, Courier, monospace;"><br /></span>
<span style="font-family: Courier New, Courier, monospace;">[oracle@ocm01 ~]$ <span style="color: blue;">sqlplus /nolog</span></span><br />
<br />
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 10 23:34:47 2013<br />
<br />
Copyright (c) 1982, 2009, Oracle. All rights reserved.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">SQL> <span style="color: blue;">connect /as sysdba</span></span><br />
Connected to an idle instance.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">SQL> <span style="color: blue;">startup mount;</span></span><br />
ORACLE instance started.<br />
<br />
Total System Global Area 680607744 bytes<br />
Fixed Size 2216464 bytes<br />
Variable Size 406851056 bytes<br />
Database Buffers 264241152 bytes<br />
Redo Buffers 7299072 bytes<br />
Database mounted.<br />
<br />
<i><u><b>Now start conversion:</b></u></i><br />
<i><u><b><br /></b></u></i>
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">connect sys@stby</span></span><br />
<span style="font-family: Courier New, Courier, monospace;">Password:</span> <<i>enter the password here></i><br />
Connected.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;">DGMGRL> <span style="color: blue;">convert database 'stby' to physical standby;</span></span><br />
Converting database "stby" to a Physical Standby database, please wait...<br />
Operation requires shutdown of instance "stby" on database "stby"<br />
Shutting down instance "stby"...<br />
ORA-01109: database not open<br />
<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
Operation requires startup of instance "stby" on database "stby"<br />
Starting instance "stby"...<br />
ORACLE instance started.<br />
Database mounted.<br />
Database "stby" converted successfully<br />
<br />
<i>This time the conversion got succeeded. Sometimes, these warning messages may encountered while switch over activity as well.</i><br />
<div>
<br /></div>
<div>
<b>Regards,<br />Sabdar Syed.</b></div>
<div>
<a href="http://sabdarsyed.blogspot.com/" style="background-color: #eeeecc; color: #223344; font-family: 'Trebuchet MS', Verdana, Arial, sans-serif; font-size: 13px; line-height: 18.90625px;"><strong>http://sabdarsyed.blogspot.com/</strong></a></div>
<div>
<br /></div>
<br />
<br />
<br />
<br /></div>
Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-28381208381968991612012-10-16T13:16:00.001-07:002012-10-16T13:16:11.501-07:00It's been quite a long time !<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Dear Blog Viewers,<br />
<br />
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.<br />
<br />
Well, there were various reasons why I didn't update my blog.<br />
<br />
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.<br />
<br />
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.<br />
<br />
However, I would be updating the blog with my preparation for 11g OCM and the concepts I’m going to practice.<br />
<br />
I hope that I would be receiving the unchanged and continuous support & wishes from my blog viewers in my preparation for the exam.<br />
<br />
Your valued suggestions and advises are always welcomed.<br />
<br />
<b>Regards,</b><br />
<b>Sabdar Syed.</b><br />
</div>
Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com1tag:blogger.com,1999:blog-4777297253091021182.post-24727547446678543872010-02-22T11:55:00.000-08:002010-02-22T12:05:07.245-08:00My Interview Published in the Peer-To-Peer Column of Oracle MagazineHello,<br /><br />This is to share with you all that Oracle Published my interview in the<br />peer-topeer column of Oracle Magazine (March - April 2010 Edition).<br /><br /><a href="http://www.oracle.com/technology/oramag/oracle/10-mar/o20peer.html" target="_blank"><br /><img src="http://www.oracle.com/technology/oramag/oracle/images/mar10_ocover_medium.gif" /><br /></a><br /><br /><span style="font-weight:bold;">Regards,<br />Sabdar Syed.<br /><a href="http://sabdarsyed.blogspot.com">http://sabdarsyed.blogspot.com</a></span>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com3tag:blogger.com,1999:blog-4777297253091021182.post-50460306160744331412009-08-08T14:07:00.000-07:002009-08-08T14:53:02.882-07:00How 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.<br /><br />We prepared an input XML file required for RCONFIG tool, and run the RCONFIG utility as follows:<br /><br /><pre>$ <span style="color:#000099;">cd /oracle/ora102/db_1/assistants/rconfig/sampleXMLs</span><br />$ <span style="color:#000099;">rconfig ConverToRAC.xml</span></pre>When 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.<br /><br />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.<br /><br />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.<br /><br />To know the RMAN default preconfigured settings for the database:<br /><br /><pre>$ <span style="color:#000099;">export ORACLE_SID=MYPROD</span><br />$ <span style="color:#000099;">rman target /</span><br />Recovery Manager: Release 10.2.0.4.0 - Production on Wed Aug 5 10:21:05 2009<br /><br />Copyright (c) 1982, 2007, Oracle. All rights reserved.<br /><br />connected to target database: MYPROD (DBID=1131234567)<br /><br />RMAN> <span style="color:#000099;">show all;</span><br /><br />using target database control file instead of recovery catalog<br />RMAN configuration parameters are:<br />CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default<br />CONFIGURE BACKUP OPTIMIZATION OFF; # default<br />CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default<br />CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default<br />CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default<br />CONFIGURE DEVICE TYPE DISK <strong><span style="color:#ff0000;">PARALLELISM 1</span></strong> BACKUP TYPE TO BACKUPSET;<br />CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br />CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br />CONFIGURE MAXSETSIZE TO UNLIMITED; # default<br />CONFIGURE ENCRYPTION FOR DATABASE OFF; # default<br />CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default<br />CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default<br />CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora102/db_1/dbs/snapcf_T24MIG1.f'; # default</pre>Here 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.<br /><br />We have changed the PRALLELISM count to 6 (it depends upon number of CPUs you have in the server).<br /><br />Solution:<br /><br /><pre>RMAN> <span style="color:#000099;">CONFIGURE DEVICE TYPE DISK PARALLELISM 6;</span><br /><br />old RMAN configuration parameters:<br />CONFIGURE DEVICE TYPE DISK <strong>PARALLELISM 1</strong> BACKUP TYPE TO BACKUPSET;<br />new RMAN configuration parameters:<br />CONFIGURE DEVICE TYPE DISK <strong><span style="color:#ff0000;">PARALLELISM 6</span></strong> BACKUP TYPE TO BACKUPSET;<br />new RMAN configuration parameters are successfully stored<br /><br />RMAN> <span style="color:#000099;">show all;</span><br /><br />RMAN configuration parameters are:<br />CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default<br />CONFIGURE BACKUP OPTIMIZATION OFF; # default<br />CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default<br />CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default<br />CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default<br />CONFIGURE DEVICE TYPE DISK PARALLELISM 6 BACKUP TYPE TO BACKUPSET;<br />CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br />CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br />CONFIGURE MAXSETSIZE TO UNLIMITED; # default<br />CONFIGURE ENCRYPTION FOR DATABASE OFF; # default<br />CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default<br />CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default<br />CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora102/db_1/dbs/snapcf_T24MIG1.f'; # default</pre>After changing the PARALLELISM count to 6, the RMAN has allocated 6 channels and the conversion process has improved greatly and reduced the downtime drastically to 4 Hours 30 minutes.<br /><br />Following is the extract of <em><span style="color:#000099;">rconfig.log file</span></em>, this file is located under:<br /><br /><pre><strong>$ORACLE_HOME/db_1/cfgtoolslogs/rconfig</strong><br />............................................................................<br />............................................................................<br />............................................................................<br />[17:17:16:43] Log RMAN Output=RMAN> backup as copy database to destination '+DATA_DG';<br /><span style="color:#cc0000;">[17:17:16:53] Log RMAN Output=Starting backup at 04-AUG-09</span><br />[17:17:16:258] Log RMAN Output=using target database control file instead of recovery catalog<br />[17:17:16:694] Log RMAN Output=<span style="color:#000099;">allocated channel: ORA_DISK_1</span><br />[17:17:16:698] Log RMAN Output=channel ORA_DISK_1: sid=866 devtype=DISK<br />[17:17:17:9] Log RMAN Output=<span style="color:#000099;">allocated channel: ORA_DISK_2</span><br />[17:17:17:13] Log RMAN Output=channel ORA_DISK_2: sid=865 devtype=DISK<br />[17:17:17:324] Log RMAN Output=<span style="color:#000099;">allocated channel: ORA_DISK_3</span><br />[17:17:17:327] Log RMAN Output=channel ORA_DISK_3: sid=864 devtype=DISK<br />[17:17:17:637] Log RMAN Output=<span style="color:#000099;">allocated channel: ORA_DISK_4</span><br />[17:17:17:641] Log RMAN Output=channel ORA_DISK_4: sid=863 devtype=DISK<br />[17:17:17:967] Log RMAN Output=<span style="color:#000099;">allocated channel: ORA_DISK_5</span><br />[17:17:17:971] Log RMAN Output=channel ORA_DISK_5: sid=862 devtype=DISK<br />[17:17:18:288] Log RMAN Output=<span style="color:#000099;">allocated channel: ORA_DISK_6</span><br />[17:17:18:293] Log RMAN Output=channel ORA_DISK_6: sid=861 devtype=DISK<br />[17:17:20:416] Log RMAN Output=channel ORA_DISK_1: starting datafile copy<br />[17:17:20:427] Log RMAN Output=input datafile fno=00053 name=/oradata/MYPROD/users_01.dbf<br />[17:17:20:532] Log RMAN Output=channel ORA_DISK_2: starting datafile copy<br />[17:17:20:544] Log RMAN Output=input datafile fno=00021 name=/oradata/MYPROD/ users_02.dbf<br />[17:17:20:680] Log RMAN Output=channel ORA_DISK_3: starting datafile copy<br />[17:17:20:694] Log RMAN Output=input datafile fno=00022 name=/oradata/MYPROD/ users_03.dbf<br />[17:17:20:786] Log RMAN Output=channel ORA_DISK_4: starting datafile copy<br />[17:17:20:800] Log RMAN Output=input datafile fno=00023 name=/oradata/MYPROD/ users_04.dbf<br />[17:17:20:855] Log RMAN Output=channel ORA_DISK_5: starting datafile copy<br />[17:17:20:868] Log RMAN Output=input datafile fno=00024 name=/oradata/MYPROD/ users_05.dbf<br />[17:17:20:920] Log RMAN Output=channel ORA_DISK_6: starting datafile copy<br />[17:17:20:930] Log RMAN Output=input datafile fno=00011 name=/oradata/MYPROD/ users_06.dbf<br />............................................................................<br />............................................................................<br />............................................................................<br /><span style="color:#ff0000;">[21:29:5:518] Log RMAN Output=Finished backup at 04-AUG-09</span><br />............................................................................<br />............................................................................<br />............................................................................<br /><br />[21:39:10:723] [NetConfig.startListenerResources:5] started Listeners associated with database MYPROD<br />[21:39:10:723] [Step.execute:255] STEP Result=Operation Succeeded<br />[21:39:10:724] [Step.execute:284] Returning result:Operation Succeeded<br />[21:39:10:724] [RConfigEngine.execute:68] bAsyncJob=false<br />[21:39:10:725] [RConfigEngine.execute:77] Result= < version="1.1"></pre><br /><br /><pre><ConvertToRAC><br /> <Convert><br /> <Response><br /> <Result code="0" ><br /> Operation Succeeded<br /> </Result><br /> </Response><br /> <ReturnValue type="object"><br /><Oracle_Home><br /> /oracle/ora102/db_1<br /> </Oracle_Home><br /> <SIDList><br /> <SID>MYPROD1<\SID><br /> <SID>MYPROD2<\SID><br /> <\SIDList> </ReturnValue><br /> </Convert><br /> </ConvertToRAC></RConfig></pre><br /><strong>Note:</strong> For the sake of look and feel format, the above output has been trimmed neatly. You can also observer that 6 channels were being allocated, timings of backup start and end, and the success code end of the rconfig.log file.<br /><br /><strong>References:</strong><br /><br />To know more about RCONFIG tool and other Metalink references on it, please take a look at the below blog post written by Mr. Syed Jaffar Hussain.<br /><br /><a href="http://jaffardba.blogspot.com/2008/09/my-experience-of-converting-cross.html">http://jaffardba.blogspot.com/2008/09/my-experience-of-converting-cross.html</a><br /><br />Oracle 10g R2 Documentation information on RCONFIG:<br /><br /><a href="http://download.oracle.com/docs/cd/B19306_01/install.102/b14205/cvrt2rac.htm#BABBAAEH">http://download.oracle.com/docs/cd/B19306_01/install.102/b14205/cvrt2rac.htm#BABBAAEH</a><br /><br /><strong>Regards,<br />Sabdar Syed,<br /></strong><a href="http://sabdarsyed.blogspot.com/"><strong>http://sabdarsyed.blogspot.com/</strong></a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com5tag:blogger.com,1999:blog-4777297253091021182.post-67795322561737567262009-03-10T05:57:00.000-07:002009-03-10T06:36:25.348-07:00Sand Storm in Saudi Arabia...Today.<div align="left"><strong>Hello,</strong><br /><br />Today, there was a huge <em><strong><span style="color:#ff0000;">sand storm</span></strong></em> in Saudi Arabia. This is the first time I have seen such real and live sand storm covering the Riyadh City in Saudi Arabia.<br /><br />Here are few pics shared in this blog. </div><div align="center"><br /></div><div align="center"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLf9g0qD9wirJRyYcqek_i4UFPnhN9GZyF0y8ITOCcfS9t9TdcUG89n2JRGNR5QMr2OYWE4xlnrtowh5ftRKDnaSuFU5qN4OExuy4qpcmPGn4Kzw4AJNxk4ASnmK8GREOBEldhfCiozQcD/s1600-h/4.bmp"><img id="BLOGGER_PHOTO_ID_5311550308470720978" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLf9g0qD9wirJRyYcqek_i4UFPnhN9GZyF0y8ITOCcfS9t9TdcUG89n2JRGNR5QMr2OYWE4xlnrtowh5ftRKDnaSuFU5qN4OExuy4qpcmPGn4Kzw4AJNxk4ASnmK8GREOBEldhfCiozQcD/s320/4.bmp" border="0" /></a><br /><br /></div><div align="center"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlXnLQe7LOWTzTH7YKyMn1ZhQOj5kk4ARstrumIwVSCXVrXrDGmJauFxb2ytmflo14MTT0Rg6nUaj9Qz8O695WNs_PrAFh9bzemudReW152SCJnqE8D80n5FrqatWgq1yNTTFRHIYrL8Lz/s1600-h/2.bmp"><img id="BLOGGER_PHOTO_ID_5311550151662972322" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlXnLQe7LOWTzTH7YKyMn1ZhQOj5kk4ARstrumIwVSCXVrXrDGmJauFxb2ytmflo14MTT0Rg6nUaj9Qz8O695WNs_PrAFh9bzemudReW152SCJnqE8D80n5FrqatWgq1yNTTFRHIYrL8Lz/s320/2.bmp" border="0" /></a><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikELSjodUww569letkoWNFTGMkSvMp2MNgIhyWMnysGeenwgoHnBSPHnxcn0YdnS-sdFfoRvZUYl32vKuRyk4fF1n48MoR1Kg-ujAxtnsJSqpfvZvRNXIVjOLCuiP5fqCm4MF_OLWUaC6n/s1600-h/6.bmp"><img id="BLOGGER_PHOTO_ID_5311550787765782754" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 218px; CURSOR: hand; HEIGHT: 320px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikELSjodUww569letkoWNFTGMkSvMp2MNgIhyWMnysGeenwgoHnBSPHnxcn0YdnS-sdFfoRvZUYl32vKuRyk4fF1n48MoR1Kg-ujAxtnsJSqpfvZvRNXIVjOLCuiP5fqCm4MF_OLWUaC6n/s320/6.bmp" border="0" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGDTxeYzCZLNR2EORuEuz3BhIF1InLXm0Jk018vRoXpikGLeG-oWJEV9pqgFfpLw894dAkPzoA6rlKErErR7c30A2gQ5QJks4Yy9C1WI8955EzzlD9BsUbSqFYiU1qHdDXU904c8WSvtfR/s1600-h/1.bmp"><img id="BLOGGER_PHOTO_ID_5311548576666843682" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGDTxeYzCZLNR2EORuEuz3BhIF1InLXm0Jk018vRoXpikGLeG-oWJEV9pqgFfpLw894dAkPzoA6rlKErErR7c30A2gQ5QJks4Yy9C1WI8955EzzlD9BsUbSqFYiU1qHdDXU904c8WSvtfR/s320/1.bmp" border="0" /></a><br /><br /></div><div align="center"><br /><br /><br /><br /></div><div align="center"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Fv7fIsDOGkNPOlrZN_w6hPec6OjNq_xcbhmFRtpQPmALw6Y0HeOEdoPg6AKQzHCVx_c2oxbMFhGfgWIJoavRedYMXnsr6KvRvJCi7qBfDquTo14LLtAo3ZrNnZKY3HU3cZ1itNZIpZuE/s1600-h/12.jpg"><img id="BLOGGER_PHOTO_ID_5311548310423554354" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 213px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Fv7fIsDOGkNPOlrZN_w6hPec6OjNq_xcbhmFRtpQPmALw6Y0HeOEdoPg6AKQzHCVx_c2oxbMFhGfgWIJoavRedYMXnsr6KvRvJCi7qBfDquTo14LLtAo3ZrNnZKY3HU3cZ1itNZIpZuE/s320/12.jpg" border="0" /></a><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpLvG7Yr82QTqHlcq0FGSpH1ywfFDO4AqfwOTBDyB6ZqZbLGj0QAAALz-XBCzYtuQsfRJ5HVZ2ZgFBehoTO5h6MRburp3cIonuK1JFz3K0-IKRYS4jgFHGE3IEi3hLk5Iz3liBMUXPhyphenhyphendv/s1600-h/10.jpg"><img id="BLOGGER_PHOTO_ID_5311544354667544290" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 213px; CURSOR: hand; HEIGHT: 320px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpLvG7Yr82QTqHlcq0FGSpH1ywfFDO4AqfwOTBDyB6ZqZbLGj0QAAALz-XBCzYtuQsfRJ5HVZ2ZgFBehoTO5h6MRburp3cIonuK1JFz3K0-IKRYS4jgFHGE3IEi3hLk5Iz3liBMUXPhyphenhyphendv/s320/10.jpg" border="0" /></a><br /><br /><br /><br /></div><div align="center"><br /><br /><br /><br /><br /><br /></div><div align="center"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIT2jUV2X2a0twqtc3LsXG4hf3Vv-IpwzEMFB2U6A99kInu71LBiTU2Sx0Ojh7d7-eJd6CMuzP59tgKO83IAHTfVv2uIg3-fKEzjmBvPzAaIYn0vGQfdCmc6e_kQUBk26Q4Y_Ou6tQQ8ak/s1600-h/9.jpg"><img id="BLOGGER_PHOTO_ID_5311544219568232098" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 206px; CURSOR: hand; HEIGHT: 320px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIT2jUV2X2a0twqtc3LsXG4hf3Vv-IpwzEMFB2U6A99kInu71LBiTU2Sx0Ojh7d7-eJd6CMuzP59tgKO83IAHTfVv2uIg3-fKEzjmBvPzAaIYn0vGQfdCmc6e_kQUBk26Q4Y_Ou6tQQ8ak/s320/9.jpg" border="0" /></a><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8c7u264MMLD_-_ckjDwFmVOpb75_euYk_qpYQomqGDJSAG-J3s9s1gSsFuEEhGpl1gzhriOEYwaJKMcV-2vRf16h6jnK7nGUkFx_onpWPuOEod83zdrKyN6KZJ9x4RpK6ng0PEu1qftHr/s1600-h/7.jpg"><img id="BLOGGER_PHOTO_ID_5311543329979633074" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 233px; CURSOR: hand; HEIGHT: 320px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8c7u264MMLD_-_ckjDwFmVOpb75_euYk_qpYQomqGDJSAG-J3s9s1gSsFuEEhGpl1gzhriOEYwaJKMcV-2vRf16h6jnK7nGUkFx_onpWPuOEod83zdrKyN6KZJ9x4RpK6ng0PEu1qftHr/s320/7.jpg" border="0" /></a><br /><br /><br /><br /><br /><br /></div><div align="center"><br /><br /><br /><br /><br /><br /><br /><br /></div><div align="center"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI7UrsftJwHWdybNEFFZp5OGFoeY16r6Bc3kXoDbkgSSWt-tSdMbdo2GTOBfr0oYX3wTt-_Im1lqCvBh22aH7zpDR6XkIy-l9uXFI2NoXlu8wI3gHhx3GoYxoOq0vhBPddAWgi_gz9TBel/s1600-h/3.jpg"><img id="BLOGGER_PHOTO_ID_5311543140736502082" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand; HEIGHT: 213px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI7UrsftJwHWdybNEFFZp5OGFoeY16r6Bc3kXoDbkgSSWt-tSdMbdo2GTOBfr0oYX3wTt-_Im1lqCvBh22aH7zpDR6XkIy-l9uXFI2NoXlu8wI3gHhx3GoYxoOq0vhBPddAWgi_gz9TBel/s320/3.jpg" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /></div><div align="center"></div><div align="center"><br /></div><div align="center"></div><div align="center"></div><div align="center"></div><div align="center"></div><div align="center"></div><div align="center"></div><div align="center"></div><div align="center"><strong></strong> </div><div align="center"><strong></strong> </div><div align="center"><strong></strong> </div><div align="left"><strong>Regards,</strong></div><div align="left"><strong><span style="color:#3333ff;">Sabdar Syed.</span></strong><br /></div>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com1tag:blogger.com,1999:blog-4777297253091021182.post-81798988797090029562009-01-28T04:27:00.000-08:002009-01-28T04:45:06.552-08:00ORA-27123: unable to attach to shared memory segment<strong>Hello,</strong><br /><br />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 <em><span style="color:#3366ff;">“<span style="color:#ff0000;">ORA-27123</span>: unable to attach to shared memory segment”</span></em> with permission denied issue.<br /><br />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.<br /><br /><strong>Here are our findings:<br /></strong><br /><pre><strong>$ </strong><em><span style="color:#3366ff;">sqlplus testusr/password@testdb</span></em><br /><br />SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jan 27 20:53:44 2009<br /><br />Copyright (c) 1982, 2005, Oracle. All Rights Reserved.<br /><br />ERROR:<br /><span style="color:#ff0000;">ORA-01034: ORACLE not available<br />ORA-27123: unable to attach to shared memory segment<br />SVR4 Error: 13: Permission denied</span> </pre><strong>As per Oracle Error Messages:<br /></strong><br /><pre><span style="color:#ff0000;">Error: ORA-27123: unable to attach to shared memory segment</span><br />Cause: shmat() call failed<br />Action: check permissions on segment, contact Oracle support</pre><strong>Check the <em>oracle</em> executable file permission.</strong><br /><br /><pre><strong>$</strong> cd $ORACLE_HOME/bin<br /><strong>$</strong> ls -l oracle<br /><span style="color:#ff0000;">-rwxrwxr-x</span> 1 oracle dba 119582976 Feb 3 2008 oracle</pre>Here the <em>oracle</em> file permission has <span style="color:#ff0000;"><em>-rwxrwxr-x</em></span> i.e. 775, but this file must have the permission <em><span style="color:#3366ff;">-rwsr-s- -x</span></em> i.e. 6751<br /><br /><strong>Change the permissions for <em>oracle</em> file.<br /></strong><br /><pre><strong>$</strong> cd $ORACLE_HOME/bin<br /><strong>$</strong> <span style="color:#ff0000;">chmod 6751 oracle</span><br /><strong>$</strong> ls -l oracle<br /><span style="color:#3366ff;">-rwsr-s--x</span> 1 oracle dba 119582976 Feb 3 2008 oracle</pre>After changing the permissions on <em>oracle</em> executable file, all the users are now able to connect to the database without any errors.<br /><br /><strong><em>Note:</em></strong> For further information refer the Oracle Metalink Note ID: <em>1011995.6</em> Subject: <em>COMMON ORACLE PERMISSION PROBLEMS ON UNIX</em>.<br /><br /><strong>Regards,<br /></strong><a href="http://sabdarsyed.blogspot.com/" target="_blank"><strong><span style="color:#3366ff;">Sabdar Syed</span></strong></a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com10tag:blogger.com,1999:blog-4777297253091021182.post-35301530332706163302009-01-04T05:37:00.000-08:002009-02-14T04:52:14.591-08:00How important is having Unix/Linux OS Knowledge for Oracle DBAs?<strong>Hello,</strong><br /><br />I wanna wish you all a very <em><strong><span style="font-size:130%;color:#ff0000;">Happy New Year 2009</span></strong></em> before being discussed on <em><span style="color:#000099;">“How Important Having UNIX OS Knowledge for Oracle DBA?”</span></em><br /><em><span style="color:#3333ff;"></span></em><br />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.<br /><br /><em><span style="color:#3333ff;">“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”<br /><br />“They are not enough confident in using the Unix/Linux OS commands to administer the databases”<br /><br />“We didn’t get the chance yet to maintain the database on UNIX environment including Solaris, HP-Unix, IBM AIX, etc.”<br /><br />“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”<br /><br />…. and so on.</span></em><br /><br /><p><strong><span style="color:#cc0000;">If anyone is with the above impression about administrating databases on Unix/Linux OS, then here are my suggestions as follows.</span></strong></p><ul><li>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 DBAs</li><li></li><li>The 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.</li><li></li><li>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.</li><li></li><li>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. </li><li></li><li>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.</li><li></li><li>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.</li><li></li><li><strong><em>Note:</em></strong> 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.</li></ul><p><strong><span style="color:#cc0000;">Quick Links:</span></strong></p><p><strong>Download:</strong> <a href="http://edelivery.oracle.com/linux" target="_blank"><span style="color:#3333ff;">Enterprise Linux and Oracle VM</span> </a></p><p><strong>Information:</strong> <a href="http://www.oracle.com/technologies/linux/index.html" target="_blank"><span style="color:#3333ff;">Oracle and Linux </span></a></p><p><strong>Installation Guides:</strong> <a href="http://www.oracle.com/pls/db102/portal.portal_db?selected=11" target="_blank"><span style="color:#3333ff;">Oracle 10g Instalaltion on Unix/Linux OS </span></a></p><p><strong>Books:</strong><a href="http://www.amazon.com/Oracle9i-Administration-Handbook-Donald-Burleson/dp/0072223049" target="_blank"> <span style="color:#3333ff;">Oracle9i UNIX Administration Handbook</span> </a></p><p><a href="http://www.apress.com/book/view/9781430215752" target="_blank"><span style="color:#3333ff;">Linux Recipes for Oracle DBAs</span> </a></p><p><strong>Training:</strong><span style="color:#3333ff;"> </span><a href="http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D46590GC10" target="_blank"><span style="color:#3333ff;">Oracle Database 10g: Managing Oracle on Linux for DBAs </span></a></p><p><strong>Exam:</strong> <a href="http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=185" target="_blank"><span style="color:#3333ff;">Oracle Database 10g: Managing Oracle on Linux Certified Expert </span></a><a href="http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D46590GC10" target="_blank"><span style="color:#3333ff;">Oracle</span> </a></p><p><strong><em>** Your comemnts and inputs are welcomed to this post. ** </em></strong></p><p><strong>Regards,</strong></p><p><a href="http://sabdarsyed.blogspot.com/" target="_blank"><strong>Sabdar Syed</strong></a></p><p><a href="http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D46590GC10" target="_blank"></a></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com4tag:blogger.com,1999:blog-4777297253091021182.post-27836711843936892642008-12-18T01:35:00.000-08:002008-12-19T12:35:37.289-08:00I’m an Oracle ACE Award Winner now !<strong>Dear All,</strong><br /><br />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.<br /><br />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. <a href="http://apex.oracle.com/pls/otn/f?p=19297:4:3380164219065796::NO:4:P4_ID:126" target="_blank"><em><strong><span style="color:#ff0000;">Syed Jaffar Hussain</span></strong></em></a> . 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?<br /><br />Take a look at my Oracle ACE Profile – <a href="http://apex.oracle.com/pls/otn/f?p=19297:4:3380164219065796::NO:4:P4_ID:2521" target="_blank"><em><strong><span style="color:#ff0000;">Sabdar Syed</span></strong></em>. </a><br /><br />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.<br /><br /><p><strong><span style="color:#3366ff;">Thanks</span></strong></p><p><span style="color:#000000;">Thanks to <em><strong>Mr. Mohan Dutt</strong></em>, OCP Advisor, for publishing about my achievement, Oracle ACE Award, in his blog - OCP Blog Community.</span></p><p>Take a look at - <a href="http://ebizocp.blogspot.com/2008/12/featured-expert-wins-oracle-ace-award.html" target="_blank"><em>Featured Expert Wins Oracle ACE Award!</em></a><em> </em></p><p><strong><span style="color:#3366ff;">Your precious comments are welcomed!</span></strong> </p><p><strong>Regards,</strong><br /><strong>Sabdar Syed.</strong><br /><a href="http://sabdarsyed.blogspot.com/"><strong>http://sabdarsyed.blogspot.com</strong></a></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com19tag:blogger.com,1999:blog-4777297253091021182.post-73121526037349469052008-12-16T23:38:00.000-08:002008-12-17T00:05:07.238-08:00Download Free Oracle Certification Dumps Here!!<p>This blog post is for them; those who are desperately looking for free Oracle Certification dumps. </p><p>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 <span style="color:#cc0000;">“</span><em><span style="color:#cc0000;">How bad it is? Cheating the Oracle Certifications by simply reading the exam dumps”</span>.</em></p><p>Mr. <em><strong>Paul Sorensen</strong></em>, Director of Oracle Certification, and other certification team members have launched the <em><a href="http://blogs.oracle.com/certification/" target="_blank"><span style="color:#3366ff;">Oracle Certification Blog</span> </a></em>, where they blog about everything on Oracle Certification. Interestingly, there are a couple of blog posts on <em><span style="color:#3366ff;">“</span><span style="color:#cc0000;">Cheating Hurts the Oracle Certification Program”</span></em> and others.</p><p>For list of blog posts on Cheating, then take a look at – <em><a href="http://blogs.oracle.com/mte1521/mt-search.cgi?tag=cheating&blog_id=163" target="_blank"><span style="color:#3366ff;">Cheating Oracle Certifications</span> </a></em>. Do not forget to read the comments of every post in the above link.</p><p><strong>Quick Links to Prepare for Oracle Certification</strong></p><ul><li>Previous Post: <a href="http://sabdarsyed.blogspot.com/2008/08/books-guides-and-materials-used-for-my.html" target="_blank"><span style="color:#3366ff;">The books, guides, and materials used for my OCA/OCP/OCE Exam Preparation. </span><a></a></li><li>On the Blog: <a href="http://sabdarsyed.blogspot.com/search/label/OCP" target="_blank"><span style="color:#3366ff;">My Other Blog Posts on Certifications. </span></a></li><li>On the Web: <a href="http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=39" target="_blank"><span style="color:#3366ff;">Oracle Certification Program. </span></a></li></ul><p><strong>Keywords:</strong></p><p>OCA, OCP, OCE, Dumps, Brain dumps, Practice Questions, Sample Questions, Cheat sheet, Test papers.</p><p><strong>Regards,
<br />Sabdar Syed.
<br /></strong></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com3tag:blogger.com,1999:blog-4777297253091021182.post-28899418196082876012008-12-13T01:39:00.000-08:002008-12-13T04:52:06.314-08:00Should I go for Oracle 10g OCA/OCP or 11g OCA/OCP Certification?Hello All,<br /><br />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.<br /><br />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.<br /><br /><strong><span style="color:#ff0000;">Following are my views on why to go for Oracle 10g OCA/OCP initially rather than 11g OCA/OCP directly.</span></strong><br /><br /><ul><li>As we all know that newer version (11g) does include older version features plus new features and bug fixes of older version issues.</li><li>Retirement date for Oracle 10g Certification has not yet been announced by Oracle. Moreover, <em>Oracle Database 11g: Administration I</em> (OCA) exam is only on production i.e. regular and <em>Oracle Database 11g: Administration II</em> (OCP) exam is not yet gone for Production i.e. still <em>Beta Exam</em>.</li><li>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 11.1.0.6 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.</li><li>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.</li><li>Both versioned (10g and 11g) certifications have two exams – <em>Administration I</em> (OCA) and <em>Administration II</em> (OCP). Each exam fees of them is $125 US i.e. there is no vary.</li><li>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.</li><li>For Oracle 10g OCP Certification holders, there is only one exam <em>1Z0-050 - Oracle Database 11g: New Features for Administrators</em> 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.</li><li>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.</li></ul><strong><span style="color:#3366ff;">One can go for direct Oracle 11g Certification under the following circumstances.</span></strong><br /><strong><span style="color:#3366ff;"></span></strong><br /><ul><li>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.</li><li>When there is no Oracle 10g course listed in the training institute in your city, instead only Oracle 11g Courses are available.</li><li>When unable to afford to take Oracle 11g Upgrade exam.</li><li>If my above views are not Okay with you -:)</li></ul><p><strong><em><span style="color:#ff0000;">Note:</span></em></strong> 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 <a href="http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=39" target="_blank"><em>Oracle Certification Program</em> </a>link and navigate yourself to the options to know more about <em>Beta Exams, Retirements, List of Exams, Upgrade your Certification, Hands on Course Requirement</em> etc.,<br /><br /><span style="color:#3366ff;">Your comments are welcomed if this article information helps you.<br /></span><br /><strong>Regards,<br />Sabdar Syed,<br /></strong><a href="http://sabdarsyed.blogspot.com/"><strong>http://sabdarsyed.blogspot.com</strong></a></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com3tag:blogger.com,1999:blog-4777297253091021182.post-33778722249949747062008-12-11T21:22:00.000-08:002008-12-11T21:37:15.951-08:00Celebrating Second Year Anniversary of the Blog Launch<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHcFG99Pfx9SgZrgtgKSAvtNjgQqM9lLkuxVbxGWwPWEHebDGvvnkOXhokgzTm07Avjc3gCOK5eVCYsLNQ6OvNrHglHfCh_-5c5RMgIaOglrsyfRFmYcuemG3F6cI2-n1gV1nxTGK8gT48/s1600-h/2nd.jpg"><img id="BLOGGER_PHOTO_ID_5278771211148249730" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 213px; CURSOR: hand; HEIGHT: 320px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHcFG99Pfx9SgZrgtgKSAvtNjgQqM9lLkuxVbxGWwPWEHebDGvvnkOXhokgzTm07Avjc3gCOK5eVCYsLNQ6OvNrHglHfCh_-5c5RMgIaOglrsyfRFmYcuemG3F6cI2-n1gV1nxTGK8gT48/s320/2nd.jpg" border="0" /></a><br /><div><strong>Dear My Blog Readers,</strong></div><br /><div></div><br /><div>It's been two years that I have lanuched and updated my blog by today. The blog originally started on 12-Dec-2006.</div><br /><p>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.</p><p>I hope, I would write more and more good articles which my blog viwers definitely like them and definitely get benifit from them.</p><p>Feel free to give comments, suggestions, and advices to improve this blog with more articles.</p><p>Once again thank you all.</p><p> </p><p><strong>Regards,</strong></p><p><strong>Sabdar Syed,</strong></p><p><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com</a></p><p> </p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-35202871021507377252008-12-03T00:40:00.000-08:002008-12-03T03:17:29.430-08:00Oracle Approved Training Centers and Certification Test Sites & Address - Kingdom of Saudi Arabia<strong>Hello All,<br /></strong><br />Here is the list of Oracle University Approved Educational Training Partners/Centers, and the certification test taking sites in Saudi Arabia.<br /><br /><span style="color:#ff0000;"><strong><span style="font-size:130%;">Oracle University Approved Education Partners - Kingdom of Saudi Arabia</span></strong><br /></span><br /><strong><span style="color:#3366ff;">New Horizons Jeddah - Oracle Approved Education Center<br /></span></strong><br />P.O. Box : 52171<br />Telephone : 026642277<br />Fax : 026642454<br />Address : Al Rawda St, Jeddah ,KSA<br /><br /><strong><span style="color:#3366ff;">New Horizons Khobar - Oracle Approved Education Center</span></strong><br /><br />P.O. Box : 2060<br />Telephone : 038588882<br />Fax : 038584014<br />Address : AL Khaleej Blg, Khobar, KSA<br /><br /><strong><span style="color:#3366ff;">Al-Khaleej Training and Education Co.(New Horizons Computer Learning Center,KSA)</span></strong><br /><br />Al Wallan Building,<br />Takhasusi Street,<br />Riyadh,Kingdom of Saudi Arabia<br /><br />Contact: Louai Al-Amir Salem, PMP<br />Title: Platinum Center Manager<br />Tel: 009661 416 0123 Ext. 400<br /><br /><strong><span style="color:#ff0000;"><span style="font-size:130%;">Prometric Test Sites and Address for taking Oracle Certifications OCA/OCP/OCE</span><br /></span></strong><br /><span style="font-size:130%;color:#cc6600;"><strong>Riyadh:<br />=======</strong></span><br /><br /><strong><span style="color:#3366ff;">NEW HORIZONS COMPUTER LEARNING</span></strong><br /><br />ABOVE AL WALAN SHOW ROOM<br />AL KHURAIS ROAD NEAR AL AZIZA<br />PANDA TAKAHASSUI PO 295300<br />RIYADH 11351<br />Phone: 14160123 Site Code: SU7<br /><br /><strong><span style="color:#3366ff;">NEW HORIZONS COMPUTER LEARNING</span></strong><br /><br />Olya Main Street<br />Behind Jareer Bookstore<br />Al Khaleej Ladies Center<br />Newhorizons P O Box 295300<br />RIYADH 11351<br />Phone: 1462 8393 Site Code: SU7M1<br /><br /><strong><span style="color:#3366ff;">ALFAISAL INTERNATIONAL ACADEMY<br /></span></strong><br />IMAM SAUD BIN ABDULAZIZ ROAD<br />KING FAHED DISTRICT<br />PO BOX 10202<br />RIYADH 11433<br />Phone: 14552444 Site Code: SU60<br /><br /><strong><span style="color:#3366ff;">ExecuTrain of Riyadh</span></strong><br /><br />Zero Floor, South Bldg.<br />Khaledyah Business Centre ,<br />Olaya St .<br />Riyadh 11351<br />Phone: 14621118 Site Code: SU74<br /><br /><span style="font-size:130%;color:#ff6600;"><strong><span style="color:#ff9900;">Jiddah:<br />======</span><br /></strong></span><br /><strong><span style="color:#3366ff;">NEW HORIZONS COMPUTER LEARNING CENTRE<br /></span></strong><br />AMIR ABDULLAH STREET<br />AL RAWDAH DISTRICT 1ST FLOOR<br />PO BOX 52171<br />JEDDAH 21563<br />Phone: 966 2 6642277 Site Code: SU5<br /><br /><strong><span style="color:#3366ff;">ARABIAN COMPUTER PROJECTS CO.</span></strong><br /><br />Ibrahim Juffali Road<br />(P.O.Box 14730)<br />Jeddah 21434<br />Phone: 966 26678411 Site Code: SU59<br /><br /><span style="font-size:130%;"><strong><span style="color:#993300;">Others Cities:<br />==========</span></strong><br /></span><br /><strong><span style="color:#3366ff;">New Horizons Computer Learning Centre<br /></span></strong><br />Al-Khaleej Training & Education Company<br />AL-FAYHA, NEAR CENTRAL MARKET<br />PO Box 10968<br />JUBAIL INDUSTRIAL CITY 31961<br />Phone: 966 3 348 1166 Site Code: SU52<br /><br /><br /><strong><span style="color:#3366ff;">New Horizons Computer Learning Center</span></strong><br /><br />Al Khaleej Training and Education<br />Dhahran Street<br />Mubaraz<br />Al Ahsa 31982<br />Phone: 966 3 5305007 Site Code: SU55<br /><br /><strong><span style="color:#3366ff;">New Horizons Computer Learning Center</span></strong><br /><br />Khalid Bin Walid Street<br />Circle Masjid Qiblatein<br />Madinah 1875<br />Phone: 48223333 Site Code: SU48<br /><br /><br /><strong><span style="color:#3366ff;">Philippine International School Ruraydah<br /></span></strong><br />PISB<br />Information Technology Dept.<br />Faiziyah District<br />P.O. Box 27089<br />Buraydah, Al Qasim 51331<br />Phone: 966 63841975 Site Code: su120<br /><br /><br /><strong><span style="color:#3366ff;">Al-Khaleej Training and Edu. Mens Branch<br /></span></strong><br />New Horizons CLC<br />KSA - King Saud Street<br />Buridah, Al Qasim 51432<br />Phone: 966 6 3827999 Site Code: SU54<br /><br /><br /><strong><span style="color:#3366ff;">NEW HORIZONS</span></strong><br /><br />AL-AHSA 31982<br />DHARAN STREET MUBARAZ<br />PO BOX 5822<br />HOFUF<br />Phone: 966 530 5007 444 Site Code: SU17<br /><br /><br /><strong><span style="color:#3366ff;">AL-KHALEEJ TRAINING AND EDUCATION</span></strong><br /><br />NEW HORIZONS CLC<br />AL-DIYAFAH STREET<br />P.O BOX 50991<br />ETWID<br />KHAMIS MUSHAIT 61311<br />Phone: 72375051 Site Code: SU57<br /><br /><strong><span style="color:#3366ff;">NEW HORIZONS TABUK BRANCH</span></strong><br /><br />50 STREET NEW HORIZONS BLD<br />TABUK<br />Phone: 966 4424 8613 Site Code: SU39<br /><br /><strong><span style="color:#ff0000;">Note:</span></strong> Check the below URLs, if the details given above are found incorrect.<br /><br /><a href="http://www.oracle.com/" target="_blank">http://www.oracle.com/</a><br /><a href="http://www.prometric.com/" target="_blank">http://www.prometric.com/</a><br /><br /><strong>Regards,<br />Sabdar Syed.</strong><br /><a href="http://sabdarsyed.blogspot.com/" target="_blank">http://sabdarsyed.blogspot.com/</a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-91673645745834315542008-11-24T23:04:00.000-08:002008-11-25T06:23:42.402-08:00How to find the particular Data Dictionary Table or Dynamic Performance View (V$)?<strong>Dear Blog Readers,</strong><br /><br />Even though we use some of the important <em>Data Dictionary Tables</em> and <em>Dynamic Performance (V$) views</em> regularly, sometimes we fall short to recall a particular view, i.e. It’s not easy to remember all the dictionary views.<br /><br />And also, many times, it’s been asked by novice in the OTN Forums that<br /><br /><em><span style="color:#000099;">What is the view to find the information about data files, tablespaces, etc.,?<br /><br />What are the list of Data Dictionary and Dynamic Performance Views in so and so Oracle Version?</span></em><br /><br />Well, I hope all of we know that there is a data dictionary view called “<em><strong>DICTIONARY</strong></em>”, using this DICTIONARY view, we can find the particular or list of pertinent views of any object in the database.<br /><br /><strong><span style="color:#3333ff;">What is the <em><span style="color:#000000;">DICTIONARY</span></em> view?<br /></span></strong><br />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.<br /><br /><strong><span style="color:#3333ff;">Discription:<br /></span></strong><br /><span style="color:#3333ff;">SQL> desc DICTIONARY;</span><br />Name Null? Type<br />--------------------- -------- --------------<br />TABLE_NAME VARCHAR2(30)<br />COMMENTS VARCHAR2(4000)<br /><br /><strong><span style="color:#3333ff;">Usage:</span> </strong><br /><strong><br /></strong>To find the list of data dictionary tables and dynamic performance views.<br /><br /><span style="color:#3333ff;">SELECT * FROM dict;</span><br /><br />To find the particular data dictionary table or dynamic performance view.<br /><br /><span style="color:#3333ff;">SELECT * FROM dictionary<br />WHERE table_name LIKE ‘%Search String%’;</span><br /><br />i.e.<br /><br /><span style="color:#3333ff;">SELECT * FROM dictionary<br />WHERE table_name LIKE ‘%TABLESP%’;</span><br /><p><strong>Example:</strong></p><p><br /><span style="color:#3333ff;">SQL> SELECT * FROM dictionary<br />WHERE table_name='DICTIONARY';<br /></span><br />TABLE_NAME<br />------------------------------<br />COMMENTS<br />-----------------------------------------------<br />DICTIONARY<br />Description of data dictionary tables and views<br /><br /><strong><span style="color:#3333ff;">Note:</span></strong> While querying, either the complete word DICTIONARY or first four characters DICT, which is a synonym for DICTIONARY, can be used.<br /><br /><strong><span style="color:#3333ff;">Reference:</span></strong> <em>Oracle® Database Reference 10g Release 2 (10.2) </em><br /><br /><a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm" target="_blank"> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm</a> <br /></p><p><strong>Regards,</strong></p><p><a href="http://sabdarsyed.blogspot.com/" target="_blank">Sabdar Syed </a><a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm" target="_blank"></a></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-11617620824646608762008-11-09T01:36:00.000-08:002008-11-09T01:38:54.471-08:00Received the Certification Kit of Oracle 10g RAC Expert Exam.Dear Friends,<br /><br />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.<br /><br />Best of luck everyone who is preparing for the Oracle 10g RAC Expert Exam – 1Z0-048.<br /><br />Check my other blog post on <a href="http://sabdarsyed.blogspot.com/2008/08/how-to-prepare-for-1z0-048-oracle-10g.html" target="_blank"><strong><span style="color:#000099;">“How to prepare for 1Z0-048 - Oracle 10g RAC Certified Expert Exam.”</span></strong></a><br /><br />Regards,<br />Sabdar Syed,<br /><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com</a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com5tag:blogger.com,1999:blog-4777297253091021182.post-65268669045370657452008-11-08T04:28:00.000-08:002008-11-09T00:02:34.380-08:00How to Get/Gain Real Time Experience/Exposure as a DBA!Dear Blog Readers,<br /><br />Every now and then I do receive e-mails from the novice DBAs saying that:<br /><br /><strong><em><span style="color:#000099;">“We could not perform well at the interview, as the questions were too technically based on real time requirements”<br /><br />“Due to not having real time experience, we failed at the interview to explain the steps/approach to resolve the issue asked”<br /><br />…… and so on<br /></span></em></strong><br />When I asked them how they prepare and practice the DBA Activities, their response is as follows:<br /><br /><strong><em><span style="color:#000099;">“We brought the Oracle DBA Books written by so and so authors for reference.”<br /><br />“We only practiced the scenarios what was taught and given as drill in the training institute.”<br /><br />“We installed the Oracle Software with starter database and get started practicing.”<br /><br />…… and so on</span></em></strong><br /><br />Well, here are my opinions/suggestions/advices, to them those who are preparing and practicing as above, to gain the real time experience/exposure.<br /><br />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.<br /><br />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.<br /><br />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.<br /><br />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.<br /><br />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.<br /><br />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.<br /><br /><strong><span style="color:#000099;">There are many a lot to say…but at the end what all I can say is…..</span></strong><br /><br />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.<br /><br /><a href="http://forums.oracle.com/forums/forum.jspa?forumID=61" target="_blank"><strong>Forum: Database - General</strong> </a><br /><br />Another good habit is referring the good Oracle Related Blogs to know how they resolved the issues, how they implement the things in their organization with their experience.<br /><br /><a href="http://wiki.oracle.com/page/List+of+Oracle-related+blogs?t=anon" target="_blank"><strong>List of Oracle-related blogs</strong> </a><br /><br />Do not forget to read and download this great document<strong> </strong><a href="http://sabdarsyed.blogspot.com/2008/07/grow-that-dba-career.html" target="_blank"><strong>"Grow That DBA Career"</strong> </a><br /><br /><strong>Note:</strong> Above suggestions are only my views and need not to be the same with others. Whoever have the information of real time ideas/tips and wanted share with the blog readers, they are free allowed to comment directly in the comments section of this blog post. I will also keep update this post with more and more real time experience ideas and tips.<br /><br /><strong><em><u><span style="color:#ff0000;">Update:</span></u></em></strong> Take a look at the <em><span style="color:#3333ff;">Mr.TOM</span></em> comment in the comment section below, where he has given his own views on real time tips further to this blog post. Thanks to <em><span style="color:#3333ff;">TOM</span></em> for adding his views to this post.<br /><br /><strong><span style="color:#3333ff;">Happy Reading !!!</span><br /></strong><br />Regards,<br /><strong>Sabdar Syed,</strong><br /><a href="http://sabdarsyed.blogspot.com/" target="_blank">http://sabdarsyed.blogspot.com/</a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com7tag:blogger.com,1999:blog-4777297253091021182.post-77554013869450942202008-10-12T06:50:00.000-07:002008-10-12T22:42:41.969-07:00Oracle Metalink Notes for Oracle Apps DBAs.Dear Friends,<br /><br />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.<br /><br /><strong><span style="color:#cc0000;">Note:</span></strong> You have to have an account in <a href="https://metalink.oracle.com/" target="_blank"><strong><em>Oracle Metalink</em></strong> </a>to access notes.<br /><br /><strong><span style="color:#ff0000;"><span style="font-size:180%;">Installation</span> </span></strong><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=452120.1" target="_blank"> <strong>452120.1</strong> </a>- How to locate the log files and troubleshoot RapidWiz for R12<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=329985.1" target="_blank"> <strong>329985.1 </strong></a>- How to locate the Rapid Wizard Installation log files for Oracle Applications 11.5.8 and higher<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=362135.1" target="_blank"> <strong>362135.1 </strong></a>- Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=312731.1" target="_blank"> <strong>312731.1</strong> </a>- Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216550.1" target="_blank"> <strong>216550.1</strong> </a>- Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=279956.1" target="_blank"> <strong>279956.1</strong> </a>- Oracle E-Business Suite Release 11i with 9i RAC: Installation and Configuration using AutoConfig<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=294932.1" target="_blank"> <strong>294932.1 </strong></a>- Recommendations to Install Oracle Applications 11i<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=403339.1" target="_blank"> <strong>403339.1</strong> </a>- Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=455398.1" target="_blank"> <strong>455398.1</strong> </a>- Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=402311.1" target="_blank"> <strong>402311.1</strong> </a>- Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Microsoft Windows<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=405565.1" target="_blank"> <strong>405565.1</strong> </a>- Oracle Applications Release 12 Installation Guidelines<br /><br /><span style="font-size:180%;color:#ff0000;"><strong>AD Utilities</strong></span><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=178722.1" target="_blank"> <strong>178722.1</strong> </a>- How to Generate a Specific Form Through AD utility ADADMIN<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=109667.1" target="_blank"> <strong>109667.1</strong> </a>- What is AD Administration on APPS 11.0.x ?<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=112327.1" target="_blank"> <strong>112327.1 </strong></a>- How Does ADADMIN Know Which Forms Files To Regenerate?<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=136342.1" target="_blank"> <strong>136342.1 </strong></a>- How To Apply a Patch in a Multi-Server Environment<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=109666.1" target="_blank"> <strong>109666.1</strong> </a>- Release 10.7 to 11.0.3 : What is adpatch ?<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=152306.1" target="_blank"> <strong>152306.1 </strong></a>- How to Restart Failed AutoInstall Job<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=356878.1" target="_blank"> <strong>356878.1</strong> </a>- How to relink an Applications Installation of Release 11i and Release 12<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=218089.1" target="_blank"> <strong>218089.1</strong> </a>- Autoconfig FAQ<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=125922.1" target="_blank"> <strong>125922.1</strong> </a>- How To Find Oracle Application File Versions<br /><br /><strong><span style="color:#ff0000;"><span style="font-size:180%;">Cloning</span> </span></strong><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=419475.1" target="_blank"> <strong>419475.1</strong> </a>- Removing Credentials from a Cloned EBS Production Database<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=398619.1" target="_blank"> <strong>398619.1 </strong></a>- Clone Oracle Applications 11i using Oracle Application Manager (OAM Clone)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=230672.1" target="_blank"> <strong>230672.1</strong> </a>- Cloning Oracle Applications Release 11i with Rapid Clone<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=406982.1" target="_blank"> <strong>406982.1</strong> </a>- Cloning Oracle Applications Release 12 with Rapid Clone<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=364565.1" target="_blank"> <strong>364565.1</strong> </a>- Troubleshooting RapidClone issues with Oracle Applications 11i<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=603104.1" target="_blank"> <strong>603104.1</strong> </a>- Troubleshooting RapidClone issues with Oracle Applications R12<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=435550.1" target="_blank"> <strong>435550.1</strong> </a>- R12 Login issue on target after cloning<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=559518.1" target="_blank"> <strong>559518.1</strong> </a>- Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216664.1" target="_blank"> <strong>216664.1</strong> </a>- FAQ: Cloning Oracle Applications Release 11i<br /><br /><span style="font-size:180%;color:#ff0000;"><strong>Patching</strong></span><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=225165.1" target="_blank"> <strong>225165.1</strong> </a>- Patching Best Practices and Reducing Downtime<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=62418.1" target="_blank"> <strong>62418.1 </strong></a>- PATCHING/PATCHSET FREQUENTLY ASKED QUESTIONS<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=181665.1" target="_blank"> <strong>181665.1</strong> </a>- Release 11i Adpatch Basics<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=443761.1" target="_blank"> <strong>443761.1</strong> </a>- How to check if a certain Patch was applied to Oracle Applications instance?<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=231701.1" target="_blank"> <strong>231701.1</strong> </a>- How to Find Patching History (10.7, 11.0, 11i)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=60766.1" target="_blank"> <strong>60766.1</strong> </a>- 11.0.x : Patch Installation Frequently Asked Questions<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=459156.1" target="_blank"> <strong>459156.1</strong> </a>- Oracle Applications Patching FAQ for Release 12<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=130608.1" target="_blank"> <strong>130608.1</strong> </a>- AdPatch Basics<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=60766.1" target="_blank">:<strong>60766.1</strong> </a>- Patch Installation FAQ (Part 1)<br /><br /><span style="font-size:180%;color:#ff0000;"><strong>Upgrade</strong></span><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=461709.1" target="_blank"> <strong>461709.1</strong> </a>- Oracle E-Business Suite Upgrade Guide - Plan<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=293166.1" target="_blank"> <strong>293166.1</strong> </a>- Previous Versions of e-Business 11i Upgrade Assistant FAQ<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=224875.1" target="_blank"> <strong>224875.1</strong> </a>- Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=224814.1" target="_blank"> <strong>224814.1 </strong></a>- Installation, Patching & Upgrade Current Issues<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=225088.1" target="_blank"> <strong>225088.1</strong> </a>- Installation, Patching & Upgrade Patches Guide<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=225813.1" target="_blank"> <strong>225813.1</strong> </a>- Installation, Patching & Upgrade Setup and Usage Guide<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=224816.1" target="_blank"> <strong>224816.1</strong> </a>- Installation, Patching & Upgrade Troubleshooting Guide<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216550.1" target="_blank"> <strong>216550.1</strong> </a>- Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=362203.1" target="_blank"> <strong>362203.1</strong> </a>- Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=423056.1" target="_blank"> <strong>423056.1</strong> </a>- Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.2)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=726982.1" target="_blank"> <strong>726982.1</strong> </a>- Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.3)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=452783.1" target="_blank"> <strong>452783.1 </strong></a>- Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=406652.1" target="_blank"> <strong>406652.1</strong> </a>- Upgrading Oracle Applications 11i DB to DB 10gR2 with Physical Standby in Place<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=316365.1" target="_blank"> <strong>316365.1</strong> </a>- Oracle Applications Release 11.5.10.2 Maintenance Pack Installation Instructions<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=418161.1" target="_blank"> <strong>418161.1</strong> </a>- Best Practices for Upgrading Oracle E-Business Suite<br /><br /><span style="font-size:180%;color:#ff0000;"><strong>Printer</strong></span><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=297522.1" target="_blank"> <strong>297522.1</strong> </a>- How to investigate printing issues and work towards its resolution ?<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=110406.1" target="_blank"> <strong>110406.1</strong> </a>- Check Printing Frequently Asked Questions<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=264118.1" target="_blank"> <strong>264118.1</strong> </a>- Pasta Pasta Printing Setup Test<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=200359.1" target="_blank"> <strong>200359.1</strong> </a>- Oracle Application Object Library Printer Setup Test<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=234606.1" target="_blank"> <strong>234606.1</strong> </a>- Oracle Application Object Library Printer Initialization String Setup Test<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1014599.102" target="_blank"> <strong>1014599.102</strong> </a>- Subject: How to Test Printer Initialization Strings in Unix<br /><br /><strong><span style="font-size:180%;color:#ff0000;">Performance</span></strong><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=390137.1" target="_blank"><strong> 390137.1</strong> </a>- FAQ for Collections Performance<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216205.1" target="_blank"> <strong>216205.1</strong> </a>- Database Initialization Parameters for Oracle Applications Release 11i<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=169935.1" target="_blank"> <strong>169935.1</strong> </a>- Troubleshooting Oracle Applications Performance Issues<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=171647.1" target="_blank"> <strong>171647.1</strong> </a>- Tracing Oracle Applications using Event 10046<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=153507.1" target="_blank"> <strong>153507.1</strong> </a>- Oracle Applications and StatsPack<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=356501.1" target="_blank"> <strong>356501.1</strong> </a>- How to Setup Pasta Quickly and Effectively<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=333504.1" target="_blank"> <strong>333504.1</strong> </a>- How To Print Concurrent Requests in PDF Format<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=356972.1" target="_blank"><strong> 356972.1</strong> </a>- 11i How to troubleshoot issues with printers<br /><br /><span style="font-size:180%;color:#ff0000;"><strong>Others</strong></span><br /><br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=189367.1" target="_blank"> <strong>189367.1</strong> </a>- Best Practices for Securing the E-Business Suite<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=403537.1" target="_blank"><strong> 403537.1</strong> </a>- Best Practices For Securing Oracle E-Business Suite Release 12<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=454616.1" target="_blank"><strong> 454616.1</strong> </a>- Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=394692.1" target="_blank"> <strong>394692.1</strong> </a>- Oracle Applications Documentation Resources, Release 12<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=370274.1" target="_blank"> <strong>370274.1</strong> </a>- New Features in Oracle Application 11i<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=130183.1" target="_blank"> <strong>130183.1</strong> </a>- How to Get Log Files from Various Programs for Oracle Applications<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=285267.1" target="_blank"><strong> 285267.1</strong> </a>- Oracle E-Business Suite 11i and Database FAQ<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=453137.1" target="_blank"> <strong>453137.1</strong> </a>- Oracle Workflow Best Practices Release 12 and Release 11i<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=398942.1" target="_blank"> <strong>398942.1</strong> </a>- FNDCPASS Utility New Feature ALLORACLE<br />Note:<a href="https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=187735.1" target="_blank"> <strong>187735.1</strong> </a>- Workflow FAQ - All Versions<br /><br /><span style="font-size:130%;color:#ff0000;"><strong>Oracle Applications 11i/12 Online Documentation<br /></strong></span><br /><a href="http://www.oracle.com/technology/documentation/applications.html" target="_blank">http://www.oracle.com/technology/documentation/applications.html</a><br /><br /><strong><em>Note:</em></strong> Above are only the few important notes, there are bunch of notes on many other issues and topics in the metalink. I would suggest one to refer the metalink for more note ids.<br /><br />Leave your comments if you feel these Oracle Metalink Notes help you in solving your Application issues.<br /><br />Regards,<br /><strong>Sabdar Syed,</strong><br /><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com/</a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com2tag:blogger.com,1999:blog-4777297253091021182.post-61836321659300117112008-10-03T16:37:00.000-07:002008-10-03T16:48:38.287-07:00My Blog Feedback Page<strong>Dear Blog Readers,</strong><br /><br />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.<br /><br />In order to serve you better with required information in my blog, please leave your comments/suggestions/doubts/questions/requirements/ etc.<br /><br />Link for comments here - <a href="https://www.blogger.com/comment.g?blogID=4777297253091021182&postID=6183632165930011711" target="_blank"><strong><em><span style="color:#cc0000;">Feedback Page !</span></em></strong></a><br /><br />Please check the comments submitted in the <em><span style="color:#000099;">comments</span></em> item below.<br /><br />Thanks & Regards,<br /><strong>Sabdar Syed.</strong><br /><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com/</a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com21tag:blogger.com,1999:blog-4777297253091021182.post-85782034790663295012008-09-27T06:34:00.001-07:002008-09-27T06:36:18.279-07:00How I Changed My Blog with 3 Column Template and Right & Left Sidebars?<p>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. </p><p>It’s as easy as simple. </p><p><strong>Step -1:</strong> 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) </p><p><strong>Step -2:</strong> Take the backup of template before trying out any customization that requires direct modification of the HTML code of original template. </p><p><strong>Step -3:</strong> Follow the below link.</p><p></p><p><a href="http://bguide.blogspot.com/2008/04/3-column-templates-rounders-left-and.html" target="_blank">3 Column Templates : Rounders : Left and Right Sidebars </a></p><p>For other type of templates, then check this </p><p><a href="http://bguide.blogspot.com/2008/02/3-columns-step-by-step-guides.html" target="_blank">3 Column Templates: Step by Step Guides </a></p><p>Regards,</p><p><strong>Sabdar Syed.</strong></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com2tag:blogger.com,1999:blog-4777297253091021182.post-37806817927335754692008-09-26T05:01:00.000-07:002008-09-26T05:21:15.941-07:00How 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.<br /><strong></strong><br /><strong><span style="color:#cc0000;"><u>Details:</u></span><br />Oracle Database Version:</strong> 10g R2 (10.2.0.1)<br /><strong>Application User:</strong> APPUSR<br /><strong>Error:</strong> ORA-28000: the account is locked<br /><br /><strong><span style="color:#cc0000;">Login as SYSDBA</span><br /></strong><br />SQL> conn /as sysdba<br /><br /><strong><span style="color:#cc0000;">Check the APPSUSR account status.<br /></span></strong><br /><span style="font-family:courier new;">SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;<br />USERNAME ACCOUNT_STATUS PROFILE<br />-------------------- -------------------- ---------------<br />APPUSR <span style="color:#ff0000;">LOCKED(TIMED)</span> <span style="color:#006600;">DEFAULT</span><br /></span><br />Here we can see the account status is LOCKED (TIMED) and the default user’s profile is DEFAULT.<br /><br /><span style="color:#cc0000;"><strong>Check the resource limits of DEFAULT profile.</strong></span><br /><br /><span style="font-family:courier new;">SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';<br /><br />RESOURCE_NAME RESOURCE LIMIT<br />-------------------------------- -------- ----------<br />COMPOSITE_LIMIT KERNEL UNLIMITED<br />SESSIONS_PER_USER KERNEL UNLIMITED<br />CPU_PER_SESSION KERNEL UNLIMITED<br />CPU_PER_CALL KERNEL UNLIMITED<br />LOGICAL_READS_PER_SESSION KERNEL UNLIMITED<br />LOGICAL_READS_PER_CALL KERNEL UNLIMITED<br />IDLE_TIME KERNEL UNLIMITED<br />CONNECT_TIME KERNEL UNLIMITED<br />PRIVATE_SGA KERNEL UNLIMITED<br /><strong>FAILED_LOGIN_ATTEMPTS PASSWORD <span style="color:#ff0000;">10</span><br /></strong>PASSWORD_LIFE_TIME PASSWORD UNLIMITED<br />PASSWORD_REUSE_TIME PASSWORD UNLIMITED<br />PASSWORD_REUSE_MAX PASSWORD UNLIMITED<br />PASSWORD_VERIFY_FUNCTION PASSWORD NULL<br />PASSWORD_LOCK_TIME PASSWORD UNLIMITED<br />PASSWORD_GRACE_TIME PASSWORD UNLIMITED<br /></span><br />All 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 <a href="http://download.oracle.com/docs/cd/B19306_01/readmes.102/b14233/toc.htm#sthref26" target="_blank"><span style="color:#ff0000;">Oracle Documentations</span></a>, it’s stated that FAILED_LOGIN_ATTEPTS attribute for DEFAULT profile has been changed from 10.2.0.1 from UNLIMITED to 10.<br /><br />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.<br /><br /><strong><span style="color:#cc0000;">Create a profile.</span></strong><br /><br /><span style="font-family:courier new;">SQL> CREATE PROFILE APPUSR_DEFAULT LIMIT<br />2 COMPOSITE_LIMIT UNLIMITED<br />3 SESSIONS_PER_USER UNLIMITED<br />4 CPU_PER_SESSION UNLIMITED<br />5 CPU_PER_CALL UNLIMITED<br />6 LOGICAL_READS_PER_SESSION UNLIMITED<br />7 LOGICAL_READS_PER_CALL UNLIMITED<br />8 IDLE_TIME UNLIMITED<br />9 CONNECT_TIME UNLIMITED<br />10 PRIVATE_SGA UNLIMITED<br />11 <strong><span style="color:#3333ff;">FAILED_LOGIN_ATTEMPTS UNLIMITED</span></strong><br />12 PASSWORD_LIFE_TIME UNLIMITED<br />13 PASSWORD_REUSE_TIME UNLIMITED<br />14 PASSWORD_REUSE_MAX UNLIMITED<br />15 PASSWORD_VERIFY_FUNCTION NULL<br />16 PASSWORD_LOCK_TIME UNLIMITED<br />17 PASSWORD_GRACE_TIME UNLIMITED;<br /><br />Profile created.<br /></span><br /><strong><span style="color:#cc0000;">Assign the newly created profile to the user as default profile.<br /></span></strong><br /><span style="font-family:courier new;">SQL> ALTER USER appusr PROFILE appusr_default;</span><br /><br /><span style="font-family:courier new;">User altered.</span><br /><br /><strong><span style="color:#cc0000;">Unlock the user account:<br /></span></strong><br /><span style="font-family:courier new;">SQL> ALTER USER appusr ACCOUNT UNLOCK;<br /><br />User altered.<br /></span><br /><strong><span style="color:#cc0000;">Now check again the status of APPUSR user.</span></strong><br /><br /><span style="font-family:courier new;">SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’;<br />USERNAME ACCOUNT_STATUS PROFILE<br />-------------------- -------------------- ---------------<br />APPUSR <strong><span style="color:#3333ff;">OPEN</span></strong> <span style="color:#006600;">APPUSR_DEFAULT</span><br /></span><br /><span style="font-family:arial;"><strong>Regards,</strong></span><br /><span style="font-family:arial;"><strong>Sabdar Syed,</strong></span><br /><span style="font-family:courier new;"><a href="http://sabdarsyed.blogspot.com/"><span style="font-family:arial;">http://sabdarsyed.blogspot.com</span></a><br /><br /></span><span style="font-family:courier new;"></span><span style="font-family:courier new;"></span>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com5tag:blogger.com,1999:blog-4777297253091021182.post-18651481345014954282008-09-24T03:01:00.000-07:002008-09-26T10:31:47.011-07:00My Mentor is an Oracle Certified Master in Oracle 10g now!<p>Dear All,<br /><br />I’m pleased to say that my elder brother, Mr. <a href="http://www.oracle.com/technology/ocm/shussain.html" target="_blank"><strong><span style="color:#ff0000;"><em>Syed Jaffar Hussain</em></span></strong></a>, 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 <a href="http://apex.oracle.com/pls/otn/f?p=19297:4:1616993543018718::NO:4:P4_ID:126" target="_blank"><strong><em><span style="color:#ff0000;">Oracle</span> <span style="color:#000000;">ACE</span></em></a></strong> Award winner.<br /><br />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.</p><p>Regards,<br /><strong>Sabdar Syed,<br /></strong><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com/</a></p><p></p>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-84399265810842290982008-09-22T03:21:00.000-07:002008-09-24T03:54:13.640-07:00Metalink 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<br /><br /><a href="https://metalink.oracle.com/" target="_blank"><img src="https://metalink.oracle.com/CSP/ui/images/global-logo.gif" /><br /><br /></a><strong>As per My Oracle Support:<br /></strong><br /><br /><center><em>“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.”</em></center><br /><strong>A new look of My Oracle Support</strong><br /><br /><a href="https://metalink.oracle.com/" target="_blank"><br /><em><img src="https://metalink2.oracle.com/i/metalinksmalllogo.gif" /><br /></em></a><br /><br /><em><img src="https://metalink.oracle.com/CSP/ui/images/metalink_collectanalyzeact_trans.gif" /><br /><br /></em><strong>Important Blog on new look of My Oracle Support.<br /></strong><br /><a href="http://blogs.oracle.com/supportportal/2008/09/introducing_my_oracle_support.html" target="_blank">Introducing... My Oracle Support!</a><br /><br /><span style="color:#cc0000;"><strong>Classic MetaLink vs. New MetaLink — <span style="color:#3333ff;"><em><a href="https://metalink.oracle.com/CSP/ui/faq.html#metalink-difference" target="_blank"><span style="color:#3333ff;"><em>What’s the Difference?</em></span></a><br /></em></span></strong></span><br />Regards,<br />Sabdar Syed,<br /><a href="http://sabdarsyed.blogspot.com/">http://sabdarsyed.blogspot.com/</a>Sabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0tag:blogger.com,1999:blog-4777297253091021182.post-55671404708014313662008-09-22T01:03:00.000-07:002008-09-22T01:17:32.456-07:00How to make a Link to be opened in a New Browser Window?It's as easy as follows:<br /><br />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 <em><span style="color:#ff0000;">target="_blank"</span></em> attribute to your link tag i.e. in in the HTML code.<br /><br />For Example:<br /><br /><pre> <code> <a href="http://sabdarsyed.blogspot.com/" target="_blank"> This is My BlogSpot!</a></code></pre><pre> </pre>This will give you the following link:<br /><br /><a href="http://sabdarsyed.blogspot.com/" target="_blank">This is My BlogSpot!</a><br /><br />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.<br /><br />Regards,<br />Sabdar Syed,<br />http://sabdarsyed.blogspot.comSabdar Syedhttp://www.blogger.com/profile/09284831783701628038noreply@blogger.com0