SLES 11 SP1 Hangs on Boot with Oracle Listener

February 3rd, 2015 Comments off

Every once in a while you might experience boot issues if you have configured Oracle to automatically start the listener, instance and agent in the /etc/sysconfig/oracle.

There might be few reasons for this to happen.

In my case after some troubleshooting I noticed that the tnsnames.ora file was configured to use an IP address rather than hostname.

Read more…

Categories: Database, Linux, Oracle, SLES Tags:

Update Cisco Switch Software

August 31st, 2014 Comments off

Sometimes it’s imperative to update the software of the networking devices. This could be due to a critical bug or general maintenance.

In any way, it is important to know the process and I’ve decided to summarize the steps for future reference.

1. Download the latest software from CISCO.COM. Please note that downloading software images requires an active CISCO account. In case you don’t have such, you will have to register for one.

Read more…

Categories: Cisco, Networking Tags:

MAC Address conversion using Excel

August 28th, 2014 Comments off

I have been working with few different hardware devices that store MAC address information in different formats.

This prevents me from quickly searching for MAC address entries through logs, configuration etc.

Here is a simple Excel formula that helps me to convert the MAC addresses from the standard colon delimited values (:), to the dot (.) delimited values used by most networking equipment such as Cisco Switches and Routers.

Read more…

Categories: VMware Tags:

Oracle DDL Generation using DBMS_METADATA.GET_DDL

August 26th, 2014 Comments off

I find it rather useful to extract and reuse DDL from existing systems.

This allows me to create objects with confidence depending on the system of extraction.

I recently had to recreate a couple of new tablespaces in line with the existing ones.

In the example below, the existing tablespace name is TAB_BIN_OBJ.

Read more…

Categories: Database, Oracle Tags:

TortoiseSVN Remove Repositories from History

July 17th, 2014 Comments off

I have recently configured a new subversion server for few projects.

We decided to use TortoiseSVN since it’s a great tool to use that integrates with Microsoft Windows Explorer.

The list of repositories that you can add in subversion is extended every time you try to connect to a new repository or even have a typo in your existing ones.

Over time, the list builds up and it’s becoming difficult to navigate to the correct one.

Read more…

Categories: Dev, SVN Tags:

Apologies for the Downtime

May 2nd, 2014 Comments off

Dear All,

Accept my apologies for the long outage that caused the website to be unavailable.



Categories: Database Tags:


March 1st, 2014 Comments off

Here is how you connect your mac to an ssh server and establish Dynamic port forwarding allowing you to browse safely.

1. Open Terminal

2. st0ma:~ st0ma$ ssh -D 8080
Authenticate with your ssh user credentials.
3. In your browser of choice, setup the advanced network settings to use a socks proxy
on localhost (or IP and port 8080 as we issued in the Dynamic forwarding in point 2.

Read more…

Categories: Linux, MAC, SSH Tags:

FreeBSD Boot halted on Recovering vi editor sessions

June 18th, 2013 Comments off

Recently I noticed that one of the FreeBSD servers that I am using is not able to boot properly due to issues with session recovery.

The thing is that when you play around with the VI editor, there are sometimes temporary session files stored on the server.

These files reside in the folder /var/tmp/vi.recover

Read more…

Categories: FreeBSD, Unix Tags:

ASUSTeK EZ Flash 2 BIOS ROM Utility V 3.06 Can’t read disk?

April 5th, 2013 Comments off

Just a reminder for those of you trying to flash your Motherboard ROMs to new versions.

In case you wonder why the utility can’t read the file you placed on the C drive of your XP, Vista, Windows 7, etc.

Most old utilities only read FAT32 partitions.

In order to flash your Motherboard just do the following:

Read more…

Categories: Hardware, Motherboard Tags:

Oracle Compile Invalid Object – PLS-00201: identifier ‘DBMS_LOCK’ must be declared

March 29th, 2013 3 comments

Just finished importing a complete oracle database dump with impdp.

Immediately after the import I checked for invalid objects and of course some were present.

In order to get the complete list of schema objects that were invalid I ran the following:


Read more…

Categories: Oracle Tags: