Oracle Patches

-

Comments

Post a Comment

Popular posts from this blog

SQL Server on Nutanix - Best pratices

-
The following taken from : Microsoft SQL Server 2016 Nutanix Best Practices Drive configuration: For optimal performance several virtual disks should be used.   Nutanix suggest eight disks per SQL Server virtual machine spread across   4 SCSI controllers as laid out below:   Drive Controller Type Controller # OS LSI SAS 0 SQL Sever installation LSI SAS 0 Backup LSI SAS 0 SQL Datafiles 1 PVSCSI 1 SQL Datafiles 2 PVSCSI 1 TempDB Datafiles 1 PVSCSI 2 TempDB Datafiles 2 PVSCSI 2 TempDB Log Files PVSCSI 3 Database Log Files PVSCSI 3 Cluster size formatting of all drives as below: SQL Data and log files   - 64KB NTFS OS and SQL Server installation - 4KB NTFS - Server Team ?? ...
Read more

ORA-19698 File is from different database

-
I came across this error during point in time recovery of  500G database . Steps followed to resolve the issue  If the error "ORA-19698: %s is from different database" is seen during an Oracle disaster recovery operation, perform the following: 1. Bring the database to nomount state (Steps mentioned below): At a command prompt, type the following command: SQLplus / as SYSDBA shutdown immediate; startup nomount; 2. Empty the contents of the directory (under the oradata directory) containing the data files and online redo logs of the newly created database. 3. Re-try the control file restore operation.
Read more

SQL Server Builds Information

-
Image
Very Useful information about SQL Server Builds .  It is nicely presented in the blog . Please see  below for our reference . Microsoft SQL Server Version List What version of SQL Server do I have? This unofficial build chart lists all of the known Service Packs ( SP ), Cumulative Updates ( CU ), patches, hotfixes and other builds of MS SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released. Useful articles: How to identify your SQL Server version and edition SQL Server Internal Database Versions Microsoft SQL Server Support Lifecycle Microsoft SQL Server Home Microsoft SQL Server Developer Center Microsoft TechNet: Microsoft SQL Server Microsoft Knowledge Base Sqlservr.exe versions   Quick summary:   RTM (no SP ) SP1 SP2 SP3 SP4   SQL Server 2017      codename vNext 14.0.1000.169 *new           SQL Server 2016 13...
Read more