Shulou(Shulou.com)05/31 Report--

This article is mainly about "ASM building single instance sharing". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "ASM building single instance sharing".

1. Modify hostname

[root@Test_run_CRM soft] # vi / etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

172.16.25.235 Test_run_CRM

two。 View the rpm package

Check to see if there are packages:

Rpm-qa binutils* compat-libstdc* glibc-2* ksh* libaio* make-3* compat-libcap1* gcc-4* gcc-c* libstdc++-devel* sysstat* glibc-devel* libgcc-4* libstdc++-4* unixODBC-2* unixODBC-devel-2* elfutils-libelf-devel* libXp*

Install the package:

Yum-y install binutils* compat-libstdc* glibc-2* ksh* libaio* make-3* compat-libcap1* gcc-4* gcc-c* libstdc++-devel* sysstat* glibc-devel* libgcc-4* libstdc++-4* unixODBC-2* unixODBC-devel-2* elfutils-libelf-devel* libXp*

3. Modify system parameters

1)

[root@Test_run_CRM soft] # vi / etc/sysctl.conf

Kernel.msgmnb = 65536

Kernel.shmall = 4294967296

Fs.file-max = 6815744

Kernel.msgmni = 2878

Kernel.msgmax = 8192

Kernel.msgmnb = 65536

Kernel.sem = 250 32000 100 142

Kernel.shmmni = 4096

Kernel.shmmax = 329853488333

Net.core.wmem_default = 262144

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_max = 1048576

Fs.aio-max-nr = 3145728

Net.ipv4.ip_local_port_range = 9000 65500

Vm.min_free_kbytes = 51200

Effective:

[root@Test_run_FOSS U01] # sysctl-p

2) [root@Test_run_CRM soft] # vi / etc/pam.d/login

Add the last line

Session required pam_limits.so

3) [root@Test_run_CRM soft] # vi / etc/security/limits.conf

Finally, add:

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 1024

Grid hard nofile 65536

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

4) [root@Test_run_CRM soft] # vi / etc/profile

Add:

If [$USER = "oracle"] | | [$USER = "grid"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Umask 022

Fi

3. Create groups and users

Create a group:

Groupadd-g 501 oinstall

Groupadd-g 502 dba

Groupadd-g 503 oper

Groupadd-g 504 asmadmin

Groupadd-g 505 asmdba

Groupadd-g 506 asmoper

Create a user:

# useradd-u 501-g oinstall-G dba,oper,asmadmin,asmdba,asmoper-s / bin/bash grid

# useradd-u 502-g oinstall-G dba,oper,asmadmin,asmdba,asmoper-s / bin/bash oracle

Change the password:

Passwd oracle

Passwd grid

Modify path permissions:

Mkdir-p / u01/app/

Chown-R oracle:oinstall / u01/app/

Chmod-R 775 / u01/app/

4. Modify bash_profile

Oracle:

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_SID=sfsdb1

Export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

Export PATH=$PATH:$ORACLE_HOME/bin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export ORACLE_TERM=xterm

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/lib64:/usr/lib64

Export NLS_DATE_FORMAT= "YYYY-MM-DD HH24:MI:SS"

Export TNS_ADMIN=$ORACLE_HOME/network/admin

Grid:

Export ORACLE_BASE=/u01/app/grid

Export ORACLE_HOME=/u01/app/11.2.0/grid

Export ORACLE_SID=+ASM

Export PATH=$PATH:$ORACLE_HOME/bin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/lib64:/usr/lib64

Export ORACLE_TERM=xterm

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Export TNS_ADMIN=$ORACLE_HOME/network/admin

5. Bind disks using udev

View the storage disk:

1) confirm with the host group that can be used from 1a to 1f

[root@Test_run_CRM soft] # ll / dev/mapper/

Total 0

Lrwxrwxrwx 1 root root 7 May 27 19:58 32ff70002ac012ff4->.. / dm-7

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001300012ff4->.. / dm-0

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001300012ff4p1->.. / dm-8

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001a00012ff4->.. / dm-5

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001b00012ff4->.. / dm-4

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001c00012ff4->.. / dm-3

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001d00012ff4->.. / dm-2

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001e00012ff4->.. / dm-1

Lrwxrwxrwx 1 root root 7 May 27 15:07 360002ac0000000000000001f00012ff4->.. / dm-6

Crw-rw---- 1 root root 10, 236 May 27 15:07 control

2) add udev binding file:

[root@Test_run_CRM soft] # vi / etc/udev/rules.d/12-dm-permissions.rules

ENV {DM_NAME} = "360002ac0000000000000001a00012ff4", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "360002ac0000000000000001b00012ff4", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "360002ac0000000000000001c00012ff4", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "360002ac0000000000000001d00012ff4", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "360002ac0000000000000001e00012ff4", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "360002ac0000000000000001f00012ff4", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

3) start UDEV

/ sbin/start_udev

4) check that disk users and groups have been modified to grid and asmadmin

[root@Test_run_FOSS U01] # ll / dev/ | grep grid

Brw-rw---- 1 grid asmadmin 252, 1 May 27 18:24 dm-1

Brw-rw---- 1 grid asmadmin 252, 2 May 27 18:24 dm-2

Brw-rw---- 1 grid asmadmin 252, 3 May 27 18:24 dm-3

Brw-rw---- 1 grid asmadmin 252, 4 May 27 18:24 dm-4

Brw-rw---- 1 grid asmadmin 252, 5 May 27 18:24 dm-5

Brw-rw---- 1 grid asmadmin 252, 6 May 27 18:24 dm-6

6. Extract the file

[root@Test_run_CRM soft] # unzip p13390677_112040_Linux-x86-64_1of7.zip

[root@Test_run_CRM soft] # unzip p13390677_112040_Linux-x86-64_2of7.zip

[root@Test_run_CRM soft] # unzip p13390677_112040_Linux-x86-64_3of7.zip

Modify its permissions:

[root@Test_run_CRM soft] # chown-R oracle:oinstall database/

[root@Test_run_CRM soft] # chown-R grid:oinstall grid/

7. Install grid softwar

[root@Test_run_CRM soft] # su-grid

[grid@Test_run_CRM ~] $cd / u01/soft/grid/

[grid@Test_run_CRM grid] $xhost

Access control disabled, clients can connect from any host

INET:10.253.1.13

[grid@Test_run_CRM grid] $

[grid@Test_run_CRM grid] $

[grid@Test_run_CRM grid] $export DISPLAY=10.253.1.13:110.0

[grid@Test_run_CRM grid] $. / runInstaller

Default:

8. Install the Oracle software:

[root@Test_run_CRM soft] # su-oracle

[oracle@Test_run_CRM database] $pwd

/ u01/soft/database

[oracle@Test_run_CRM database] $. / runInstaller

9. Create a new DB:

Using asm disk

Do not open filing

Specify SGA+PGA:

Specify the character set:

At this point, I believe you have a deeper understanding of "ASM building single instance sharing". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.