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

原文地址:https://www.cnblogs.com/102x/p/14327446.html