Category: Oracle

Patch db node(linux server node) for ExaCC from oel6 to oel7

Updating the Exadata System Software on database servers is a process that entails patching the entire Oracle Linux operating system, and related Exadata software rather than just updating single packages. Updating the operating system does […]

 327 total views

Single block i/o and Multi block i/o

Whenever we are doing single block i/o on a table which is having index, the optimizer only has to traverse through the root—-branch—leaf and it will do a random i/o on the block address which […]

 250 total views

Different location of datafile, errors RMAN-06094: datafile 31 must be restored ,RMAN-06571: datafile 31 does not have recoverable copy

I was trying to sync my standby database with incremental backup from production due to huge archive log gap of more than 500 archive. While trying to catalog the datafile for switching, the switching was […]

 484 total views

Grid patching was failing with Failed to bring down CRS servic(Clean of ‘ora.gipcd’ on ‘host’ failed)

We were trying to patch out GI home with Oct 2020 PSU, but the patch was not proceeding and every time it failed , when it was trying to bring the CRS down Executing patch […]

 608 total views

ORA-01450: maximum key length (6398) exceeded while doing impdp

Today while performing logical import of data(impdp) , I faced this unique error , which was failing to create index on the imported tables column’s. The whole errors looks like below Failing sql is: CREATE […]

 276 total views,  1 views today

0602-101 Out of memory saving lines for undo

I was trying to open alert log for one of the issue happening in the database , was unable to open the alert log . The opening of file failing with ex: 0602-101 Out of […]

 348 total views

PRVG-13602 : NTP daemon is not synchronized with any external time source on node “exa01”. Result: Clock synchronization check using Network Time Protocol(NTP) failed

I was trying to add some node in our existing 6 node clusters, out ./cluvfy stage -pre crsinst was failing because of NTP sync error . [grid@exa01 bin]$ ./cluvfy stage -pre crsinst -n exa05 -verbose […]

 794 total views

Infiniband Oct 2020( patch was failing No such file or directory

I was trying to apply the InfiniBand switch patch(October 2020 ) to our exadata x5-2 box but it was failing with error saying No such file or directory root@exa01 patch_19.]# ./patchmgr -ibswitches ib_group […]

 508 total views

Increase u01 file system in Exadata Virtual Machine(OVM)

In this article , I am going to explain how to increase the default 20g size of /u01 partition on Exadata x7 machine to sufficient size depending upon your requirement. For this , we need […]

 717 total views

Create sql profile and move sql profile from one database to another(part 2)

In part 1 , we have created a sql profile and demonstrated how the query was taking the effective plan path after using the sql profile . In this part we will create a staging […]

 509 total views