OWB 11gR2: A New User Interface and How to Restore Factory Layouts

Starting from 11gR2, OWB has adopted the Fusion Client Platform (FCP), which is the same IDE platform as Jdeveloper and SQL Developer. FCP provides an efficient and flexible way to manage navigators, panels and editors. When we login to OWB Design Client the first time, we have a interface as shown in fig 1. Projects Navigator, Locations Navigator, Globals Navigator, Graphical Navigator and Structure Explorer are bundled on the left. The main window is a Start Page, which links to many useful documentations as well as online resources, and is a good place to get started.

owb_start Fig. 1

With 11gR2, multiple editors can be opened for editing at the same time. Take a look at fig 2, we have two mapping editors and one table editor. Projects navigator is minimized for better utilization of screen space, while Property Inspectors and Component Palette are docked for easier manipulation of mappings and access to component properties. All panels and editors can be dragged, resized, or docked as preferred, and the layout is fully customizable. If you would like to change the overall window layout, you can go to menu Tools->Preference->Environment->Dockable Windows.

owb_multi_editors Fig. 2

Interested in OWB 11gR2 user interface? Take a User Interface Tour.

However, in rare cases, the layouts just get messed up. For instance, Property Inspector is gone missing. Fortunately, we can restore the factory default layout by removing the layout setting files. There was a post talking about this, but as time goes by, the content is outdated and may not be applied to 11gR2. Let's look into how to fix this in 11gR2.

1. Locate the settings directory.

On Linux, it is "~/.owb" (aka $HOME/.owb). This is a hidden folder under your home directory. Suppose your login handler is "tom", and you started OWB Design Client before, the setting directory for you sould be "/home/tom/.owb".

On Windows, it is "%APPDATA%/OWB". Depending on Windows version and configurations, it should be something like "C:\Documents and Settings\<username>\Application Data\OWB" on Windows XP.

(Note: For earlier releases, "$OWB_HOME/owb/bin/admin" is used.)

2. Change current working directory to the settings direcotry and delete setting files.

Under the settings directory, there is a folder named system11.2.0.X.X, where X.X is version numbers. Usually on a fresh install, you only have one folder, but if you upgraded from previous versions, there might be more than one. By removing these folders, the layout will be restored to factory defaults.

Following is an example on how to remove the setting directory from command line. If you prefer, you can also use a GUI explorer instead, but make sure hidden files are shown.

On Linux:

$ cd ~/.owb
$ ls
$ rm -rf system11.2.0.*

On Windows:

08/28/2009  01:54 PM    <DIR>          system11.
>del /s /f system11.2.0.*

Now, if you start the Design Client, you should see the factory default layout as shown in fig 1 again. And don't worry. Your data stored in database repository are kept safe and untouched.


Extended Reading:

OWB User Interface Tour

What's New in OWB 11gR2


Well not quite what I had been trying to find however it was some good reading anyway, guess its a ok that I wasn't capable of doing a search properly or I wouldn't ended up here.

Posted by Telma Breznay on March 21, 2010 at 08:58 AM PDT #

Hi, I am not able to find the hidden dir .owb or the system11.2.0.X.X folder. (I have set to show hidden files and I am on Red Hat Linux 5) I am on Owb 11.2 Where might this file be? If it's a standard install? Mine owb install dir is dbhome\owb

Posted by Mark on April 29, 2010 at 03:45 AM PDT #

Hi Mark, Usually, the ".owb" folder, under your $HOME (usually /home/), will be created the first time OWB Design Client is started.

Posted by Nick Huang on April 29, 2010 at 02:58 PM PDT #

You have saved my day. My OWB designer setting got messed up and when I was trying to generate, I was not able to see the generated code windows. Not after deleting the folder you mentioned above, I have got the default layout again.

The only thing, I would like to add that I could not delete the windows folder by the del command you have above, but I was able to get the folder deleted from windows explorer. And after deleting the folder when you start designer, it does ask you whether you want to upgrade from previous version and I choose NO.

I wasted my whole day and then hit your page.

Thanks Internet and thank you.

Posted by guest on June 08, 2012 at 11:13 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.


« July 2016