Tuesday, December 30, 2008

Creating Oracle Extended RAC on Oracle VM

Click here for details on Oracle Extended RAC on Oracle VM.

Thursday, December 11, 2008

Oracle SQL Developer Data Modeling

Oracle SQL Developer Data Modeling is the latest product offering to join the Oracle Database Tools. SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.

SQL Developer Data Modeling can connect to any Oracle Database version and later, and is platform independent. Initially available as a standalone product, with future releases available as an extension to Oracle SQL Developer. The second Early Adopter release is stand alone and file-based only.


Wednesday, November 05, 2008

Friday, September 26, 2008

Oracle Locator Express

Oracle Locator Express is a small free utility with which you can switch the default Oracle Home on-the-fly, just like the Oracle Home Selector does.


Wednesday, June 04, 2008

You can get ...

You can get OpenSolaris Live CD and Oracle Unbreakable Linux DVD shipped to you free of cost.
Order OpenSolaris
Order Oracle Unbreakable Linux

Thursday, April 24, 2008

Developing own program using Oracle XE and APEX

Steve Hall method:
1) Fresh install of Oracle XE to default location on new machine,
2) Run backup.bat script on my development machine (ApEx 3.1, my app etc),
3) Copied these files / folders from the development machine to the new installation :
4) Run the restore.bat script on the target machine.
Voila! ApEx 3.1 and my app on the target machine. It needs more testing and automating but it certainly seems to work 'in the lab'.

Suggestion: You can try the COMPRESS option in backup.

Andre method:
Basically the steps are as follows.

1. Create your schema.
2. Create a workspace using that schema.
3. Create your underlying db objects.
4. Import the application into the workspace.

This is pretty basic and there may be some other steps required to complete the job, such as importing images and workspace users but overall, once you do it once, its not that hard.

Thursday, April 03, 2008

Connection to Oracle without using tnsnames

You can use the following syntax to connect

sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba

This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2

Friday, January 04, 2008

Oracle Application Express (APEX) related open source projects

ApexGen - The Oracle APEX Generator
A utility to generate Oracle Application Express pages based on a PL/SQL API.

The Oracle APEX Builder Plugin
The Plugin is a productivity and usability enhancement tool for the development evironment of Oracle Application Express (APEX).It integrates with Firefox and Internet Explorer 6 & 7 to put a wealth of new features to your favourite development tool.

ApexLib - The Oracle APEX Framework Project
The aim of this project is to provide "the" development framework for the Oracle web development environment APEX (Oracle Application Express). APEX is a very productive declarative web-development environment, but which has (as any tool) some short comings. Especially in the area of "out of the box AJAX features" and "out of the box client-side validation".