DbaNotePad

Oracle APPS DBA Blog

Archive for the ‘Database’ Category

12c database rac install using virtual box

Posted by dbanotepad on July 8, 2013

Used instructions at following url to setup 12c 2 node RAC on my laptop ( windows 7 64-bit )

http://www.pythian.com/blog/oracle-12c-rac-on-your-laptop-step-by-step-guide/

Many thanks to Yury for sharing his notes.

In my laptop network setup was as below

10.0.0.3

         (IP ADDRESS GIVEN BY MY ISP)

HOST WINDOWS OS
|
|

10.154.137.1
Host-only Network
(GATEWAY) (ALSO DUAL DNS SERVER LISTENS ON THIS)

HOST WINDOWS OS

|
|

10.154.137.101(VM1) GUEST LINUX OS          10.154.137.102(VM2) GUEST LINUX OS

ON HOST OPERATING SYSTEM

VirtualBox Host-Only Ethernet Adapter #2 –> (GATEWAY) 10.154.137.1
OVB -> File Preferences -> Network -> Add host-only network Edit ipv4 address
DNS server –> 10.154.137.1 255.255.255.0 DHCPServer DISABLED

VirtualBox Host-Only Ethernet Adapter
OVB DHCP Server –> 192.168.56.1 255.255.255.0 DHCPServer : 192.168.56.100
ServerMask : 255.255.255.0
LowerAddress: 192.168.56.101
UpperAddress: 192.168.56.254

ON GUEST OPERATING SYSTEM
public ip (eth0) IPADDR  NETWORK MASK

ol6r01 –> 10.154.137.101 255.255.255.0
ol6r02 –> 10.154.137.102 255.255.255.0

private ip (eth1) IPADDR  NETWORK MASK
ol6r01-priv –> 10.154.138.101 255.255.255.0
ol6r02-priv –> 10.154.138.102 255.255.255.0

virtual ip (eth0:1) IPADDR  NETWORK MASK
ol6r01-vip –> 10.154.137.103 255.255.255.0
ol6r02-vip –> 10.154.137.104 255.255.255.0

scan ip  IPADDR  NETWORK MASK
scan-f1 –> 10.154.137.115 255.255.255.0
10.154.137.116 255.255.255.0
10.154.137.117 255.255.255.0

NAT (eth2)
ol6r01-nat –> DHCP (No Connect Automatically) –> ifup eth2 –> 10.0.4.15
ol6r02-nat –> DHCP (No Connect Automatically)

Seperate Network is necessary for host OS to access guest VMs to do that each GuestVM should have 2 network adapters

one is for GuestVM to access outbound Network namely NAT adapter another is for hostOS to access each guest VM, namely Host-Only adapter

In VirtualBox NAT is attached to each VM and is useful for guestVM to access outbound network but is treated as a seperate network

In VirtualBox Host-only network is a gateway for host(external network) to access guestVMs(internal network) to communicate with each other

 

Had following issues when doing the setup

Cloned VM network interface for public IP is not reachable from host OS using putty

To fix this have renamed file  /etc/udev/rules.d/70-persistent-net.rules to  70-persistent-net.rules.orig and made sure the mac address on the Virtualbox -> VM1 or VM2 -> Settings -> Network for each of the adapters were matching with /etc/sysconfig/network-scripts/ifcfg-ethN mac address and rebooted the VM’s

Private IP address between the nodes were not pingable

Virtualbox -> VM1 or VM2 -> Settings -> Network -> For adapter eth1 (private NIC) re-generated mac address and applied above work around to rename the rules file and rebooted VM’s. After this was done ping between private ip addresses started working.

Entries in /etc/resolv.conf on Linux VM’s were getting removed after restarting host OS(windows)

As workaround to this issue added commands(echo “search myinstall.com” > /etc/resolv.conf; echo “nameserver 10.154.137.1” >> /etc/resolv.conf provided by Yury in his instructions to both VM’s /etc/rc.d/rc.local at the end so they get  executed during VM startup

Posted in Database | Leave a Comment »

11g ORA-15061: ASM operation not supported [41] with unpatched PSU2 ASM

Posted by dbanotepad on April 5, 2010

On our 11.1.0.7 Instance using Solaris SPARC 64 bit OS was trying to add datafiles to existing tablespace and it was erroring out:

SQLPUS> alter tablespace TSNAME add datafile ‘+SID_DG_DG’ size 32m;
alter tablespace TSNAME add datafile ‘+SID_DG_DG’ size 32m
*
ERROR at line 1:
ORA-19510: failed to set size of 4096 blocks for file “+SID_DG_DG/SIDDG/datafile/tsname.680.715525589″ (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 4096 blocks
ORA-15061: ASM operation not supported [41]

Checked view v$asm_diskgroup and there was enough free space in the DG

We have SINGLE 11.1.0.7 ASM codetree and several RDBMS codetrees.

Several RDBMS Instances make use of common ASM Instance.

One of the RDBMS codetree was recently upgraded to PSU2 (while others were at PSU1) but corresponding ASM Instance was left un patched which caused this problem.

To resolve the issue have patched the ASM Instance to PSU2.

NOTE: This worked fine with PSU1 but looks like oracle made this more strict with PSU2.

Posted in Database | Leave a Comment »