Get guest OS virtual machine's mac address (for eg: OEL73-x64bit) sudo vi /Library/Preferences/VMware\ Fusion/vmnet8/dhcpd.conf ####### VMNET DHCP Configuration. End of "DO NOT MODIFY SECTION" #######  host OEL73-x64bit {    hardware ethernet 00:0C:29:A3:AA:95;    fixed-address 172.16.23.195;  } Restart Fusion Start Guest OS

Recently came across this link and thanks goes to the author, Larry Kim, for compiling the most useful twenty links to just learn about anything. I'm sure there is something for every inspired learner. https://www.business2community.com/startups/20-incredibly-useful-websites-you-wish-you-knew-earlier-02162371 Of course, there is google, youtube and countless other websites to search and learn as well.

I wanted to create a new PDB (pluggable database) using an existing before making a major changes to the original PDB but hit with FILE_NAME_CONVERT error. Creating a pluggable database was supposed to be a simple single statement. My environment is Oracle Enterprise Linux 7 on VMware Fusion 8 with Oracle 12c environment. I have … Continue reading Oracle pluggable database – FILE_NAME_CONVERT error

This is the second installment of ORDS as a mod_plsql replacement for PL/SQL web toolkit based applications. The part I was database side install, basically as a segregation of tasks that need to be performed by a DBA versus middle tier administrator. Click here for Part I. 2) Middle Tier Installation and Configuration The middle tier … Continue reading Oracle ORDS as a mod_plsql replacement in a Non-APEX environment – Part II (Mid-Tier Install and Config)

It took me sometime to figure out. I wish I did a simple google to learn more about "yum.conf" file. If the server is behind a proxy, like almost all work networks are, you'd need to setup the proxy at the system level or add the proxy server information in the 'yum' configuration file. The … Continue reading Run “yum” behind proxy on Oracle Enterprise Linux

I was asked this question in my current employment and I thought it might be a good idea to blog about it. This is a very simple and high level steps to get an Oracle database XE (free edition) and update APEX to the latest version on a windows (windows 7) platform. But the installation … Continue reading How to get a working Oracle APEX environment for free in 2 hours

The new mac OS X (10.11) is out on public beta and time to kick the tires. Obviously, didn't want to install it on top of my Macbook Pro running Yosemite. So installed as a guest OS using VMWare Fusion. Initially thought it might not be possible to install as a guest OS, but it … Continue reading El Capitan beta (10.11) as a guest OS on VMware fusion

In the project that I work, the primary language for apex application is 'en' and there are 11 different languages it needs to be translated to. There have been many circumstances when there is a simple 'process change' in one of the page, I had to seed and publish all applications in the standard translation … Continue reading How to do seed and publish for Oracle APEX translations using a simple SQL script

The documentation on oracle technology network isn't clear enough and I was looking for a better and cleaner install of SQL plus client for mac OS. Google came to the rescue and thanks to Casey Lucas for his detailed blog how to install (unzip) and update the libraries references dynamically so that everything is on one … Continue reading Install oracle instant client on mac