RAC one node to another node clone if another rac crash due to file deletion or permission change in grid home
1. On the source node to target node, create a copy of the Oracle Grid Infrastructure home. For example, as […]
Technology
Installation, oracle 12c
Installation of Oracle 12c RAC Flex cluster infrastructure on Virtual Box
Introduction This document will help to guide you for installation of Oracle 12cR1 RAC Flex cluster infrastructure on Virtual Box
oracle 12c
EXPDP and IMPDP command reference 12c
A.Very useful method to upgrade 11gR2 to 12c using transportable=always Full transportable export/import is a new feature in Oracle Database
security
Oracle Database Audit FGA using SYSLOG to capture
Oracle Database Audit using SYSLOG to capture Oracle Database can be configured to log events into a database table, XML
SCRIPTS
Script for checking tablespace growth
with t as ( select ss.run_time,ts.name,round(su.tablespace_size*dt.block_size/1024/1024/1024,2) alloc_size_gb, round(su.tablespace_usedsize*dt.block_size/1024/1024/1024,2) used_size_gb from dba_hist_tbspc_space_usage su, (select trunc(BEGIN_INTERVAL_TIME) run_time,max(snap_id) snap_id from dba_hist_snapshot group by
SCRIPTS
Script to clean or truncate unified audit record table
exec dbms_audit_mgmt.clean_audit_trail(audit_trail_type=>dbms_audit_mgmt.audit_trail_unified, use_last_arch_timestamp=>FALSE);
SCRIPTS
script to get query for reclaim space from auto extensible datafile
set linesize 1000 pagesize 0 feedback off trimspool on with hwm as ( — get highest block id from each
Technology
Implementing the Golden Gate plug-in monitor for Oracle Cloud Control 13cR2(13.2.0.0.0)
This note describes the procedure of implementing the GoldenGate plug-in for Oracle Cloud Control 13cR2. These versions are required for
oracle 12c
Upgrade of Oracle 11g RAC database to Oracle 12c RAC DBUA
This document will help you providing guideline to upgrade Oracle 11g RAC to Oracle 12c RAC clusterware and Database .
Dataguard, Troubleshooting
ORA-01111: name for data file is unknown – rename to correct file
Error in dataguard alert log/start managed recovery process:- SYS@XXX>alter database recover managed standby database; alter database recover managed standby database