I explained how to change the disks of a normal database in the article “How To Change The Disk Of Database Files On SQL …
Read More »dbtut
AWR baseline drop operation
The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots. Therefore, it is necessary …
Read More »SQL Server Startup Parameters
With SQL Server Startup Parameters, the location of certain files in the startup phase of the SQL Server service, and some conditions in the …
Read More »DAC(Dedicated Administrator Connection) On SQL Server
Sometimes SQL Server becomes inaccessible and DBA cannot even intervene. In such cases, there is a back door so that DBAs can find and …
Read More »Querying Oracle alert.log Errors With SQL Query
You can query errors in Alert.log by sql query. You can use the following queries for this. The following query returns with 20 rows. …
Read More »SQL Server Configuration Manager Settings
SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …
Read More »Reconfiguring Grid Infrastructure Components
If you have cloned an existing server as another server, even if ASM disks and all files are moved, then services like ohas css …
Read More »Exadata cell server ORA-700 ORA-600
For disk errors such as ORA-700 or ORA-600 on the cell server, first check whether there is a physical fault. If there is a …
Read More »SQL Server Service Account’s Permissions on Windows
Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is not necessary. You must not …
Read More »Cellcli Commands
In this article we have examined many of CellCLI commands. CellCLI — Cell Command Line Interpreter (Exadata) [crayon-676eab6950a10288963276/] Help Command: [crayon-676eab6950a14465401395/] Commands for obtaining …
Read More »