Oracle - SQL - MySQL DBA - Life Long Learning Experience

Prior Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System (ACFS) Service on a node connected to the local ASM instance running on the same host to fetch the required metadata. If the ASM instance on a node were to fail, then ACFS file systems could no longer be accessed on that node. With introduction of Flex ASM in Oracle 12c, hard dependency between ASM and its clients has been relaxed and only a smaller number of ASM instances need run on a subset of servers in a cluster. In such a scenario, in order to make ACFS services available on nodes without an ASM instance, a new instance type has been introduced by Flex ASM: the ASM-proxy instance which works on behalf of a real ASM instance. ASM Proxy instance fetches the metadata about ACFS volumes and file systems from an ASM instance and caches it. If ASM instance is not available locally, ASM proxy instance connects to other ASM instances over the network to fetch the me

Follow the below process to change password , please be aware it is also case sensitive.

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 ?? Size for at least

The following Summary is taken from:- Oracle on Nutanix Best Practice Guide The Nutanix Distributed File System (NDFS) has a built in Information Lifecycle Management process which ensures all the hot data is automatically written to the highest performance SSD tier. An in-memory read cache is leveraged to cache frequently accessed data from all tiers. Hot and Warm data is kept via the NDFS SSD storage tier, whilst cold data is kept on larger and slower HDD. General Best Practices. Use benchmarks to regularly check performance is matching or exceeding expectations. Spend time upfront to architect the required solution for both current and future needs. Design to deliver consistent performance, reliability and scalability. Use only Oracle certified operating systems and Oracle RDBMS versions. Use Oracle validated packages, for database software pre-installation. Configure Oracle parameters Parallel_threads_per_cpu = 1 Db_file_multibl