tag:blogger.com,1999:blog-8590682598203753162024-02-06T21:08:37.503-05:00My Oracle BlogFocusing on Oracle Database, RAC, Data Guard, Exadata, Linux, MySQL ...Unknownnoreply@blogger.comBlogger29125tag:blogger.com,1999:blog-859068259820375316.post-63910011572085847432018-04-23T10:52:00.000-04:002018-04-23T12:31:32.774-04:00Choosing the Right Encryption Approach for RDBMS<div style="text-align: justify;">
<div style="text-align: left;">
Sometimes, specially now a days when people are planning to move to cloud, security is one of the key factor, and in my experience, what I saw is the cloud architect tries to sell the full disk encryption as a solution for all applications, databases etc. Which in my opinion, is absolutely incorrect.</div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
<br></div>
</div>
<div style="text-align: justify;">
<div style="text-align: left;">
The goal of this post is to evaluate, at a higher level, <b>different encryption approach </b>for different scenario (specially RDBMS) to better inform the decision making process.</div>
</div>
<b></b><br>
<a href="http://www.myoracleblog.com/2018/04/choosing-right-encryption-approach-for.html#more">Continue reading... »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-40994954139021892422018-04-17T16:24:00.001-04:002018-04-18T15:44:00.399-04:00MySQL vs. MariaDBA high level comparison between <b>MySQL </b>& <b>MariaDB</b>.<br>
The goal of this post is to evaluate, at a higher level, <b>MySQL </b>& <b>MariaDB </b>to better inform the decision making process.<br>
<br>
<br>
<a href="http://www.myoracleblog.com/2018/04/mysql-vs-mariadb.html#more">Continue reading... »</a>Unknownnoreply@blogger.com8tag:blogger.com,1999:blog-859068259820375316.post-5320947142604769242018-01-24T15:31:00.001-05:002018-04-18T15:43:07.290-04:00ZERO Downtime Kernel Security updates for Oracle & Redhat Linux<div style="text-align: justify;">
<div class="MsoNormal">
<b>Linux Kernel vulnerabilities</b>, e.g. Kernel Side-Channel Attacks (Meltdown, Spectre), Dirty COW, Linux Kernel Double Fetch Denial of Service
Vulnerability, udp.c in the Linux kernel ... … … the list goes on and on.<br>
<br>
Linux kernel security updates with important new security and reliability patches are released about once per month to stay up to date with important kernel and user-space security updates.<br>
<br>
Industry regulations and best practices require companies to apply these security updates and patches regularly because security is compromised by a failure to update. System administrators are forced to choose between known best practices and system reboots that are costly and disruptive.<br>
<br></div>
<div class="MsoNormal">
Since these are kernel security fixes which means the
operating system requires restart in order to active the new kernel and the
fixes.<o:p></o:p></div>
<div class="MsoNormal">
<br></div>
<div class="MsoNormal">
<b>ONLY</b> to fix Linux kernel vulnerabilities, every month
organizations have hundreds of hour's system downtime in every quarter at
minimum.<o:p></o:p><br>
<br></div>
<div class="MsoNormal">
<br>
</div></div><a href="http://www.myoracleblog.com/2018/01/ksplice-zero-downtime-kernel-security.html#more">Continue reading... »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-1445063633515256422018-01-17T16:13:00.000-05:002018-04-18T15:42:35.097-04:00Oracle SPARC: Software & SQL in Silicon: What It Does and Why<div style="text-align: start;">
<b style="text-align: justify;">Software in Silicon: </b>Software features incorporated into Oracle's SPARC processors (e.g. M7, M8) provide increased security and higher performance for databases and software applications.</div>
<div style="text-align: start;">
<br></div>
<div style="text-align: start;">
Software in Silicon is comprised of three very unique technology offerings: <b>SQL in Silicon</b>, <b>Capacity in Silicon</b> and <b>Security in Silicon</b>.<br>
<br>
<br>
</div><a href="http://www.myoracleblog.com/2018/01/url-sparc-software-sql-in-silicon-what.html#more">Continue reading... »</a>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-859068259820375316.post-71279401744203277702018-01-15T14:29:00.000-05:002019-01-19T14:54:17.602-05:00Observation: Amazon Redshift & AuroraMany organizations are thinking about <b>Amazon's Redshift & Aurora</b> Databases. Followings are some observations and thoughts for anyone who plans to use these database technologies -<br>
<br>
<br>
<a href="http://www.myoracleblog.com/2018/01/observations-amazon-redshift-aurora.html#more">Continue reading... »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-859068259820375316.post-1588539950539867492018-01-12T12:06:00.000-05:002018-01-15T15:06:12.227-05:00Next Oracle Release will be Oracle Database 18 instead 12.2.0.2<b>Release 12.2:</b> New releases will be annual and the version will be the last two digits of the release year. The release originally planned as 12.2.0.2 will now be release 18, and the release originally planned as 12.2.0.3 will be release 19. Releases 18 and 19 will be treated as under the umbrella of 12.2 for Lifetime Support purposes. The current plan is for Oracle Database 19 to be the last release for 12.2. This may change in the future to Oracle 20 as the last release for 12.2.<br />
<br />
<br />
<b>Reference:</b><br />
<ul>
<li>My Oracle Support Note: Release Schedule of Current Database Releases (Doc ID 742060.1)</li>
<li><a href="https://mikedietrichde.com/2017/08/10/thoughts-new-oracle-database-release-schedule/">https://mikedietrichde.com/2017/08/10/thoughts-new-oracle-database-release-schedule/</a></li>
</ul>
<div>
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-53616046650332761462018-01-10T16:05:00.000-05:002018-04-17T15:55:08.120-04:00Oracle Database Security Assessment Tool (DBSAT)<span style="background-color: white; color: #343a41; font-family: "segoe ui westeuropean" , "segoe ui" , "segoe ui emoji" , , "blinkmacsystemfont" , "roboto" , "helvetica neue" , sans-serif; font-size: 15px;"><b>Check this one out -</b></span><br />
<span style="background-color: white; color: #343a41; font-family: "segoe ui westeuropean" , "segoe ui" , "segoe ui emoji" , , "blinkmacsystemfont" , "roboto" , "helvetica neue" , sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: #343a41; font-family: "segoe ui westeuropean" , "segoe ui" , "segoe ui emoji" , , "blinkmacsystemfont" , "roboto" , "helvetica neue" , sans-serif; font-size: 15px;"><b>DB Security: Oracle Database Security Assessment Tool (DBSAT)</b> (MOS Note # 2138254.1)</span><br />
<span style="background-color: white; color: #343a41; font-family: "segoe ui westeuropean" , "segoe ui" , "segoe ui emoji" , , "blinkmacsystemfont" , "roboto" , "helvetica neue" , sans-serif; font-size: 15px;">-- Works with: 10.2.0.5 and later releases.</span><br />
<br style="background-color: white; box-sizing: inherit; color: #343a41; font-family: "Segoe UI WestEuropean", "Segoe UI", "Segoe UI Emoji", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px;" />
<span style="background-color: white; color: #343a41; font-family: "segoe ui westeuropean" , "segoe ui" , "segoe ui emoji" , , "blinkmacsystemfont" , "roboto" , "helvetica neue" , sans-serif; font-size: 15px;">This tool provides a detail analysis, insights & recommendations.</span><br />
<span style="background-color: white; color: #343a41; font-family: "segoe ui westeuropean" , "segoe ui" , "segoe ui emoji" , , "blinkmacsystemfont" , "roboto" , "helvetica neue" , sans-serif; font-size: 15px;"><br /></span>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-3493712999892895132018-01-08T12:00:00.000-05:002018-01-15T12:08:52.517-05:00Review MOS Note: 2312911.1 - Before upgrading an Oracle Database from 12.1 to 12.2 or laterIf you are planning to upgrade an Oracle Database from <b>12.1</b> to <b>12.2</b> or later, depending on your configuration, there is a possibility that the upgrade can result in immediate execution plan changes for a lot of SQLs due to the changes in adaptive feature in 12cR2.<br />
<br />
Review the <b>MOS Note: 2312911.1</b> for optimizer behavior (adaptive feature) change in 12cR2.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-44967233352426522062018-01-05T11:42:00.000-05:002018-04-18T15:40:59.672-04:00Storage Mirroring vs. Database Replications/Mirroring Technologies<div class="ace-line" id="magicdomid271" style="margin: 0px; padding: 0px 1px 0px 0px;">
<div class="ace-line" id="magicdomid271" style="margin: 0px; padding: 0px 1px 0px 0px;">
<div class="ace-line" id="magicdomid2809" style="color: #222222; font-family: "lucida grande", verdana, arial, helvetica, sans-serif; font-size: 12px; margin: 0px; padding: 0px 1px 0px 0px;">
<div style="text-align: justify;">
Most organizations have some sort of storage based remote mirroring (array mirroring) technology as a disaster recovery solution. It's really a good solution for files and applications but definitely <b><u>NOT for RDBMS</u></b>.</div>
</div>
<div class="ace-line" id="magicdomid273" style="font-family: "lucida grande", verdana, arial, helvetica, sans-serif; font-size: 12px; margin: 0px; padding: 0px 1px 0px 0px;">
<div style="color: #222222;">
<div style="text-align: justify;">
<br></div>
</div>
<div style="color: #222222;">
<div style="text-align: justify;">
Array mirroring is a sophisticated technology promoted as a generic infrastructure solution that makes a simple promise – <b>whatever is written to a primary volume will also be written to a mirrored volume at a remote site.</b></div>
</div>
<div style="color: #222222;">
<div style="text-align: justify;">
<br></div>
</div>
<div style="color: #222222;">
<div style="text-align: justify;">
Keeping this promise, however, can have disastrous consequences for data protection and availability when the data written to primary volumes is corrupt.<br>
<br></div>
</div>
<div style="color: #222222;">
<div style="text-align: justify;">
<br>
</div></div></div></div></div><a href="http://www.myoracleblog.com/2018/01/storage-mirroring-vs-database.html#more">Continue reading... »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-432361936605777082018-01-02T11:00:00.000-05:002018-04-18T15:40:32.106-04:00Running Oracle on VMware: Challenges<div class="" id="magicdomid2" style="color: #222222; margin: 0px; padding: 0px 1px 0px 0px;">
<span style="font-family: "lucida grande" , "verdana" , "arial" , "helvetica" , sans-serif;"><span style="font-size: 12px;">I am sure that there are number of reasons why VMware is</span></span><span style="font-family: "calibri" , "calibri_msfontservice" , sans-serif;"><span style="background-color: white;"> </span></span>preferred <span style="font-family: "lucida grande" , "verdana" , "arial" , "helvetica" , sans-serif; font-size: 12px;">to run RDBMS in some cases. But there are some major challenges are there as well.</span></div>
<div class="" id="magicdomid5" style="color: #222222; font-family: "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px; padding: 0px 1px 0px 0px;">
<br style="margin: 0px; padding: 0px;"></div>
<div class="" id="magicdomid6" style="color: #222222; font-family: "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px; padding: 0px 1px 0px 0px;">
<span class="author-1633704903" style="cursor: auto; margin: 0px; padding: 1px 0px;">This note is just to highlight the challenges observed when running Oracle in VMware environment.</span></div>
<div class="" id="magicdomid7" style="color: #222222; font-family: "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px; padding: 0px 1px 0px 0px;">
<br style="margin: 0px; padding: 0px;"></div>
<div class="" id="magicdomid8" style="color: #222222; font-family: "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px; padding: 0px 1px 0px 0px;">
<br>
</div><a href="http://www.myoracleblog.com/2018/01/running-oracle-on-vmware-challenges.html#more">Continue reading... »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-5253648976996158042015-12-22T02:26:00.001-05:002015-12-22T02:42:25.231-05:00Exadata Pre-upgrade: Backing up /, /boot & /u01 mount pointDuring any Exadata patching and/or Grid Infrastructure/Oracle Database upgrade we always want to keep a backup of the OS & Oracle Binaries before start changing anything in the environment.<br>
<br>
Backup of <b>/ (root)</b> & <b>/boot</b> mount point can be done using DBNU utility (MOS Note # 1553103.1).<br>
For /u01, it is possible to follow the below procedure to backup.<br>
<a href="http://www.myoracleblog.com/2015/12/exadata-pre-upgrade-backing-up-boot-u01.html#more">Continue reading... »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-859068259820375316.post-17295630097615506582015-12-15T01:42:00.001-05:002015-12-18T00:42:55.253-05:00Exadata Compute Node: Filesystem resize issue<div style="text-align: justify;">
Exadata documentation talks about how to resize an LVM Partitions in compute node for two different scenario -</div>
<div style="text-align: justify;">
<br></div>
<div style="text-indent: 4em;">
<div style="text-align: justify;">
<b>Option 1:</b> <a href="http://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#CHDGGBBJ" target="_blank">Extending the root LVM Partition on Systems Running Oracle Exadata Storage Server Software Release 11.2.3.2.1 or Later</a></div>
</div>
<div style="text-indent: 4em;">
<div style="text-align: justify;">
<b>Option 2:</b> <a href="http://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#CHDDCJGA" target="_blank">Extending the root LVM Partition on Systems Running Oracle Exadata Storage Server Software Earlier than Release 11.2.3.2.1</a></div>
</div>
<div style="text-align: justify;">
<br>
Obviously anyone will consider to resize the filesystem <b>ONLINE</b> using <b>Option 1</b>. But if the environment came (patched/upgraded) from an older image version (e.g. from <= 11.2.3.2.0, look for imagehistory output) but current running a newer image version, lets say 11.2.3.3.x, 12.1.2.1.x or even greater, though the image is newer but still it might not possible to do the filesystem resize online. This is mainly applicable for X2, X3 (early releases).</div>
<div style="text-align: justify;">
</div><a href="http://www.myoracleblog.com/2015/12/exadata-compute-node-filesystem-resize.html#more">Continue reading... »</a>Unknownnoreply@blogger.com30tag:blogger.com,1999:blog-859068259820375316.post-6338619869325480192015-12-14T23:53:00.001-05:002015-12-15T01:49:21.063-05:00iLOM: Exadata Compute Node, Storage Server & IB Switches<div style="text-align: justify;">
<b>Oracle Integrated Lights Out Manager (ILOM)</b> provides advanced service processor (SP) hardware and software that can use to manage and monitor Exadata machine components, such as compute nodes, storage server and the InfiniBand switch. ILOM's dedicated hardware and software is preinstalled on these components.</div>
<div style="text-align: justify;">
<br>
</div><a href="http://www.myoracleblog.com/2015/12/ilom-exadata-compute-node-storage.html#more">Continue reading... »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-19814025082857056182015-12-14T22:41:00.005-05:002015-12-27T02:43:27.904-05:00Incremental & Concurrent Statistics Collection<b><br></b>
<b>Incremental Statistics Collection for Partitioned Objects</b><br>
<div style="text-align: justify;">
<div style="text-align: start;">
<span style="text-align: justify;">Determines whether or not the global statistics of a partitioned table will be maintained without doing a full table scan. With partitioned tables it is very common to load new data into a new partition. As new partitions are added and data loaded, the global table statistics need to be kept up to date. Oracle will update the global table statistics by scanning only the partitions that have been changed instead of the entire table if the following conditions hold:</span></div>
<div style="text-indent: 4em;">
<b>-- </b>the INCREMENTAL value for the partitioned table is set to TRUE;</div>
<div style="text-indent: 4em;">
<b>-- </b>the PUBLISH value for the partitioned table is set to TRUE;</div>
<div style="text-indent: 4em;">
<b>-- </b>the user specifies AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT and AUTO for GRANULARITY when gathering statistics on the table;<br>
<br></div>
<div style="text-align: justify;">
If the INCREMENTAL value for the partitioned table was set to FALSE (default value), a full table scan is used to maintain the global statistics, which is a much more resource intensive and time-consuming operation for large tables.<br>
<br>
</div></div><a href="http://www.myoracleblog.com/2015/12/incremental-concurrent-statistics.html#more">Continue reading... »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-89238440743834585622015-12-14T03:52:00.000-05:002015-12-30T02:42:03.959-05:00InfiniBand Diagnostic Data Collection<b>From Database Servers:</b><br>
<div>
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> # /opt/oracle.SupportTools/ibdiagtools/verify-topology
# ibqueryerrors.pl -rR -s PortRcvSwitchRelayErrors,PortXmitDiscards,PortXmitWait,VL15Dropped
# ibstat
# ibv_devinfo -v
# /opt/oracle.SupportTools/CheckSWProfile.sh -I <switch1>,<switch2>,<switch3>
</code></pre>
<br>
</div><a href="http://www.myoracleblog.com/2015/12/infiniband-switch-diagnostic-data.html#more">Continue reading... »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-13419141103680378342015-12-14T03:39:00.003-05:002017-04-20T15:40:40.203-04:00GI & DB Pre-Upgrade Data Collection<div style="text-align: justify;">
As a DBA and/or Support Consultant, we frequently work with customers to upgrade their existing Oracle Databases.</div>
<div style="text-align: justify;">
<br></div>
<div style="text-align: justify;">
Upgrading an Oracle Database is looked like very easy now a days. But the truth is, it's not that easy. Certainly the steps or activities are simple and straight forward. But after effects (Post Upgrade) of the upgrade sometimes ruin everything.</div>
<div style="text-align: justify;">
<br></div>
<div style="text-align: justify;">
I always prefer to give effort and time for pre-upgrade activity rather during the upgrade or even post upgrade. With proper pre-upgrade analysis and correction can lead to successful & smooth upgrade of Oracle GI & Database.</div>
<div style="text-align: justify;">
<br></div>
<div style="text-align: justify;">
For Database Upgrade activity, I always ask the customers to provide me the following information, mainly applicable for Exadata (RAC on Linux) -<br>
<br>
</div><a href="http://www.myoracleblog.com/2015/12/gi-db-pre-upgrade-data-collection-guide.html#more">Continue reading... »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-43081260303938179472015-12-10T04:12:00.001-05:002015-12-11T03:42:05.360-05:00Exadata Storage Server Diagnostic Data Collection<div style="text-align: justify;">
Whenever any issue occurs with Exadata Storage Server, like SMART SCAN issues, H/W Failures, SQL getting quarantined etc. It is best to collect the bellow information immediately from the environment and if any SR has been raised with Oracle Support, upload them into the SR.</div>
<div style="text-align: justify;">
<br></div>
<div style="text-align: justify;">
It's always best to upload the below information into the SR even if the SR engineer doesn't ask for these yet. But trust me, they will ask these now or later. So why waste time?<br>
<br>
For one Exadata Storage Server, it might take 10-20 mins on an average to collect these information. If the same situation is observed in multiple storage server, then it might be alright to collect these information from only one or two storage servers as a start and upload into the SR.</div>
<a href="http://www.myoracleblog.com/2015/12/exadata-storage-server-diagnostic-data.html#more">Continue reading... »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-82874756719486908002015-12-10T03:36:00.003-05:002015-12-12T02:11:52.896-05:00Print messages when someone accessing a particular directoryIf you ever want to print a message when some accessing a particular directory like below.<br>
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"><b> [root@pxe-yum ~]# cd /TEST.DIR/ </b>
WARNING! WARNING! WARNING!
DO NOT -
SAVE, REMOVE OR ALTER any files or directories in this mount point.
This mount point is ONLY for SYSTEM backup.
<b> [root@pxe-yum TEST.DIR]# pwd </b>
/TEST.DIR
</code></pre>
<br>
<a href="http://www.myoracleblog.com/2015/12/print-messages-when-someone-accessing.html#more">Continue reading... »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-859068259820375316.post-4602134579357717262015-12-09T04:20:00.000-05:002015-12-14T01:22:25.299-05:00How To: Move Oracle Database Files in 12cIf it's required to change/setup db_unique_name (if not done during database creation which I always forgot to do so), then changing the db_unique_name will create another directory in ASM and start keeping all the new files into the new directory.<br>
<br>
For Example:<br>
-- If the db_name=DB and no db_unique_name is set: then in ASM, the database will create files like: +DATA/DB/*/<br>
-- If the db_name=DB and db_unique_name is set, i.e. db_unique_name=DBPR, then in ASM, the database will create files like: +DATA/DBPR/*/<br>
<br>
As a result, we will have two directory in ASM (+DATA/DB & +DATA/DBPR) which I don't want.<br>
<a href="http://www.myoracleblog.com/2015/12/how-to-move-oracle-database-files-in-12c.html#more">Continue reading... »</a>Unknownnoreply@blogger.com4tag:blogger.com,1999:blog-859068259820375316.post-33432876700976187552015-12-09T01:58:00.001-05:002020-05-21T13:56:19.094-04:00Install Oracle Linux 6.x with reduced set of packages for Oracle Database 12c, Grid Infrastructure 12c, EM12c etc ...<div style="text-align: justify;">
</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-style: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<div style="color: black; font-style: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-ligatures: normal; font-variant-position: normal; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<div style="font-family: -webkit-standard;">
</div>
<div style="font-family: -webkit-standard; font-weight: normal;">
<div style="font-weight: normal; text-align: justify;">
It's always best to install the operating system with a smaller footprint which automatically make the environment more secure since there are much less to consider to secure the environment.</div>
<div style="font-weight: normal; text-align: justify;">
<br></div>
<div style="text-align: justify;">
<b>From the My Oracle Support Note:</b> Linux OS Installation with Reduced Set of Packages for Running Oracle Database Server (<b>Doc ID 728346.1</b>): Limiting the number of installed packages to only those needed provides a smaller footprint for Linux operating system installation and will help to reduce the amount of storage used. A minimal configuration will also help to avoid unnecessary processes and services and result in reduced memory usage, along with a more secure and reliable setup overall.</div>
<div style="font-weight: normal;">
</div></div></div></div><a href="http://www.myoracleblog.com/2015/12/install-oracle-linux-6x-with-reduced.html#more">Continue reading... »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-859068259820375316.post-76300715637832755872015-11-30T22:39:00.000-05:002015-12-11T01:53:30.239-05:00ORA-32017: failure in updating SPFILE, followed by: ORA-65500: could not modify DB_UNIQUE_NAME, resource exists (12c)<div class="tr_bq">
<div style="text-align: justify;">
I was working to setup a Data Guard in my test machine and noticed the following error when I was trying to change the db_unique_name parameter in the primary database -</div>
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> SQL> alter system set db_unique_name=TESTPR scope=spfile sid='*';
alter system set db_unique_name=TESTPR scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
</code></pre>
<br></div>
<a href="http://www.myoracleblog.com/2015/11/ora-32017-failure-in-updating-spfile.html#more">Continue reading... »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-859068259820375316.post-37680758849595933372015-11-30T22:37:00.001-05:002015-12-14T00:43:31.385-05:00umount: /u01: device is busy: even when Grid Infrastructure is down (12c)<div style="font-family: Merriweather, Georgia, 'Times New Roman', Times, serif; font-size: 15px; line-height: 25.5px; margin-bottom: 24px; widows: 1;">
<div style="text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Sometimes back, I noticed that even after shutting down GI (12.1.0.2.x) in a RAC setup, I still can't unmount the filesystem where the GI binaries are located.</span></div>
<div style="text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br></span></div>
<div style="text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">This is applicable for GI version 12.1.0.2.x and even in Exadata too. Reproducible every time when GI shutdown completes.</span><br>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"></span><br>
</div></div><a href="http://www.myoracleblog.com/2015/11/umount-u01-device-is-busy-even-when.html#more">Continue reading... »</a>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-859068259820375316.post-10025693538206908142015-11-20T03:00:00.000-05:002015-12-12T02:18:08.251-05:00How To: mount ISO image as yum repositoryThis post is just a quick how to reference about how to <b>mount an ISO image</b> contains Oracle Linux Installation Binaries and use that as a YUM repository to install/update the operating system.<br>
<br>
<a href="http://www.myoracleblog.com/2015/12/how-to-mount-iso-image-as-yum-repository.html#more">Continue reading... »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-859068259820375316.post-63469809748979294052015-11-04T03:00:00.000-05:002015-12-14T23:45:03.040-05:00How To: iLOM SNAPSHOT using CLI<div style="text-align: justify;">
Below is just an example on how to collect iLOM snapshot using CLI.</div>
<a href="http://www.myoracleblog.com/2015/12/how-to-ilom-snapshot-using-cli.html#more">Continue reading... »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-859068259820375316.post-71483809082501309452015-11-02T00:32:00.000-05:002015-12-12T05:28:04.577-05:00Huge number of Oracle Database Home/Binary in a single server<div style="text-align: justify;">
Sometimes, during database consolidation planning, people tends to plan to install one ORACLE_HOME (DB Home/Binary) for each database.</div>
<div style="text-align: justify;">
<br></div>
<div style="text-align: justify;">
<b>Which means: Lets say, if there are 50 databases then there will be 50 ORACLE_HOME. Specially it's been seen in Exadata/SuperCluster which has capacity to consolidate a very large RDBMS environment.</b></div>
<div style="text-align: justify;">
<b><br></b></div>
<div style="text-align: justify;">
<b><u>Question is, is it really a good idea or crazy ?? !!!!</u></b></div>
<div style="text-align: justify;">
<br>
</div><a href="http://www.myoracleblog.com/2015/12/high-number-of-oracle-database-home.html#more">Continue reading... »</a>Unknownnoreply@blogger.com0