Setting Auto Login Weblogic Oracle 11g with boot.properties

Create file with name boot.properties

and type in boot.properties
username=<username>
password=<password>

Then put in on

ORACLE_BASE/admin/<domain_name>/aserver/<domain_name>/servers/AdminServer/security

In my case, path for put boot.properties is

C:\Oracle\Middleware\user_projects\domains\ClassicDomain\servers\AdminServer\security

REP-0118: A temporary file cannot be created

How to solve this Error ?

Make Temp folder on OracleHome

Go to Regedit HKEY_LOCAL_MACHINE\SOFTWARE\ORACE

Search Reports_temp

Change Path to folder created earlier

Step 9. Install APEX 5.1.4 en

Install Apex just can do it with SQLPLUS, so need some attention to Install Apex. Just Follow this step

Download APEX here
Choose Accept License Agreement then choose Oracle Application Express 5.1.4 download, in my case I choose English Language Only

Extract apex_5.1.4_en.rar, in my case I extract file to C:\Source\OracleInstaller\Apex_5

Run Command Prompt with Administrator

Check path apex, we need this path for installation Apex on SQLPlus, in my case, my path is C:\Source\OracleInstaller\Apex_5\apex

Navigate cmd with Administrator to apex directories and follow this Step below

Navigate to Apex Directories

sqlplus /nolog

conn sys/sys@orcl as sysdba

@apexins.sql sysaux sysaux temp /i/

After success apxinst.sql, it will auto terminate

Connect again to sqlplus /nolog

connect again to conn sys/sys@orcl as sysdba

@apxchpwd.sql to create admin

fill username/pass = oracle/P4$$w0rd

@apxldimg.sql [path Apex]

@apxldimg.sql success

 @apx_epg_config.sql [path Apex]

 @apex_epg_config.sql success

In this step, we need Open SQLPlus directly and go connect to sys

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

check port, SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

set port to 8080, EXEC DBMS_XDB.SETHTTPPORT(8080); and don’t forget to COMMIT;

Open Browser, then access localhost:8080/apex/apex_admin

Fill Username and Password, in my case oracle/P4$$w0rd

Apex 5.1.4 Ready to use

Step 8. Install TOAD 11.6

For some reason, TOAD is best tool for Development Oracle, for link download it hard to find. But I am sorry about my TOAD not right License.

Toad 11.6 x64 is first Toad who can connect to Oracle 64 bit.
Click Toad DBA installer

Click Accept … then Next to continue

If there is blocked Product, just uncheck it, in my case, I cant install Brenchmark and Backup product

At product licensing just Click Next to continue, we will insert License later

For Product Registration, just click No Thanks to continue

Click Finish to complete installation

Now Run Toad for Oracle 11.6 from desktop shortcut

For first time use Toad, Toad will ask Licensing

License Toad, and in my experience, this license work on Toad 10 until Toad 12

Insert License Key and Site Message, then click Apply

This is Toad layout

Follow the previous step, we already have user is hr/hr@orcl, click Connect to continue

Step 7. Configure Forms before use

There is some setting to complete this Guide, for Oracle Forms always use Internet Explorer as browser to run Forms, but sometime it always get some error when open Form. To avoid error just follow this step.

Set Shortcut for Weblogic Admin Server

Run Start Weblogic Admin Server, don’t forget fill username and password weblogic with weblogic/Web_logic

Run Form Builder

Create New Data Block, choose Use the Data Block Wizard

Setting Browser Runtime

Edit -> Preference

Choose Runtime Tab, then Browse Web Browser Location

Search for Intenet Explorer
C:\Program Files\Internet Explorer\iexplore.exe

Try to run runtime form

Follow image below

If Application Blocked, we need to more setting on Java. Follow for next Step

Application Blocked

Open Control Panel

Change view Control Panel from Category to Small Icons, like image below, after that click Java icon there

Go to Security tab then choose Edit Site List

Add forms url, in my case see image below

Click OK to continue, then Restart Internet Explorer Browser

Click Runtime again in Forms Builder

Check I accept the risk … and click Run to continue

Just click Run with the latest version to continue

Check Private Networks, and click Allow access to continue

Result Forms success Run on Internet Explorer

Test Report Builder

On Destop, click Start Report Builder

For first time use, there is will pop up like this,  just check Private network and click Allow access to continue

Report Builder layout, choose Use the Report Wizard then click OK to continue

Follow this Step