In SQL Server, sometimes you do not want anyone to see the contents of an important column in an important table. In such a …
Read More »Mysql Galera Cluster for High Availability Solution
Steps to Install & Configure MySQL 3-Node Galera Cluster on CENTOS Step 1: Enabling the Galera Cluster yum repositories. [crayon-662b20ad88344882277060/] Step 2: Install …
Read More »ORA-24247: network access denied by access control list (ACL)
Assume that the user receiving the error is SCOTT. In this case a checklist should be created for the SCOTT user. You can use …
Read More »Mysql Physical Backup Using Percona Xtrbackup Tool
Percona Xtrabackup is open source backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing …
Read More »How To Detach and Attach a Database Containing FileStream Data
You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …
Read More »Running SQL Server With High Performance(High Performance)
It is a setting made on windows so that SQL Server can work with higher performance. This setting can be made on Windows Server …
Read More »Enterprise Manager OC4J Configuration issue
ERROR : OC4J Configuration issue. <ORACLE_HOME> / oc4j / j2ee / OC4J_DBConsole_ <SERVER> _ <SID> not found. SOLUTION : The passwords of sysman and dbsnmp …
Read More »EMC flash drive as Temp database device
Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB …
Read More »ORA-01552: cannot use system rollback segment for non-system tablespace ‘XXXX’
The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …
Read More »What is Contained Database and How To Create
We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …
Read More »