This blog post is inspired on work I have been doing on Standard Edition databases and the returning confusion about what is and what is not part of Standard Edition.
DBA_FEATURE_USAGE_STATISTICS is a tool in determining license usage for the Oracle database. It is good to understand the implications of each entry, know what is happening in your database and thus be able to have a substantial conversation about the usage of your license, being (more...)
As a DBA, you must be familiar with the various tools provided by My Oracle Support (MOS) for diagnostics and health check. Here are few every DBA must be familiar with, which will help you when everyone else in the organization is jumping on you to resolve a failure or troubleshoot a performance issue. 1513912.2 […]
In a hectic year it is good to attend and contribute to Oracle user group sessions. This adds an element of a ‘Working Holiday’ to someones schedule. I can promise you, the vacation isle of Rovinj is a perfect venue for this and especially since it is the last week of the opening of the Hotel for this season.
Of course you can find all information about contributing to these events right here!!
There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the 184.108.40.206 instances. ora_acms_bt9prod1 ora_lreg_bt9prod1 ora_p00w_bt9prod1 ora_aqpc_bt9prod1 ora_m000_bt9prod1 ora_p00x_bt9prod1 ora_asmb_bt9prod1 ora_mark_bt9prod1 ora_p00y_bt9prod1 ora_cjq0_bt9prod1 ora_mman_bt9prod1 ora_p00z_bt9prod1 ora_ckpt_bt9prod1 ora_mmnl_bt9prod1 ora_ping_bt9prod1 ora_dbrm_bt9prod1 ora_mmon_bt9prod1 ora_pmon_bt9prod1 ora_dbw0_bt9prod1 ora_o000_bt9prod1 ora_ppa6_bt9prod1 ora_dbw1_bt9prod1 ora_p000_bt9prod1 ora_ppa7_bt9prod1 ora_dbw2_bt9prod1 ora_p001_bt9prod1 ora_psp0_bt9prod1 ora_dbw3_bt9prod1 ora_p002_bt9prod1 ora_pxmn_bt9prod1 ora_dbw4_bt9prod1 […]
Well, honestly, have forgotten working on Windows platform administering Oracle databases. Recently, installed Oracle Database 12c on Windows and wanted to apply the latest PSU. Could not find the PSU, but found the BP (Bundled Patch) – hoped it the same and included more than a PSU! Had some challenges installing… did not remember to run […]
I had the pleasure of rebuilding an Exadata rack for a customer a while back, and it provided a pretty good refresher in backup and recovery for me. As DBAs, we back up databases all the time, but the restores are performed much less frequently. In the case of this rack, there were several databases across multiple ASM diskgroups. One of the goals of the rebuild was to consolidate all of the databases into a (more...)
I’ve been doing some Enterprise Manager installs a bit more lately. At the same time, I’ve been working on Data Integration items such as GoldenGate and ODI. What these products have in common are that they require an Oracle Database for a repository. Needless to say I’ve been installing a lot of 220.127.116.11 databases in test and production environments. The one thing that has been consistent is the issue I keep seeing (more...)
A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was 18.104.22.168 on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.
The error message was something like this
MRP0: Background Media Recovery terminated with error 600
Errors in file /u01/app/oracle/product/22.214.171.124/diag/diag/rdbms/xxxprd/xxxprd1/trace/xxxprd1_pr00_6342.trc:
ORA-00600: internal error code, arguments: , , , , , , , (more...)
A client of mine was busy correcting one of his development streets and therefore the NLS charactersets of about 10 126.96.36.199 EE databases had to be changed.
Most of the databases were originally configured with WE8ISO8859P15, others with WE8ISO8859P1 and all of them had to get WE8MSWIN1252. Some of them were single instances (export, development and test), some RAC (acceptance) and some of them were RAC plus Dataguard (production, for the procedure (more...)
Almost exactly a year ago I published a post covering my first impressions of the ASM Filter Driver (ASMFD) released in Oracle 188.8.131.52, followed swiftly by a second post showing that it didn’t work with 4k native devices.
When I wrote that first post I was about to start my summer holidays, so I’m afraid to admit that I was a little sloppy and made some false assumptions toward the end – assumptions (more...)
This is no regular bit of work and it will probably (and hopefully) never hit you in a production setup…
The prerequisite is that you know how on-line data replication in general, and Dbvisit Replicate specifically, work.
The following case is true:
I had half of a replication pair running.
It means that the MINE process was running, converting REDO-log in PLOG-format. The APPLY process had not yet started because the target database was (more...)
This week I decided to redo a few of my virtual box machines and build a few new ones for testing. Getting the Oracle Linux 6.6 installed was a breeze; however, when I started to install the Oracle Database 12c binaries I was hitting errors during the linking phase. This had me puzzled for a bit to say the least. I kept getting this error:
After driving myself nuts, I decided to look closer (more...)
If you’ve run an exachk report, y0u may have seen the following message with regard to your databases:
||Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value
This check is commonly seen when a database is created on Exadata without using the custom “Exadata” templates included with the database creation assistant. These customized templates include a multitude of recommended parameter settings found in (more...)
Kscope15 promised to be a brand new experience in more than one way.
As I start to write this report, I am flying from Düsseldorf airport to Atlanta. It will be the first time flying to the United States with a stopover, and because of Erik van Roon, I came prepared. With just carry-on luggage, I should end up at my final destination, Fort Lauderdale, Florida, together with my ‘stuff’. I am flying Delta (more...)
Dumb title for a blog post? No, not really I guess…
I have been using a terminal emulator, basically ever since I got away from the VT100 terminal:
- ICE.TCP Pro
- Reflection ‘X’
And a few other obscure applications that I cannot even recall anymore.
Currently, and over the last 6 to 8 years, I have been using ZOC.
The background of this story is: In the beginning these were the first DOS PC’s (more...)
This is a very simple post to show the results of some recent testing that Tom and I ran using Oracle SLOB on Violin to determine the impact of using virtualization. But before we get to that, I am duty bound to write a paragraph of text featuring lots of long sentences peppered with industry buzz words. Forgive me, it’s just the way I’m wired.
It is increasingly common these days to find database environments running (more...)