Posted by Mir Sayeed Hassan on 24th October 2020
ORA-16826: apply service state is inconsistent with the DelayMins property on Oracle Database 11gr2(11.2.0.4) Check the status of database SQL> select instance_name,version,status,open_mode from V$instance, v$database; INSTANCE_NAME VERSION STATUS OPEN_MODE —————- —————–… Read more..
Posted in ORA-Error | Comments Off on ORA-16826: apply service state is inconsistent with the DelayMins property on Oracle Database 11gr2(11.2.0.4)
Posted by Mir Sayeed Hassan on 20th October 2020
Overview of Profile Management with real-time scenario in Oracle Database 11gR2 (11.2.0.4) A Profile is a database object & it’s named set of resource limits to such as restrict database usage by a system user. Examples of resources that need to be managed are Disk storage space, I/O bandwidth to run queries, CPU power, CPU Read More
Posted in Oracle SQL | Comments Off on Overview of Profile Management with real-time scenario in Oracle Database 11gR2 (11.2.0.4)
Posted by Mir Sayeed Hassan on 20th October 2020
Error while deleting the oracleasm disks from Oracle Server Check the disk need to delete [root@pri-db ~]# cd /dev/oracleasm/disks/ [root@pri-db disks]# ls ORADATA Delete the oracleasm disk “ORADATA” [root@pri-db disks]# oracleasm deletedisk ORADATA Clearing disk header: failed Unable… Read more..
Posted in ORA-Error | Comments Off on Error while deleting the oracleasm disks from Oracle Server