189 8069 5689
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 ~]#
[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 ~]#
[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
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]#
[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]#
[root@jwdb01 by-path]# raw /dev/mapper/ocr1p1 /dev/raw/raw1
Usage:
raw /dev/raw/rawN
raw /dev/raw/rawN /dev/
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 ~]#
[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 ~]#
[root@jwdb02 ~]#
[root@jwdb02 ~]#
[root@jwdb02 ~]#
[root@jwdb02 ~]#
[root@jwdb02 ~]#
[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 ~]$
[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 ~]$
[oracle@jwdb01 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:25:00 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
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>
SQL>
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；
3
SQL>
SQL> create user incon identified by incon
2 default tablespace incon;
User created.
SQL>
SQL>
SQL> grant connect,dba to incon;
Grant succeeded.
SQL>
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>
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 ~]$
[grid@jwdb01 ~]$
[oracle@jwdb01 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:48:39 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
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>
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 ~]$
[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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
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 ~]#
[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