The history of scott/tiger

scott/tiger

Almost every Oracle database has had an account called SCOTT with password TIGER. It is named after Bruce Scott (one of the original Oracle employees) and the password is the name of his daughter’s cat. This schema contains the EMP and DEPT tables used in innumerable demos. In recent versions of the database, this account is locked by default and must be unlocked with

SQL> ALTER USER SCOTT ACCOUNT UNLOCK;

Oracle XE inexplicably doesn’t have this classic account, but you can add the user yourself and fill it using the demobld script.

Later versions has an additional demo schema called HR with password HR. This schema contains many additional database objects to allow demonstration of newer database features.

The following links discuss the new sample schemas in more detail.

• Following SCOTT/TIGER

• Oracle’s Sample Schemas: Saying Goodbye to Scott
• Build oracle sqlplus demo table

To drop Scott you need to run the demodrop.sql script

Source: http://wiki.oracle.com/page/scott%2Ftiger

BEA DSPControl bug in WLI under Linux

ALDSP Version: 3.0.1
WLI Version: 9.2.2
OS: Ubuntu 8.0.4 (2.6.24-19-generic, x86_64)
Problem description: When you try to create a new DSPControl in a Process project (WLI), after the settings (remote context, ip, application name, etc…) you select which data service you want this control to call. After that, click on finish. I’ve just got an error message saying that Workshop try to create a directory called /tmpcontrolxsd1223392115385/classes/apache_schemaorg_xml. The directory name changes each time you click on finish.. But the point is, WHY ? WHY Workshop need to create that in the root directory ? Under / ? Come on… Doesn’t make sense and I didn’t find a way to setup that.
Dirt-quick workaround: Run workshop with sudo permission or give write permission on / to the user that you are running workhsop. I prefer the first one, but I’ll research about this bug and try to figure out another way to do that…

And there we go! ORACLE BEA Products for download!

And here is the link if you want to download any “ORACLE Bea Product”:

http://www.oracle.com/technology/software/products/ias/bea_main.html

2 awesome things:

• Workshop Studio is finally a free project (free, not open). Check this link: Oracle Weblogic Workshop Independence day
• JRockit is back again for download

And why these 2 things are so great ? Well, the first one is obvious, workshop studio is a great IDE with many plugins for JEE development, web services, ejb wizards. Also great for other application servers (JBoss, Websphere) and has plugins for Adobe Flex, which is really cool! But until this day, you were not able to download workshop studio, only “workshop”, the basic IDE that comes with all products. That really great news!
The second one is for the people who wants to use one of the best and fastest JVM in the market to work with other JEE products, not only Oracle/BEA ones.

Great job Oracle.