November 2016 – Page 3

Puppet Enterprise 2016.x : Start & Stop scripts

STOP Puppet Services. $ more puppet_stop.sh #!/usr/bin/shpuppet resource service puppet ensure=stopped puppet resource service pe-puppetserver ensure=stopped puppet resource service pe-activemq ensure=stopped puppet resource service mcollective ensure=stopped puppet resource service pe-puppetdb ensure=stopped puppet resource service pe-postgresql ensure=stopped puppet resource service pe-console-services ensure=stopped puppet resource service pe-nginx… Read More

Transparent Data Encryption Setup Steps

8 years ago by Pawana PaulSQL Server - Production Support

Transparent Data Encryption Setup Steps Below are the bullet points in setting up and usage of TDE 1. Take Full Backup of Master and User/Application Database (User database part of Encryption). 2. Create Folder to hold Certificate and Key 3. Create Master Key 4. Create… Read More

Database files details – SQL Server

8 years ago by Pawana PaulSQL Server - Production Support

Database files details – SQL Server This script will help to identify the Database files Size in MB, Space Used, Available Space, % used. If there is space crunch on Database Drive and this query will help to release space if the %used is very… Read More

Oracle : Change AWR Retention

8 years ago by Vinod SiramOracle DB Admin

Check existing retention and current snapshot interval. set linesize 300 select extract( day from snap_interval) *24*60+extract( hour from snap_interval) *60+extract( minute from snap_interval ) snapshot_interval, extract( day from retention) *24*60+extract( hour from retention) *60+extract( minute from retention ) retention_interval, topnsql from dba_hist_wr_control; Below query is… Read More

Oracle Delete Set of rows in a table

8 years ago by Vinod SiramOracle Adhoc SQL Scripts

DECLAREcount1 NUMBER := 0;total NUMBER := 0;CURSOR del_record_cur ISSELECT rowid FROM scott.emp WHERE empno<=20000;BEGINFOR rec IN del_record_cur LOOPDELETE FROM scott.emp WHERE rowid = rec.rowid;total := total + 1;count1 := count1 + 1;IF (count1 >= 1000) THEN COMMIT;count1 := 0;END IF;END LOOP;COMMIT;DBMS_OUTPUT.PUT_LINE(‘Deleted ‘ || total ||… Read More

Oracle – How to Gather Stats for Table where stats of that table is locked.

8 years ago by Vinod SiramOracle DB Admin

Check Stats of Table : –example : ‘DEPT’,’EMP’,’SALGRADE’ set linesize 300 set pagesize 100 col owner for a15 col LAST_ANALYZED for a30 col table_name for a40 select OWNER,TABLE_NAME , NUM_ROWS , BLOCKS , EMPTY_BLOCKS , CHAIN_CNT, AVG_ROW_LEN CACHE, to_char(LAST_ANALYZED,’DD-MON-YYYY HH24:MI:SS’) LAST_ANALYZED from dba_tables where table_name… Read More

To Compare Parameters on all nodes in RAC Environment

8 years ago by LAYADHAR.DUPPATI11gR2 RAC

Dear Readers, In this article we will see To Compare Parameters on all nodes in RAC Environment. col name for a20 trunc col value for a40 trunc set pagesize 140 select name,value,inst_id from gv$parameter where inst_id in (1,2) order by 1,3; Herewith the sample output… Read More

ASM Disk Group Performance Summary

8 years ago by LAYADHAR.DUPPATIORACLE ASM

SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(sys_context(‘USERENV’, ‘INSTANCE_NAME’), 17) current_instance FROM dual; SET TERMOUT ON; SET ECHO OFF SET FEEDBACK 6 SET HEADING ON SET LINESIZE 256 SET PAGESIZE 50000 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON… Read More

Oracle Database Restore archivelogs from Sequence to Sequence Based on the Dates we give.

8 years ago by LAYADHAR.DUPPATIOracle DB Admin

select ‘restore archivelog from logseq ‘|| min(sequence#) || ‘ until logseq ‘ || max(sequence#) || ‘ thread ‘ || thread# || ‘;’ from gv$archived_log where completion_time between to_date(‘&start_date’,’DD-MON-YY HH24:MI:SS’) AND to_date(‘&end_date’,’DD-MON-YY HH24:MI:SS’) group by thread#; Input Required: Enter value for start_date: 02-OCT-16 Enter… Read More

Oracle Metadata information

8 years ago by Vinod SiramOracle DB Admin

Table Metadata Definition : set pagesize 0 set long 90000 select dbms_metadata.get_ddl(‘TABLE’,’&TABLE_NAME’,’&OWNER’) FROM DUAL; Procedure Metadata Definition : set pagesize 0 set long 90000 select dbms_metadata.get_ddl(‘PROCEDURE’,’&PROCEDURE_NAME’,’&OWNER’) FROM DUAL; Tablespace Metadata Definition : set pagesize 0 set long 90000 select dbms_metadata.get_ddl(‘TABLESPACE’,’&TABLESPACE_NAME’) FROM DUAL; Index Metadata Definition… Read More