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.
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.
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.
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.
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.
Accept my apologies for the long outage that caused the website to be unavailable.
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 firstname.lastname@example.org
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 127.0.0.1) and port 8080 as we issued in the Dynamic forwarding in point 2.
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
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:
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: