This will be my first time to attend Oracle Open World, and I’ll speak about Enterprise Manager Command-Line Interface (EMCLI) Scripting” on User Group Sunday. I already presented it on several conferences, heard people’s feedback and modified the content to improve my presentation. Now I will focus more on practical information, share sample scripts that can be used in real world scenarios. Hope to see you there!
How Many ASM Disks Per Disk Group And Adding vs. Resizing ASM Disks In An All-Flash Array Environment
I recently posted a 4-part blog series that aims to inform readers that, in an All-Flash Array environment (e.g., XtremIO), database and systems administrators should consider opting for simplicity when configuring and managing Oracle Automatic Storage Management (ASM).
The series starts with Part I which aims to convince readers that modern systems, attached to All-Flash Array technology, can perform large amounts of low-latency physical I/O without vast numbers of host LUNs. Traditional storage (more...)
Prompted by a recent OTN posting I’ve dug out from my library the following demonstration of an anomalty with the parallel_index() hint. This note is a warning about how little we understand hints and what they’re supposed to mean, and how we can be caught out by an upgrade. We’ll start with a data set which, to match a comment made in the origina posting rather than being a necessity for the demonstration, has an (more...)
Resizing ASM Disks On Modern Systems. Real Application Clusters Doesn’t Make It Any More Difficult. An XtremIO Example With RAC.
My recent post about adding space to ASM disk groups by resizing them larger, as opposed to adding more disks, did not show a Real Application Clusters example. Readers’ comments suggested there is concern amongst DBAs that resizing disks (larger) in a RAC environment might somehow be more difficult than in non-RAC environments. This blog entry shows that, no, it is not more difficult. If anything is true it is that adding disks to ASM (more...)
At times, I find it much simpler to shutdown my test database and create cold backup which will allow me to revert from any errors.
$ echo $ORACLE_SID DB01 $ tar -cvzf /media/sf_OracleSoftware/$ORACLE_SID_$USER_`hostname -s`_backup.tar.gz . ./ ./obj_source.out ./onlinelog/ ./onlinelog/o1_mf_1_cw3syboq_.log ./onlinelog/o1_mf_2_cw3sybrt_.log ./onlinelog/o1_mf_3_cw3syc03_.log ./controlfile/ ./controlfile/o1_mf_cw3sybl0_.ctl ./datafile/ ./datafile/o1_mf_temp_cw3syrhz_.tmp ./datafile/o1_mf_users_cw3syrk7_.dbf ./datafile/o1_mf_sysaux_cw3syl2w_.dbf ./datafile/o1_mf_demo_cw4tz56f_.dbf ./datafile/o1_mf_undotbs1_cw3syoc6_.dbf ./datafile/o1_mf_system_cw3syd5k_.dbf $ ll /media/sf_OracleSoftware/DB01_oracle_arrow_backup.tar.gz -rwxrwx---. 1 root vboxsf 382676286 Aug 28 13:09 (more...)
I used to spend most of my time — blogging and consulting alike — on data warehouse appliances and analytic DBMS. Now I’m barely involved with them. The most obvious reason is that there have been drastic changes in industry structure:
A huge thank you to Pete Finnigan for his blog post.
Not only is the implementation of ORACLE_MAINTAINED not ideal, it’s a possible security risk.
My tip to you is to always exit the session before performing any object creation.
From my pain as you can see, looks like “_ORACLE_SCRIPT was not reset when new users where created.
Learned quite a few new thing this weekend and (more...)
What a disaster this is with 12c full database export and ORACLE_MAINTAINED objects.
Somehow, oracle thinks MDINH is an ORACLE_MAINTAINED user and user MDINH does not get exported.
Why Can an Object Not Be Exported? Expdp of SYSTEM User’s Table Returns ORA-39166 or ORA-31655 (Doc ID 2114233.1)
There are certain system generated schemas that are not exportable using exp or expdp because they contain Oracle-managed data and metadata. SYS, MDSYS, and ORDSYS are some (more...)
I recently discovered about column ORACLE_MAINTAINED added to DBA views and got excited over nothing.
ORACLE_MAINTAINED from DBA_ROLES
Denotes whether the role was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql).
A role for which this column has the value Y must not be changed in any way except by running an Oracle-supplied script.
It looks like ORACLE_MAINTAINED is only valid for CDB and seems as if Oracle is really wanting all (more...)
About six months ago, when I was in the OUGN Spring Conference, someone asked me how they can let developers access to performance tuning pages on Enterprise Manager Cloud Control 13c. He said that they granted full administrator privileges to the developers so they could access the performance page but it’s not acceptable. He also mentioned that they didn’t need to grant full administration privilege to the developers’ EM users while they were using (more...)
RDA, or the Remote Diagnostics Agent, has been around for a little while. Over the time, and with the growing number of Oracle’s acquisitions it has become, shall we say, a little more difficult to handle. It appears to me as if every one of them will have its diagnostics handled by RDA making it hard to focus on something specific, like for example the database.
I won’t go into very detail of the Remote (more...)
I wrote a blog post about how to import data from a XML file to Oracle about 7 years ago. I demonstrated how we can use DBMS_XMLSTORE package to parse XML data. Yesterday, I replied a question from a blog reader about that post. He had problem with running my sample script, I did troubleshoot and find out the problem with his script, and while testing the sample script, I noticed that I can write (more...)
I was doing another GI 22.214.171.124 cluster installation last month when I got really weird error.
While root.sh was running on the first node I got the following error:
2016/07/01 15:02:10 CLSRSC-343: Successfully started Oracle Clusterware stack 2016/07/01 15:02:23 CLSRSC-180: An error occurred while executing the command '/ocw/grid/bin/oifcfg setif -global eth0/10.118.144.0:public eth1/10.118.255.0:cluster_interconnect' (error code 1) 2016/07/01 15:02:24 CLSRSC-287: FirstNode configuration failed Died at /ocw/grid/crs/install/crsinstall.pm (more...)
At the end of the previous installment we saw that a single big batch delete would (apparently) attach all the “reusable” chunks into a single freepool, and asked the questions:
- Why would the Oracle developer think that this use of one freepool is a good idea ?
- Why might it be a bad idea ?
- What happens when we start inserting more data ?
(Okay, I’ll admit it, the third question is a clue about the answer (more...)