Hey Folks, Today I faced an issue while configuring Oracle DR setup which was due to different diskgroup present in primary (DGDATA) and standby (DATA). While running Active duplicate command in standby it was throwing below error: Therefore I tried to rename diskgroup in standby same as primary. Rename : DATA to DGDATA Check the … Read more
From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 2. Check the datafiles size and path present in respective tablespace: 4. Give a Log Switch and monitor the Alert Log:
After successfully installing Grid Infrastructure with the “grid” user, I attempted to install Oracle Database 19c Release 3 using the “oracle” user. However, during the installation process, I encountered an issue where none of my ASM (Automatic Storage Management) disks were visible in the disk group selection menu. Log in as root user Login as … Read more
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. On Linux, the ASM processes can be listed using the following command: Some of the more important ASM background processes: ARBx These are the slave processes that do the rebalance … Read more
Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User Change the password for Oracle and Grid user Create the Directories for Oracle Database installation Create the Directories for Oracle Grid installation Step2. Configure Oracle ASM Load / initiate Oracle ASM init 0 Add 25 GB Hard Disk Add … Read more
Check the status of ASM instance . Check the database version and its status. Check ASM disk name available from the instance which we created earlier If you are using a spfile, take a backup of spfile using rman to restore it to ASM disk. Now restore the spfile from the backup to ASM disk as … Read more
The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some of the requested alterations to the disk group could not be completed. The reasons for this error can vary, but it often involves problems with disk group configurations, permissions, or the state of the ASM … Read more
Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 : olsnodes -nserver1 1server2 2server3 3 DB Alert Log: /u01/oracle/product/diag/crs/server3/crs/trace/alert.log String containing event: 2022-07-09 04:06:51.055 [OCSSD(62652)]CRS-1612: Network communication with node server2 (2) has been missing for 50% of the timeout interval. If this persists, removal of this node from cluster will … Read more
To identify the number of diskgroup ,status from below query. Size of ASM Diskgroup Check Diskgroup online/offline Status from OS Prompt Check Datafile, Controlfile, Logfile existence in respective Diskgroup. Check the compatibility version for below diskgroup. Change ASM Compatibility to 18.0.0.0.0. ASM_DISKSTRING Validate Unused Disk To identify the free allocation units for each lun based … Read more