Increasing VDI file for VirtualBox

Today, I ran out of space when populating my mongodb database on Ubuntu which was a virtual machine using VirtualBox (on Windows 7). Thus, I need to increase the size of the virtual disk image for the VM. Here are the steps that I took:

1. Shutdown the VM
2. Open a windows command prompt
3. Change directory to where your .vdi file is.
4. Type the following from the prompt:

"\Path\To\VirtualBox\VBoxManage.exe" modifyhd --resize <file>.vdi

Alas! The image file has been resized. To verify, open VirtualBox and click the VM. Go to settings > storage.

Cloning an Ubuntu VM using Virtualbox

I was able to install Ubuntu on a virtual machine that I created with Oracle Virtualbox.  I installed Oracle XE, SOLR, and MongoDB. Since I will be testing master-slave for SOLR and MongoDB, I decided to clone my first VM. Here's what I did when cloning a VM and any issue that I encountered.

Oracle: ORA-24247: network access denied by access control list (ACL)

I created a SOLR utility package in Oracle but was getting an HTTP request failed error during run time.

Oracle: Determine OS Process Id based on Oracle Process Id

To get the OS process Id of an Oracle process, join the v$session and v$process views:

select vp.spid "OS Id", vs.sid "Oracle Id", vs.username, vs.osuser

from v$process vp, v$session vs

where vp.addr = vs.paddr;

SOLR: dataImportHandler and Oracle

We are going to test the latest version of SOLR (3.3) and we need to populate it with data that is as close as the what we have on production. However, the script that populates the production index will not work with the new version because there are fields that were taken out due to localSOLR not being used with 3.3. Thus, a data-config.xml was created to be used by the data import handler.

Oracle: Removing targets from Grid Control

I was installing Oracle 11g Grid Control when I tested something and messed up the target list. An agent was listed as a target but unfortunately, I wasn't able to delete it from the console. Thus, I have manually delete it from the repository.

Oracle: Changing a column using SQL*Loader

Our project requires that data in one of our tables need to be summarized first before inserting into the new tables. Data that are loaded into the old table, summarized, then inserted into the new ones. While looking into the script that loads into the old table, we saw that it loads the data first using SQL*Loader, then updates a date column based on a character column. Let’s call them col_date and col_char, respectively.