alter tablespace sysaux read only
ERROR at line 1:
ORA-13505: SYSAUX tablespace can not be made read only
Read and monitor Oracle related blogs and news sources, all in one place.
In preparation of the OUGN Spring Seminar and to finally fulfill at least a part of my promise from July I was getting ready to research RAC, PDBs and services for my demos. It turned out to become a lot more interesting than I first assumed.
RAC and Multi-Tenancy
So the first attempt to really look at how this works has started with my 2 node cluster where I created a RAC database: RAC12C, administrator (more...)
As the name suggests, I wrote it with Violin devices in mind, but there should be overlap with other storage which will potentially make it useful elsewhere… see here for more details.
As anyone familiar with the use of Oracle on Advanced Format storage devices will know to their cost, Oracle has had some difficulties implementing support of 4k devices. Officially, support for devices with a 4096 byte sector size was introduced in Oracle 11g Release 2 (see section 188.8.131.52 of the New Features Guide) but actually, if the truth be told, there were some holes.
(Before reading on, if you aren’t sure (more...)
I was recently configuring backup on the customers Exadata with IBM TSM Data Protection for Oracle and run into weird RMAN error. The configuration was Oracle Database 11.2, TSM client version 6.1 and TSM Server version 5.5 and this was the error:
[oracle@oraexa01 ~]$ rman target / Recovery Manager: Release 184.108.40.206.0 - Production on Wed Jan 29 16:41:54 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. (more...)
Are you looking to install Oracle software on your VirtualBox but are running low on disk space? Learn how to add disk storage to Oracle VirtualBox with Linux Guest OS.
The post How to Add Disk Storage to Oracle VirtualBox with Linux Guest OS? appeared first on VitalSoftTech.
We want to install Oracle E-Business Suite on Red Hat Linux 6.2. To be able to use RHN Repository to install packages, we tried to register our system but when we issued “rhn_register” we got the following error:
[Sat Jan 25 16:55:24 2014] rhn_register Traceback (most recent call last): File "/usr/sbin/rhn_register", line 76, in <module> app.run() File "/usr/share/rhn/up2date_client/rhncli.py", line 74, in run sys.exit(self.main() or 0) File "/usr/sbin/rhn_register", line 58, in (more...)
When creating VMs on my laptop I like to configure the minimum number network interfaces. I also tend to end up with environments where I want multiple VMs to be able to see each other, see the internet and see my physical host. It seems many people using VirtualBox use the approach of having a “Host-only Adapter” interface and a “NAT” interface. The only reason I have for not liking this is that it (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...)
In my previous posts about the first RAC Grid Infrastructure Patchset I document a few issues I encountered that were worth noting. But where things work as advertised I am more than happy to document it too. In a way, the January 2014 GI PSU works as you’d hope it would (at least in my lab for my 2 node cluster).
I have a 2 node RAC cluster that hasn’t previously been patched. (more...)
In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over (more...)
This blogpost is about how to print the system call arguments of a system call catches in gdb. The reason is I spend quite some time on searching for this, and working around this, so writing it in a blogpost might help others who spend their time in the gdb (more...)
This is a quick writeup of an oddity I found while trying to install the vmwareware tools in an Oracle Linux host with the UEK3 kernel enabled (which is by default).
This is what is encountered during the vmware tools installation dialog when running vmwaretools.pl:
Searching for a valid (more...)
This method applies to RHEL; let’s first install the VNC Server. Through yum command # yum install tigervnc-server Or Through RPM command First, locate and mount your RHEL 6.3 install media. [root@oraerp ~]# cd “/media/RHEL_6.3 x86_64 Disc 1/Packages” [root@oraerp Packages]# pwd /media/RHEL_6.3 x86_64 Disc 1/Packages Install (more...)
This post also applies to non-Exadata systems as hard drives work the same way in other storage arrays too – just the commands you would use for extracting the disk-level metrics would be different.
I just noticed that one of our Exadatas had a disk put into “predictive failure” mode (more...)
Recently we noticed that imageinfo was displaying the following information at a customers site. Imageinfo was not displaying data i suspected, so a quick little blogpost about what was going on there.
[root@dm01db01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/dbs_group -l root "imageinfo | grep 'Image version'" dm01db01: Image version: 11.2. (more...)
If like me, and a couple of others I’ve spoken to recently, you were not previously aware of “sudo -s” then you might be interested to know that you can save yourself two keystokes by switching from:
sudo su -
From the man page:
The -s (shell) (more...)