DbaNotePad

Oracle APPS DBA Blog

Archive for July, 2013

Copy ConcurrentQueue Definition between environments

Posted by dbanotepad on July 8, 2013

Found following command to be useful when copying new concurrent queue between source and target environments.

SOURCE:
FNDLOAD apps/appspass 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpque.lct concurrent_queue_name.ldt QUEUE APPLICATION_SHORT_NAME=XXABC CONCURRENT_QUEUE_NAME=”Custom_Manager”

TARGET:

FNDLOAD apps/appspass 0 Y UPLOAD $FND_TOP/patch/115/import/afcpque.lct concurrent_queue_name.ldt QUEUE APPLICATION_SHORT_NAME=XXABC CONCURRENT_QUEUE_NAME=”Custom_Manager”

Posted in E-Business Suite | Leave a Comment »

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 »