Situation

You have a master-detail table relationship and you want to filter the detail rows, programmatically or any other way.

In a jDeveloper - Oracle database environment [View object (master) - View link - View object (detail)]

Solutions

With jDeveloper you have some options, maybe even more than mentioned here.

Here are some solutions. Choose the best solution in your case.

1. database view

Create a new detail view object based on a database view. Easy solution, easy to maintain in case of where clause adjustments, but a pretty static solution. A view change is necessary when the condition changes.

2. view criteria

Create a view criteria (named or programmatically). That's pretty dynamic. 

You can programmatically control the view criteria you want to use.

3. where clause

Add a where clause to the detail view object. Like option 1, pretty static, but with the use of bind variables you have a nice solution. Furthermore, you can also add a where clause programmatically.

4. while loop

Not the best solution, but you can just loop through the detail values and select the rows you need. Personally, I don't like it, especially when a lot of rows are involved and you only want to display a few rows.

5. search criteria

It depends on what the problem is and what the customer wants, but you can also choose to add search items above your detail page. This way the user can filter the data.

 

Choose one. Consider the fastest (performance) and easy to maintain.

Situation

I have an Oracle Linux 5.10 with Oracle 11g Standard Edition installed on a VM (virtualbox).

The "harddisk" of this VM is stored on a external disk. This way I can easily re-use my virtualbox on another PC; a laptop in my case. So, I plugged the external disk in my other laptop, created a VM, started the VM, et voila, it all works...

Problem

Then, I started the database, at least, I tried it... but it failed with an "ORA-00845: MEMORY_TARGET not supported on this system."

Cause

The cause is probably that the other laptop has less memory and thus the VM has less memory

Solution

Pretty easy, once you've found it:

Start a terminal and login as root (su)

Check the filesystem

df -h

The output should display a Filesystem tmpfs. The size of that filesystem must be bigger than your MEMORY_TARGET.

The question then is: how big is my MEMORY_TARGET? You can check that easily if your database is started... duh.
My advise, just trial-and-error with the following command (execute as root):

mount -t tmpfs shmfs -o size=1g /dev/shm

once executed, try to start the database. If it fails, increase the size until you have success.

To prevent the error from happening the next time you start the database, add this size to your fstab (etc/fstab).

tmpfs     /dev/shm    tmpfs     size=1g   0   0

Hope this helps, good luck!

This article describes how to install the Oracle Forms and Reports service.

My setup

Oracle VM
Oracle Linux 5.10 (64 bit)

My software to install

JDK 1.7_45
Weblogic 10.3.6
Forms 11.1.2.1

Lets start

First install the JDK (I installed it as root). Download it here.

Extract it (use tar -xvf) in a directory, e.g. /usr/lib/java-1.7.0/

tar -xvf <filename> -C /usr/lib/java-1.7.0/

and make it the java version-to-use with alternatives

/usr/sbin/alternatives --install /usr/bin/java java <full path to your java executable> <java version number>

e.g.

/usr/sbin/alternatives --install /usr/bin/java java /usr/lib/java-1.7.0/jdk1.7.0_45/bin/java 17045

then check your java version with

java -version

Second, meet the requirements for your Linux OS x86_64 and install the necessary packages (install as root):

yum install binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXi make openmotif openmotif22 redhat-lsb sysstat xorg-x11-utils

Third, install the Weblogic server using the wls1036_generic.jar file. Download it here.

Install it with the following command (64 bit, not as root)

java -d64 -Xmx1024m -jar wls1036_generic.jar

An Oracle installer window will appear, follow the instructions. You only need to install the WebLogic Server, Oracle Coherence is an option. So, choose Custom install when asked to choose the install type.

Once installed, leave the quick start checkbox checked and press done. The quick start window will start.
In the quick start window, choose to create a new domain. Press the next button 2 times in the window that follows.

  • As a domain location, choose a location outside the middleware directory and press next. 
  • Then supply a password for the weblogic user and press next.
  • Choose a mode and press next.
  • Press next and then create
  • Close the quickstart window

 Check if the WebLogic server works with the following url: http://<your host>:7001/console

If the console doesn't work, start it with the startWebLogic.sh script which resides in your domain directory, and try again

Close the browser, press ctrl+c in your terminal to stop the WebLogic server.

Fourth and last, install the Forms and Reports service. Download it here.

Extract it in a directory, e.g. <your home>/forms/

Start the installation script

./<your home>/forms/Disk1/runInstaller

If you receive a "permission denied" then run the following commands to allow execution of certain scripts:

chmod 774 ./<your home>/forms/Disk1/runInstaller
chmod 774 ./<your home>/forms/Disk1/install/linux64/runInstaller
chmod 774 ./<your home>/forms/Disk1/install/linux64/unzip

When the installer proceeds, an Oracle Forms and Reports Installation window will appear.
Press OK and then execute the script, as root, as mentioned in the message window.
Then press OK.

Another window appears, follow the instructions.
I choose to "skip updates" and "Install software - do not configure". We will configure after the installation.

Once installed, another script needs to be executed as root. Then press OK and Finish.

As a final step, we need to configure the Forms and Reports service. 

Start the config.sh script in the bin directory of your Oracle (Forms and Reports) Home.
Press next, 2 options, Deployment or Development. Choose what you need.
I choose Deployment. When asked to select a Domain, choose to Create Domain.
I also choose to only install Oracle Forms (no reports), Auto Port Configuration, no use of Application Identity Store.

Press next and then configure and wait...

Be patient, it'll take a while and then press next and finish.

That's it!

Verify your installation by following these instructions.

Goodbye OAS...

This is the situation. You have an Oracle Forms application server 10g, maybe even headstart and/or webutil included and you want to start using 11g, on the server and as a developer on the client... then say goodbye to Oracle OAS/DeveloperSuite 10g and hello WebFusion...

...welcome weblogic

Its WebLogic and Fusion only. On the server as on the client (as a developer). Thus, start downloading! You need the proper JDK, WebLogic and Forms software. When you have a linux server and a windows client, then you need to download an estimate of 6 GigaByte of software.

Like a charm

But, the good news is, I performed the migration/upgrade with success - without using the Oracle upgrade tool -  including headstart and webutil, and it works! It was a complete clean install of Oracle Weblogic and Fusion on the server. Once installed, I installed the application including headstart libraries and the webutil "plugin". All with success. Thus, don't give up it is possible and not that difficult.

Furthermore, realize that it is the true end of life of Oracle Designer...

What to do before you start installing Weblogic 12 on a Oracle Linux 5.10 OS?

JDK

First, install the proper JDK: 1.7. Download it. Extract it in e.g. /usr/lib/java-1.7.0/

Second, do alternatives

/usr/sbin/alternatives --install /usr/bin/java java <full path to your java executable> <java version number>

I did:

/usr/sbin/alternatives --install /usr/bin/java java /usr/lib/java-1.7.0/jdk1.7.0_45/bin/java 17045

And check it:

java -version

Weblogic 

When the JDK version is installed correctly, you can start to install the Weblogic application server (WLS)

First create a directory where you want to install/extract the WLS. E.g. /home/<your username>/wls/

Extract the contents of the WLS zip file to that directory

adjust your .bash_profile and add the following lines

JAVA_HOME=<your java home directory>
MW_HOME=<your WLS home directory>
EXPORT JAVA_HOME
EXPORT MW_HOME

save the changes, logout and log in

check the variables; start terminal (ctrl+alt+t)

echo $JAVA_HOME

it will show something like this: /usr/lib/java-1.7.0/jdk1.7.0_45/

start the installation script

 cd $MW_HOME
./configure.sh

a lot of jar files will be deployed

when asked to create a new domain, answer NO ! (because it creates a domain inside the WS_HOME and that's not smart)

Now, setup the WLS environment

./wlserver/server/bin/setWLSEnv.sh

Create a new WLS domain and start WLS

./wlserver/common/bin/config.sh

NB. After a reboot you can start the domain with the startWeblogic.sh script, which can be found in your domain directory.

 

 

 

 

Joomla templates by a4joomla