Friday, June 15, 2012

How to create a 11gR2 physical standby database using virtual machines on Oracle VM 3.0.3: step 1

I think the following will be a long post series on Data Guard. My goal is to create some data guard scenarios using virtual machines created on Oracle VM 3.0.3 and Oracle Database Enterprise Edition 11.2.0.1.0. I will try to create first a physical standby configuration: I mean "manually" without any use of Data Guard Broker or Enterprise Manager Grid Control (now Cloud). Then I will proceed with logical standby database, describing benefits of both configurations and when you should choose them; if I have time I will continue with Active Data Guard and snapshot scenarios. And what about if you can't use the Oracle Database Enterprise Edition ?

Let's start.
First of all, I've cloned one machine (here are the steps: 1, 2 and 3) where there was installed just the software of Oracle Database 10gR2 (10.2.0.1.0). Then I modified the /etc/sysctl.conf file to use the 11g settings provided by Oracle validated rpm package.


Load the new settings with the command:
[root@vsi08devpom ~]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
fs.file-max = 6815744
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.sysrq = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 9000 65500
vm.min_free_kbytes = 51200



Next verify your limit settings according to Oracle documentation:

cat /etc/security/limits.conf

# Oracle-Validated setting for nofile soft limit is 131072
oracle   soft   nofile    131072

# Oracle-Validated setting for nofile hard limit is 131072
oracle   hard   nofile    131072

# Oracle-Validated setting for nproc soft limit is 131072
oracle   soft   nproc    131072

# Oracle-Validated setting for nproc hard limit is 131072
oracle   hard   nproc    131072

# Oracle-Validated setting for core soft limit is unlimited
oracle   soft   core    unlimited

# Oracle-Validated setting for core hard limit is unlimited
oracle   hard   core    unlimited

# Oracle-Validated setting for memlock soft limit is 50000000
oracle   soft   memlock    50000000

# Oracle-Validated setting for memlock hard limit is 50000000
oracle   hard   memlock    50000000



I didn't modify the following settings coming from the previous Oracle Database 10gR2 software installation.




I modified the ORACLE_SID and the ORACLE_HOME in /home/oracle/settings.sh file

Now I have to create the software installation path for Oracle Database 11gR2.

[root@vsi08devpom ~]# cd /opt/app/oracle/product

[root@vsi08devpom product]# ll
total 4
drwxrwx--- 3 oracle oinstall 4096 Feb 27 14:20 10.2.0

[root@vsi08devpom product]# mkdir -p 11.2.0/db_1

[root@vsi08devpom product]# ll
total 8
drwxrwx--- 3 oracle oinstall 4096 Feb 27 14:20 10.2.0
drwxr-xr-x 3 root   root     4096 Jun  6 14:41 11.2.0

[root@vsi08devpom product]# chown -R oracle.oinstall 11.2.0/

[root@vsi08devpom product]# chmod -R 755 11.2.0/

[root@vsi08devpom product]# ll
total 8
drwxrwx--- 3 oracle oinstall 4096 Feb 27 14:20 10.2.0
drwxr-xr-x 3 oracle oinstall 4096 Jun  6 14:41 11.2.0



Download the 11gR2 database software, extract it and as oracle user execute the runInstaller as usual.

Next steps are here:
step 2
step 3
step 4
step 5

5 comments:

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

oakleyses said...

sac vanessa bruno, new balance, vans pas cher, ray ban uk, nike blazer pas cher, true religion outlet, michael kors outlet, true religion outlet, replica handbags, polo lacoste, oakley pas cher, coach purses, hollister uk, abercrombie and fitch uk, nike free uk, north face uk, louboutin pas cher, polo ralph lauren, hollister pas cher, nike air max uk, michael kors pas cher, nike air max, true religion jeans, timberland pas cher, nike air max uk, coach outlet, air max, michael kors, jordan pas cher, sac hermes, north face, lululemon canada, coach outlet store online, nike roshe, sac longchamp pas cher, nike air force, mulberry uk, hogan outlet, ralph lauren uk, longchamp pas cher, michael kors, converse pas cher, burberry pas cher, nike roshe run uk, true religion outlet, kate spade, nike free run, nike tn, ray ban pas cher, guess pas cher

yanmaneee said...

yeezy boost
nike kd 11
michael kors outlet online
yeezy shoes
jordan shoes
off white
balenciaga shoes
michael kors outlet online
hermes belt
canada goose

Vale Co Xenia said...

This is really such a great article. I really enjoyed it. Thank you for sharing.

IEEE Projects on Cloud Computing



JavaScript Training in Chennai


Final Year Projects for CSE



JavaScript Training in Chennai