Ameer Khan

Step by step guide to convert physical standby database into snapshot standby database (READ WRITE mode) What is Standby snapshot Database?Oracle provides an unique feature where the physical standby database can be opened in READ WRITE mode to perform update able transactions.A snapshot standby database is a fully updatable standby database that is created by… Continue Reading

Microsoft SQL Server 2012 Enterprise Edition Service pack 1 64 bit download link with no cd key required:- Continue Reading

Creating a physical standby database on Oracle 11.2.0.1.0 using RMAN :- OS Version:-Red Hat Enterprise Linux Server release 6.4Oracle version:- Oracle Database 12c Enterprise Edition Release 11.2.0.1.0 64bitPrimary database:- prim   Standby database:- stand System Configuration primary server:- edit the following files vi /etc/hosts 192.168.2.102   server1.soumya.com      server1192.168.2.104   server2.soumya.com      server2 :wq vi /etc/sysconfig/networkHOSTNAME=server1.soumya.com :wq vi /etc/sysconfig/network-scripts/ifcfg-eth0 NETMASK=255.255.255.0IPADDR=192.168.2.102GATEWAY=192.168.2.1 :wq… Continue Reading

How to find out Total Oracle Database size:- An oracle database consists of data files, redo log files, control files & temporary files.The size of the database actually means the total size of all these files.The below query show the total size of an oracle database. SQL>select( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +( select… Continue Reading

Mysql single database backup:- mysqldump –force –opt –single-transaction –lock-tables=false –skip-events –user=root –password=xxxx –routines –databases testdb > singledb.sql Mysql all database backup:- mysqldump –force –opt –single-transaction –lock-tables=false –skip-events –user=root –password=xxxx –routines –all-databases > all_databases.sql Mysql Restore database: mysql -u root -predhat dbname < /mnt/dbname.sql Continue Reading

Migraing SQL Users from one SQL Server To Another SQL Server Instance============================================================= Here i am Migrating User “soumya” from one SQL Server to Another SQL Server. On Source Database: — Logged in as sa/system User— Expand Databases— Expand System Databases— Right click on master database— New Query.— Paste the below lines & Click Execute. USE… Continue Reading

Prerequisites:============= Step: 1. Install Java : # yum -y install java-1.7.0-openjdk# export JAVA_HOME=/usr/lib/jvm/jre-1.7.0-openjdk.x86_64# java -version Step: 2. Download & Unzip Amazon EC2 CLI Tools : # yum -y install wget zip unzip# cd /tmp# wget http://s3.amazonaws.com/ec2-downloads/ec2-api-tools.zip# unzip ec2-api-tools.zip Step: 3. Install the Amazon EC2 CLI Tools : # mkdir /usr/local/ec2# mv ec2-api-tools-1.7.5.0 /usr/local/ec2/apitools/ Step: 4.… Continue Reading

Master server:-192.168.100.122Hostname:-server2.soumya.com Slave server:-192.168.100.175Hostname:-server1.soumya.com Postgresql Version:9.4-1Linux version:Rhel 6.3 Install postgresql in both server:-Step 1:-Download the repositoryyum install http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-1.noarch.rpm # vi /etc/yum.repos.d/centos.repoadd the following lines[centos-6-base]name=CentOS-$releasever – Basemirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=osbaseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/enabled=1 step 2:- Install Postgresql required packages:-# yum install postgresql94-server postgresql94-contribIncase if the above command gives error regarding the public key, we can use the following commandcd /etc/pki/rpm-gpgrpm –import RPM-GPG-KEY-CentOS-6… Continue Reading

Install Cassandra (Standalone) on CentOS 6x ================================================== Step: 1. Install JAVA : # cd /tmp# wget –no-check-certificate –no-cookies –header ‘Cookie: oraclelicense=accept-securebackup-cookie’ http://download.oracle.com/otn-pub/java/jdk/8u5-b13/jdk-8u5-linux-x64.rpm# yum -y install jdk-8u5-linux-x64.rpm# export JAVA_HOME=/usr/java/jdk1.8.0_05# export PATH=$PATH:$JAVA_HOME# echo $JAVA_HOME# vi /etc/profile.d/java.sh #!/bin/bashJAVA_HOME=/usr/java/jdk1.8.0_05PATH=$JAVA_HOME/bin:$PATHexport PATH JAVA_HOMEexport CLASSPATH=. — Save & Quit (:wq) chmod +x /etc/profile.d/java.shsource /etc/profile.d/java.shStep: 2. Install the Java Native Access (JNA) :… Continue Reading

Percona XtraDB Cluster configuration on CentOS 6.4 Host 1: 192.168.72.22Host 2: 192.168.72.23Linux version : Centos 6.4Percona version : 5.5 Prerequisites:- All the nodes must have a CentOS 6.4 installation.Firewall Must be disabled or atleast 3306 port must be open.SELinux must be disabled.Check if Mysql is already installed in the server also check if its running.Remove… Continue Reading