backupAs you probably know there are some issues with the Enterprise-Manager, today i came around some really ugly things. In my Test-Installation i am using Enterprise-Manager on Windows Server, and tried to write a RMAN-Job. When trying to start these jobs i get: "No rman found in c:\oracle\product\11.1.0/bin". In this error-messages there are several issues there is one slash "/" instead of a backslash "\" and the directory is NOT my Oracle-Home.

I installed the newest version of the agent, but it did not work either. So i tried a workaround. I simply wrote a batch-script that starts RMAN and a RMAN-Script with "rman @testscript.txt" in the script i use connect target to connect to the correct instance (not the best way but it works).

Next Error-Message: "Message file RMAN<>.msb not found". This time the ORACLE_HOME variable was not set. ORACLE_HOME on Windows? Isn't that a linux/unix-thing? YES.... normally in windows just the PATH-Variable is rewritten wenn changing Oracle-Homes, but in this case the management seems to rely that there is such an variable. So i simply added a SET ORACLE_HOME=C:\oracle\product\11.1.0\db_1 in my batch-script.

Now it seems to work properly Laughing, i hope they fixed it in the new Enterprise-Manager version already....

passwordIf you are getting a "ORA-1017: invalid username/password; logon denied" when creating a database link, and you ensured to enter the correct password, you probably try it against a 11g database version. In this version is a new feature the "case sensitivity rules". This statement worked from a 11g db to a 10g database, and threw a exception from 10g to 11g.

create public database link testdblink
connect to TESTUSER identified by 'testpw'
using 'test2db';

After using double-quotes it worked fine in every direction.

create public database link testdblink
connect to TESTUSER identified by "testpw"
using 'test2db';

Seems to be a bug or a feature....

If your resolv.conf gets overwritten in Debian after a reboot, and thats not wanted check if you have accidentially installed the package resolvconf. This package is a framework for exchanging name server information, used by several programs. In my case a simple "apt-get remove resolvconf " resolved Wink the problem.

I am currently testing my Amazon4PHP framework and was trying to analyze what items on Amazon are really worth to buy. You can find the results here. If you have any suggestions for the lists let me know. I am thinking on generating them on a regulary base for all Amazon-Sites. The lists here are from Amazon Germany and the Price is including the Austrian VAT of 20%. I was just able to include some Electronical stuff, i will work on a version for books and others

The framework is written in PHP and i am using the Amazon Web Services to retrieve the product-data. If you have any suggestions what would be a nice feature let me know!

The index-files with the links can also be found here: Index File to Amazon-Bestseller

xen_logoOn one of my xen-guests i got "4gb seg fixup" errors after upgrading from etch to lenny. Reason was that the libc6-xen library was not linked correctly. I fixed it with:

  • apt-get remove libc6-xen
  • reboot
  • apt-get  install libc6-xen
  • reboot

Last week i got the following error on a 10gR2 Database when using Views:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [__VInfreq__kxccres+1516] [PC:0x2FB0BE4] [ADDR:0xC] [UNABLE_TO_READ] []
alter system set _optimizer_join_elimination_enabled=false scope=both;

bug I ran into the bug Oracle Bug 5579055, the solution for this is documented in note 370701.1

It is solved when you turn a optimizer feature off with:

alter system set _optimizer_join_elimination_enabled=false scope=both;

debianAs before mentioned i am not a Linux-Pro but try to survive on Debian since a while. This time it took me some time to get a solution to this error message "C compiler cannot create executables."
Reason was that you have to install the build-packages for Debian. This can be done with

apt-get install build-essential make bin86

Last weekend used some Java Procedures in the database to read and parse files. When granting the permissions (done by the dbms_java package)

EXEC DBMS_JAVA.GRANT_PERMISSION( 'testdeveloper', '','/mnt/myhome/tesfiles/', 'read' );

I got this error:

ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.vm.IdNotFoundException: -1 is not the number of a user or role
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 1

Solution for this: just write the schema name in uppercase!Smile

EXEC DBMS_JAVA.GRANT_PERMISSION('TESTDEVELOPER','','/mnt/myhome/tesfiles/', 'read' )


I was testing around with the Oracle Enterprise Manager, in the Console i found that the listener can't be configured error-message "Compute dynamic property takes too long". Reason was that the TNS_ADMIN (Windows, TWO_TASK Unix/Linux??)was set so that just one specific TNSNAMES.ORA file in "c:\oracle" could be used.

When configuring the listener the  listener.ora file was also placed in "c:\oracle", and EM could not handle the file in another directory than the default home. 

Solution was to delete TNS_ADMIN and put the listener file back to the home-directory, you could also recreate thel listener i think.





I wanted to update some sites from Joomla 1.x to 1.5.x, so i looked for the official migrator, i did not want to use any 3rd party extension for this important task. I really spent a lot lot of time looking for it in the extension-directory.... but the official migrator is not in the extension-directory Yell. It can be downloaded here.


Sind years i have a simple Emai-check in my Toolbox. It is a simple PL/SQL function within a package. Two weeks ago i came about this regexp-page. There you can find a regexp that implements the RFC 2822 standard, or an more practical approach of it.  Since a time regular expressions are supported in PL/SQL, so i implemented it in my little email-check. I don't understand a lot of regexp and the regexp did not work out of the box, so a colleague helped me to correct and implement it for PL/SQL. The problem was a missing ^ at the start and the ?: in the regexp. The results are excellent! The regexp checks all official domains that are longer than 2 characters and also checks if the other domain are not longer than 2 characters. Give it a try!

Here is my code:

-- %author          Manfred Hofbauer (
-- {*}CreateDate:   07.05.2006
-- {*}purpose:      function checks for an valid email (contains @ and ....)
-- %version         0.3
-- {*}ChangeHistory
-- {*}When          Who                     Version       purpose
-- {*}07.05.2006    Manfred Hofbauer        0.1           created
-- {*}03.12.2007    Manfred Hofbauer        0.2           changed to regexp
-- {*}05.12.2007    Manfred Hofbauer        0.3           returns number to be usable in SQL
-- %param           pEmail                  String that shall be checked for an valid email
-- %return          true or false (1=TRUE 0=False)
-- %raises

cEmailRegexp CONSTANT VARCHAR2(1000) := '^[a-z0-9!#$%&''*+/=?^_`{|}~-]+(\.[a-z0-9!#$%&''*+/=?^_`{|}~-]+)*@([a-z0-9]([a-z0-9-]*[a-z0-9])?\.)+([A-Z]{2}|arpa|biz|com|info|intww|name|net|org|pro|aero|asia|cat|coop|edu|gov|jobs|mil|mobi|museum|pro|tel|travel|post)$';

IF REGEXP_LIKE(pEmail,cEmailRegexp,'i') THEN

END isValidEmail;



In the future i will be using a PowerEdge Server of Dell, and because I don't want to have such a loud piece of hardware at home, i was lookingdelllogo for a server-housing possibility. A lot of them ask how many power-consumption this server has, and guess what... there is nothing in the technical details about the consumption.

But i found the following great rack-planner. This tool is for planning how your 19'' rack will look like, what power heat will be produced and last but not least what power will be consumed. You choose a rack, choose a server, edit the server tell how much RAM HD, if it will be idle most time or most time used what processor etc....

Really nice tool, here is the link to the rackplanner