Differences

This shows you the differences between two versions of the page.

--- oracle [2020/07/27 12:47]
ss_wiki_admin
+++ oracle [2021/04/23 07:54] (current)
ss_wiki_admin [ASM]
@@ Line 549: / Line 549: @@
 ==== Auditing Control ====
+== Get size of Audit Table ==
+<code sql>
+select segment_name table_name ,bytes/1024/1024 size_in_megabytes from dba_segments where segment_name in ('AUD$');
+</code>
+== Show count of audited actions ==
+<code sql>
+select username,OWNER,OBJ_NAME,ACTION,ACTION_NAME,count(*) from dba_audit_trail group by username,OWNER,OBJ_NAME,ACTION,ACTION_NAME;
+</code>
 ==Show audited options==
 <code sql>
@@ Line 697: / Line 707: @@
 select slave_name, sessions, idle_time_cur, cpu_secs_total
   from v$pq_slave order by slave_name;
-<code>
+</code>
 == Show global parallelism details ==
@@ Line 745: / Line 755: @@
 SQL>
 select * from gv$asm_operation;
+</code>
+== Show rebalance operation estimates ==
+<code sql>
+select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
 </code>
@@ Line 765: / Line 780: @@
 == Add disk to diskgroups ==
 <code sql>
-SQL> alter diskgroup dbfs_dg add disk 'o/192.168.3.143/DBFS_DG_CD_04_m1cel03man' name DBFS_DG_CD_04_m1CEL03MAN force rebalance nowait
+SQL> alter diskgroup dbfs_dg add disk 'o/192.168.3.143/DBFS_DG_CD_04_m1cel03man' name DBFS_DG_CD_04_M1CEL03MAN force rebalance nowait
-SQL> alter diskgroup reco_m1 add disk 'o/192.168.3.143/RECO_M1_CD_04_m1cel03man' name RECO_HEM1_CD_04_M1CEL03MAN
+SQL> alter diskgroup reco_m1 add disk 'o/192.168.3.143/RECO_M1_CD_04_m1cel03man' name RECO_M1_CD_04_M1CEL03MAN
 </code>
@@ Line 786: / Line 801: @@
 == Drop old disk ==
 <code sql>
-alter diskgroup DATA_HEM1 drop disk '_DROPPED_0074_DATA_HEM1';
+alter diskgroup DATA_M1 drop disk '_DROPPED_0074_DATA_M1';
 </code>
@@ Line 797: / Line 812: @@
 == Moving multiple files inside ASM ==
 <code bash>
-for i in $(asmcmd ls +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2); do
+for i in $(asmcmd ls +RECOC1/DB/ARCHIVELOG/RESTORE2); do
-   asmcmd cp +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2/$i +DATAC1/TMPARCH/RESTORE2;
+   asmcmd cp +RECOC1/DB/ARCHIVELOG/RESTORE2/$i +DATAC1/TMPARCH/RESTORE2;
-   asmcmd rm +RECOC1/EIWODSD/ARCHIVELOG/RESTORE2/$i;
+   asmcmd rm +RECOC1/DB/ARCHIVELOG/RESTORE2/$i;
 done
 </code>
@@ Line 992: / Line 1007: @@
 </code>
-====Check Software version and Patch level of Clusterware====
+====Clusterware Version/Patch Level====
-CRSCTL is used to manages the clusterware resources. You can also check the software version and patch level of your grid home with CRSCTL utility. CRSCTL utility present in $GRID_HOME\bin directory.
+crsctl resides in //$GRID_HOME\bin// directory.
-==CHECK ACTIVE VERSION OF CLUSTERWARE==
+==Active Version of Clusterware==
-crsctl query crs activeversion command to display the active version and the configured patch level of the Oracle Clusterware software running in the cluster. During a rolling upgrade the active version is not changed until the upgrade is finished across the cluster.
+Display the active version and the configured patch level of the Oracle Clusterware software running in the cluster.
-CRSCTL QUERY CRS ACTIVEVERSION
+<code bash>
-Output:
+$ crsctl query crs activeversion
 Oracle Clusterware active version on the cluster is [12.1.0.0.2]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [456789126].
+</code>
-==CHECK PATCH LEVEL OF CLUSTERWARE==
+==Patch Level of Clusterware==
-crsctl query crs releasepatch command to display the patch level which is updated in the Grid home patch repository while patching a node.
+Display the patch level in the Grid home patch repository.
 The patch level corresponds to only the local node in which the command is executed.
-CRSCTL QUERY CRS RELEASEPATCH
+<code bash>
-Output:
+$ crsctl query crs releasepatch
 Oracle Clusterware release patch level is [3180840333] and the complete list of patches is [13559647] on the local node.
+</code>
-==CHECK VERSION OF THE ORACLE CLUSTERWARE SOFTWARE==
+==Oracle Clusterware Software Version==
-crsctl query crs releaseversion command to display the version of the Oracle Clusterware software stored in the binaries on the local node.
+Display the version of the Oracle Clusterware software installed
+<code bash>
+$ crsctl query crs releaseversion
-CRSCTL QUERY CRS RELEASEVERSION
-Output:
 Oracle High Availablity Services release version on the local node is [12.2.0.1.0]
+</code>
-==CHECK PATCH LEVEL OF ORACLE CLUSTERWARE FOR SPECIFIC NODE==
+==Check Patch Level of Clusterware on Specific Node==
-crsctl query crs softwarepatch command to display the configured patch level of the installed Oracle Clusterware.
+Display the configured patch level of the installed Oracle Clusterware.
-CRSCTL QUERY CRS SOFTWAREPATCH [NODE_NAME]
+<code bash>
-Output:
+$ crsctl query crs softwarepatch <node_name>
 Oracle Clusterware patch level on node [node1] is [456789126]
+</code>
-==CHECK LATEST VERSION OF THE SOFTWARE RUNNING SUCCESSFULLY ON SPECIFIC NODE==
+==Latest Running Version of Clusterware==
-crsctl query crs softwareversion command to display latest version of the software that has been successfully started on the specified node.
+Display latest version of the software that has been successfully started on the specified node.
-CRSCTL QUERY CRS SOFTWAREVERSION [NODE_NAME]
+<code bash>
-Output:
+$ crsctl query crs softwareversion <node_name>
 Oracle Clusterware version on node [node1] is [12.2.0.1.0]
+</code>
+==Verify a Patch is Installed==
+<code bash>
+$ <gihome>/grid/OPatch/opatch lsinventory -bugs_fixed | grep ^27463879
+</code>

Shaun's Wiki

User Tools

Site Tools

Differences

Page Tools