Sunday, January 12, 2020

Oracle 12c 2 Nodes sandbox RAC environment on your laptop!

Oracle 12c 2 Nodes sandbox RAC environment on your laptop! 2013.06.28, v1.0 Yury Velikanov Short Introduction As result of...
Before you start Software Components Please note that the process that I describe should work even if you use other (presu...
Implementation process Main steps 1. Setup VBOX 2. Create one node 3. Create shared ASM devices 4. Clone node 5. Install G...
Install or upgrade an existing system Skip => Next =>Next =>Next =>Next => Yes Discard Any Data => ol6r01.yuryffun.com Con...
Next => =>Write changes to disk Next =>(minimum) Basic Server => Next (Timing Start 11:17 => Finish 11:25 => 8 mins) => Re...
[root@ol6r01 yum.repos.d]# time yum update -y Loaded plugins: security Setting up Update Process No Packages marked for Up...
Add Hard Drive => Create new disk => =>VDI =>Fixed Size (otherwise you will not be able to make it sharable) F:vboxol6-12c...
-- Make the HDDs shareable OVB => File => Virtual Media Manager =>asm1/2/3/4.vdi => Modify => Shareable => Close
VBoxLinuxAdditions Remove mounted CD ROM OVB => ol6-12c-rac1 => Settings ... => Storage =>CDROM OVB => ol6-12c-rac1 => Mac...
Building the OpenGL support module [ OK ] Doing non-kernel setup of the Guest Additions [ OK ] Starting the VirtualBox Gue...
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBc1c2a35c-e0d538...
Next => Next => => Next F:vboxol6-12c-rac_1ol6-12c-rac2.vdi => Close Create second node Node OVB => Machine => New => ol6-...
Start second node OVB => ol6-12c-rac2 => Machine => Start Adjust network setup NOTE: from OVB VM console vi /etc/sysconfig...
ping -c 3 ol6r02 ping -c 3 ol6r02-priv ping -c 3 ol6r01 ping -c 3 ol6r01-priv Check UDEV devices from both nodes ls -al /d...
putty root@10.154.137.101 cd/media/sf_12c/ time unzip -o V38500-01_1of2.zip; time unzip -o V38500-01_2of2.zip; time unzip ...
Install GUI
ol6r02 ol6r02-vip
Setup scan-f1.yuryffun.com
Next
oracle1 /dev/asm*
~/12crac_r01.rsp
puttyoracle@10.154.137.101 ORAENV_ASK=NO; ORACLE_SID=+ASM1; .oraenv [oracle@ol6r01 ~]$ crsctl stat res -t ----------------...
1 ONLINE ONLINE ol6r02 STABLE ora.scan1.vip 1 ONLINE ONLINE ol6r02 STABLE ora.scan2.vip 1 ONLINE ONLINE ol6r01 STABLE ora....
Untick
[root@ol6r01 sf_12c]# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh Performing root user operation for Oracle 12c The fo...
Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need t...
Creating Database puttyoracle@10.154.137.101 export DISPLAY=:1 /u01/app/oracle/product/12.1.0/dbhome_1/bin/dbca vncviewer ...
Connecting to the database puttyoracle@10.154.137.101 echo "CAT1:/u01/app/oracle/product/12.1.0/dbhome_1:N:" >> /etc/orata...
CAT1 ol6r01.yuryffun.com CAT2 ol6r02.yuryffun.com SQL> Enjoy and don’t forget to let me know how did it go :) Email: velik...
C:progDualServerDualServerDualServer.exe
Next => Next RAC12c_DNS Optionally you can add Protocol/Port and Scope (see below)
53
10.154.137.1 10.154.137.0/24 Test setup From your workstation cmd C:Usersvelikanov>nslookup Default Server: home.gateway.h...
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
Oracle 12c RAC On your laptop Step by Step Implementation Guide 1.0
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

  How to Change Instance Type & Security Group of EC2 in AWS By David Taylor Updated April 29, 2023 EC2 stands for Elastic Compute Cloud...