centos7.3上安装oracle11.2.4RAC

环境：centos7.3、oracle11.2.4、配置了yum仓库服务10.64.39.210、配置了ntp服务器10.64.39.138

直接获取脚本初始化系统配置oracle基础依赖

?

1 2 3 4

wget http://10.64.39.210/download/csh.sh wget http://10.64.39.210/download/oracle-shel.sh sh csh.sh sh oracle-shel.sh

1、centos7.3基础环境初始化

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

cat csh.sh   #!/bin/bash   #关闭selinux sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config rm -rf /etc/yum.repos.d/* #配置yum      cat <<EOF >/etc/yum.repos.d/centos7.repo [centos7] name=centos7 baseurl=http://10.64.39.210/centos7 gpgcheck=0 enabled=1 EOF   yum clean all yum makecache     #关闭防火墙 systemctl disable firewalld systemctl stop firewalld   #安装快捷工具 yum -y install vim yum -y install bash-completion yum -y install lrzsz   #设置时区和ntp timedatectl set-timezone Asia/Shanghai   cat <<EOF > /etc/chrony.conf   server 10.64.39.138 driftfile /var/lib/chrony/drift makestep 1.0 3 rtcsync logdir /var/log/chrony EOF   systemctl enable chronyd systemctl restart chronyd   #安装java yum -y install wget mkdir /java wget http://10.64.39.210/java/jdk.tar -P /java tar -xvf /java/jdk.tar -C /java >/dev/null rm -rf /java/jdk.tar   cat <<EOF >> /etc/profile   export JAVA_HOME=/java/jdk1.8.0_11 export JRE_HOME=/java/jdk1.8.0_11/jre export CLASSPATH=.:\$JAVA_HOME/lib:\$JRE_HOME/lib:\$CLASSPATH export PATH=\$JAVA_HOME/bin:\$JRE_HOME/bin:\$PATH EOF   source /etc/profile   java -version

2、配置oracle的初始化环境

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110

cat oracle-shel.sh   #!/bin/bash #建用户和组 groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 503 oper groupadd -g 504 asmadmin groupadd -g 505 asmdba groupadd -g 506 asmoper   #2.创建安装oracle的用户 useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper,dba grid useradd -u 502 -g oinstall -G dba,asmdba,oper oracle   #3.为 grid及 oracle用户设置密码 echo "grid" | passwd --stdin grid echo "oracle" | passwd --stdin oracle   #配置Linux内核参数   cat <<EOF >> /etc/sysctl.conf   fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 90793041264 kernel.shmmni = 4096 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 = 1048576 EOF   #为 oracle 用户设置 shell limits.   cat <<EOF >>/etc/security/limits.conf   oracle              soft    nproc   2047 oracle              hard    nproc   16384 oracle              soft    nofile  2047 oracle              hard    nofile  65536 oracle              soft    stack   10240   grid              soft    nproc   2047 grid              hard    nproc   16384 grid              soft    nofile  2047 grid              hard    nofile  65536 grid              soft    stack   10240 EOF   #修改/etc/pam.d/login,如果不存在以下行，请加入   cat <<EOF >> /etc/pam.d/login   session    required     pam_limits.so EOF sysctl -p   #对默认 shell startup file 做变更，加入如下行到/etc/profie   cat <<EOF >> /etc/profile   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 EOF   source /etc/profile   #.创建 Oracle Inventory Directory    mkdir -p /u01/oraInventory chown -R grid:oinstall /u01/oraInventory chmod -R 775 /u01/oraInventory   #创建 Oracle Grid Infrastructure home 目录   mkdir -p /u01/grid/11.2 chown -R grid:oinstall /u01/grid chmod -R 775 /u01/grid   #创建 grid Base  目录 mkdir -p /u01/grid_base chown -R grid:oinstall /u01/grid_base chmod -R 775 /u01/grid_base   #创建 Oracle Base  目录   mkdir -p /u01/oracle chown -R oracle:oinstall /u01/oracle chmod -R 775 /u01/oracle/ mkdir -p /u01/oracle/cfgtoollogs chown -R oracle:oinstall /u01/oracle/cfgtoollogs chmod -R 775 /u01/oracle/cfgtoollogs      #创建 Oracle RDBMS home 目录   mkdir -p  /u01/oracle/product/11.2.4/db_1 chown -R oracle:oinstall  /u01/oracle/product/11.2.4/db_1 chmod -R 775  /u01/oracle/product/11.2.4/db_1

3、asm、grid、oracle安装

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671

1、执行oracle-csh.txt   上面执行了 2、安装依赖包 yum -y install binutils compat-libcap1 compat-libstdc* gcc gcc-c++* glibc glibc-devel ksh libgcc libstdc libaio libaio-devel make elfutils-libelf-devel sysstat   3、配置主机名称和hosts 配置ssh 互通 hostnamectl set-hostname lsrkzyk1 hostnamectl set-hostname lsrkzyk2   cat <<EOF >> /etc/hosts   #pub 80.128.0.202     lsrkzyk1  80.128.0.203     lsrkzyk2  #pri 192.168.1.10        lsrkzyk1p 192.168.1.11        lsrkzyk2p #vip 80.128.0.205     lsrkzyk1v 80.128.0.206     lsrkzyk2v   #scan 80.128.0.207      msrkscan   EOF   su - grid ssh-keygen ssh-copy-id grid@80.128.0.202 ssh-copy-id grid@80.128.0.203   ssh grid@80.128.0.202 date ssh grid@80.128.0.203 date   ssh grid@lsrkzyk1 date ssh grid@lsrkzyk2 date   ssh grid@lsrkzyk1p date ssh grid@lsrkzyk2p date   su - oracle ssh-keygen ssh-copy-id oracle@80.128.0.202 ssh-copy-id oracle@80.128.0.203   ssh oracle@80.128.0.202 date ssh oracle@80.128.0.203 date   ssh oracle@lsrkzyk1 date ssh oracle@lsrkzyk2 date   ssh oracle@lsrkzyk1p date ssh oracle@lsrkzyk2p date     5、配置grid 环境变量 和 oracle 环境变量 su - grid vi .bash_profile   ORACLE_SID=+ASM1; export ORACLE_SID ORACLE_BASE=/u01/grid_base; export ORACLE_BASE ORACLE_HOME=/u01/grid/11.2; export ORACLE_HOME GRID_HOME=/u01/grid/11.2; export GRID_HOME THREADS_FLAG=native; export THREADS_FLAG PATH=$ORACLE_HOME/bin:$PATH; export PATH export LANG=en_us.UTF-8     su - oracle vi .bash_profile   ORACLE_BASE=/u01/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.4/db_1; export ORACLE_HOME ORACLE_SID=lsrkzyk1; export ORACLE_SID export ORACLE_UNQNAME=msrkzyk TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss" LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH export LANG=en_us.UTF-8     当rac2节点配置完毕以后，修改oracle 、grid用户下的环境变量:   [root@node2 network-scripts]# vi /home/oracle/.bash_profile   将ORACLE_SID=snrk1 改为ORACLE_SID=snrk2   [root@node2 network-scripts]# vi /home/grid/.bash_profile   将ORACLE_SID=+ASM1 改为ORACLE_SID=+ASM2   统统设置完成后，建议重启一下第2 个节点。       ---------asmlib方法一   6、安置oracle ASMlib  配置 ASM 磁盘   wget http://10.64.39.210/asmlib/asmlib.repo -P /etc/yum.repos.d/ yum clean all yum install -y oracleasm-support oracleasmlib oracleasm     7、对共享磁盘进行分区 parted /dev/sdc mklabel gpt mkpart primary 20G  520G mkpart primary 520G  1020G mkpart primary 1020G  1520G mkpart primary 1520G  2020G mkpart primary 2020G  2520G mkpart primary 2520G  3020G mkpart primary 3020G  3520G mkpart primary 3520G  4020G mkpart primary 4020G  4520G mkpart primary 4520G  5020G mkpart primary 5020G  5520G mkpart primary 5520G  6020G mkpart primary 6020G  6520G mkpart primary 6520G  7020G mkpart primary 7020G  7520G mkpart primary 7520G  8020G mkpart primary 8020G  8520G mkpart primary 8520G  9020G mkpart primary 9020G  9520G mkpart primary 9520G  10020G mkpart primary 10020G  10520G mkpart primary 10520G  11020G mkpart primary 11020G  11950G p quit   8、root 用户配置 ASMLib 先重启一下 /etc/init.d/oracleasm configure grid asmdba y y   9、设置共享磁盘 节点1   /usr/sbin/oracleasm createdisk OCR_VOTE /dev/sdb1 /usr/sbin/oracleasm createdisk ASMDATA /dev/sdb2 /usr/sbin/oracleasm createdisk BACKUP /dev/sdb3   节点2（rac2）上以root用户登录，使用scandisks命令扫描已经创建的ASM磁盘 也就是说，我们只需要在节点 1 上创建 ASM 磁盘，其他节点不需要。     /etc/init.d/oracleasm scandisks   Scanning the system for Oracle ASMLib disks:               [  OK  ]   /etc/init.d/oracleasm listdisks   ASMDATA BACKUP OCR_VOTE   ASM磁盘组配置完成。   systemctl status oracleasm systemctl restart oracleasm systemctl daemon-reload   -------------------------------------------- for i in {1..19}; do echo "ACTION==\"add\", KERNEL==\"sdc$i\", RUN+=\"/bin/raw /dev/raw/raw$i %N\"";done vi /etc/udev/rules.d/60-raw.rules ACTION=="add", KERNEL=="sdn1", RUN+="/bin/raw /dev/raw/raw1 %N" ACTION=="add", KERNEL=="sdn2", RUN+="/bin/raw /dev/raw/raw2 %N" ACTION=="add", KERNEL=="sdn3", RUN+="/bin/raw /dev/raw/raw3 %N" ACTION=="add", KERNEL=="sdn4", RUN+="/bin/raw /dev/raw/raw4 %N" ACTION=="add", KERNEL=="sdn5", RUN+="/bin/raw /dev/raw/raw5 %N" ACTION=="add", KERNEL=="sdn6", RUN+="/bin/raw /dev/raw/raw6 %N" ACTION=="add", KERNEL=="sdn7", RUN+="/bin/raw /dev/raw/raw7 %N" ACTION=="add", KERNEL=="sdn8", RUN+="/bin/raw /dev/raw/raw8 %N" ACTION=="add", KERNEL=="sdn9", RUN+="/bin/raw /dev/raw/raw9 %N" ACTION=="add", KERNEL=="sdn10", RUN+="/bin/raw /dev/raw/raw10 %N" ACTION=="add", KERNEL=="sdn11", RUN+="/bin/raw /dev/raw/raw11 %N" ACTION=="add", KERNEL=="sdn12", RUN+="/bin/raw /dev/raw/raw12 %N" ACTION=="add", KERNEL=="sdn13", RUN+="/bin/raw /dev/raw/raw13 %N" ACTION=="add", KERNEL=="sdn14", RUN+="/bin/raw /dev/raw/raw14 %N" ACTION=="add", KERNEL=="sdn15", RUN+="/bin/raw /dev/raw/raw15 %N" ACTION=="add", KERNEL=="sdn16", RUN+="/bin/raw /dev/raw/raw16 %N" ACTION=="add", KERNEL=="sdn17", RUN+="/bin/raw /dev/raw/raw17 %N" ACTION=="add", KERNEL=="sdn18", RUN+="/bin/raw /dev/raw/raw18 %N" ACTION=="add", KERNEL=="sdn19", RUN+="/bin/raw /dev/raw/raw19 %N" ACTION=="add", KERNEL=="sdn20", RUN+="/bin/raw /dev/raw/raw20 %N" ACTION=="add", KERNEL=="sdn21", RUN+="/bin/raw /dev/raw/raw21 %N" ACTION=="add", KERNEL=="sdn22", RUN+="/bin/raw /dev/raw/raw22 %N" ACTION=="add", KERNEL=="sdn23", RUN+="/bin/raw /dev/raw/raw23 %N" ACTION=="add", KERNEL=="sdn24", RUN+="/bin/raw /dev/raw/raw24 %N" ACTION=="add", KERNEL=="sdn25", RUN+="/bin/raw /dev/raw/raw25 %N" ACTION=="add", KERNEL=="raw[1-9]",OWNER="oracle",GROUP="oinstall",MODE="660" ACTION=="add", KERNEL=="raw1[0-9]",OWNER="oracle",GROUP="oinstall",MODE="660" ACTION=="add", KERNEL=="raw2[0-5]",OWNER="oracle",GROUP="oinstall",MODE="660"   60-raw.rules udevadm trigger --action=add; ll /dev/raw ---------------udev方式2 --注意单个磁盘不能大于2T --uedv for i in {c1,c2,c3,c4,c5}    do echo "KERNEL==\"sd$i\", SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i\", RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd${i:0:1}`\", SYMLINK+=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""         done;   vi /etc/udev/rules.d/60-raw.rules   KERNEL=="sdc1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sdc1", RESULT=="36000c2901e60ce42abd27813d3d273b1", SYMLINK+="asm-diskc1", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sdc2", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sdc2", RESULT=="36000c2901e60ce42abd27813d3d273b1", SYMLINK+="asm-diskc2", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sdc3", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sdc3", RESULT=="36000c2901e60ce42abd27813d3d273b1", SYMLINK+="asm-diskc3", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sdc4", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sdc4", RESULT=="36000c2901e60ce42abd27813d3d273b1", SYMLINK+="asm-diskc4", OWNER="grid", GROUP="asmadmin", MODE="0660" KERNEL=="sdc5", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sdc5", RESULT=="36000c2901e60ce42abd27813d3d273b1", SYMLINK+="asm-diskc5", OWNER="grid", GROUP="asmadmin", MODE="0660" systemctl restart systemd-udevd --配置到/etc/rc.local中 chown -R grid:asmadmin /dev/asm-diskc1 chown -R grid:asmadmin /dev/asm-diskc2 chown -R grid:asmadmin /dev/asm-diskc3 chown -R grid:asmadmin /dev/asm-diskc4 chown -R grid:asmadmin /dev/asm-diskc5   ls /dev/asm* -------------   rpm -qa|grep oracleasm rpm -ivh kmod-oracleasm-2.0.8-22.el7.x86_64.rpm --nodeps --force rpm -ivh kmod-oracleasm-2.0.8-16.1.el6_10.x86_64.rpm --nodeps --force cd /usr/lib/modules     10、下载gird和oracle包 mkdir -p /home/grid/soft mkdir -p /home/oracle/soft   wget -P /home/grid/soft http://10.64.39.210/download/p13390677_112040_Linux-x86-64_3of7.zip   wget -P /home/oracle/soft http://10.64.39.210/download/p13390677_112040_Linux-x86-64_1of7.zip   wget -P /home/oracle/soft http://10.64.39.210/download/p13390677_112040_Linux-x86-64_2of7.zip     chown -R grid:oinstall /home/grid/soft chown -R oracle:oinstall /home/oracle/soft   11、安装cvu包   rac1和rac2节点上以 root 用户身份安装操作系统程序包cvuqdisk-1.0.9-1.rpm，此包位于grid安装包下rpm目录下。   rpm -ivh http://10.64.39.210/download/cvuqdisk-1.0.9-1.rpm yum install -y http://10.64.39.210/download/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm rpm -ivh --force --nodeps http://10.64.39.210/download/pdksh-5.2.14-30.x86_64.rpm   12、rac1和rac2使用CUV验证硬件和操作系统配置   进入解压完毕的grid安装包目录下，执行   su - grid   cd grid   /home/grid/soft/grid/runcluvfy.sh stage -post hwos -n lsrkzyk1,lsrkzyk2 -verbose     lsrkzyk1和lsrkzyk2执行集群预检查     /home/grid/soft/grid/runcluvfy.sh stage -pre crsinst -n lsrkzyk1,lsrkzyk2 -verbose   全部为pass即通过，个别的如 dns  没通过（failed）可以忽略。             ---------------------------- 远程桌面 yum -y install tigervnc-server   cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:1.service --------------------------- [Unit] Description=Remote desktop service (VNC) After=syslog.target network.target   [Service] Type=forking User=root # Clean any existing files in /tmp/.X11-unix environment ExecStartPre=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :' ExecStart=/usr/sbin/runuser -l root -c "/usr/bin/vncserver %i" PIDFile=/root/.vnc/%H%i.pid ExecStop=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'   [Install] WantedBy=multi-user.target ------------------------------ root用户vncpasswd systemctl start vncserver@:1.service ---------------------------------------------- --安装界面不弹出界面 root下执行 echo $DISPLAY xhost + su - grid export DISPLAY=(root的$DISPLAY)   ------------------------------------- --安装grid oracle（界面不规范） 1、./runInstaller -jreLoc /etc/alternatives/jre_1.8.0   2、设置电脑的分辨率和配置电源永不断开 mkdir -p /u01/oraInventory chown grid:oinstall /u01/oraInventory/   3、执行root的时候ohas失败可以直接配置服务（开始是失败的，执行root后就启动成功了） ———————————————————————————————— cat <<EOF>/usr/lib/systemd/system/ohas.service [Unit] Description=Oracle High Availability services After=syslog.target   [Service] ExecStart=/etc/init.d/init.ohasd run >/dev/null 2>&1 Type=simple Restart=always   [Install] WantedBy=multi-user.target   EOF   systemctl daemon-reload systemctl start ohas.service systemctl enable ohas.service    —————————————————————————————— grid 用户通过如下命令查看grid进程   crs_stat -v -t crs_start –all 启动grid crs_stop -all 停止grid   srvctl start      数据库 查看 数据库软件是否安置成功命令 /u01/oracle/product/11.2.4/db_1/OPatch/opatch lsinv ----------------------------------------------------------------- 查看ocr文件 数据文件 控制文件 redo文件     grid用户用asmcmd进入命令窗口   asmcmd ------------- 修改字符编码 数据库查看  select userenv('language') from dual; select userenv('language') from dual; alter system set cluster_database=false scope=spfile; shutdown immediate; startup mount;   alter system enable restricted session; alter system set job_queue_processes=0; alter system set aq_tm_processes=0; alter database open; alter database CHARACTER set INTERNAL_USE AL32UTF8; alter system set cluster_database=false scope=spfile; shutdown immediate startup alter database CHARACTER set INTERNAL_USE ZHS16GBK; ---------------------------------------------------- --查看acfs文件系统信息 select name,path from v$asm_disk; select name,total_mb from v$asm_diskgroup; select * from v$asm_volume; select * from v$asm_acfsvolumes;   --------------------------------- 1、替换opatch 工具 wget http://10.64.39.210/download/p6880880_112000_Linux-x86-64.zip unzip p6880880_112000_Linux-x86-64.zip   mv /u01/oracle/product/11.2.4/db_1/OPatch /u01/oracle/product/11.2.4/db_1/OPatchbak mv /u01/grid/OPatch /u01/grid/OPatchbak cp -r  OPatch /u01/oracle/product/11.2.4/db_1/OPatch cp -r  OPatch /u01/grid/OPatch   chown -R oracle:oinstall /u01/oracle/product/11.2.4/db_1/OPatch chown -R grid:oinstall /u01/grid/OPatch      2、打grid补丁 wget http://10.64.39.210/download/p25078431_11204160419forACFS_Linux-x86-64.zip unzip p25078431_11204160419forACFS_Linux-x86-64.zip -d /tmp chown grid: /u01/grid su - grid   /u01/grid/OPatch/opatch apply  /tmp/25078431   ---------------------------------------------------------------------------------- 3、打oracle补丁 wget http://10.64.39.210/download/p27338049_112040_Linux-x86-64.zip unzip p27338049_112040_Linux-x86-64.zip -d /tmp su - oracle   /u01/oracle/product/11.2.4/db_1/OPatch/opatch apply /tmp/27338049   4、查看补丁 [grid@myrknew1:/oracle/grid/11g/OPatch]$ /u01/grid/OPatch/opatch lsinv   ---------------------------------------------------------------------------------------   --安装acfs ---acfs安装 （asm clusert file system） --查看是否支持该系统 都是root 用户执行   cd /u01/grid/install/usm tree -L 3 Oracle Novell   /u01/grid/bin/acfsdriverstate supported    find / -name osds_acfslib.pm cp /u01/grid/lib/osds_acfslib.pm /u01/grid/lib/osds_acfslib.pm.bak vi /u01/grid/lib/osds_acfslib.pm vi /u01/oracle/product/11.2.4/db_1/lib/osds_acfslib.pm      if ((defined($release)) &&                     # Redhat or OEL if defined       (($release =~ /^redhat-release/) ||        # straight RH        ($release =~ /^enterprise-release/) ||    # Oracle Enterprise Linux         ($release =~ /^centos-release/) ||        # CentOS hack  --添加        ($release =~ /^oraclelinux-release/)))    # Oracle Linux   1、安装acfs find / -name acfsroot /u01/grid/bin/acfsroot install 2、启动acfs find / -name acfsload /u01/grid/bin/acfsload start -s   ------------------------------------------------------------------------------ --换取内核 yum -y install http://10.64.39.210/centos7/Packages/kernel-3.10.0-514.el7.x86_64.rpm rpm -qa|grep kernel   grub2-editenv list   cat /boot/grub2/grub.cfg |grep menuentry grub2-set-default   —————————————————————————— su - grid -c 'crs_stat -v -t' grid 启动数据库 srvctl start database -d lsrkzyk  srvctl stop database -d dzrkzyk  srvctl start database -d dzrkzyk crsctl status resource ora.lsrkzyk.db -f   srvctl start instance -d lsrkzyk -i lsrkzyk1   su - grid -c 'crs_stat -v -t' su - grid -c 'srvctl start database -d lsrkzyk'   su - grid -c 'crsctl status res -t'   su - grid -c 'srvctl start instance -d msrkzyk -i lsrkzyk2'    crsctl stat res -t -init crsctl check crs root启动crs su - root cd $ORACLE_HOME/bin ./crsctl start crs   ---------------- --实例启动提示 ora-01078:failure in processing system parameters ora-01565:error in identifying file '\+DATA/RACDB/spfileDB.ora' ora-17503:ksfdopn:2 failed to open file +DATA/RACDB/spfileDB.ora ora-12547:TNS:lost contact   --或者client连接报ora-12537:TNS:connection closed   1、检查两节点oracle、grid用户组 是否有asmdba dba oinstall 2、赋予oracle.grid 权限 chmod 6755  $ORACLE_HOME/bin/oracle --chmod 6755 /u01/grid/bin/oracle    -------------------------------- --最后配置   cat <<EOF>> /etc/rc.local   /u01/grid/bin/acfsload start -s   chown -R grid:asmadmin /dev/asm-diskc1 chown -R grid:asmadmin /dev/asm-diskc2 chown -R grid:asmadmin /dev/asm-diskc3 chown -R grid:asmadmin /dev/asm-diskc4 chown -R grid:asmadmin /dev/asm-diskc5 sleep 20 mount.acfs -o all   EOF   chmod 755 /etc/rc.d/rc.local   srvctl status listener   -----------------------------   chown oracle:asmadmin /dev/asm/ogg-416 chown oracle:asmadmin /dev/asm/pic-416   ll /data_pic   _____________________________ --修改sga alter system set sga_target=20000M scope=spfile sid='*'; alter system set sga_max_size=20000M scope=spfile sid='*';   show parameter sga;   alter system set workarea_size_policy=auto scope=both sid='*'; alter system set pga_aggregate_target=10000M scope=both sid='*'; show parameter pga;   shutdown immediate; startup   show parameter sort;   alter session set sort_area_size=104857600;   srvctl stop database -d msrkzyk  srvctl start database -d msrkzyk   select count(*) from v$process; select value from v$parameter where name ='processes'; --修改连接数 alter system set session_cached_cursors=1000 scope=spfile sid='*'; alter system set session_max_open_files=1000 scope=spfile sid='*'; alter system set sessions=1105 scope=spfile  sid='*'; alter system set license_max_sessions=1000 scope=spfile sid='*'; alter system set license_sessions_warning=1000 scope=spfile sid='*'; alter system set processes=1000 scope=spfile sid='*';     select value from v$parameter where name ='processes';   --------------------- --orqcle用户过期处理 （方法一） --查看数据库密码过期时间   sqlplus / as sysdba   select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; alter profile default limit password_life_time unlimited; 修改前已经过期了的需要再次修改密码。 alter user  user_name identified by user_passwd;   __________________________________ --解决密码过期（sys用户） （方法二） 1、创建一个profile（相当于创建一个角色） create profile  passwd_unlimit limit  PASSWORD_LIFE_TIME unlimited; ALTER profile  passwd_unlimit limit COMPOSITE_LIMIT          UNLIMITED; ALTER profile  passwd_unlimit limit SESSIONS_PER_USER        UNLIMITED; ALTER profile  passwd_unlimit limit CPU_PER_SESSION          UNLIMITED; ALTER profile  passwd_unlimit  limit CPU_PER_CALL             UNLIMITED; ALTER profile  passwd_unlimit  limit LOGICAL_READS_PER_SESSION UNLIMITED; ALTER profile  passwd_unlimit  limit LOGICAL_READS_PER_CALL   UNLIMITED; ALTER profile  passwd_unlimit limit IDLE_TIME                UNLIMITED; ALTER profile  passwd_unlimit limit CONNECT_TIME             UNLIMITED; ALTER profile  passwd_unlimit  limit PRIVATE_SGA              UNLIMITED; ALTER profile  passwd_unlimit limit FAILED_LOGIN_ATTEMPTS    10      ; ALTER profile  passwd_unlimit limit PASSWORD_REUSE_TIME      UNLIMITED; ALTER profile  passwd_unlimit limit PASSWORD_REUSE_MAX       UNLIMITED; ALTER profile  passwd_unlimit  limit PASSWORD_VERIFY_FUNCTION NULL    ; ALTER profile  passwd_unlimit  limit PASSWORD_LOCK_TIME       1       ; ALTER profile  passwd_unlimit  limit PASSWORD_GRACE_TIME      7       ;   2、用户改成这个角色 alter user  SCRK5109_QRY  profile   passwd_unlimit; 3、查看用户角色 SELECT  *  FROM  dba_profiles； select  *  from  dba_users; select  username, user_id, account_status, expiry_date, profile  from  dba_users;   ---后期修改数据库时区-（先改系统时区） select dbtimezone,systimestamp from dual; +08:00 29-JUL-19 09.40.03.769147 AM +08:00   select sysdate from dual;   alter database set time_zone='+8:00'; --grid 用户 srvctl stop database -d msrkzyk  srvctl start database -d msrkzyk     --aix ntp startsrc -s xntpd stopsrc -s xntpd   lssrc -ls xntpd xntpdc -c peers   --------------------------------------------------------------------- acfs 更换挂载点 root 下 1、取消两个节点的挂载 umount /挂载目录 2、取消acfs文件的注册 acfsutil registry -d /u01 3、删除acfs系统 acfsutil rmfs /dev/asm/asm_pic 4、查看asm volume 信息 su - grid asmcmd  volinfo -G ACF -a 5、禁用asm volume   voldisable -G ACFS ACFS  -- 前一个是disgroup name 后一个acfs是volume name volinfo  -G ACFS -a 6、删除asm volume voldelete -G ACFS ACFS volinfo  -G ACFS -a     ------------------------------------------------------------- 定时调动执行不起 SQL> alter system set job_queue_processes=1000;   System altered.   SQL> show parameter queue_processes   --------------------------------------------- rman 修改备份文件路径并备份 alter system set events '10298 trace name context forever,level 32'; configure channel 1 device type disk format '/data/%d_db_%u.dmp'; configure channel 2 device type disk format '/data/%d_db_%u.dmp'; backup database plus archivelog delete input;     create script full_backup { allocate channel c1 device type disk format '/data/%d_db1_%u.dmp'; allocate channel c2 device type disk format '/data/%d_db2_%u.dmp'; backup database; release channel c1; release channel c1; }   run { allocate channel c1 device type disk format '/data/%d_db1_%u.dmp'; allocate channel c2 device type disk format '/data/%d_db2_%u.dmp'; backup database; release channel c1; release channel c1; }