Installation 6/6 - ProFrame 4 Java installation

Database account creation
While ProFrame 4 Java installation, installer will create tables and insert data into them. Therefore, ProFrame 4 Java installer will ask Oracle database information. For this purpose, we need to create separte database account.
Let's do this first. Open the Oracle web admin, and log in using the proper account information.

Oracle Web Admin Page

Once you logged in the page, you can see the following figure. To add new account select down arrow located on the left side of the Administration button.

Oracle Web Admin Home page

Then, select "Creating User" menu by selecting Database Users as shown in following figure.

Oracle Web Admin "Create User" menu

Then, input the account information. Please assign all privileges as long as it is not problem. Basically, the account should be able to manage tables and data contents.

Creating New account in the Oracle Web Admin

Once you successfully create an account, you can jump to next section.


ProFrame 4 Java installation
After you get the ProFrame 4 Java installer, please run it using the following command

$ ./ProFrame4_0Server_unix_generic.bin

To begin with, you will see the license information screen. Then, the installer will ask path for ProFrame. In my case, I just use default path (/root/proframe/). Next, it will ask you WAS type and path of the installed WAS. Then, select default settings if there is no restriction except IP address. For the IP address, please input your IP address instead of 127.0.01. Actually, it is not strict options but recommended.
Sonner or later, the installer will ask about database information. Please input the account information accoridng to previous section. When it comes to the Oracle SID, just input XE if you also install Oracle 10g Express Edition.
After selecting several default settings options, you can see the installing process screen.


Configuration
After the installation process, the installer will notify you to configure using run_first.sh script in the {proframe path}/bin/. Before run the script, you need to reboot JEUS server. Then, run the script using the following command.

$ ./run_first.sh

If there is no error, the script will show you "upload success !!" messages. During this process, the script insert some data into the database. If you log in the database system using the accout created for ProFrame, you can see the newly created tables.

Newly created tables

Then, installation process is done! Please restart your JEUS server and you can play with the ProFrame


Meta-data Correction
After the installation, there is another minor issue which should be fixed before we use ProBuilder and ProFrame. To do this, we need to correct some database contents in manual way.
Once you open the list of tables created by the ProFrame installer, find out the "DEV_RESOURCE" and "DEV_PROPERTY" tables. Then switch the physical name and logical name of the following items.

• Dbio Total Count
• Dbio Fetch Seq
• Dbio Fetch Size
• Dbio Affected Count

Since this document is based on the b163 installer, you don't need to fix the problem if you use higher version installer.