Category: Exadata

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 […]

 146 total views,  2 views today

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 […]

 82 total views,  2 views today

PRVG-13602 : NTP daemon is not synchronized with any external time source on node “oralux405”. 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 […]

 292 total views,  4 views today

Infiniband Oct 2020(19.3.13.0.0.201022) patch was failing upgradeIBSwitch.sh: No such file or directory

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

 310 total views,  2 views today

Exadata Cloud Service: the flexible X8M shape now available on OCI

You can now provision an Exadata Cloud Service instance using the flexible X8M shape. This shape allows you to expand your system after provisioning, as your databases grow and you need more storage servers, compute […]

 422 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 […]

 224 total views,  3 views today

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

In part 1http://parwezexa.com/create-sql-profile-and-move-sql-profile-from-one-database-to-anotherpart-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 […]

 275 total views,  1 views today

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

SQL Profile is a collection of information stored in the data dictionary that enables the query optimizer to create an optimal execution plan for a SQL statement.The SQL profile contains corrections for poor optimizer estimates […]

 314 total views,  2 views today

ExaCC: GI 18C upgrade precheck at the error ‘ERROR: Patch num not specified correctly’ While Upgrading GI home to 18c from 12c

I am writing this article regrading one issue I encountered while upgrading the grid home 12c to 18c in ExaCC gen 1 cloud. The patch pre check was failing saying “ERROR: Patch num not specified […]

 250 total views,  1 views today

Drop and recreate ASM diskgroup in Exadata(vote disk & ocr move)

There was a requirement to clone one database from x5 exadata machine to x7 exadata. The database version was 11.2.0.3 and the clone was failing on target Exadata x7 machine , saying that the database […]

 436 total views,  3 views today