When using the DBCA tool under Oracle 11gR2 64-bit on Windows 2008, and trying to specify ASM as the file storage, the following error is encountered:
“grid infrastructure or clusterware home not found”
The DBCA tool must be run as Administrator, even if the account you are using is already an Administrator privileged account.
If you launch DBCA from the command line, the CMD executable must be launched with the Run As Administrator option.
In this blog post, we are going to install Oracle Enterprise Manager 12c (12.1.0.2) on CentOS 6.3 64-bit using VMware Workstation 8.
Oracle Enterprise Manager (OEM) has been around since the 8.0 days. What started out as a fairly light-weight client-server GUI tool for managing database functions has morphed into a complex and brittle mess of poor interface design and sloppy coding.
Although 12c is a step up from the god-awful OEM 11g, the hapless Oracle DBA is still left with a muddled mess of an interface and a tool that is likely to cause more headaches than it solves.
In this blog post, we are going to silently install Oracle 11.2.0.3 64-bit on RedHat 6.0 using VMWare Workstation 8.
This install demonstration is going to use the silent install mode for all components. At least within the guest VM, at no point will we use a GUI for the install. We will need to use the VMWare GUI to create the VM, install the OS and add disks.
With the increasing use of VMWare, many organizations are looking to automate the deployment of Oracle database environments for development, test or validation. And increasingly DBAs are being tasked with automating the provisioning process.
During the install of Oracle 11.2.0.3, the installer pre-requisite check fails on the NTP daemon configuration.
Network Time Protocol (NTP) – This task verifies cluster time synchronization on clusters that use Network Time Protocol (NTP).
Error: – PRVF-5507 : NTP daemon or service is not running on any node but NTP configuration file exists on the following node(s): localhost –
Cause: The configuration file was found on at least one node though no NTP daemon or service was running. –
Action: If you plan to use CTSS for time synchronization then NTP configuration must be uninstalled on all nodes of the cluster.
To address this, remove the /etc/ntp.conf file. This will allow the use of CTSS for time synchronization.
[root@localhost ~]# cd /etc [root@localhost etc]# mv ntp.conf ntp.conf.bak
While trying to install Oracle on a Red Hat 6.0 system, running on VMWare, you might encounter the following error:
# An unexpected error has been detected by HotSpot Virtual Machine: # # SIGSEGV (0xb) at pc=0x00007fd0b80d0d70, pid=2951, tid=140533187077904 # # Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_30-b03 mixed mode) # Problematic frame: # C [ld-linux-x86-64.so.2+0x14d70] # # An error report file with more information is saved as hs_err_pid2951.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp #
To resolve this problem, execute the following before launching runInstaller
$ export LD_BIND_NOW=1
The installer will run normally.
This problem has been reported with Oracle 11.2.0.1 and Oracle 11.2.0.3
In this blog post, we are going to install Oracle 11.2.0.3 64-bit on CentOS 6.3 using VMware Workstation 8. Given that Oracle no longer offers ASMLib for non Oracle branded Linux, we are going to use UDEV rules to manage the disk presentation to ASM.
In my 10-part post on installing Oracle RAC on VMware Workstation I deliberately used an excessive number of screen shots to guide readers through the process. This time I am going to assume you are already comfortable with the Oracle GUI installers, and will skip over excess details to condense this down into a single blog post.
Hybrid Columnar Compression is one of the new features that Oracle has been touting to persuade DBAs on the virtues of their Exadata and ZFSSA storage solutions.
As stated in my bio, I currently get paid by EMC, but this blog post is not another critique of Oracle sales massaging technical numbers on the assumption that you can use HCC for OLTP loads.
Rather, this is a USE AT YOUR OWN RISK method to explore what HCC can and cannot do. Using this method will render your databases unsupported by Oracle and you must NOT do this on any production or mission critical system. Please note I accept no responsibility for anyone destroying critical data from trying any of this.
You may find the scsi_id command returns a null result in CentOS 6 or RHEL 6 on VMware.
[root@localhost ~]# scsi_id -g -u -d /dev/sdb [root@localhost ~]#
The problem here is that VMware Workstation does not provide unique SCSI identifiers to the virtual SCSI devices. We need to modify the VMX file to make this happen by adding the following directive:
disk.EnableUUID = "TRUE"
Restart the VM and now the scsi_id command should work:
[root@localhost ~]# scsi_id -g -u -d /dev/sdb 36000c2980c56d98cc5150a0ac103058d
Last week I was in Dallas, Texas meeting with some customers and reminding myself what sunny weather looks like.
I took the opportunity to hook up with my friend and colleague Lester Wells, an awesome EMC guy based out of Dallas, and who is also an expert in all things Oracle.
Sitting in the Champps bar near to DFW, we decided, as geeks are often want to do, to see if the 11gR2 RAC on VMware Workstation 8, the process for which is shown in this blog, would also work under Lester’s VMware Workstation 9.
Two guys, two laptops, a table close to wall sockets and more than just a few beers later, happily it turns out that everything worked exactly the same under Workstation 9, as it did under Workstation 8.
If you’re running under Workstation 8 you can go ahead and upgrade, it won’t break anything.
If you are wishing to create a RAC under your Workstation 9, the ten part process will work just the same.
Time Required: 60 minutes
Class Materials:
Next we are going to install the Oracle Database 11gR2 software.
This is the last part of our ten-part process of installing a two node RAC on VMware Workstation 8.
To begin, download the zip file from the Oracle software download website and unzip on Orpheus. Make sure you are logged into Orpheus as the oracle user so that oracle owns the unzipped files.
the gruffdba 