Shaun's Wiki

User Tools

Site Tools

Trace:
oracle

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
oracle [2020/02/21 10:01]
ss_wiki_admin 		oracle [2021/04/23 07:54] (current)
ss_wiki_admin [ASM]
Line 549: Line 549:
  
 ==== Auditing Control ==== ==== 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== ==Show audited options==
 <code sql> <code sql>
Line 697: Line 707:
 select slave_name, sessions, idle_time_cur, cpu_secs_total select slave_name, sessions, idle_time_cur, cpu_secs_total
   from v$pq_slave order by slave_name;    from v$pq_slave order by slave_name; 
-<code>+</code>
  
 == Show global parallelism details == == Show global parallelism details ==
Line 745: Line 755:
 SQL> SQL>
 select * from gv$asm_operation; 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> </code>
  
Line 765: Line 780:
 == Add disk to diskgroups == == Add disk to diskgroups ==
 <code sql> <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> </code>
  
Line 786: Line 801:
 == Drop old disk == == Drop old disk ==
 <code sql> <code sql>
-alter diskgroup DATA_HEM1 drop disk '_DROPPED_0074_DATA_HEM1'; +alter diskgroup DATA_M1 drop disk '_DROPPED_0074_DATA_M1'; 
 </code> </code>
  
Line 797: Line 812:
 == Moving multiple files inside ASM == == Moving multiple files inside ASM ==
 <code bash> <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 done
 </code> </code>
Line 956: Line 971:
 <code sql> <code sql>
 /* Display current value */ /* Display current value */
-SQL> show parameter control_management_pack_access+show parameter control_management_pack_access
  
 NAME                                 TYPE        VALUE NAME                                 TYPE        VALUE
 ------------------------------------ ----------- ------------------------------ ------------------------------------ ----------- ------------------------------
 control_management_pack_access       string      DIAGNOSTIC+TUNING control_management_pack_access       string      DIAGNOSTIC+TUNING
-SQL> 
  
- +SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;
-SQL> SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;+
  
   COUNT(*)   COUNT(*)
Line 971: Line 984:
                  
 /* Disable feature */  /* Disable feature */ 
 +
 alter system set control_management_pack_access='NONE'; alter system set control_management_pack_access='NONE';
  
Line 991: Line 1005:
 <code sql> <code sql>
 show parameters STATISTICS_LEVEL; show parameters STATISTICS_LEVEL;
 +</code>
 +
 +====Clusterware Version/Patch Level====
 +
 +crsctl resides in //$GRID_HOME\bin// directory.
 +
 +==Active Version of Clusterware==
 +Display the active version and the configured patch level of the Oracle Clusterware software running in the cluster. 
 +
 +<code bash>
 +$ 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>
 +
 +==Patch Level of Clusterware==
 +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.
 +
 +<code bash>
 +$ crsctl query crs releasepatch
 +
 +Oracle Clusterware release patch level is [3180840333] and the complete list of patches is [13559647] on the local node.
 +</code>
 +
 +==Oracle Clusterware Software Version==
 +Display the version of the Oracle Clusterware software installed
 +
 +<code bash>
 +$ crsctl query crs releaseversion
 +
 +Oracle High Availablity Services release version on the local node is [12.2.0.1.0]
 +</code>
 +
 +==Check Patch Level of Clusterware on Specific Node==
 +Display the configured patch level of the installed Oracle Clusterware.
 +
 +<code bash>
 +$ crsctl query crs softwarepatch <node_name>
 +Oracle Clusterware patch level on node [node1] is [456789126]
 +</code>
 +
 +==Latest Running Version of Clusterware==
 +Display latest version of the software that has been successfully started on the specified node.
 +
 +<code bash>
 +$ 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> </code>
oracle.1582279302.txt.gz · Last modified: 2020/02/21 10:01 by ss_wiki_admin

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki