Oracle 10g RAC joins new node

1. Install the Linux system C3 on a bare metal and prepare it to join the C1,C2 two-node RAC environment

To have two NICs eth0,eth1

Slightly

2. Adjust/etc/hosts file

Turn three nodes into 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, configuration hangcheck-tImer: for monitoring Linux the core is suspended
Vim /etc/modprobe.conf

Options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180

4. Automatic loading hangcheck-tImer module/u01/app/oracle/product/10.2.0/db_1
Vim /etc/rc.local
Modprobe hangcheck-tImer
Check if the hangcheck-tImer module is already loaded:
Lsmod | grep hangcheck_tImer

5. Create Group DBA & Oinstall, create user Oracle
Groupadd Oinstall

Groupadd dba

USREADD-G oinstall-g dba Oracle

6. Configure Cluster Trust
To create a key on the new node:
Su-oracle
SSH-KEYGEN-T RSA
Ssh-keygen-t DSA
CD. SSH
Cat *.pub >> Authorized_keys

Then three nodes are alternately appended (slightly)

7. c3 Configuring 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. Binding 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"

and start Udev.

Start_udev

9.5, for the future on the C3 to open the instance convenient

You can copy the C1 directly.

/etc/sysctl.conf

/etc/security/limits.conf

/home/oracle/.bashrc

Then make the appropriate changes

10. Check cluster nodes

cd/soft/clusterware/cluvfy/
./runcluvfy.sh stage-pre CRSinst-n c1,c2,c3-verbose

11. Add Clusterware

To start the Add Node Wizard from the old node:

Cd/u01/crs_1/oui/bIn/

./addnode.sh

On the Specify Cluster Nodes to the ADD to installation page

Join C3,C3-PRIV,C3-VIP 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 the ADD to installation page

Tick C3

Execute a script

Execute on the C3

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

13, configuration 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

Installing Oracleasmlib, Oracleasm, Oracle-support packages in C3

/etc/init.d/oracleasm Configure

/etc/init.d/oracleasm Scandisks

15. Start DBCA Configuration ASM Instance

Configure Automatic Storage Management

Select C1 and C3 (C1 is automatically selected)

16. Add an instance

or use the DBCA

Instance Management

ADD Instance

Confirm that database services on the left is a service,

The instance on the right is three, select Preferred,taf Select Basic

Complete

17. Start a new instance

You may not be able to start instance 3 after 16 steps, which requires a few steps to modify

On the C1 instance

Aletr SYSTEM SET cluseter_database_instances=3 scope=spfile;

CREATE pfile= '/tmp/init.ora ' from SPFILE;

Copy the Pfile to the 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 the C3.

STARTUP pfile= '/tmp/init.ora '

On the C3.

CREATE spfile= ' +as/kdata/spfilekdata.ora ' from pfile= '/tmp/init.ora ';

Modify the Initkdata3.ora on C3

Spfile= ' +as/kdata/spfilekdata.ora '

At this point, all the parts have been modified.

Oracle 10g RAC joins new node