The syntax to start and stop the listener is as follows:
--------------------------------------------------------
srvctl start listener -n nodename
srvctl stop listener -n nodename
Create a disk group with SQL:
----------------------------
CREATE DISKGROUP ACFS NORMAL REDUNDANCY
FAILGROUP ACFS2
DISK 'ORCL:DATA7' SIZE 1953 M ,'ORCL:DATA8' SIZE
2329 M
FAILGROUP ACFS1
DISK 'ORCL:DATA5' SIZE 1953 M ,'ORCL:DATA6' SIZE
1953 M
ATTRIBUTE 'compatible.rdbms' = '11.2.0.0.0',
'compatible.asm' = '11.2.0.0.0',
'compatible.advm' = '11.2.0.0.0' ;
Controlling Oracle Clusterware -
------------------------------
crsctl start crs
crsctl stop crs
crsctl enable crs
crsctl disable crs
To determine the overall health on a specific node:
crsctl check crs
To check the viability of CSS across nodes :
crsctl check cluster
To determine the location of the Voting disk:
crsctl query css votedisk
To determine the location of the OCR:
cat /etc/oracle/ocr.loc
Checking the integrity of Oracle Clusterware Configuration Files:
grep voting <grid_home>/log/<hostname>/cssd/ocssd.log
or
cluvfy comp ocr -n all -verbose
or
ocrcheck
To add or remove Voting disks (11gR2) for NON-ASM storage -
crsctl delete css votedisk path_to_voting_disk
crsctl add css votedisk path_to_voting_disk
To add Voting disk to ASM -
crsctl replace votedisk +asm_disk_group
To migrate voting disks from non-ASM storage devices to ASM or vice versa, specify the ASM disk group name or path
to the non-ASM storage device:
crsctl replace votedisk {+asm_disk_group |path_to_voting_disk}
Locating OCR Manual Backups -
ocrconfig -showbackup auto
Default target location for each automatically generated OCR backup file -
<Grid_home>/cdata/<Cluster_name>
Changing the automatic OCR backup location (Best Practice is to store in shared location)-
ocrconfig -backuploc <New_path_name>
Add an OCR location to either ASM or other storage device:
ocrconfig -add +DATA2
ocrconfig -add /dev/sde1
To replace the current OCR location:
ocrconfig -replace /dev/sde1 -replacement +DATA2
To repair OCR configuration, run this command on the node on which you have stopped Oracle Clusterware:
You cannot perform this operation on a node on which Oracle Clusterware is running.
ocrconfig -repair -add +DATA1
Removing the OCR Location (Do not perform any OCR removal unless there is atleast one other active OCR location
online-
ocrconfig -delete +DATA2
ocrconfig -delete /dev/sde1
Performing Manual OCR backups-
ocrconfig -manualbackup
ocrconfig -showbackup manual
To perform Logical backup -
ocrconfig -export /home/oracle/ocr.backup
To determine the list of interfaces available to the cluster -
oifcfg iflist –p -n
To determine the public and private interfaces that have configured -
oifcfg getif
To determine the VIP hostname, VIP address, VIP subnet mask, VIP interface names -
srvctl config nodeapps -a
--------------------------------------------------------
srvctl start listener -n nodename
srvctl stop listener -n nodename
Create a disk group with SQL:
----------------------------
CREATE DISKGROUP ACFS NORMAL REDUNDANCY
FAILGROUP ACFS2
DISK 'ORCL:DATA7' SIZE 1953 M ,'ORCL:DATA8' SIZE
2329 M
FAILGROUP ACFS1
DISK 'ORCL:DATA5' SIZE 1953 M ,'ORCL:DATA6' SIZE
1953 M
ATTRIBUTE 'compatible.rdbms' = '11.2.0.0.0',
'compatible.asm' = '11.2.0.0.0',
'compatible.advm' = '11.2.0.0.0' ;
Controlling Oracle Clusterware -
------------------------------
crsctl start crs
crsctl stop crs
crsctl enable crs
crsctl disable crs
To determine the overall health on a specific node:
crsctl check crs
To check the viability of CSS across nodes :
crsctl check cluster
To determine the location of the Voting disk:
crsctl query css votedisk
To determine the location of the OCR:
cat /etc/oracle/ocr.loc
Checking the integrity of Oracle Clusterware Configuration Files:
grep voting <grid_home>/log/<hostname>/cssd/ocssd.log
or
cluvfy comp ocr -n all -verbose
or
ocrcheck
To add or remove Voting disks (11gR2) for NON-ASM storage -
crsctl delete css votedisk path_to_voting_disk
crsctl add css votedisk path_to_voting_disk
To add Voting disk to ASM -
crsctl replace votedisk +asm_disk_group
To migrate voting disks from non-ASM storage devices to ASM or vice versa, specify the ASM disk group name or path
to the non-ASM storage device:
crsctl replace votedisk {+asm_disk_group |path_to_voting_disk}
Locating OCR Manual Backups -
ocrconfig -showbackup auto
Default target location for each automatically generated OCR backup file -
<Grid_home>/cdata/<Cluster_name>
Changing the automatic OCR backup location (Best Practice is to store in shared location)-
ocrconfig -backuploc <New_path_name>
Add an OCR location to either ASM or other storage device:
ocrconfig -add +DATA2
ocrconfig -add /dev/sde1
To replace the current OCR location:
ocrconfig -replace /dev/sde1 -replacement +DATA2
To repair OCR configuration, run this command on the node on which you have stopped Oracle Clusterware:
You cannot perform this operation on a node on which Oracle Clusterware is running.
ocrconfig -repair -add +DATA1
Removing the OCR Location (Do not perform any OCR removal unless there is atleast one other active OCR location
online-
ocrconfig -delete +DATA2
ocrconfig -delete /dev/sde1
Performing Manual OCR backups-
ocrconfig -manualbackup
ocrconfig -showbackup manual
To perform Logical backup -
ocrconfig -export /home/oracle/ocr.backup
To determine the list of interfaces available to the cluster -
oifcfg iflist –p -n
To determine the public and private interfaces that have configured -
oifcfg getif
To determine the VIP hostname, VIP address, VIP subnet mask, VIP interface names -
srvctl config nodeapps -a
No comments:
Post a Comment