ASM
936 dzdo su - root
937 dzdo -l
938 ps -ef | grep -i d\.bin - To check CRS services
939 ps -ef | grep -i ASM - To check ASM service
940 ps -ef | grep -i dbw0 - To check DB sercicse
949 crsctl status crs
950 crsctl check crs
976 dzdo -l
977 sudo -l
978 . oraenv
979 sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
[]-->sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@amxdobi01:/home/is_sup/oracle]
[]-->
980 sudo crsctl check crs
981 which crsctl
982 who -b
983 ps -ef | grep -i d\.bin
984 cd /dev/mapper
985 ls -lrt obi*
986 pwd
987 id
988 sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
989 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
990 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
991 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl stop crs -f
992 pwd
993 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
994 pw
995 cd /dev/mapper
996 ls -lrt
997 ls -l | grep -i vote
998 pwd
999 ps -ef | grep -i dbw0
1000 who -b
1001 ps -ef | grep pmon
1002 history
[oracle@amxdobi01:/home/is_sup/oracle]
[]-->
936 dzdo su - root
937 dzdo -l
938 ps -ef | grep -i d\.bin - To check CRS services
939 ps -ef | grep -i ASM - To check ASM service
940 ps -ef | grep -i dbw0 - To check DB sercicse
949 crsctl status crs
950 crsctl check crs
976 dzdo -l
977 sudo -l
978 . oraenv
979 sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
[]-->sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@amxdobi01:/home/is_sup/oracle]
[]-->
980 sudo crsctl check crs
981 which crsctl
982 who -b
983 ps -ef | grep -i d\.bin
984 cd /dev/mapper
985 ls -lrt obi*
986 pwd
987 id
988 sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
989 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
990 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
991 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl stop crs -f
992 pwd
993 date; sudo /u01/oracle/11.2.0/grid/bin/crsctl check crs
994 pw
995 cd /dev/mapper
996 ls -lrt
997 ls -l | grep -i vote
998 pwd
999 ps -ef | grep -i dbw0
1000 who -b
1001 ps -ef | grep pmon
1002 history
[oracle@amxdobi01:/home/is_sup/oracle]
[]-->
import sql_file == file ane metadata only
worker process and all
asm backgroudd porcess
ps -ef | grep -i ASM
gmon ,rebalance ,lck etc
asm we required grid
%u is for parallel
Index and bitmap inde and tuyps
[]-->ps -ef | grep -i d\.bin
oracle 659 8390 0 08:53 pts/3 00:00:00 grep -i d.bin
root 17067 1 0 05:31 ? 00:00:09 /u01/oracle/11.2.0/grid/bin/ohasd.bin reboot
oracle 20336 1 0 05:32 ? 00:00:19 /u01/oracle/11.2.0/grid/bin/oraagent.bin
oracle 20363 1 0 05:32 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/mdnsd.bin
oracle 20457 1 0 05:32 ? 00:00:04 /u01/oracle/11.2.0/grid/bin/gpnpd.bin
root 20493 1 0 05:32 ? 00:00:26 /u01/oracle/11.2.0/grid/bin/orarootagent.bin
oracle 20496 1 0 05:32 ? 00:00:11 /u01/oracle/11.2.0/grid/bin/gipcd.bin
root 20508 1 0 05:32 ? 00:00:23 /u01/oracle/11.2.0/grid/bin/osysmond.bin
root 20894 1 0 05:32 ? 00:00:18 /u01/oracle/11.2.0/grid/bin/ologgerd -M -d /u01/oracle/11.2.0/grid/crf/db/amxdobi01
root 24317 1 0 05:42 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/cssdmonitor
root 24342 1 0 05:42 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/cssdagent
oracle 24353 1 0 05:42 ? 00:00:20 /u01/oracle/11.2.0/grid/bin/ocssd.bin
root 25544 1 0 05:46 ? 00:00:01 /u01/oracle/11.2.0/grid/bin/octssd.bin reboot
root 25569 1 0 05:46 ? 00:00:08 /u01/oracle/11.2.0/grid/bin/crsd.bin reboot
oracle 25572 1 0 05:46 ? 00:00:02 /u01/oracle/11.2.0/grid/bin/evmd.bin
oracle 25650 25572 0 05:46 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/evmlogger.bin -o /u01/oracle/11.2.0/grid/evm/log/evmlogger.info -l /u01/oracle/11.2.0/grid/evm/log/evmlogger.log
root 25688 1 0 05:46 ? 00:01:02 /u01/oracle/11.2.0/grid/bin/orarootagent.bin
oracle 26059 1 0 05:46 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/scriptagent.bin
oracle 26142 1 0 05:46 ? 00:00:55 /u01/oracle/11.2.0/grid/bin/oraagent.bin
oracle 26190 1 0 05:46 ? 00:00:01 /u01/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 26220 1 0 05:46 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
oracle 26233 1 0 05:46 ? 00:00:00 /u01/oracle/11.2.0/grid/bin/tnslsnr LISTENER -inherit
[]-->ps -ef | grep -i ASM
oracle 754 8390 0 08:53 pts/3 00:00:00 grep -i asm
oracle 18292 1 0 06:47 ? 00:00:00 oracle+ASM1_o000_obid11 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 19697 1 0 06:50 ? 00:00:00 oracle+ASM1_o000_obit11 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26347 1 0 05:47 ? 00:00:00 asm_pmon_+ASM1
oracle 26349 1 0 05:47 ? 00:00:00 asm_psp0_+ASM1
oracle 26356 1 0 05:47 ? 00:00:00 asm_vktm_+ASM1
oracle 26360 1 0 05:47 ? 00:00:00 asm_gen0_+ASM1
oracle 26362 1 0 05:47 ? 00:00:00 asm_diag_+ASM1
oracle 26364 1 0 05:47 ? 00:00:00 asm_ping_+ASM1
oracle 26366 1 0 05:47 ? 00:00:22 asm_dia0_+ASM1
oracle 26368 1 0 05:47 ? 00:00:00 asm_lmon_+ASM1
oracle 26370 1 0 05:47 ? 00:00:03 asm_lmd0_+ASM1
oracle 26372 1 0 05:47 ? 00:00:00 asm_lms0_+ASM1
oracle 26376 1 0 05:47 ? 00:00:00 asm_lmhb_+ASM1
oracle 26378 1 0 05:47 ? 00:00:00 asm_mman_+ASM1
oracle 26380 1 0 05:47 ? 00:00:00 asm_dbw0_+ASM1
oracle 26382 1 0 05:47 ? 00:00:00 asm_lgwr_+ASM1
oracle 26384 1 0 05:47 ? 00:00:00 asm_ckpt_+ASM1
oracle 26386 1 0 05:47 ? 00:00:00 asm_smon_+ASM1
oracle 26388 1 0 05:47 ? 00:00:05 asm_rbal_+ASM1
oracle 26390 1 0 05:47 ? 00:00:01 asm_gmon_+ASM1
oracle 26392 1 0 05:47 ? 00:00:00 asm_mmon_+ASM1
oracle 26394 1 0 05:47 ? 00:00:00 asm_mmnl_+ASM1
oracle 26399 1 0 05:47 ? 00:00:00 asm_lck0_+ASM1
oracle 26535 1 0 05:47 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26539 1 0 05:47 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26567 1 0 05:47 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26626 1 0 05:47 ? 00:00:00 asm_asmb_+ASM1
oracle 26628 1 0 05:47 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26744 1 0 05:47 ? 00:00:00 ora_asmb_OBIT11
oracle 26750 1 0 05:47 ? 00:00:00 oracle+ASM1_asmb_obit11 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26894 1 0 05:47 ? 00:00:00 ora_asmb_OBID11
oracle 26904 1 0 05:47 ? 00:00:00 oracle+ASM1_asmb_obid11 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 32128 1 0 08:50 ? 00:00:00 asm_fd00_+ASM1
[oracle@amxdobi01:/dev/mapper]
[]-->
295 which oracleasm
296 oracleasm listdisks
570 sqlplus "/ as sysdba" << EOF
alter system set remote_listener='';
alter system register;
alter system set remote_listener='obid-scan:1521' scope=both;
alter system register;
srvctl config database -d OBID1
srvctl config database -d OBID1
584 srvctl status service -d OBID1
585 srvctl add service -d OBID1 -s BATCH_SERVICE -r OBID11 -a OBID12 -P BASIC -y AUTOMATIC -j SHORT -B THROUGHPUT -e SELECT -m BASIC -z 5 -w 30
586 srvctl START service -d OBID1 -s BATCH_SERVICE
587 srvctl status service -d OBID1
srvctl relocate service -d OBID1 -s OBID1_BATCH -i OBID12 -t OBID11 -f
757 crsctl status res > ~oracle/crsctl.txt.20180126
No comments:
Post a Comment