Author: debasis maity

  1. Home
  2. Author: debasis maity
January 7, 2018

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 root on Linux systems, run the cp command:- # cp -prf root@rac1:/u01/app/product/12.1.0/grid/* root@rac2:/u01/app/product/12.1.0/grid 2. Delete unnecessary files from the copy.The Oracle Grid Infrastructure home contains files that are relevant only to the source node, so you can remove the unnecessary […]

Read More
January 5, 2018

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 which is very popular because of shared storage simulation feature. Below is overall requirement in nut-shell. We need 3 servers for now.I will install RAC on First 2 servers and 3rd server will act as DNS server.My desktop RAM is […]

Read More
December 22, 2017

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 12c that greatly simplifies the process of database migration. Combining the ease of use of Oracle Data Pump with the performance of transportable tablespaces, full transportable export/import gives you the ability to upgrade or migrate to Oracle Database 12c in […]

Read More
December 21, 2017

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 files or syslog. To configure Oracle Database to log events using syslog: Configure SYSLOG 1. Execute the following commands: mkdir -p /var/log/oracledb/ touch /var/log/oracledb/oracledb.log 2. Add the following line to /etc/rsyslog.conf: local1.info /var/log/oracledb/oracledb.log 3.Configuring Logging on Network Elements Note: The […]

Read More
December 21, 2017

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 trunc(BEGIN_INTERVAL_TIME) ) ss, v$tablespace ts, dba_tablespaces dt where su.snap_id = ss.snap_id and su.tablespace_id = ts.ts# and ts.name =upper(‘USERS’) and ts.name = dt.tablespace_name ) select e.run_time,e.name,e.alloc_size_gb,e.used_size_gb curr_used_size_gb, b.used_size_gb prev_used_size_gb, case when e.used_size_gb > b.used_size_gb then to_char(e.used_size_gb – b.used_size_gb) when e.used_size_gb = […]

Read More
December 21, 2017

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 datafiles ( from x$ktfbue as we don’t need all joins from dba_extents ) select /*+ materialize */ ktfbuesegtsn ts#,ktfbuefno relative_fno,max(ktfbuebno+ktfbueblks-1) hwm_blocks from sys.x$ktfbue group by ktfbuefno,ktfbuesegtsn ), hwmts as ( — join ts# with tablespace_name select name tablespace_name,relative_fno,hwm_blocks from hwm […]

Read More
December 20, 2017

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 installing the plug-in: Enterprise Manager Cloud Control 13c Bundle Patch 1 (13.2.0.0.0) and later Oracle GoldenGate 12c (12.3.0.1.0) and later Oracle GoldenGate Plug-in for EMCC Release 13c http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Download, install and configure Oracle GoldenGate Monitor Agent 12.2.1.2.0 http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html – Oracle GoldenGate […]

Read More
December 17, 2017

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 . Author:-Saibal Ghosh https://www.linkedin.com/in/saibal-ghosh-ccsk-prince2-%C2%AE-469b0a7/ 1 Tasks Before Upgrade 1.1 Backup the Database: Before we start the upgrade, it is a best practice to backup the database, Oracle Cluster Registry (OCR) and Oracle database home and Grid home . 1.2  LINUX X86-64 […]

Read More
December 11, 2017

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 * ERROR at line 1: ORA-00283: recovery session canceled due to errors ORA-01111: name for data file 61 is unknown – rename to correct file ORA-01110: data file 61: ‘/u01/app/oracle/product/12.1.0/db_1/dbs/UNNAMED00061’ ORA-01157: cannot identify/lock data file 61 – see DBWR trace […]

Read More

Debasis Maity

Translate

Ad

Please connect me in linkedin

Top Posts & Pages

Follow Us