• Oracle RAC


    [grid@rac01 ~]$ crsctl check crs
    CRS-4638: Oracle High Availability Services is online
    CRS-4535: Cannot communicate with Cluster Ready Services
    CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
    CRS-4534: Cannot communicate with Event Manager
    [grid@rac01 ~]$ crsctl stat res -t -init
    --------------------------------------------------------------------------------
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.asm
    1 ONLINE OFFLINE Instance Shutdown
    ora.cluster_interconnect.haip
    1 ONLINE OFFLINE
    ora.crf
    1 ONLINE ONLINE rac01
    ora.crsd
    1 ONLINE OFFLINE
    ora.cssd
    1 ONLINE OFFLINE STARTING
    ora.cssdmonitor
    1 ONLINE ONLINE rac01
    ora.ctssd
    1 ONLINE OFFLINE
    ora.diskmon
    1 OFFLINE OFFLINE
    ora.drivers.acfs
    1 ONLINE OFFLINE
    ora.evmd
    1 ONLINE OFFLINE
    ora.gipcd
    1 ONLINE ONLINE rac01
    ora.gpnpd
    1 ONLINE ONLINE rac01
    ora.mdnsd
    1 ONLINE ONLINE rac01
    [grid@rac01 ~]$ ps -ef | grep crsd.bin
    grid 3968 3490 0 04:26 pts/0 00:00:00 grep crsd.bin

    [grid@rac01 ~]$ crsctl start res ora.crsd -init
    CRS-5702: Resource 'ora.crsd' is already running on 'rac01'
    CRS-4000: Command Start failed, or completed with errors.
    [grid@rac01 ~]$ crsctl stat res -t -init
    --------------------------------------------------------------------------------
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.asm
    1 ONLINE ONLINE rac01 Started
    ora.cluster_interconnect.haip
    1 ONLINE ONLINE rac01
    ora.crf
    1 ONLINE ONLINE rac01
    ora.crsd
    1 ONLINE ONLINE rac01
    ora.cssd
    1 ONLINE ONLINE rac01
    ora.cssdmonitor
    1 ONLINE ONLINE rac01
    ora.ctssd
    1 ONLINE ONLINE rac01 OBSERVER
    ora.diskmon
    1 OFFLINE OFFLINE
    ora.drivers.acfs
    1 ONLINE ONLINE rac01
    ora.evmd
    1 ONLINE ONLINE rac01
    ora.gipcd
    1 ONLINE ONLINE rac01
    ora.gpnpd
    1 ONLINE ONLINE rac01
    ora.mdnsd
    1 ONLINE ONLINE rac01
    [grid@rac01 ~]$ vi /u01/app/
    11.2.0/ grid/ oracle/ oraInventory/
    [grid@rac01 ~]$ vi /u01/app/11.2.0/grid/
    assistants/ crs/ deinstall/ gpnp/ jdbc/ md/ ologgerd/ oui/ relnotes/ suptools/
    auth/ csmig/ demo/ has/ jdk/ mdns/ OPatch/ owm/ root.sh sysman/
    bin/ css/ diagnostics/ hs/ jlib/ mesg/ opmn/ perl/ rootupgrade.sh tfa/
    cdata/ ctss/ eons/ install/ JRE/ network/ oracore/ plsql/ scheduler/ usm/
    cfgtoollogs/ cv/ evm/ instantclient/ ldap/ nls/ oraInst.loc precomp/ slax/ utl/
    clone/ dbs/ gipc/ inventory/ lib/ oc4j/ ord/ racg/ sqlplus/ wwg/
    crf/ dc_ocm/ gnsd/ javavm/ log/ ohasd/ osysmond/ rdbms/ srvm/ xdk/
    [grid@rac01 ~]$ vi /u01/app/11.2.0/grid/l
    ldap/ lib/ log/
    [grid@rac01 ~]$ vi /u01/app/11.2.0/grid/log/
    crs/ diag/ rac01/
    [grid@rac01 ~]$ vi /u01/app/11.2.0/grid/log/rac01/
    acfs/ acfsreplroot/ agent/ crflogd/ cssd/ diskmon/ gnsd/ ohasd/
    acfslog/ acfssec/ alertrac01.log crfmond/ ctssd/ evmd/ gpnpd/ racg/
    acfsrepl/ admin/ client/ crsd/ cvu/ gipcd/ mdnsd/ srvm/
    [grid@rac01 ~]$ vi /u01/app/11.2.0/grid/log/rac01/crsd/crsd.log 

    [oracle@rac01 ~]$ ps aux|grep ora

    root 2105 1.0 3.3 989012 64536 ? Sl 04:20 0:13 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/app/11.2.0/grid/tfa/rac01/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/rac01/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/rac01/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0/grid/tfa/rac01/tfa_home
    grid 3246 0.1 1.1 703312 22428 ? Ssl 04:20 0:01 /u01/app/11.2.0/grid/bin/oraagent.bin
    root 3282 0.1 1.1 686752 21652 ? Ssl 04:20 0:01 /u01/app/11.2.0/grid/bin/orarootagent.bin
    grid 4727 0.0 0.5 1339840 9668 ? Ss 04:31 0:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid 4750 0.0 0.7 1341868 13408 ? Ss 04:31 0:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid 4754 0.0 0.5 1339956 10232 ? Ss 04:31 0:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid 4851 0.3 2.0 692412 38236 ? Ssl 04:32 0:01 /u01/app/11.2.0/grid/bin/oraagent.bin
    root 4858 0.5 1.2 727568 24708 ? Ssl 04:32 0:02 /u01/app/11.2.0/grid/bin/orarootagent.bin
    grid 4951 0.0 0.4 1339772 9456 ? Ss 04:32 0:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid 4958 0.0 0.4 1339260 8932 ? Ss 04:32 0:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid 4965 0.0 0.4 1339260 8548 ? Ss 04:32 0:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid 5091 2.3 8.2 1310244 156368 ? Sl 04:32 0:11 /u01/app/11.2.0/grid/jdk/bin/java -server -Xcheck:jni -Xms128M -Xmx384M -Djava.awt.headless=true -Ddisable.checkForUpdate=true -Dstdstream.filesize=100 -Dstdstream.filenumber=10 -DTRACING.ENABLED=false -Doracle.wlm.dbwlmlogger.logging.level=INFO -Dport.rmi=23792 -jar /u01/app/11.2.0/grid/oc4j/j2ee/home/oc4j.jar -config /u01/app/11.2.0/grid/oc4j/j2ee/home/OC4J_DBWLM_config/server.xml -out /u01/app/11.2.0/grid/oc4j/j2ee/home/log/oc4j.out -err /u01/app/11.2.0/grid/oc4j/j2ee/home/log/oc4j.err
    oracle 5169 0.3 1.6 678088 31192 ? Ssl 04:32 0:01 /u01/app/11.2.0/grid/bin/oraagent.bin
    oracle 5267 0.0 1.1 1009908 21776 ? Ss 04:32 0:00 ora_pmon_orcl1
    oracle 5269 0.0 0.9 1007340 17452 ? Ss 04:32 0:00 ora_psp0_orcl1
    oracle 5279 1.1 0.8 1007340 17156 ? Ss 04:32 0:05 ora_vktm_orcl1
    oracle 5283 0.0 2.4 1013680 46032 ? Ss 04:32 0:00 ora_gen0_orcl1
    oracle 5285 0.0 1.2 1013508 24136 ? Ss 04:32 0:00 ora_diag_orcl1
    oracle 5287 0.0 1.5 1008908 29004 ? Ss 04:32 0:00 ora_dbrm_orcl1
    oracle 5289 0.0 0.9 1007340 17936 ? Ss 04:32 0:00 ora_ping_orcl1
    oracle 5291 0.0 0.9 1007340 17288 ? Ss 04:32 0:00 ora_acms_orcl1
    oracle 5296 0.2 1.5 1015556 30208 ? Ss 04:32 0:01 ora_dia0_orcl1
    oracle 5299 0.1 2.0 1019892 39640 ? Ss 04:32 0:00 ora_lmon_orcl1
    oracle 5302 0.3 2.2 1023644 42364 ? Ss 04:32 0:01 ora_lmd0_orcl1
    oracle 5304 0.8 7.0 1022444 135076 ? Ss 04:32 0:04 ora_lms0_orcl1
    oracle 5311 0.0 1.5 1008944 29796 ? Ss 04:32 0:00 ora_rms0_orcl1
    oracle 5316 0.0 0.9 1007940 18504 ? Ss 04:32 0:00 ora_lmhb_orcl1
    oracle 5318 0.0 5.0 1007340 96848 ? Ss 04:32 0:00 ora_mman_orcl1
    oracle 5320 0.0 2.2 1016768 42532 ? Ss 04:32 0:00 ora_dbw0_orcl1
    oracle 5326 0.0 1.3 1031044 25944 ? Ss 04:32 0:00 ora_lgwr_orcl1
    oracle 5328 0.0 1.3 1009536 25240 ? Ss 04:32 0:00 ora_ckpt_orcl1
    oracle 5330 0.0 4.6 1014056 88504 ? Ss 04:32 0:00 ora_smon_orcl1
    oracle 5332 0.0 1.4 1008888 26864 ? Ss 04:32 0:00 ora_reco_orcl1
    oracle 5334 0.0 1.0 1007940 19284 ? Ss 04:32 0:00 ora_rbal_orcl1
    oracle 5336 0.0 1.1 1009268 21068 ? Ss 04:32 0:00 ora_asmb_orcl1
    oracle 5338 0.1 3.9 1013896 74572 ? Ss 04:32 0:00 ora_mmon_orcl1
    grid 5340 0.0 0.5 1339956 10320 ? Ss 04:32 0:00 oracle+ASM1_asmb_orcl1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    oracle 5342 0.0 1.5 1010120 30040 ? Ss 04:32 0:00 ora_mmnl_orcl1
    oracle 5344 0.0 1.3 1015104 24952 ? Ss 04:32 0:00 ora_mark_orcl1
    oracle 5346 0.0 0.8 1013604 17024 ? Ss 04:32 0:00 ora_d000_orcl1
    oracle 5348 0.0 0.8 1008536 16100 ? Ss 04:32 0:00 ora_s000_orcl1
    oracle 5357 0.2 2.1 1009476 40672 ? Ss 04:32 0:01 ora_lck0_orcl1
    oracle 5359 0.0 1.1 1013356 22072 ? Ss 04:32 0:00 ora_rsmn_orcl1
    oracle 5417 0.0 0.9 1007340 17436 ? Ss 04:32 0:00 ora_gtx0_orcl1
    oracle 5419 0.0 1.2 1007920 23032 ? Ss 04:32 0:00 ora_rcbg_orcl1
    oracle 5425 0.0 1.0 1007340 19416 ? Ss 04:32 0:00 ora_qmnc_orcl1
    oracle 5428 0.0 2.0 1011184 39956 ? Ss 04:32 0:00 oracleorcl1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    oracle 5440 0.0 1.8 1011200 34956 ? Ss 04:32 0:00 oracleorcl1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    oracle 5479 0.1 2.6 1012004 50788 ? Ss 04:32 0:00 ora_cjq0_orcl1
    oracle 5503 0.0 1.9 1012944 37984 ? Ss 04:32 0:00 ora_q001_orcl1
    oracle 5630 0.0 0.9 1007336 18200 ? Ss 04:33 0:00 ora_q002_orcl1
    oracle 6191 0.0 0.9 1007340 17904 ? Ss 04:37 0:00 ora_smco_orcl1
    oracle 6193 0.0 1.2 1007884 23356 ? Ss 04:37 0:00 ora_w000_orcl1
    root 6264 0.0 0.1 163516 2744 pts/0 S 04:38 0:00 su - oracle
    oracle 6267 0.0 0.0 108340 1828 pts/0 S 04:38 0:00 -bash
    oracle 6575 1.0 0.0 110236 1136 pts/0 R+ 04:40 0:00 ps aux
    oracle 6576 0.0 0.0 103312 872 pts/0 S+ 04:40 0:00 grep ora
    [oracle@rac01 ~]$ export DISPLAY=192.168.58.1:0.0
    [oracle@rac01 ~]$ dbca
    [oracle@rac01 ~]$ export ORACLE_SID=orcl
    [oracle@rac01 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 25 04:43:21 2021

    Copyright (c) 1982, 2013, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> select instance_name,status from v$instance;
    select instance_name,status from v$instance
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0


    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
    SQL> exit
    Disconnected
    [oracle@rac01 ~]$ vi .bash_profile
    [oracle@rac01 ~]$ ll /u01/app/oracle/product/11.2.0/db_1/dbs/
    hc_orcl1.dat init.ora initorcl1.ora orapworcl1
    [oracle@rac01 ~]$ export ORACLE_SID=orcl1
    [oracle@rac01 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 25 04:46:44 2021

    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> select instance_name,status from v$instance;

    INSTANCE_NAME STATUS
    ---------------- ------------
    orcl1 OPEN

    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第一课
    Web前端试题
    E
    Kingdom of Black and White
    D. Let's Go Hiking
    2021牛客寒假 第一场
    Codeforces Round #691 (Div. 2)
    CF1461D
    CF1461B
    浙财16th校赛 F因子
  • 原文地址:https://www.cnblogs.com/102x/p/14327446.html
Copyright © 2020-2023  润新知