debasis maity

12+ years of rich experience on Database Administrations and on Infrastructure Solution Architect. AWS Certified Solution Architect and Senior Oracle DBA
158

debasis maity 's Posts

  MANAGING SECURITY Managing Profiles 1.Creating profile and Granting it to user CONN sys/password AS SYSDBA CREATE PROFILE my_profile LIMIT FAILED_LOGIN_ATTEMPTS 3  — Account locked after 3 failed logins. PASSWORD_LOCK_TIME 5     — Number of days account is locked for. UNLIMITED required explicit unlock by DBA. PASSWORD_LIFE_TIME 30    — Password expires… Continue Reading Oracle users,roles,audit and security

  Install mysql 5.7 in Ubuntu root@ubuntu:~# sudo apt-get install mysql-server Reading package lists… Done Building dependency tree Reading state information… Done The following additional packages will be installed:  libaio1 libhtml-template-perl mysql-client-5.7 mysql-client-core-5.7  mysql-common mysql-server-5.7 mysql-server-core-5.7 Suggested packages:  libipc-sharedcache-perl mailx tinyca The following NEW packages will be installed:  libaio1 libhtml-template-perl… Continue Reading MySQL Admin

First Add disk from datastore to the VM server node using following steps Login to vCenter console and Right Click Server -> Edit Settings. Click Add and add a New Disk Create a new virtual disk. Provide capacity and all related setting. Also specify the Datastore.   Select proper settings… Continue Reading How to add raw disk first in vmware host RHEL 7 from datastore and attach to ASM diskgroup using udev rules and asmca

ORACLE DATA GUARD FOR RAC 12C USING SEPERATE REPLICATION NETWORK Table of Contents Revision history   3 1       Environment   4 1.1         Hardware  4 1.2         Software  4 1.3         Networking  4 1.3.1      Primary Site  4 1.3.2      Disaster recovery Site  5 1.4         LISTENER_DG both for primary and standby  5 1.4.1      Listener Configuration Kolkata1  10… Continue Reading ORACLE DATA GUARD FOR RAC 12C USING SEPARATE REPLICATION NETWORK

Data loading:- create table t(c1 char(2000),c2 char(2000)); insert into t select ‘A’,’B’ from dual connect by rownum<1000000; commit; the data loading of 8 GB data took 160 sec . Now redo generation rate by 2 nodes RAC database as calculated by following example is:- SYS@EBILPD11> select thread#,sequence#,blocks*block_size/1024/1024 MB,(next_time-first_time)*86400 sec, blocks*block_size/1024/1024/((next_time-first_time)*86400)… Continue Reading Case Study on Network Bandwidth Calculation in 12c dataguard environment and testing with redo generation rate

This document describe the step to clone database in another host using RMAN from DR (Data gurad) .We need not to connect to source database.Moreover we will use different location for backup. A. Please follow below step for pre-requisites setup mentioned in below url 1.Copy the init parameter file from… Continue Reading RMAN clone from data guard DR to different host and different backup location

Introduction This document will help to guide you for installation of Oracle 12cR1 RAC grid infrastructure on Virtual Box which is very popular because of shared storage simulation feature. Below is overall requirement in nut-shell. Hostname:-rac1 Physical IP:-192.168.56.101 Private IP:-192.168.100.101 Virtual IP:- 192.168.56.103 Hostname:-rac2 Physical IP:-192.168.56.102 Private IP:-192.168.100.102 Virtual IP:-… Continue Reading Oracle Database 12c Release 1 (12.1) RAC GRID Infrastructure RHEL Redhat linux 7 VirtualBox

1 Background Often in many IT projects (involving Oracle as the primary RDBMS), we face an issue of bringing data from disparate systems. Now, the problem can be solved by implementing any ETL solution which has the required connectors/drivers to connect to different heterogeneous database systems and pull the required… Continue Reading Database Link Oracle to Heterogeneous Database Systems SAP HANA

1.Copy the init parameter file from source . 2.In target place this init file to $ORACLE_HOME/dbs 3.Change following parameter in init file to make it compatible to single instance. Replace original instance name to target name in pfile .For my case it should EBILTST as target. ##Remove following parameters## EBILDR12.__data_transfer_cache_size=0… Continue Reading RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name