Author Archives: Abdulhameed Basha

About Abdulhameed Basha

15 years experienced Database Management professional armed with Post Graduate Program in Big Data Engineering. Proficient in Oracle technologies deploying high availability applications, migrations, upgrades and performance tuning. Adept at automating business process and the repetitive tasks that led to a reduction in cost/time to the organization. Highly skilled in developing and integrating mission critical complex applications by following end-to-end software development lifecycle.

Error accessing MongoDB in Apache Hive

Posted on October 1, 2019 by Abdulhameed Basha

Accessing MongoDB collection via HiveQL after integrating it with Apache Hive is throwing error. Detailed error can be obtained by enabling hive shell in debug mode as below; hive hive.root.logger=DEBUG,console  select * from table_name; Error Stack: 19/08/27 10:16:35 [main]: DEBUG … Continue reading →

Posted in MongoDB | Tagged , , , | 1 Comment

MongoDB Integration with Apache Hive

Posted on October 1, 2019 by Abdulhameed Basha

One of the application of Big Data is to analyse the historical transaction data and classify the incoming new transactions. To perform this we can have NoSQL database to hold the historical transaction data and use MapReduce to analyse the … Continue reading →

Posted in MongoDB | Tagged , , , | Leave a comment

Block Corruption after Hot backup

Posted on March 5, 2011 by Abdulhameed Basha

In Oracle E-Business Suite 11i/R12, very rarely we get block corruption error after cloning with hot backup or in activated Standby. Re-backup or Re-cloning may solve this issue but in some case where we cannot afford to redo the activity … Continue reading →

Posted in Uncategorized | Leave a comment

Internal 500 error accessing direct forms in R12

Posted on March 2, 2011 by Abdulhameed Basha

Many a times we hit lot of issues after cloning, mostly it would be login issues. Being APPS DBA we will try to eliminate and find the root cause of the problem to fix the issue. One such approach is … Continue reading →

Posted in Uncategorized | Leave a comment

How to handle lost undo datafile

Posted on February 27, 2011 by Abdulhameed Basha

As DBA we are not suppose to drop any datafile without proper analysis and backup even if it is offline datafile. But as Human we make mistakes which sometimes cost us large. In this blog i am going to share how … Continue reading →

Posted in Uncategorized | Leave a comment

rconfig does not recognize cluster environment

Posted on February 15, 2011 by Abdulhameed Basha

rconfig is a command line tool to convert single instance database to RAC. It got introduced from 10gR2. We were trying to convert single instance 11gR1 database to RAC database using 11gR2 grid. After installing grid, we verified the cluster … Continue reading →

Posted in Uncategorized | Leave a comment

SYSTEM09.dbf file corrupted in R12.1.1 fresh install on Linux x86_64

Posted on February 12, 2011 by Abdulhameed Basha

Fresh installed R12.1.1 with rapidwizard version (StartCD) 12.1.1.9 or below on Linux X86_64 contains corrupted SYSTEM09.dbf file. Thankfully those corruption are not data corruption (does not belong to any extents/segments) hence will not affect your installation and database startup. Might … Continue reading →

Posted in R12.1 | Tagged , , , | Leave a comment

Device Mapper Multipathing

Posted on February 9, 2011 by Abdulhameed Basha

Multipath ======== The connection from the server through the Host Bus Adapter (HBA) to the storage controller is referred as a path. When multiple paths exists to a storage device(LUN) on a storage subsystem, it is referred as multipath connectivity. … Continue reading →

Posted in Device Mapper, File System, Multipath, OS | Leave a comment

OCFS2 Fencing

Posted on February 8, 2011 by Abdulhameed Basha

I am very excited to start writing my experience with Oracle products and solutions. In this blog am going to detail on OCFS2 fencing technology. We are setting up a new data center for Oracle products, for which we have … Continue reading →

Posted in File System, OS | Tagged , | Leave a comment