System & Database Related Solutions

by SaidRasel

Pages

▼

Sunday, 5 October 2025

Move OCR , Vote File , ASM SPILE to new Diskgroup (Oracle 19c RAC)

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl query css votedisk ## STATE File Universal Id File Name Disk group -...

Oracle 19c RAC Database Drop LUN from Liunx OS (2 Node RAC)

---Drop Disk From ASM---- ALTER DISKGROUP RECO DROP DISK RECO_0006 REBALANCE POWER 11; ALTER DISKGROUP RECO DROP DISK RECO_0005 REBALANCE ...

Wednesday, 9 October 2024

step by step Oracle 12c Data Guard Switchover

Step:1 In Primary database check the database role and open_mode SQL> select name,open_mode,database_role from v$database; NAME ...

Remove Instance from InnoDb cluster in MYSQL

[root@nikash-db2 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost lo...

Tuesday, 8 October 2024

ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 41 into a target database with TSTZ version 32.

Import: Release 19.0.0.0.0 - Production on Wed Oct 9 09:11:46 2024 Version 19.21.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affilia...

View web version

Powered by Blogger.