Time Required: 20 minutes
Class Materials:
- none
We are now ready to clone our VM. From this point forward we will have two machines, and we will start to think of them individually.
Make sure your Windows VM is shutdown.
Oracle 11gR2 11.2.0.3 2-node RAC on Windows 2008 on VMware Workstation 9 – Part V
Time Required: 20 minutes
Class Materials:
- none
Next we are going to add a DNS server to our Windows VM.
The DNS server is needed to support the SCAN address. If you have an existing DNS server available to you, then by all means use it, but in my case I do not, so I am going to create one on my Windows VM.
Oracle 11gR2 11.2.0.3 2-node RAC on Windows 2008 on VMware Workstation 9 – Part IV
Time Required: 20 minutes
Class Materials:
- None
Next we are going to modify the Windows security policy and account settings to support Oracle RAC.
Open a command prompt and enter the following command:
secpol
This opens the Local Security Policy interface. Alternatively you can navigate here by using:
Start->Administrative Tools->Local Security Policy
Oracle 11gR2 11.2.0.3 2-node RAC on Windows 2008 on VMware Workstation 9 – Part III
Time Required: 10 minutes
Class Materials:
- None
Next we need to edit the Windows registry to change certain behaviours and to make sure we are ready for a RAC install.
Open a command prompt and type regedit to open the Windows registry editor.
Oracle 11gR2 11.2.0.3 2-node RAC on Windows 2008 on VMware Workstation 9 – Part II
Time Required: 30 minutes
Class Materials:
- None
Next we need to add additional networking components to allow our RAC nodes to communicate.
Oracle RAC requires two separate networks, one for public traffic and one for private cluster traffic. Both adapters must use static IP addresses.
VMware Workstation already installed a Bridged Adapter as part of the install process, and this adapter will provde internet access to our VM. But in most cases, the IP address of this adapter will change as DHCP leases expire, or in the case of a laptop, the machine moves from network to network.
Therefore, we need to add two additional NICs on virtual networks between the RAC nodes, one to be our public network and the other to be our private network.
Oracle 11gR2 11.2.0.3 2-node RAC on Windows 2008 on VMware Workstation 9 – Part I
Time Required: 30 minutes
Class Materials:
- 50GB of free disk
- An operational VMware Workstation 9 or later install
- Windows Server 2008R2 64-bit install media
To create our Oracle RAC database on Windows on VMware Workstation 9, we first need to create a Windows VM.
I am using an ISO image of Windows Server 2008R2 that I downloaded from MSDN. An MSDN subscription offers developers the opportunity to test out different technologies from Micorosft for development purposes.
Silent Install of Oracle 11.2.0.3 on Solaris 11 x86
In this blog post, we are going to install Oracle 11.2.0.3 64-bit on Solaris 11 x86 using VMWare Workstation 9.
Solaris represents a popular alternative to Linux for many Oracle shops, especially since it offers some familiarity for System Admins and DBAs who were previously running Oracle on SPARC.
Adding VNC Server to Red Hat Enterprise Linux 6.3
Time Required: 10 minutes
Class Materials:
- Red Hat Enterprise Linux 6.3 64-bit install media
The following steps show how to install a VNC server on Red Hat Enterprise Linux 6.3.
VNC provides a remote desktop solution, allowing users to connect to the Linux system remotely and being able to use the native Linux desktop.
In many Linux distributions, a VNC server is installed by default, but with Red Hat Enterprise Linux 6.x the package must be manually added.
Note: Although the test system for this blog was a RHEL 6.3 system, these steps should work with any RHEL 6.0 or CentOS 6.0 and above Linux system.
First, locate and mount your RHEL 6.3 install media.
“grid infrastructure or clusterware home not found” when using DBCA on Oracle 11gR2 64-bit on Windows 2008
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.
Installing Oracle Enterprise Manager 12c 12.1.0.2 on CentOS 6.3 on VMware Workstation 8
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.
the gruffdba 