This was caused by reusing ASM disks from a previous installation of GI. Remedied this with the following commands: [root@redfern1 ~]# dd if=/dev/zero of=/dev/sda1 bs=32768 count=32768 conv=notrunc oflag=direct 32768+0 records…
Introduction This article, will cover Oracle 19c restart data-guard physical standby configuration, but before we start, you need to have two oracle 19c restart servers one as Primary server and…
Error I installed SQL Server 2017 on Centos 7 and used MSSM GUI for database replication configuration. when the distribution configuration process was successful until the end but when…
Details This article provides steps to recreate a lost virtual disk descriptor file (.vmdk). You may need to recreate missing header/descriptor files if: The virtual machine disk file listed in…
Check the status of online or offline for datafile in Oracle Check the status of datafile Select file#, status from v$datafile; OR SELECT FILE_NAME,ONLINE_STATUS FROM DBA_DATA_FILES; Take the data file…
Check datafiles and tablespace information in Oracle Check information about datafiles SQL> select * from dba_data_files; SQL> select * from v$datafile; Check information about tablespace SQL> select * from dba_tablespaces SQL>…
Check the Undo tablespace total, free and used space usage in Oracle Check the undo tablespace total, free and used space(Size in MB) in Oracle SELECT a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB…
Find the date and patch number applied in Oracle Database. List the patches applied in Oracle Database Go to directory CD %ORACLE_HOME%\OPatch opatch lspatches List the patches with lsinventory –…