- Powered by
- WordPress
-
Check for non-successful connection attempts in listener.log
This could become a regular question from your security team: can you find out if someone tried to mess with the listener when trying to connect? Often you see hackers target port 1521 and sending random data and/or garbage over the wire. The listener initially accepts the connection but closes it when it doesn’t receive…
-
Upgrade ASM 10.2 to 11.2 single instance
This post describes how to upgrade an existing single instance ASM installation to the latest and greatest, Oracle 11.2. The most noteworthy change is that ASM is no longer installed using RDBMS installer but rather the Grid Infrastructure. Huh-installing CRS for single instance? That at first sounded like a bit of an overkill but Oracle…
-
OpenSolaris 2009.06 domU on opensuse 11.2 dom0
I was curious to get started with opensolaris and quite eager to install it as a domU on a Linux dom0. There would have been little problem to do it the other way around. Actually, I could have installed opensolaris on my Toshiba R600 too! Then I tried out a number of current linux distributions,…
-
How to move OCR and voting disks into ASM
Moving OCR and voting disk into ASM is the Oracle Grid Infrastructure or 11.2 way of storing essential metadata. During new installations this is quite simple since the work is done by OUI. When upgrading to 11.2 from a previous Oracle release, things look slightly different. Note that storing OCR and voting disk on raw…
-
Compile DBD::Oracle 1.23 with Oracle 11.2 client
This article discusses how to compile DBD::Oracle for Oracle client 11.2 x86-64 on Linux (Fedora 12 to be precise). I recommend not to mess around with your distribution’s perl, that’s why I will base it on ActivePerl 5.10 from Activestate.com. If you (and you system administrator don’t mind mangling your distribution’s perl you might skip…
-
Policy managed databases
This is a long overdue reply to an email Mark Bobak sent to the oracle-l mailing list. The questions Mark asked were regarding policy managed databases, a new 11g Release 2 feature. Since I have been very interested in the same topic (and also partly due to the fact that I am presenting about this…
-
Upgrade Clusterware 10.2 to 11.2
This post is about upgrading Oracle Clusterware 10.2.0.4 on Oracle Enterprise Linux 5.4 x86-64. The setup is as follows: 3 node RAC system, hostnames: racupgrade1, racupgrade2, racupgrade3 Oracle Clusterware 10.2.0.4 with CRS bundle patch 4-(patch 8436582) Oracle ASM 10.2.0.4.1, i.e. PSU 10.2.0.4.1 (patch 8576156) Oracle RDBMS 10.2.0.4.1 Additionally I patched OPatch and applied one off…
-
Xen-based virtualisation with opensuse 11.2
I recently upgraded my laptop’s opensuse 11.1 installation to 11.2, mainly because it has updated xen to version 3.4 which makes it one of the most modern distributions with xen support available. I did some research first about which linux distribution would best suit my needs. When I came across a post which said that…
-
Installation of Fedora 12 x86-64 on Dell Optiplex 760
These office PCs are actually quite nice-not powerfull but neither the opposite with a Core 2 Duo processor and in my case 4 GB of memory. I think they might be able to take on more memory which could come in handy later. The machines come with an on-board graphics and sound device and almost…
