To extend an ACFS cluster filesystem dynamically, we need to use the acfsutil command:
node01:/u01/grid>/sbin/acfsutil size +10G /u02
acfsutil size: ACFS-03008: The volume could not be resized. The volume expansion limit has been reached.
acfsutil size: ACFS-03216: The ADVM compatibility attribute for the diskgroup was below the required
version (22.214.171.124.0) for unlimited volume expansions.
Oh dear, not 126.96.36.199, so you can only extend volumes dynamically a (more...)
Thank you for attending my session RAC'fying Multitenant at Oracle Open World 2014. You can download the slide deck here
As always I would love to hear from you.
Thank you all those who attended my session Cache Fusion Demystified.
As I mentioned, it was impossible to fit in a demo within that compressed 45 minute timeline. I put the details of the demo
in a separate file with all the scripts and instructions that allows you to execute the demos at your own site.Download the slide deck
as well as the scripts. In addition I have also written a whitepaper
to explain (more...)
The Grid Infrastructure filesystem was reporting that it was a bit full today (release 188.8.131.52). This was tracked down to the “crfclust.bdb” file, which records information about the cluster health for monitoring purposes. It was 26GB. It’s not supposed to get bigger than 1GB so this is probably a bug, but let’s explicitly resolve the size issue right now and search Oracle support later. Worst case, bdb (Berkerley Database) files get (more...)
I have recently upgraded my RAC 184.108.40.206.3 system to RAC 220.127.116.11 including the RDBMS installation. Currently I am updating my skills with information relevant to what I would normally have called 12c Release 2 (so that would also answer the question: when is 12c Release 2 coming out?). Then I realised I haven’t posted a first look at RAC 12c post yet-so here it comes.
There are (more...)
Oracle 18.104.22.168 is out, after lots of announcements the product has finally been released. I had just extended my 22.214.171.124.3 cluster to 3 nodes and was about to apply the July PSU when I saw the news. So why not try and upgrade to the brand new thing?
What struck me at first was the list of new features … Oracle’s patching strategy has really changed over time. I (more...)
These are a bit of a pain as their location isn’t intuitive. So to remind me where they are:
Login to the server(s) as the grid owner and check the scan listener status. This will show you the location of the listener log. cd to just below the diag directory and you’re off!:
server-name:/u01/grid>ps -ef | grep SCAN
grid 8542 8282 0 10:20 pts/0 00:00:00 grep SCAN
grid 9349 1 0 Mar07 ? 00:07:33 (more...)
I have recently configured Active/Passive Failover cluster using Grid Infrastructure 12cR1 and wrote document on that subject. Now I plan to use this environment and convert "test12" database from Single-Instance to RAC database.
There are several ways to convert non-RAC database to RAC database:
- using Database Configuration Assistant (DBCA)
- Oracle Enterprise Manager
- rconfig command line utility
In this post I will describe how to perform conversion using rconfig utility
I noticed something for the first time tonight when I was playing around in the Enkitec lab – something that I have been doing wrong for a while. When working in the lab, I often rely on the crsctl command to shut down the entire cluster stack for me. It’s really easy to use “crsctl stop cluster -all” followed by “dcli -l root -g ~/dbs_group /u01/app/126.96.36.199/grid/bin/crsctl stop crs” to get everything down (more...)
Not a new thing right now since 11.2 is out from some time already.A very common question that I get is that GSD (Group Service Daemon) is offline in 11.2 RAC. That’s not something to be worried about as it’s officially documented in MOS doc# 429966.1. Only if you have 9i database, it would be available but the point is why in 2014, you are still planning to run a 9i (more...)
This post is about exploring the mechanisms used by Oracle Clusterware 188.8.131.52 to restrict remote service registration, i.e. the 12c new feature "Restricting Service Registration for Oracle RAC Deployments"Why is this useful?
This improvement of 12c clusterware and listeners over the 11.2 version is useful mainly for security purposes, for example as a measure against TNS poisoning attacks (see also CVE-2012-1675
), and it is particularly relevant for (more...)
I had quite an interesting case recently where I had to build stretch cluster for a customer using Oracle GI 12.1 and placing quorum voting disk on NFS. There is a document at OTN regarding the stretch clusters and using NFS as a third location for voting disk but it has information for 11.2 only as of the moment. Assuming there is no difference in the NFS parameters I used the Linux parameters (more...)
Removing a service via srvctl has not historically resulted in the service being fully removed from the database and it would still be visible in DBA_SERVICES as show below in an 184.108.40.206 database:
Create the service:
$ srvctl add service -d orcl -s demo -r "ORCL1,ORCL2"
During my project work I had to tune the SOA dehydration store on more than one occasion. Through this posting I would like to share the tuning tips collected during these exercises. It is not a step-by-step guide, because with tuning there never is a 'one-size-fits-all' in my humble opinion, but I provide in general a guidance that you can use as a reference for your own situation. I will also refer to related Oracle (more...)
Original Post can be viewed at MGMTDB: Grid Infrastructure Management Repository
MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being stored in berkley database but starting Oracle database 12c it is configured as Oracle Database Instance. In 11g, .bdb files (more...)
Original Post can be viewed at Openfiler on Virtualbox and 12c Oracle Flex ASM
Last week Oracle released 12c database and Oracle blogosphere is bustling with lot of people posting details about new versions and setup. I too decided to take plunge and setup my own RAC cluster. I had (more...)
Original Post can be viewed at portmap: unrecognized service on RHEL6
Quick note for people using NFS for shared storage on RAC database. Till RHEL5 we had to ensure nfs,nfslock and portmap service has to be running. These services are required otherwise you will get following errors while mounting database (more...)
[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.]
After reviewing my blog post about running EBS OVM templates in VirtualBox, two of my teammates suggested that I work on something with potentially broader appeal. Their basic message was, "This is really cool for us EBS nerds, but what about the Core DBAs?"
So how does "11gR2 RAC in an hour" sound? In this post, I'll demonstrate how to deploy the pre-built Oracle VM templates to create a two-node (more...)
This is just a post ot point out that ODA Patch 2.4 is out. ODA Patch 2.4 requires 2.2 or above to install.
A couple of Highlights of this release seem to be
- Enhanced odachk 2.16
- A trace file analyzer
- The ability to now use normal (more...)