Sometimes the standard installation is not sufficient for the extension package you want to install. The reason for this is that the extension has …
Read More »How To List Files and Sizes within an ASM Disk Group
We can see asm files in Oracle ASM disk group without asmcmd. You can run the following query to view files and sizes in …
Read More »How To Connect SQL Server via SSMS(SQL Server Managemet Studio) With Different Domain Account
In some cases, you may need to connect to the sql server via SSMS with a different domain account(for windows authentication). You connect to …
Read More »Poor Performance Status on Exadata Cellnode Flash Disks
The status of the Exadata cellnode flash disks may occasionally be poor performance. If the error numbers are 0 (zero) or too low when …
Read More »Policy-Based Management(Special Character Control in Database Names-Database Facet)
Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …
Read More »ORA-01618: redo thread 2 is not enabled – cannot mount
When opening the database, if there is a redolog group that is not enabled for the corresponding thread, it gives an error as ORA-01618. …
Read More »Cannot open backup device ”. Operating system error 3(The system cannot find the path specified.)
You have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …
Read More »How To Transfer a Database in the File System To ASM
This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two …
Read More »How To Restore Encrypted Backup To Another Instance On SQL Server
First you should restore your certificate to this instance. You can restore your certificate with the help of following script. You must write the …
Read More »Encrypted Backup On SQL Server
You can encrypt your backups with SQL Server’s own encryption method in order to avoid the risk of unauthorized access to the backup. You …
Read More »