Ameer Khan

RMAN throwing error no AUTOBACKUP found of controlfile Error:- RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece Reason:-Basically we get to see above error comes generally in two cases.1. Either the controlfile autobackup is not present in os level2. Or if the controlfiles are not present in Flash recovery… Continue Reading

Step 1:- If mysql is already running stop it. [root@server1 ~]# service mysql stopShutting down MySQL..[  OK  ] Step 2:- Add the following lines in my.cnf file and start mysql. [root@server1 ~]# vi /etc/my.cnf[client]default-character-set=utf8 [mysql]default-character-set=utf8 [mysqld]collation-server = utf8_unicode_ciinit-connect=’SET NAMES utf8′character-set-server = utf8 –save & exit (:wq) [root@server1 ~]# service mysql start mysql> show variables like… Continue Reading

ORA-01466: unable to read data – table definition has changed 01466, 00000, “unable to read data – table definition has changed”// *Cause: Query parsed after tbl (or index) change, and executed//         w/old snapshot// *Action: commit (or rollback) transaction, and re-execute While selecing a table for a specific point of time i faced the error. 15:23:07… Continue Reading

Installation Procedure for a SQL Server 2012 Instance:- Physical setup specifications for Microsoft SQL Server (theoretical): Disk Partitions: C:\ drive of 40GB, E:\ drive for 30GB for SQL Server Data and Application Files (root used, not program files) Prerequisites if asked for Dot Net Framework core role is enabled or Service Pack 1, click OK… Continue Reading

Step by step oracle 12c Binaries installation and Database creation in Silent mode.Requirements :- *) For large-scale installation we need to use multicore processors with High availability.*) Recommended minimum RAM needed for Oracle is 2GB or more.*) Swap must be enabled double the size of RAM.*)Disk space must be more than 8GB, its depends on… Continue Reading

OS Version: Rhel 6.4PostgreSQL Version:- 9.4 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 #yum install postgresql94-server # service postgresql-9.4 initdbor# service… Continue Reading

Installation of Oracle Database 11g Release 2 Software installs all the licensable database options. Though installed, not all the licensable database options are enabled by default.During installation, installer gives an option for users to enable the licensable database options that are not enabled in a default installation. SQL> SET LINESIZE 200SQL> select * from v$option… Continue Reading

Requirements :- *) For large-scale installation we need to use multicore processors with High availability.*) Recommended minimum RAM needed for Oracle is 2GB or more.*) Swap must be enabled double the size of RAM.*)Disk space must be more than 8GB, its depends on edition which are we going to choose for installing.*)/tmp directory must have… Continue Reading

Scenario:- I had a requirement where i needed to recover a table at a specific time on primary database.So i did TSPITR on primary database and then recreated the standby database.Flashback Database was  not enabled in my database hence i had to recreate the standby database. Here are the steps i followed. Oracle version : 11.2.0.1.0… Continue Reading

1. Query to Find ByteSize of All the Tables in SQL Server :- SELECT CASE WHEN (GROUPING(sob.name)=1) THEN ‘All_Tables’ELSE ISNULL(sob.name, ‘unknown’) END AS Table_name,SUM(sys.length) AS Byte_LengthFROM sysobjects sob, syscolumns sysWHERE sob.xtype=’u’ AND sys.id=sob.idGROUP BY sob.nameWITH CUBE 2.Query to find out all database size along with full details:- Ans. Sp_helpdb — execute this is master database.… Continue Reading