Installing Oracle 11G RAC on Linux 6

发布时间：2020-06-11 05:41:39 来源：网络阅读：972 作者：Liang_yujie 栏目：关系型数据库

vi /etc/hosts

10.254.28.11jwdb01

10.254.28.12jwdb02

10.254.28.13 jwdb01-vip

10.254.28.14jwdb02-vip

6.6.7.101jwdb01-priv

6.6.7.102jwdb02-priv

10.254.28.15jwdb-scan

vi /etc/sysctl.conf

#oracle rac config parameter

fs.aio-max-nr = 1048576

fs.file-max = 6815744

#kernel.shmall = 2097152

#kernel.shmmax = 1054504960

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

[root@jwdb01 ~]# vi /etc/pam.d/login

#%PAM-1.0

auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so

auth include system-auth

account required pam_nologin.so

account include system-auth

password include system-auth

# pam_selinux.so close should be the first session rule

session required pam_selinux.so close

session required pam_loginuid.so

session optional pam_console.so

# pam_selinux.so open should only be followed by sessions to be executed in the user context

session required pam_selinux.so open

session required pam_namespace.so

session optional pam_keyinit.so force revoke

session include system-auth

-session optional pam_ck_connector.so

session required pam_limits.so

# End of file

vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 4096

oracle hard nofile 65536

oracle soft stack 10240

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 4096

grid hard nofile 65536

grid soft stack 10240

[root@jwdb01 ~]#

[root@jwdb01 ~]# groupadd -g 500 oinstall

groupadd -g 501 dba

useradd -u 501 -g oinstall -G dba oracle

passwd oracle[root@jwdb01 ~]# groupadd -g 501 dba

[root@jwdb01 ~]# useradd -u 501 -g oinstall -G dba oracle

[root@jwdb01 ~]# passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: it is based on a dictionary word

BAD PASSWORD: is too simple

Retype new password:

passwd: all authentication tokens updated successfully.

[root@jwdb01 ~]#

[root@jwdb01 ~]# useradd -u 500 -g oinstall -G dba grid

passwd grid[root@jwdb01 ~]# passwd grid

Changing password for user grid.

New password:

BAD PASSWORD: it is too short

BAD PASSWORD: is too simple

Retype new password:

passwd: all authentication tokens updated successfully.

[root@jwdb01 ~]#

[root@jwdb01 ~]# id grid

uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(dba)

[root@jwdb01 ~]# id oracle

uid=501(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

vi /etc/security/limits.d/90-nproc.conf

# Change this

* soft nproc 1024

# To this

* - nproc 16384

chown -R oracle.dba /oracle

mkdir -p /home/oracle/app/grid

mkdir -p /home/oracle/app/asm

mkdir -p /home/oracle/app/product/db

chown -R grid:dba /home/oracle/app

chown -R grid:dba /home/oracle/app/asm

chown -R grid:dba /home/oracle/app/grid

chown -R oracle:dba /home/oracle/app/db/product/11.2

chmod -R 775 /home/oracle/app

grid

export ORACLE_BASE=/home/oracle/app/grid

export ORACLE_HOME=/home/oracle/app/asm

export ORACLE_SID=+ASM1

export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

umask 022

mkdir -p /home/u01/app/grid

mkdir -p /home/u01/app/asm

mkdir -p /home/u01/db/product/11.2

chown -R grid:oinstall /home/u01/app

chown -R grid:oinstall /home/u01/app/asm

chown -R grid:oinstall /home/u01/app/grid

chown -R oracle:oinstall /home/u01/db/product/11.2

chmod -R 775 /home/u01/app

grid

export ORACLE_BASE=/home/u01/app/grid

export ORACLE_HOME=/home/u01/app/asm

export ORACLE_SID=+ASM1

export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

umask 022

oracle

export ORACLE_BASE=/home/u01/db

export ORACLE_HOME=$ORACLE_BASE/product/11.2

export ORACLE_SID=dzxjdb1

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

umask=022

useradd -g tellin -d /home/uportal -m -s /usr/bin/csh uportal

usermod -d /u01 grid

切换到root用户，使用usermod命令，例如usermod -d /tmp test (test为你的用户名)，使用该命令请确保该用户下没有运行的软件或进程

ntp

ntp时间同步

202.112.128.33

[root@jwsysdb02 etc]# mv ntp.conf ntp.conf.bak

[root@jwsysdb02 etc]# vi ntp.conf

server 202.112.128.33 prefer

driftfile /var/lib/ntp/drift

broadcastdelay 0.008

/etc/init.d/ntpd start

存储的设备处理步骤：

root@jwdb01 by-path]# sfdisk -s

/dev/sdc: 209715200

/dev/sdd: 2097152

/dev/sde: 2097152

/dev/sdb: 209715200

/dev/sda: 292935982

/dev/sdi: 2097152

/dev/sdg: 209715200

/dev/sdh: 2097152

/dev/sdf: 209715200

/dev/mapper/vg_jwdb01-lv_root: 52428800

/dev/mapper/vg_jwdb01-lv_swap: 4194304

/dev/sdj: 209715200

/dev/sdk: 209715200

/dev/sdl: 2097152

/dev/sdm: 2097152

/dev/sdn: 209715200

/dev/sdo: 209715200

/dev/sdp: 2097152

/dev/sdq: 2097152

/dev/mapper/vg_jwdb01-lv_home: 235798528

/dev/mapper/data2: 209715200

/dev/mapper/ocr2: 2097152

/dev/mapper/ocr1: 2097152

/dev/mapper/data1: 209715200

/dev/mapper/data1p1: 209712478

/dev/mapper/ocr1p1: 2096451

/dev/mapper/data2p1: 209712478

/dev/mapper/ocr2p1: 2096451

total: 3127098992 blocks

[root@jwdb01 by-path]#

[root@jwdb01 by-path]# chmod 0660 /dev/mapper/ocr1

ocr1 ocr1p1

[root@jwdb01 by-path]# chmod 0660 /dev/mapper/ocr1p1

[root@jwdb01 by-path]# chmod 0660 /dev/mapper/ocr2p1

[root@jwdb01 by-path]#

[root@jwdb01 by-path]# raw /dev/mapper/ocr1p1 /dev/raw/raw1

Usage:

raw /dev/raw/rawN <major> <minor>

raw /dev/raw/rawN /dev/<blockdev>

raw -q /dev/raw/rawN

raw -qa

[root@jwdb01 by-path]# raw /dev/raw/raw1 /dev/mapper/ocr1p1

/dev/raw/raw1: bound to major 253, minor 7

[root@jwdb01 by-path]# raw /dev/raw/raw2 /dev/mapper/ocr2p1

/dev/raw/raw2: bound to major 253, minor 9

[root@jwdb01 by-path]# raw -qa

/dev/raw/raw1: bound to major 253, minor 7

/dev/raw/raw2: bound to major 253, minor 9

[root@jwdb01 by-path]# cd /dev/raw

[root@jwdb01 raw]# ls -lrt

total 0

crw-rw----. 1 root disk 162, 0 Mar 9 15:36 rawctl

crw-rw----. 1 root disk 162, 1 Mar 9 19:33 raw1

crw-rw----. 1 root disk 162, 2 Mar 9 19:33 raw2

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/ocr1p1

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/ocr1

3600b342212af8cad3666d6158d0000da

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/ocr2

3600b342ea1bc4eddbcfbd001cd0000d4

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/data1

3600b342513d1ae1d508dd7034d0000d7

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/data2

3600b34292a10124d90fcdec9bd0000dc

[root@jwdb01 raw]# chown -R grid:oinstall /dev/raw/raw1

[root@jwdb01 raw]# chown -R grid:oinstall /dev/raw/raw2

[root@jwdb01 raw]# chmod 660 /dev/raw/raw1

[root@jwdb01 raw]# chmod 660 /dev/raw/raw2

[root@jwdb01 raw]# raw -qa

/dev/raw/raw1: bound to major 253, minor 7

/dev/raw/raw2: bound to major 253, minor 9

[root@jwdb01 raw]#

[root@jwdb01 ~]#

[root@jwdb01 ~]# /home/u01/app/oraInventory/orainstRoot.sh

Changing permissions of /home/u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@jwdb01 ~]#

[root@jwdb01 ~]# /home/u01/app/asm/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= /home/u01/app/asm

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/u01/app/asm/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

root wallet

root wallet cert

root cert export

peer wallet

profile reader wallet

pa wallet

peer wallet keys

pa wallet keys

peer cert request

pa cert request

peer cert

pa cert

peer root cert TP

profile reader root cert TP

pa root cert TP

peer pa cert TP

pa peer cert TP

profile reader pa cert TP

profile reader peer cert TP

peer user cert

pa user cert

Adding Clusterware entries to upstart

CRS-2672: Attempting to start 'ora.mdnsd' on 'jwdb01'

CRS-2676: Start of 'ora.mdnsd' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'jwdb01'

CRS-2676: Start of 'ora.gpnpd' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'jwdb01'

CRS-2672: Attempting to start 'ora.gipcd' on 'jwdb01'

CRS-2676: Start of 'ora.cssdmonitor' on 'jwdb01' succeeded

CRS-2676: Start of 'ora.gipcd' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'jwdb01'

CRS-2672: Attempting to start 'ora.diskmon' on 'jwdb01'

CRS-2676: Start of 'ora.diskmon' on 'jwdb01' succeeded

CRS-2676: Start of 'ora.cssd' on 'jwdb01' succeeded

ASM created and started successfully.

Disk Group CRSDG created successfully.

clscfg: -install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 51f01ae0711a4fa1bfb2edf48a5e7e7d.

Successfully replaced voting disk group with +CRSDG.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

## STATE File Universal Id File Name Disk group

-- ----- ----------------- --------- ---------

1. ONLINE 51f01ae0711a4fa1bfb2edf48a5e7e7d (/dev/raw/raw1) [CRSDG]

Located 1 voting disk(s).

CRS-2672: Attempting to start 'ora.asm' on 'jwdb01'

CRS-2676: Start of 'ora.asm' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.CRSDG.dg' on 'jwdb01'

CRS-2676: Start of 'ora.CRSDG.dg' on 'jwdb01' succeeded

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@jwdb02 ~]# /home/u01/app/oraInventory/orainstRoot.sh

Changing permissions of /home/u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@jwdb02 ~]#

[root@jwdb02 ~]# /home/u01/app/asm/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= /home/u01/app/asm

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/u01/app/asm/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

Adding Clusterware entries to upstart

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node jwdb01, number 1, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@jwdb02 ~]# su - grid

[grid@jwdb02 ~]$

[grid@jwdb02 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora....SM2.asm application ONLINE ONLINE jwdb02

ora.jwdb02.gsd application OFFLINE OFFLINE

ora.jwdb02.ons application ONLINE ONLINE jwdb02

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

vi /etc/rc.local

chown -R grid:oinstall /dev/mapper/ocr1p1

chown -R grid:oinstall /dev/mapper/ocr2p1

chown -R grid:oinstall /dev/mapper/data1p1

chown -R grid:oinstall /dev/mapper/data2p1

sleep 3

chmod 660 /dev/mapper/ocr1p1

chmod 660 /dev/mapper/ocr2p1

chmod 660 /dev/mapper/data1p1

chmod 660 /dev/mapper/data2p1

sleep 3

raw /dev/raw/raw1 /dev/mapper/ocr1p1

raw /dev/raw/raw2 /dev/mapper/ocr2p1

raw /dev/raw/raw3 /dev/mapper/data1p1

raw /dev/raw/raw4 /dev/mapper/data2p1

sleep 3

chown -R grid:oinstall /dev/raw/raw1

chown -R grid:oinstall /dev/raw/raw2

chown -R grid:oinstall /dev/raw/raw3

chown -R grid:oinstall /dev/raw/raw4

chmod 660 /dev/raw/raw1

chmod 660 /dev/raw/raw2

chmod 660 /dev/raw/raw3

chmod 660 /dev/raw/raw4

应用连接配置连接IP

10.254.28.15

即scan-ip

虚拟IP--vip

10.254.28.13

10.254.28.14

端口：1521

第一个节点(28.11)

root用户下执行

1.停止11g rac

su - oracle -c "srvctl stop instance -d orcl -i orcl1"

su - root -c "/home/u01/app/asm/bin/crsctl stop crs"

2.启动11g rac

su - root -c "/home/u01/app/asm/bin/crsctl start crs"

sleep 120

su - oracle -c "srvctl start instance -d orcl -i orcl1"

第二个节点(28.12)

root用户下执行

1.停止11g rac

su - oracle -c "srvctl stop instance -d orcl -i orcl2"

su - root -c "/home/u01/app/asm/bin/crsctl stop crs"

2.启动11g rac

su - root -c "/home/u01/app/asm/bin/crsctl start crs"

sleep 120

su - oracle -c "srvctl start instance -d orcl -i orcl2"

crs_stat -t的用法

在grid用户下，执行

crs_stat -t

[grid@jwdb01 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora....01.lsnr application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora....SM2.asm application ONLINE ONLINE jwdb02

ora....02.lsnr application ONLINE ONLINE jwdb02

ora.jwdb02.gsd application OFFLINE OFFLINE

ora.jwdb02.ons application ONLINE ONLINE jwdb02

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

注明：gsd

ora.jwdb01.gsd

ora.jwdb02.gsd

ora.gsd

已经废弃了额offline是正常的

其他所有项，target online，state(状态) online

假如出现offline，表示11g grid rac有问题，需要检查

shutdown immediate

incon/incon connect,dba,resource incon.dbf

orcl bhjw/bhjw connect,dba,resource bhjw.dbf

create tablespace incon

datafile '+DATADG'

autoextend on

next 5m maxsize 20480m

extent management local;

create user incon identified by incon

default tablespace incon;

create tablespace bhjw

datafile '+DATADG'

size 5000m

autoextend on

next 5m maxsize 20480m

extent management local;

create user bhjw identified by bhjw

default tablespace bhjw;

grant connect,dba to incon;

grant connect,dba to bhjw;

测试

[root@jwdb01 ~]# su - oracle

[oracle@jwdb01 ~]$

[oracle@jwdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:25:00 2015

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

SQL> create tablespace incon

2 datafile '+DATADG'

3 autoextend on

4 next 5m maxsize 20480m

5 extent management local;

Tablespace created.

SQL> create user incon identified by incon

2 default tablespace incon；

SQL>

SQL> create user incon identified by incon

2 default tablespace incon;

User created.

SQL>

SQL> grant connect,dba to incon;

Grant succeeded.

SQL>

SQL> create tablespace bhjw

2 datafile '+DATADG'

3 size 5000m

4 autoextend on

5 next 5m maxsize 20480m

6 extent management local;

Tablespace created.

SQL>

SQL> create user bhjw identified by bhjw

2 default tablespace bhjw;

User created.

SQL>

SQL> grant connect,dba to bhjw;

Grant succeeded.

SQL> show paramater name

SP2-0158: unknown SHOW option "paramater"

SP2-0158: unknown SHOW option "name"

SQL> show parameter name

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cell_offloadgroup_name string

db_file_name_convert string

db_name string orcl

db_unique_name string orcl

global_names boolean FALSE

instance_name string orcl1

lock_name_space string

log_file_name_convert string

processor_group_name string

service_names string orcl

SQL> !

[oracle@jwdb01 ~]$ ps -ef|grep LOCAL

[grid@jwdb01 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora....01.lsnr application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora....SM2.asm application ONLINE ONLINE jwdb02

ora....02.lsnr application ONLINE ONLINE jwdb02

ora.jwdb02.gsd application OFFLINE OFFLINE

ora.jwdb02.ons application ONLINE ONLINE jwdb02

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[grid@jwdb01 ~]$

[oracle@jwdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:48:39 2015

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

SQL> shutdown abort

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[oracle@jwdb01 ~]$

[oracle@jwdb01 ~]$ ps -ef|grep smon

oracle 51634 51102 0 21:49 pts/3 00:00:00 grep smon

root 62097 1 6 20:04 ? 00:06:24 /home/u01/app/asm/bin/osysmond.bin

grid 62240 1 0 20:04 ? 00:00:00 asm_smon_+ASM1

[oracle@jwdb01 ~]$

[grid@jwdb01 ~]$

[grid@jwdb01 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora....01.lsnr application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora....SM2.asm application ONLINE ONLINE jwdb02

ora....02.lsnr application ONLINE ONLINE jwdb02

ora.jwdb02.gsd application OFFLINE OFFLINE

ora.jwdb02.ons application ONLINE ONLINE jwdb02

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora.orcl.db ora....se.type ONLINE ONLINE jwdb02

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[oracle@jwdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:50:08 2015

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 4.4896E+10 bytes

Fixed Size 2263296 bytes

Variable Size 7381976832 bytes

Database Buffers 3.7447E+10 bytes

Redo Buffers 64831488 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[oracle@jwdb01 ~]$ ps -ef|grep smon

oracle 52029 1 0 21:50 ? 00:00:00 ora_smon_orcl1

oracle 52216 51102 0 21:50 pts/3 00:00:00 grep smon

root 62097 1 6 20:04 ? 00:06:30 /home/u01/app/asm/bin/osysmond.bin

grid 62240 1 0 20:04 ? 00:00:00 asm_smon_+ASM1

[grid@jwdb01 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora....01.lsnr application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora....SM2.asm application ONLINE ONLINE jwdb02

ora....02.lsnr application ONLINE ONLINE jwdb02

ora.jwdb02.gsd application OFFLINE OFFLINE

ora.jwdb02.ons application ONLINE ONLINE jwdb02

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[root@jwdb02 ~]# su - oracle -c "srvctl stop instance -d orcl -i orcl2"

[root@jwdb02 ~]#

[root@jwdb02 ~]# su - root -c "/home/u01/app/asm/bin/crsctl stop crs"

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'jwdb02'

CRS-2673: Attempting to stop 'ora.crsd' on 'jwdb02'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'jwdb02'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.CRSDG.dg' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.ARCHDG.dg' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'jwdb02'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.jwdb02.vip' on 'jwdb02'

CRS-2677: Stop of 'ora.ARCHDG.dg' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.DATADG.dg' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.registry.acfs' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.jwdb02.vip' on 'jwdb02' succeeded

CRS-2672: Attempting to start 'ora.jwdb02.vip' on 'jwdb01'

CRS-2676: Start of 'ora.jwdb02.vip' on 'jwdb01' succeeded

CRS-2677: Stop of 'ora.CRSDG.dg' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'jwdb02'

CRS-2677: Stop of 'ora.asm' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'jwdb02'

CRS-2677: Stop of 'ora.ons' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'jwdb02'

CRS-2677: Stop of 'ora.net1.network' on 'jwdb02' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'jwdb02' has completed

CRS-2677: Stop of 'ora.crsd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.crf' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.ctssd' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.evmd' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.asm' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'jwdb02'

CRS-2677: Stop of 'ora.evmd' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.crf' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.asm' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'jwdb02'

CRS-2677: Stop of 'ora.drivers.acfs' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'jwdb02'

CRS-2677: Stop of 'ora.cssd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'jwdb02'

CRS-2677: Stop of 'ora.gipcd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'jwdb02'

CRS-2677: Stop of 'ora.gpnpd' on 'jwdb02' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'jwdb02' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@jwdb02 ~]#

[grid@jwdb01 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora....01.lsnr application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora....SM2.asm application ONLINE ONLINE jwdb02

ora....02.lsnr application ONLINE ONLINE jwdb02

ora.jwdb02.gsd application OFFLINE OFFLINE

ora.jwdb02.ons application ONLINE ONLINE jwdb02

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

[grid@jwdb01 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

ora.asm ora.asm.type ONLINE ONLINE jwdb01

ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE jwdb01

ora....01.lsnr application ONLINE ONLINE jwdb01

ora.jwdb01.gsd application OFFLINE OFFLINE

ora.jwdb01.ons application ONLINE ONLINE jwdb01

ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb01

ora....network ora....rk.type ONLINE ONLINE jwdb01

ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

ora.ons ora.ons.type ONLINE ONLINE jwdb01

ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[grid@jwdb01 ~]$

备份，

exp，如果是登陆linux服务器的oracle用户下，请使用全库导出full=y参数，外加buffer=1000000，使用system/oracle

归档清除，稍后提供

11g存储

多路径裸盘，分区建lvm，然后raw设备绑定。

或者多路径裸盘udev绑定

Base System > Base

Base System > Client management tools

Base System > Compatibility libraries

Base System > Hardware monitoring utilities

Base System > Large Systems Performance

Base System > Network file system client

Base System > Performance Tools

Base System > Perl Support

Servers > Server Platform

Servers > System administration tools

Desktops > Desktop

Desktops > Desktop Platform

Desktops > Fonts

Desktops > General Purpose Desktop

Desktops > Graphical Administration Tools

Desktops > Input Methods

Desktops > X Window System

Applications > Internet Browser

Development > Additional Development

Development > Development Tools

rpm -Uvh binutils-2.*

rpm -Uvh compat-libstdc++-33*

rpm -Uvh elfutils-libelf-0.*

rpm -Uvh libaio-0.*

rpm -Uvh libaio-devel-0.*

rpm -Uvh sysstat-9.*

rpm -Uvh glibc-2.*

rpm -Uvh glibc-common-2.*

rpm -Uvh glibc-devel-2.* glibc-headers-2.*

rpm -Uvh ksh-2*

rpm -Uvh make-3.*

rpm -Uvh libgcc-4.*

rpm -Uvh libstdc++-4.*

rpm -Uvh libstdc++-4.*.i686*

rpm -Uvh libstdc++-devel-4.*

rpm -Uvh gcc-4.*x86_64*

rpm -Uvh gcc-c++-4.*x86_64*

rpm -Uvh --allfiles elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64*

rpm -Uvh elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686*

rpm -Uvh libtool-ltdl*i686*

rpm -Uvh ncurses*i686*

rpm -Uvh readline*i686*

rpm -Uvh unixODBC*

vi /etc/sysctl.conf

#oracle rac config parameter

fs.aio-max-nr = 1048576

fs.file-max = 6815744

#kernel.shmall = 2097152

#kernel.shmmax = 1054504960

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

vi /etc curity mits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 4096

oracle hard nofile 65536

oracle soft stack 10240

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 4096

grid hard nofile 65536

grid soft stack 10240

vi /etc/pam.d/login

session required pam_limits.so

groupadd -g 500 oinstall

groupadd -g 501 dba

useradd -u 501 -g oinstall -G dba oracle

passwd oracle

useradd -u 500 -g oinstall -G dba grid

passwd grid

[root@oradb1 ~]# id oracle

uid=501(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

[root@oradb1 ~]# id grid

uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(dba)

解开grid包的时候

rpm -Uvh cvuqdisk*

cat /etc/hosts

127.0.0.1 localhost

#rac 112 config

#scan-ip

192.168.56.30 racdb-scan

#public-ip

192.168.56.31 racdb1

192.168.56.33 racdb2

#private-ip

10.10.10.31 racdb1-priv

10.10.10.33 racdb2-priv

#virtual-ip

192.168.56.32 racdb1-vip

192.168.56.34 racdb2-vip

vi /etc curity mits.d/90-nproc.conf

# Change this

* soft nproc 1024

# To this

* - nproc 16384

cat /etc linux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is enforced.

# permissive - SELinux prints warnings instead of enforcing.

# disabled - No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:

# targeted - Targeted processes are protected,

# mls - Multi Level Security protection.

SELINUXTYPE=targeted

service iptables stop

chkconfig iptables off

/oracle/grid

/oracle/asm

/oracle

# mkdir -p /u01/app/11.2.0/grid

# mkdir -p /u01/app/grid

# mkdir -p /u01/app/oracle

# chown grid:oinstall /u01/app/11.2.0/grid

# chown grid:oinstall /u01/app/grid

# chown oracle:oinstall /u01/app/oracle

# chmod -R 775 /u01/

# chown -R grid:oinstall /u01

杨东 22:24:18

mkdir -p /u01/app/grid

mkdir -p /u01/app/11.2/grid

mkdir -p /u01/oracle/product/11.2

chown -R oracle:oinstall /u01/oracle

chown -R grid:oinstall /u01

chmod -R 775 /u01

#grid

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/11.2/grid

export ORACLE_SID=+ASM1

export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export ORACLE_TERM=xterm

export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle l:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME b:$ORACLE_HOME/oracm b: b:/usr b:/usr/local b

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

echo ORACLE_SID=$ORACLE_SID

echo ORACLE_BASE=$ORACLE_BASE

echo ORACLE_HOME=$ORACLE_HOME

#oracle

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2

export ORACLE_SID=oradb1

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle l:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME b:$ORACLE_HOME/oracm b: b:/usr b:/usr/local b

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export ORACLE_TERM=xterm

echo ORACLE_SID=$ORACLE_SID

echo ORACLE_BASE=$ORACLE_BASE

echo ORACLE_HOME=$ORACLE_HOME

向AI问一下细节

Installing Oracle 11G RAC on Linux 6

猜你喜欢

最新资讯

相关推荐

相关标签