Install Oracle Database 11g with the Advanced Installation. Note that if you install the database with the basic installation, you will not get all the necessary files to perform the Installing and Testing Translation Versions of Application Express section of this tutorial.

From your terminal window, enter the following command:

sqlplus / as sysdba
@apxconf

Enter oracle when prompted for the ADMIN password.

Press enter (to use the 8080 default) when prompted for the port for the XDB HTTP Listener.

You also need to unlock the anonymous user. From your terminal window, enter the following command:

alter user anonymous account unlock;  

To can now verify the port number where the Oracle XML DB HTTP Server is running. From your terminal window, enter the following command:

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL; 

You now need to provide less privileged access to local network resources. This will enable indexing the Oracle Application Express Online Help and will enable email and PDF printing when the server is also on the local host. From your terminal window, enter the following command:

cd < location where you unzipped the files from the prerequisites>
sqlplus / as sysdba
@change_priv
exit 

The script change_priv.sql is as follows:

DECLARE
  ACL_PATH  VARCHAR2(4000);
  ACL_ID    RAW(16);
BEGIN
  -- Look for the ACL currently assigned to 'localhost' and give APEX_030200
  -- the "connect" privilege if APEX_030200 does not have the privilege yet.
  SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
   WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
  -- Before checking the privilege, ensure that the ACL is valid
  -- (for example, does not contain stale references to dropped users).
  -- If it does, the following exception will be raised:
  --
  -- ORA-44416: Invalid ACL: Unresolved principal 'APEX_030200'
  -- ORA-06512: at "XDB.DBMS_XDBZ", line ...
  --
  SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
    FROM XDB.XDB$ACL A, PATH_VIEW P
   WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
         EQUALS_PATH(P.RES, ACL_PATH) = 1;
  DBMS_XDBZ.ValidateACL(ACL_ID);
   IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_030200', 
     'connect') IS NULL THEN 
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 
     'APEX_030200', TRUE, 'connect'); 
  END IF;
EXCEPTION
  -- When no ACL has been assigned to 'localhost'.
  WHEN NO_DATA_FOUND THEN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',
    'ACL that lets power users to connect to everywhere',
    'APEX_030200', TRUE, 'connect');
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');
END;
/
COMMIT;

From your browser window, enter the following URL:

http://www.oracle.com/technology/software/products/publishing/index.html 

Accept the license and download the file corresponding to the environment you want to install.

Unzip the file and depending on what environment you are in, start the installer. In this case, you execute the following command on linux.

./runInstaller

When the Welcome window appears, click Next.

Enter BIPHome1 for Name and /u01/app/oracle/product/bipub for Path and click Next.

Accept the default Installation Type of Basic and click Next.

Enter welcome1 for oc4jadmin Password and Confirm Password and click Next.

At the Summary window click Install.

The progress window appears.

The configuration assistant will run.

The installation completed successfully. Click Exit.

Click Yes to confirm.

Note that after the installation is complete, a window is displayed where BI Publisher OC4J is running. Do not close this window. BI Publisher OC4J must be running to be able to successfully generate a PDF report in Application Express.

Open your browser and enter the following URL:

http://<hostname>:8080/apex/apex_admin

Enter admin as the username and enter your password oracle (or whatever password you specified during the installation). Then click Login.

The first time you login, you need to change your password. Enter your current password oracle and then enter the new password (in the VM Template provided, the password is Oracle_1) and click Apply Changes.

Click Return.

You need to login again and specify your new password. Then click Login.

Select the arrow next to Manage Services, select the arrow next to Manage Envrionment Settings and select Instance Settings.

Select the Report Printing tab.

Make sure the following are specified and click Apply Changes.

Print Server: Advanced
Print Server Protocol: HTTP
Print Server Host Address: localhost
Print Server Port: 9704
Print Server Script: /xmlpserver/convert

Application Express has been configured to use BI Publisher. In the next section, you create a workspace.

Select the Manage Workspaces tab.

Under Manage Workspaces, select Create Workspace.

Enter obe as the Workspace Name and click Next.

For "Re-use Existing Schema?" select No. Enter obe in the Schema Name and Password fields, and select 5 for the Space Quota. Then click Next.

Enter obe as the Administrator Username, and enter your Administrator Password and your e-mail address. Then click Next. Note: A new administrator user will be created in addition to the workspace.

Review your workspace request, and then click Create.

Your workspace and user are now created. Click Done.

You now want to log in as the obe user for the obe workspace. Click Logout.

Click Login.

Enter the following details, and click Login.

Workspace: obe
Username: obe
Password: <your password>

From your terminal window, execute the following commands:

cd $ORACLE_HOME/apex/builder/de
sqlplus / as sysdba
alter session set current_schema=apex_030200;
@load_de.sql 

In your browser you need to add the German Language. Select Edit > Preferences.

Select the Advanced tab and under the General tab, click Edit Languages.