After updating to Virtual Box 5 I noticed my 3 node demo RAC cluster had problems starting cluster resources. Any time I do any sort of upgrade with Virtual Box I cycle through my vm’s to make sure they are all working so I don’t have any nasty surprises whenever I need to use them.…
Category: 12c
Deinstall 12c Agent Home
After a few issues with a 12c agent on a cluster I decided the best course of action was to reinstall and configure again. Here’s what I did to deinstall the agent. Prior to the removal of the software I stopped the agents and used the emcli command line tool to remove all monitored targets…
Global Data Services – Part 3
In this post we’ll look at configuring GDS and connecting to a database via a global service. GDS Catalog Firstly we’ll need to create a catalog as every GDS configuration requires a catalog. I’ll be using the 12c developer days VM as my catalog database. We need to create a GDS administrator on the catalog…
Global Data Services – Part 2
In this post we’ll install a Global Services Manager. The software can be downloaded from here – Oracle Database 12c Release 1 Global Service Manager (GSM/GDS) (12.1.0.2.0) for Linux x86-64 I’ll be installing the Global Services Manager on the 12c Developer Days VM. The VM is a pre configured system and should have enough of…
Global Data Services – Part 1
One of the new features in 12c is Global Data Services (GDS). GDS is basically the Oracle database service model but for replicated databases. Together they form a GDS configuration. In this post we’ll explore some of the high level components and design of GDS. Before we describe the GDS components lets make it clear…
Enterprise Manager 12.1.0.4 and Server Adaptive Threshold Metric
One of the big changes in 12.1.0.4 with the 12.1.0.6 database plugin is most server generated alerts are now evaluated by the agent. The “Server Adaptive Threshold” is not one of the metrics which utilises this new behaviour but remains for backward compatibility. What this means is you cannot set thresholds for these metrics via…
Log Files in 12c RAC
One of the things I’ve noticed in my 12.1.0.2 lab environment is the location of the clusterware log files now reside in diag_dest under the $ORACLE_BASE/diag/crs/$HOSTNAME/crs/trace directory. I don’t have access to a 12.1.0.1 cluster anymore so I can’t double check to see if it was the same in the first 12c release. If memory…
Temporary Suspension of 12c Database as EM 12cR4 Repository
I was in the processing of starting an EM Cloud Control 12.1.0.4 installation and wanted to use a 12c database as a repository. From a previous 12c Cloud Control installation I was pretty sure that 12c was not certified as an EM repository. Double checking the new documentation I was happy to see it in…
12.1.0.2 – Full Database Caching
One of the new features of 12.1.0.2 is full database caching. Some of the cynics out there might say “hey, this is how it used to work back in the pre 11 days” before this direct path read thingy. Lets see it in action.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SQL> create table t1 as select * from all_objects; Table created. SQL> @gts t1 Gather Table Statistics for table t1... PL/SQL procedure successfully completed. SQL> exec DBMS_STATS.SET_TABLE_STATS(user, 'T1', numrows=>1000000, numblks=>1000000); PL/SQL procedure successfully completed. |
We’ve created a table and set some dummy stats so…
12.1.0.1 to 12.1.0.2 Upgrade
Now that 12.1.0.2 is released and readily available lets see it in action adn upgrade an existing 12c database. I’ll be using the 12c Oracle Developoer Days VM as my lab. Download linuxamd64_12102_database_1of2.zip and linuxamd64_12102_database_1of2.zip Unzip the files into a staging area.
|
1 2 |
unzip linuxamd64_12102_database_1of2.zip -d /u01/app/stage unzip linuxamd64_12102_database_2of2.zip -d /u01/app/stage |
Once unzipped run “runInstaller” and follow the prompts. I’ll be running and…