Happy New Year

So, that's the last entry for this year.Happy new year, guten Rutsch (german) and bonne et joyeuse année 2010 (french) to all my readers.Next year I will continue with more stuff about Oracle Fusion Middleware 11g and Enterprise Content Management. So stay tune ... :-)...

Read More

Fun with DUAL Table

Try this "little hack": connect to Database as sysdba and execute following commands: select * from dual; D - X select count(*) from dual; COUNT(*) -------- 1 insert into dual values ('Y'); commit; Connect in another session with a normal user and try to drop one table: conn scott/tiger drop table t1; ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows select * from dual; D - X Cool the dual just shows one row as expected Go back to the session with the connect...

Read More

Explaining Enterprise 2.0

Today I discover a really cool presentation from Oracle concerning Enterprise 2.0 http://getsocial.oracle.com/?id=d2dI can strongly recommend this interactive presentation to you, it's one of the best presentations I ever see from Orac...

Read More

DOAG Conference 2009 - Training Day

From the 17th until 19th November is in Nürnberg/Germany the DOAG Conference and in access on the 20th November 2009 I will give on the Training Day a workshop for "Identity Management for DBA's", details can be found under http://www.doag.org/konferenz/doag/2009/konferenz/schulu...

Read More

Oracle Fusion Middleware 11.1.1.2.0 available

The latest release of the Oracle Fusion Middleware 11.1.1.2.0 is now available on http://www.oracle.com/technology/software/products/middleware/htdocs/fmw_11_download.htmlTo find the new features/changes of this new release is a little tricky :-) so here is the link to the new features http://download.oracle.com/docs/cd/E15523_01/core.1111/e10105/whatsnew.htm#ASADM10740The major new feature in the FMW 11.1.1.2.0 is the implementation of the Automatic Diagnostic Repository (ADR). Oracle DBA's are used to this component since Oracle 11g, so now even...

Read More

Method-R for Non-Technicals

Today I discover some nice article from Cary Millsap explaining Method-R for non-technical people: http://method-r.com/faq/31-method-r/44-can-you-explain-method-rBut I wonder if this model will work, if you try to adapt this model to a shopping tour with your girlfriend ...

Read More

Oracle Reports desname Bug fixed with Fusion Middleware 11g

This time I come back with an old stuff, which I publish nearly 4 years ago (ups, I'm getting old): The famous Oracle Reports desname Bug, my White Paper concerning this can be found under following Link A Security Hole in Oracle Application Server (Reports) and how to ... (Website of my previous employer). Due to this bug (which was never fixed from Oracle in the Oracle Application Server 10g) it was/is possible to override any file to which the oracle user got access (details see in my mentioned White Paper). And now start claping Oracle introduce...

Read More

Security Hole in Fusion Middleware 11g WebLogic Admin Server

After a little bit playing with the new Fusion Middleware 11g I found a small security hole in the WebLogic Admin Server.In order to start the WebLogic Admin Server Oracle provides you a shellscript $MW_HOME/user_projects/domains/$DOMAIN_NAME/startWebLogic.shThe first way you can use this script is in an interactive way, just execute the script and it will prompt you for the WebLogic Admin-User and his Password. But this methode is not usefull for...

Read More

Oracle Fusion Middleware 11.1.1 Forms & Reports Next Errors Part II

And here I go with the update on my previous post "Oracle Fusion Middleware 11.1.1 Forms & Reports Next ErrorsThe first response from Oracle Metalink was:Confirm it is physically a Linux OS and not any form of virtualisation (which is not supported)Here my 2 Cents for this response:In the meantime, I found the solution for this problem :-)If you are running the Installer for the Oracle Fusion Middleware, you will be asked for either creating...

Read More

Oracle Fusion Middleware 11.1.1 Forms & Reports Next Errors

After I solved yesterday the first error during the linking process of the Oracle Fusion Middleware 11g Forms & Reports the next error comes up :-) Now at the configuration steps, the first configurations like creating Managed Servers for Forms & Reports, Deploying of the Enterprise Manager aso. was successfull, but at the configuration step "Creating ASInstance" a failure comes up :-(The Installation Logfiles just say:An internal operation has failed: The oracle instance is not empty. Select a different location or remove the instance...

Read More

Oracle Fusion Middleware 11.1.1 Forms & Reports Linking Error

As I am playing now with the new Release of the Oracle Fusion Middleware 11g Forms & Reports I run in a linking error during the installation.My environment is as follows:Oracle Enterprise Linux 5 x86-64All required packages according to the installation guide in 32bit and 64bit installedulimts correct set (4096) and not as wrongly stated in the documentation with 2048 :-)I start the installation within a linux32 bash as the Fusion Middleware 11g Forms & Reports is only available for 32bit and 64bit Operating Systems are certified according...

Read More

Reverse Engineering with DBMS_METADATA

Today I'm coming with PL/SQL stuff, nothing with Oracle Application Server :-)At the moment I'm developing for a customer a small reverse engineering routine to capture an Oracle Database (CreateDB.sql, Tablespaces, Users, Grants aso). For this I'm using the package dbms_metadata. If you are using this package to capture e.g. all objects grants to all users, you may receive errors like this "SQL Error: ORA-31608: specified object of type OBJECT_GRANT not found". This comes up, if the user don't hold any object grants.To avoid this simply run a...

Read More

Oracle Fusion Middleware 11g available

Since yesterday (Thursday, 02.07.2009) the new Oracle Fusion Middleware 11g is available on Oracle Technet:http://www.oracle.com/technology/software/products/middleware/htdocs/111110_fmw.htmlThe following components are available:SOA SuiteWebCenter SuiteIdentity ManagementAccess ManagerPortal, Forms, Reports and DiscovererRepository Creation UtilityThe whole stack is available for Windows and Linux platforms, the remaining Operating Systems will follow.With the Fusion Middleware 11g a complete new concept of the architecture is established, all...

Read More

JDBC URL with Oracle SID or ServiceName

Today I face a small problem with a definition of a JDBC URL which is referencing an Oracle Database. I just define:jdbc:oracle:thin:scott/tiger@localhost:1521/PROD.OCZH.CHwhere PROD.OCZH.CH is the ServiceName of my Database, but it fails :-( After a some investigations, the solution is simple, if you want to use the ServiceName of your Database in the JDBC URL you have to place // in front of the servername:jdbc:oracle:thin:scott/tiger@//localhost:1521/PROD.OCZH...

Read More

Cool Video about APEX

I discover today a cool video from Oracle concerning Oracle APEX Enjoy it ...

Read More

Oracle 10.2.0.4.0 on OS X Intel (Part 2)

Today I got some time to test the new Oracle 10.2.0.4.0 on my MacBook Pro. Really cool stuff.Installation is quite simple, just follow the Installation Guide. Only thing what is missing, is that you have to set the Environment Variable DYLD_LIBRARY_PATH=$ORACLE_HOME/lib in order to use all necessary utilities (e.g. lsnrctl, sqlplus aso.)You should also set all mentioned settings according to the Installation Guide, like Kernel Settings and specially...

Read More

Oracle Database 10g Release 2 (10.2.0.4.0) for Mac OS X (Intel) available

My first post about a long time is about the availability of Oracle Database 10g Release 2 (10.2.04.0) for Mac OS X on Intel Platform :-) Cool, now I can use my Mac ProBook with almost every Oracle Tools.The Download can be found under Oracle TechN...

Read More