How to install Oracle Application Express 4.1 with Database XE 11.2g

Download and install Oracle Database XE 11.2g

Download Oracle Application Express 4.1 (APEX)

Tip: In case you get an ORA-12560 error, your database listener has not started.
Either start it by running “c:\oraclexe\app\oracle\product\11.2.0\server\bin\StartDB.bat” or use  the “Start DB” shortcut from the start menu.

Connect as SYS to the database console
[bash]conn sys/passw as sysdba[/bash]

Run the following sql command to setup APEX
[sql] @c:\apex\apexins myapp myapp  temp /i/
exit[/sql]

How to set forms 11g buttons to display icons

Simple way

Copy your images to:

[text]c:\Oracle\Middleware\as_1\forms\java\[/text]

Notes:
– Icon files may not be supported.
– In case of a Java security issue when using gif images, you will need to create a jar file and sign it with oracles sign-tool (see below, point 6).
– In case you having trouble with oracle’s sign-tool, do it directly with java’s

Recommended way (more…)

How to configure a Weblogic 11g VM if moved or copied

When you move or copy a WebLogic 11g environment setup as a VM from one host PC to another, you will encounter various IP connection problems (may also be needed if you have problems debugging forms). To help make a quick fix to this problem, try this:

1. Make sure you have the following files set with your machine’s new IP:

[bash]edit C:\Oracle\Middleware\user_projects\domains\<domain_name>\servers\WLS_FORMS\
data\nodemanager\startup.properties
AdminURL=http\://<ip-address_of_pc>\:7001

C:\Oracle\Middleware\asinst_1\config\OPMN\opmn\instance.properties
adminHost=<ip-address_of_pc>

C:\Oracle\Middleware\user_projects\domains\<domain_name>\config\config.xml
//replace ip.address for every occurrence found (~ 7)[/bash]

2. Restart the machine/server

3. Start the Node Manager
Tip: tail the log file to see whether the ip-address is the correct one being used
C:\Oracle\Middleware\user_projects\domains\<domain_name>\servers\AdminServer\logs\AdminServer.log

4. Start the em “http://localhost:7001/em” to further configure the server to start forms and reports services.

5. Start the Administration Console (Weblogic Domain > select your domain > from Weblogic Domain menu select “Weblogic Administration Console” or enter the url: http://192.168.139.128:7001/console)

6. from the Change Center click on “Lock & Edit”

7. from the Domain Structure pane > Environment > Servers > click on Control tab

8. select WLS_FORMS and WLS_REPORTS > click Start to start the services

9. make sure after you start Forms Builder that “Application Server URL” in Runtime tab of Preferences is set to what your new ip-address is (i.e. http://192.168.139.128:9001/forms/frmservlet)

 

How to install Oracle Forms and Reports 11g on Windows XP 32bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows XP 32bit
reqs: WinXp SP2 or later, 1GB Memory,
time: Oracle Weblogic: 10 min,
Fusion Middleware: 40 min setup, 50 min config

  1. Download Weblogic Server 10.1.3.2 (11g) from here
    Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
    the i586 JVM installer package (about over 1/2 GB)
  2. Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
    Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
    the i586 zip files (about 2.5 GB in chunks of ~500MB).
  3. Make sure you have at least
    • an i586 compatible CPU and Windows system
    • 1 GB of memory
    • 5 GB of free disk space for a typical install

If needed, download Java JDK 6u25 i586 (jdk-6u25-windows-i586.exe). (more…)

How to install Oracle Forms and Reports 11g on windows 7 64bit

specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows 7 64bit
reqs: Win7 x64, 1GB Memory, Administrator
time: Oracle Weblogic: 5 min, Fusion Middleware: 23 min setup, 16 min config

  1. Download Java JDK 6u25 x64 (jdk-6u25-windows-x64.exe)
  2. Download Weblogic Server 10.1.3.2 (11g) from here
    Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
    the x64 JVM installer package (about 1 GB)
  3. Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
    Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
    the x64 zip files (about 2.5 GB in chunks of ~500MB).
  4. Make sure you have at least
    • a 64bit CPU and Windows system
    • 1 GB of memory
    • 5 GB of free disk space for a typical install (more…)