Shulou(Shulou.com)06/01 Report--

1. Install Linux system c3 on a bare metal, and prepare it to join the rac environment of C1 and c2 nodes.

There must be two network cards eth0,eth2.

(slightly)

2. Adjust / etc/hosts file

Change all three nodes to the following

127.0.0.1localhost

192.168.33.101c1

192.168.33.201c1-vip

10.0.0.2c1-priv

192.168.33.102c2

192.168.33.202c2-vip

10.0.0.3c2-priv

192.168.33.103c3

192.168.33.203c3-vip

10.0.0.4c3-priv

10.0.0.1san

3. Configure hangcheck-timer: used to monitor whether the Linux kernel hangs

Vim / etc/modprobe.conf

Options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180

4. Automatically load hangcheck-timer module / u01/app/oracle/product/10.2.0/db_1

Vim / etc/rc.local

Modprobe hangcheck-timer

Check to see if the hangcheck-timer module is loaded:

Lsmod | grep hangcheck_timer

5. Create group dba & oinstall, and create user oracle

Groupadd oinstall

Groupadd dba

Usreadd-g oinstall-G dba oracle

6. Configure cluster mutual trust

Create a key on the new node:

Su-oracle

Ssh-keygen-t rsa

Ssh-keygen-t dsa

Cd .ssh

Cat * .pub > > authorized_keys

Then the three nodes are appended in turn (abbreviated)

7. C3 configure ntp

Vim / etc/ntp.conf

-

Server 192.168.0.253

Restrict 192.168.0.253 mask 255.255.255.255 nomodify notrap noquery

Crontab-e

* / 5 * / usr/sbin/ntpdate san

8. Import san storage

Yum install iscsi-initiator-utils-y

Service iscsid start

Iscsiadm-m discovery-t st-p san

Service iscsi start

Chkconfig iscsid on

Chkconfig iscsi on

9. Bind with udev

Vim / etc/udev/rules.d/60-raw.rules

ACTION== "add", KERNEL== "sdf1", RUN+= "/ bin/raw / dev/raw/raw1 N"

ACTION== "add", KERNEL== "sdg1", RUN+= "/ bin/raw / dev/raw/raw2 N"

KERNEL== "raw1", OWNER= "oracle", GROUP= "oinstall", MODE= "660"

KERNEL== "raw2", OWNER= "oracle", GROUP= "oinstall", MODE= "660"

Then start udev

Start_udev

9.5. For the convenience of opening instances on c3 in the future

You can copy C1 directly.

/ etc/sysctl.conf

/ etc/security/limits.conf

/ home/oracle/.bashrc

And then modify it accordingly.

10. Check the cluster node

Cd / soft/clusterware/cluvfy/

. / runcluvfy.sh stage-pre crsinst-n C1 verbose c2meme c3-verbose

11. Add clusterware

Start the add Node Wizard from the old node:

Cd / u01/crs_1/oui/bin/

. / addNode.sh

On the Specify Cluster Nodes to Add to Installation page

Add c3tech, c3copyright privprecy, c3kovip information

Execute three scripts

Execute on c3

/ u01/app/oracle/oraInventory/orainstRoot.sh

Execute on C1

/ u01/crs_1/install/rootaddnode.sh

Execute on c3

/ u01/crs_1/root.sh

12. Add database software

Cd / u01/app/oracle/produt/10.2.0/db1/oui/bin/

. / addNode.sh

On the Specify Cluster Nodes to Add to Installation page

Check c3

Execute a script

Execute on c3

/ u01/app/oracle/product/10.2.0/db_1/root.sh

13. Configure monitoring

Start netca on the old node C1

Select Cluster configuration

Select c3 node

Listener configuration

Add

LISTENER

TCP

Use the standard port number of 1521

14. Scan ASM disk

Install oracleasmlib, oracleasm, oracle-support packages on c3

/ etc/init.d/oracleasm configure

/ etc/init.d/oracleasm scandisks

15. Start the dbca configuration ASM instance

Configure Automatic Storage Management

Select C1 and c3 (C1 is selected automatically)

16. Add an instance

Or use dbca

Instance Management

Add Instance

Confirm that the Database Services on the left is a service

There are three instances on the right, all of which choose Preferred,TAF and Basic

Complete

17. Start a new instance

You may not be able to start instance 3 after the completion of the 16 steps. The following steps are needed to modify

On C1 instance

ALETR SYSTEM SET CLUSETER_DATABASE_INSTANCES=3 SCOPE=SPFILE

CREATE PFILE='/tmp/init.ora' FROM SPFILE

Copy pfile to c3

Scp / tmp/init.ora c3:/tmp/init.ora

On the c3 host

Modify content

Kdata1.__db_cache_size=352321536

Kdata2.__db_cache_size=356515840

Kdata3.__db_cache_size=352321536

Kdata2.__java_pool_size=4194304

Kdata1.__java_pool_size=4194304

Kdata3.__java_pool_size=4194304

Kdata2.__large_pool_size=4194304

Kdata1.__large_pool_size=4194304

Kdata3.__large_pool_size=4194304

Kdata1.__shared_pool_size=230686720

Kdata2.__shared_pool_size=226492416

Kdata3.__shared_pool_size=226492416

Kdata2.__streams_pool_size=0

Kdata1.__streams_pool_size=0

Kdata3.__streams_pool_size=0

* .audit_file_dest='/u01/app/oracle/admin/kdata/adump'

* .background_dump_dest='/u01/app/oracle/admin/kdata/bdump'

* .cluster_database_instances=3

* .cluster_database=true

* .compatible='10.2.0.1.0'

* .control_files='+AS/kdata/controlfile/current.268.803056777'#Restore Controlfile

* .core_dump_dest='/u01/app/oracle/admin/kdata/cdump'

* .db_block_size=8192

* .db_create_file_dest='+AS'

* .db_create_online_log_dest_1='+AS'

* .db_domain=''

* .db_file_multiblock_read_count=16

* .db_name='kdata'

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=kdataXDB)'

Kdata1.instance_number=1

Kdata2.instance_number=2

Kdata3.instance_number=3

* .job_queue_processes=10

* .log_archive_dest='+AS'

* .open_cursors=300

* .pga_aggregate_target=199229440

* .processes=150

* .remote_listener='LISTENERS_kdata'

* .remote_login_passwordfile='exclusive'

* .sga_target=599785472

Kdata2.thread=2

Kdata1.thread=1

Kdata3.thread=3

* .undo_management='AUTO'

Kdata1.undo_tablespace='UNDOTBS1'

Kdata2.undo_tablespace='UNDOTBS2'

Kdata3.undo_tablespace='UNDOTBS3'

* .user_dump_dest='/u01/app/oracle/admin/kdata/udump'

On c3

STARTUP PFILE='/tmp/init.ora'

On c3

CREATE SPFILE='+AS/KDATA/spfilekdata.ora' FROM PFILE='/tmp/init.ora'

Modify initkdata3.ora on c3

SPFILE='+AS/KDATA/spfilekdata.ora'

At this point, all the parts have been modified.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.