How to resize ACFS file system online ?
We can resize the ACFS file system online without having to umount or disable volume. For this, we use the acfsutil tool....
November 8, 2024
ORACLE
2024
How to convert Administrator-Managed databases to Policy-Managed databases ?
The cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has instances managed on a per-server pool basis...
November 8, 2024
Oracle Flashback Query
Oracle Flashback Query allows the use of select query with AS OF. It allows us to query as much of...
November 8, 2024
How to fix poor performance issues on Exadata cellnode flash disks without replacement?
Exadata cellnode flash disks can sometimes have poor performance. If the error numbers are 0 (zero) or very low when...
November 8, 2024
Goldengate “Not enough database memory” issue
If Goldengate extract services fail to start with errors such as the ones below, the solution is very easy. Possible...
November 8, 2024
Oracle 12c IDENTITY Columns & Default SEQUENCES
I will try to explain the identity field, which is my favorite innovation in Oracle 12c. MS SQL, MYSQL users...
November 8, 2024
How to reconfigure Grid Infrastructure components?
If you cloned an existing server as another server and the ASM disks and all files are moved but ohas...
November 8, 2024
How to fix corrupt UNDO tablespace ?
If the Oracle UNDO tablespace is corrupted, it is possible to receive errors such as the one below. ORA-00376: file...
November 8, 2024
Partitioning a table online using DBMS_REDEFINITION
It is possible to make changes to the structure of tables online with the DBMS_REDEFINITION package in the Oracle database....
October 11, 2024
CRS-4995 error in crsctl command
When crsctl command runs CRS-4995 error is received. This is normal behavior. Operations should be performed with srvctl. The error...
October 11, 2024
What is Temporary Undo?
Temp tables are widely used for preparing intermediate results. Modifying these tables is much faster than regular tables. The performance...
October 11, 2024
resmgr:cpu quantum wait event
The “resmgr:cpu quantum” wait event is seen when the session is waiting for some CPU resources to be allocated. This...
October 11, 2024
How to setup database link from Oracle to SQL Server database using Heterogeneous Services ?
You can review the following document to access tables in the MSSQL database using the DBLINK architecture over the Oracle...
October 9, 2024
CRS-2412: The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time
In Grid versions 12.2.0.1 and later, although the time is the same in all nodes, the following error is seen...
October 8, 2024
How to bring up Oracle Exadata infiniband switch ports when they are down due to AutomaticHighErrorRate?
When the number of errors on Oracle Exadata infiniband switch ports reaches the specified threshold values, it is automatically brought...
October 8, 2024
