Category : B12phpfw Written by w On 2014-05-25 17:01:59

Edit post in op. system file altervista002.txt ⟩⟩
We cre/edit .txt here and del .txt in op.system. TODO: del .txt here).

Edit post data in database table row ⟩⟩

Post summary :

2. Install all 64bit: Oracle DB 11g XE on Windows 10 + Forms 12c + APEX 5.0.3

Image :


Image description :

aaa post_aboutwhatever.txt post_aboutwhatever.txt post_aboutwhatever.txt $tmp_imgpath=/srv/disk16/3266814/www/

Post content :

2. Install all 64bit: Oracle DB 11g XE on Windows 10 + Forms 12c + APEX 5.0.3 HOME - old downloads are here, but better

07. August 2018

I could not find good tutorial for Forms 12 64 bit on Windows 10 64 bit, Oracle DB 11g XE.

So is (I think best) tutorial for  installation (last version) Forms 11 64 bit on Windows 10 64 bit, Oracle DB 11g XE, webstart works. 20. March 2016

I successfully installed Forms 12c which seems to be much better than Forms 11g.
I installed Oracle DB 11XE 64 bit - but this article is still usefull because 64 bit 11XE is simpler installation then 32 bit.
My Newest APEX 5.0.3  installation (slowww) also works on Win10 64 bit.

Help pdf:forms12c_upgrade_forms6i_FSMFA.pdfis interresant, other help pdf-s look good. But they still are :

  • language references = lists of all existing features
    (sometimes also non existing - Lary Ellison's speciality) - encyclopedias
  • there are no gooduser manuals (tutorials) = simple recipes collections
    like this I try to show here.
    May be Oracle wants us to pay his expensive courses ?

All 3 ways of running "Installed successfully..." form described in
work for me. This is best (?) :  New standalone way for end-users to run Oracle Forms applications.

Forms 12c developer runs and connects to DB 11g XE (icon in start folder).

My .fmb & .fmx are in J:\sw\possys12 which I added to my FORMS_PATH in file
so :FORMS_PATH=J:\sw\possys12;**C:\oracle\midw\home_midw\forms;C:\oracle\midw\home_midw\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1

After that I couldrun my tipdok.fmxso :
URL in firefox shows my tipdok.fmx screen :
Release Forms and Reports 12.2.x
GA Date                 Oct 2015
Premier Support Ends    Oct 2020
Extended Support Ends   Oct 2023
Sustaining Support Ends Indefinite
Oracle Forms 12c version can now be used without a browser while still keeping the native appearance of the application.
Either JDK or Java Plugin (JRE) has to be installed on the client PC.
An example of how to use this type of configuration can be found in the Forms web configuration file (formsweb.cfg), present in Forms 12c environment.

Download Oracle Forms12c and help :

and see end this text: [L1], [L2]...

[L1] 02_fusion_admin_ASADM.pdf Administering Oracle Fusion Middleware
[L2] forms12c_deployment_FSDEP.pdf Forms Services Deployment Guide 12c (12.2.1)

My two attempts to install Oracle Forms 11 were unsuccessful (to big, to complicated - nobody starts new projects with Forms 11 - pity - it is great SW developed in wrong direction), but installing Oracle Forms 6i on win 8.1 64 bit and 11g (not XE) was successful (with patch 18 and that two almost 15 years old dll-s instead newer !!)

Forms 12c post installation


  1. Also can be step 2. POSTINST 1  :
    Fusion Middleware Control: Weblogic Server Adminis.Console 12c
    action1111111   start Weblogic (Administration) Server:
    To stop admin server, close the command shell in which it is running.action2222222  start  Weblogic Server Adminis.Console 12c :
    http://sspc1:7001/console   user=weblogic   psw=mypsw*2
  2. Also can be step 1. POSTINST 2  Starting and Stopping Node Manageraction333333   start NodeManager utility which is used to start F or R servers :
    To stop Node Manager, close the command shell in which it is running.
  3. POSTINST 3   Starting and Stopping Managed Servers (F, R...)action444444 Starting/Stopping Managed F/R Servers WLS_FORMS / WLS_REPORTS :
    http://sspc1:7001/console :
    1. Frame "Domain Configurations" -> Servers -> Control Tab
    2. chk box Managed Server eg WLS_FORMS or WLS_REPORTS
    (I have only this two plus AdminServer)
    3. button Start or Resume or ShutDown or...
  4. POSTINST 4  Running Oracle Forms
    DO NOT USE old way Embedded Java applet.action555555 run "Installed successfully..." form Standalone way from CLI (or from .bat)
    cd J:\0downl\1_instalirano\1_oracle\z_doc_oracle
    Enter the following to run your application:
    java -jar frmsal.jar -url "http://sspc1:9001/forms/frmservlet?config=standaloneapp" -t 30000action666666 run "Installed successfully..." form Java Webstart way from ibrowser

Forms 12c installation

Refer to documentation

  1. Deinstall older java SW. Install 64bit JDK (v8U51+)
    01_jdk-8u74-windows-x64.exe191803 kB
    I installed all as administrator
    java -version shows :
    java version "1.8.0_74"
    Java(TM) SE Runtime Environment (build 1.8.0_74-b02)
    Java HotSpot(TM) 64-Bit Server VM (build 25.74-b02, mixed mode)
  2. Install  W e b L o g i c  Server 12c (Infrastructure)
    fmw_12. 1498316 kB
    You do not have to create a WebLogic Server domain Forms and Reports installer can do it. In admin CLI :
    winkey+X -> Comm.prompt admin
    or winkey, cmd , right click -> run as admin
    "C:\Program Files\Java\jdk1.8.0_74\bin\java" -d64 -jar fmw_12.
    (default is C:\Oracle\Middleware\Oracle_Home)
    If you are installing Oracle Forms and Reports on MS Windows, you must make sure that the Node Manager utility that was installed with Oracle WebLogic Server is stopped before you begin Forms installation:
    2.1 Verify the Oracle WebLogic Server Node Manager utility is stopped. If it is running, kill the process.
    2.2 Determine if file is present in WebLogic_Home\common\nodemanager directory.
    a. If the file is not present, continue installing Oracle Forms and Reports.
    b. If the file does exist, open it and verify that the ListenPort parameter is included and that it is set. If the ListenPort parameter is not included or set, edit the file so that it is similar to the following, where NODE_MANAGER_LISTEN_PORT represents the port the Node Manager listens on, such as 5556:
  3. Install Forms and Reports 12c (DEPLOYMENT install.type and select Oracle Home created in step 2. above that contains Infrastructure install).
    3.1 Run as admin:setup_fmw_12. 942641 kB
    3.2 you can skip Auto Update option then click to continue.
    3.3 specify installation directory (see 3.4) :
    when you are going to install forms/reports for DEPLOYMENT install. dir. is Oracle Home that contains infrastructure install:
    not eg c:\oracle\midw\home_f12c (see error 3.3 below)
    which is ok for Forms Builder STANDALONE install.
    3.4 Installation type screen: option to install Oracle Forms Builder Standalone and Oracle Forms & Reports deployment.
    Choose Oracle Forms & Reports DEPLOYMENT
    The standalone installation :
    1. does not allow forms to be run, just built and compiled. To run them, they must be deployed to a full installation of Oracle Forms and Reports Services.
    2 There is no standalone equivalent of Oracle Reports. (see
    3.5 Check system requirements screen, if OK, click next
    3.6 Installation summary screen, click next
    3.7 Installation successful screen with check box to Run Oracle Forms Configuration wizard after installation.
    Do not (?) check box and click Finish to exit the installation.In the Forms configuration wizard, you will be prompted to specify Oracle Forms Instance directory location, so just create a new directory and specify that directory for Forms instance and when the Configuration wizard will complete you can find tnsnames.Ora and other properties files in this directory.
  4. Create repository using RCU GUI:
    forms12c need to install Oracle Repository with at least following components:
    Oracle Platform Security Services containing :
    Audit Services
    Audit Services Append
    Audit Services Viewer
    host name: localhost (  ?)
    service name : XE
    recommended is AL32UTF8 char.set click "Ignore" button
    11g XE db is not certified for use in fusion midw production environm.    click "Ignore" button11.2.0.4+ Ora.DB required, but XE DB is not :
    select banner from v$version where banner like 'Oracle Database%';
    outputs: Oracle Database 11g Express Edition Release - 64bit ProductionDEV schema prefix
    advaced replication not enabled  click "Ignore" buttonIn SQL+ I see 9 new DEV_... users created 19.3.2016.
  5. Create WebLogic Server domain using Config Wizard GUI
    eg base_domain :
    Start GUI Configuration of Forms & Reports with :
       chk box create new domain, located in:
    C:\oracle\midw\home_midw\user_projects\domains\base_domainapplication location:
    C:\oracle\midw\home_midw\user_projects\applications\base_domainadmin user name = weblogic
    psw = your choice (8 char, min. one num or...)autoconfig - RCU data (not manual)vendor OracleDBMS/service  XE (ora7 ?)
    schema owner  DEV_STB
    host name localhost (  port 1521created domain : base_domain
    C:\oracle\midw\home_midw\user_projects\domains\base_domainWebLogic Admin server URL:
  6. Start all servers (how: see postinst above) :
    Node Manager=util which starts not Admin servers, Domain servers are: Admin Server, forms server and reports server and other servers if you have them (I do not)

May 2014


1a.**upgrade-apex-for-xe**_-154969.html   upgrade was unsuccessfull


  • drop all APEX and FLOWS schemas,
  • and fresh install APEX 4.2.5 which was unsuccessfull
    (same as upgrade APEX 4.0 -> 4.2.5)

Thank's to link 1.(snapdba, especcialy Nancy Schorr) I solved partially this, except  can not load images becouse of invalid VIEW XDB.PATH_VIEW

  • and this is my question to more experienced people:

conn xdb/xdb@XE
start C:\oraclexe\app\oracle\product\11.2.0\server\bin\sredi (standard code to show invalid DB objects) outputs:
 3 invalids can not be compiled:

Goal details

At this job end I have:
1. working link
(no error: "Unable to run page sentry in application 4500")
2. select * from all_users order by username;
start C:\oraclexe\app\oracle\product\11.2.0\server\bin\users.sql

<pre -moz-background-clip:="" -moz-background-inline-policy:="" -moz-background-origin:="" -moz-initial;="" -moz-initial;"="" 1.5;="" 10="" 14px;="" 20px;="" 51);="" 51,="" color:="" courier="" font-size-adjust:="" font-size:="" font-stretch:="" font-style:="" font-variant:="" font-weight:="" line-height:="" margin-bottom:="" none;="" normal;="" pitch",courier,monospace;="" rgb(51,="" style="padding: 10px; background: rgb(244, 244, 244) none repeat scroll 0%; overflow: auto; font-family: ">USERNAME  USER_ID  CREATED

ANONYMOUS 35 27-AUG-11 APEX_040200 59 24-MAY-14 APEX_PUBLIC_USER 58 24-MAY-14 CTXSYS 32 27-AUG-11 FLOWS_FILES 57 24-MAY-14 HR 43 27-AUG-11 ...

What / how  do to reach goal
A standard Oracle 32 bit database installation comes bundled with
APEX (Application Express) 3.2.1 by default (DB 11XE R2 32 bit - with 4.0).

  1. upgrade DB 11XE R2 to latest version of APEX (currently 4.2.5 - 24.5.2014)

  2. configure EPG (Embedded PL/SQL Gateway):

    • which uses Oracle XML DB HTTP components within DB itself
    • so no need to run a separate HTTP server.
  3. Download from :

  4. Drag apex folder from, to drop to C:

  5. C:\apex> sqlplus /nolog

  6. drop user APEX_040000 cascade;
    drop user APEX_040200 cascade;   upgrade created this - was unsuccessfull
    drop user APEX_PUBLIC_USER cascade;
    drop user FLOWS_FILES cascade;

  7. @apexins APEX APEX TEMP /i/
    Usage: @apexins
    apex_tbs - name of the tablespace for the APEX user.
    apex_files_tbs - name of the tablespace for APEX files user.
    temp_tbs - name of the temporary tablespace.
    images - virtual directory for APEX images. Define the virtual
    image directory as /i/ for future updates.

  8. Log back into SQLPlus (as above)
    C:\apex> sqlplus /nolog
    change ADMIN account password:
    NOTE: password must min length=6, and contain at least :
    one uppercase letter, one lowercase, one number
    one punctuation character: ( !"#$%&()"
    +,-/:;?_ )

    alter user ANONYMOUS identified by NULL;
    Changed ANONYMOUS password to NULL.
    ALTER USER apex_public_user ACCOUNT UNLOCK;

  10. select username, account_status from dba_users where username = 'XDB';
    Database     User Status

    XDB             EXPIRED  
    if **EXPIRED & LOCKED** then  
    first : alter user xdb account unlock;     then:  
    alter user XDB identified by XDB;
  11. Script to enable anonymous access to XML DB repository.
    Some people said that it didnt help (helped me). Run it if:
    start C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin**epgstat.sql
    outputs: Allow repository anonymous access?   FALSE
            shows also:    nls-language             american_america.al32utf8
    l_configxml XMLTYPE;
    l_value VARCHAR2 (5) := 'true'; (true/false)
    l_configxml := DBMS_XDB.cfg_get ();IF l_configxml.
    '/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') =
    Add missing element.
    XMLType (
    || l_value
    || '
    INTO l_configxml
    FROM DUAL;DBMS_OUTPUT.put_line ('Element inserted.');
    Update existing element.
    DBMS_XDB.cfg_get (),
    INTO l_configxml
    FROM DUAL;DBMS_OUTPUT.put_line ('Element updated.');
    END IF;DBMS_XDB.cfg_update (l_configxml);
    outputs: Element inserted.**
    start C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\epgstat.sql
    Now is: Allow repository anonymous access? TRUE !!!

  12. and load images:
    SQL> @apxldimg.sql APEXHOME
    & FLOW_ USERS:
    PL/SQL: ORA-04045: errors during recompilation/revalidation of XDB.PATH_VIEW

  13. Configure database parameters for APEX
    Check that the JOB_QUEUE_PROCESSES parameter is set to at least 20:
    SHOW PARAMETER job_queue_processes
    ALTER system SET job_queue_processes=20 scope=both;For a small group of concurrent users, Oracle recommends a value
    of 5 for SHARED_SERVERS:
    SHOW PARAMETER shared_servers
    ALTER system SET shared_servers=5 scope=both;

  14. Enable network services (ACL) and XML DB HTTP server
    Re enable the Oracle XML DB HTTP Server port (8080):
    EXEC dbms_xdb.sethttpport(8080);Enable remote HTTP connections (optional):
    EXEC dbms_xdb.setListenerLocalAccess(l_access => FALSE);
    If l_access is set to TRUE, setListenerLocalAccess allows access to
    XML DB HTTP server on the localhost only.
    If l_access is set to FALSE, setListenerLocalAccess allows access to
    XML DB HTTP server on both the localhost and non-localhost interfaces
    i.e. remote connections.By default, the ability to interact with network services is disabled
    in Oracle Database 11g.
    Therefore, you must use DBMS_NETWORK_ACL_ADMIN package to grant
    connect privileges to any host for the APEX_040200 database user:DECLARE
    ACL_PATH VARCHAR2(4000);
    Look for the ACL currently assigned to '' and give APEX_040200
    the "connect" privilege if APEX_040200
    does not have the privilege yet.
    WHERE HOST = '
    ACL_PATH, 'APEX_040200', 'connect'
    ACL_PATH, 'APEX_040200', TRUE, 'connect'
    END IF;
    When no ACL has been assigned to ''.
    'ACL that lets power users to connect to everywhere',
    'APEX_040200', TRUE, 'connect');
    COMMIT;ERROR at line 1: ~~~~ !"#$%&()"*+,-/:;?_ ~~~~
    ORA-04045: errors during recompilation/revalidation of XDB.PATH_VIEW
    ORA-00600: internal error code, arguments: [qctchr : bfl], [4000], [1024], [1],
    [170], [2], [175], [], [], [], [], []
    ORA-06508: PL/SQL: could not find program unit being called:
    ORA-06512: at line 19   ORA-01403: no data found


COL comp_name FOR A30
SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';

COMP_NAME                         VERSION      STATUS
Oracle Application Express    VALID

  • It's hard to find error messages with Apex. To get error messages:
    execute dbms_epg.set_global_attribute('log-level', 7);
    Then look for logs in your Oracle trace directory that start with _s .
    Or grep for epg or apex in that directory and you'll see some errors.

  • Switching to brand new port. I made up 8083 as I wasn't sure
    some settings somewhere were still stuck for 8080.
    Setting it back and forth to 0 and back to 8083 seems to help.
    EXEC dbms_xdb.sethttpport(8083);
    EXEC dbms_xdb.sethttpport(0);
    EXEC dbms_xdb.sethttpport(8083);

  • 8083 never showed up in netstat but it doesn't seem to make a difference

Test scripts: ed C:\oraclexe\app\oracle\product\11.2.0\server\bin\t.sql
start C:\oraclexe\app\oracle\product\11.2.0\server\bin\t.sql
ed C:\apex\tmp.txt - output of t.sql

TXT AFTER EACH POST : I have odd cosmic thoughts every day

Science is an enterprise that should be cherished as an activity of the free human mind...

Venus has a runaway greenhouse effect. ... we're twiddling knobs here on Earth without knowing the consequences of it. Mars once had running water. Something bad happened there as well.


Share your thoughts about this post



~~~$pp1->dbg=1~~~/srv/disk16/3266814/www/ , line 119 SAYS:
Coding step c s 0 1. GLOBAL VARIABLES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~

PHP_OS=Linux, php_uname()=Linux 5.10.138kvmcap #1 SMP Fri Aug 26 07:32:35 UTC 2022 x86_64
OS doc root adress is $this->p p 1->wsroot_ path=/srv/disk16/3266814/www/
Same web server doc root adress is $this->p p 1->wsroot_ url=

Module property pallete like in Oracle Forms :
$this->p p 1
=stdClass Object ( [module_version] => Blog Msg MySQL Feb. 2023 [dbg] => 1 [dbicls] => Db_allsites [stack_trace] => Array ( [0] => Array ( [0] => /srv/disk16/3266814/www/, lin=31 ) [1] => /srv/disk16/3266814/www/, lin=25 (B12phpfw\core\b12phpfw\Autoload::__construct) ) [dir_apl] => glomodul [wsroot_path] => /srv/disk16/3266814/www/ [shares_path] => /srv/disk16/3266814/www/ [site_path] => /srv/disk16/3266814/www/ [module_path] => /srv/disk16/3266814/www/ [shared_dbadapter_obj] => B12phpfw\core\b12phpfw\Db_allsites Object ( [errmsg:B12phpfw\core\b12phpfw\Db_allsites:private] => ) [rblk] => 10 [Home_ctr_obj] => B12phpfw\module\blog\Home_ctr Object ( [pp1:B12phpfw\core\b12phpfw\Config_allsites:private] => stdClass Object *RECURSION* ) [uriq] => stdClass Object ( [i] => read_post [id] => 67 [HELP_ROUTING_AND_URL_QUERY] => ~~~~~~~~~~~~~~~~~ properties = key-keyvalue pairs : LINKALIAS => ?i/HOME_METHOD_TO_CALL/param1/param1value... (? is QS=Query Separator) 1. LINKALIAS 2. URLurlqrystring 3. Router (Config_allsites) extracts (from 2.) IN VIEW SCRIPT IN Home_ ctr CALLED METHOD IN Home_ ctr ,'cre_row_frm' => QS.'i/cc/' METHOD cc or cre_row_frm or... ,'home_url' => QS.'i/home/' METHOD home : key="i", value="home" ,'ldd_category' => QS.'i/del_category/id/' id value we assign in view script after $ p p 1->ldd_category ,'loginfrm' => QS.'i/loginfrm/' METHOD loginfrm (or include script) ,'login' => QS.'i/login/' METHOD login ) [HELP_STATES_ATTRIBUTES] => F O R $_S E S ARR. (D B S H E M A...) ~~~~~~~~~~~~~~~~~ [cncts] => stdClass Object ( ) [states] => stdClass Object ( ) [HELP_PATHS_IN_UTL_CLS] => cs02. R O U T I N G - A D R E S S E S in Config_ allsites.php ~~~~~~~~~~~~~~~~ [wsroot_url] => [shares_url] => [img_url] => [lang] => en [uri_qrystring] => i/read_post/id/67 [uri_qrystring_arr] => Array ( [0] => i [1] => read_post [2] => id [3] => 67 ) [uri_arr] => Array ( [0] => /fwphp/glomodul/blog/ [1] => i/read_post/id/67 ) [module_relpath] => fwphp/glomodul/blog [module_url] => [site_url] => [LINK_ALIASES] => $ p p 1->LINK_ALIAS => HOME METHOD TO CALL ~~~~~ eg1: in view script href="<?=$pp1->home_blog?>" calls home method in Home_ctr so : QS."i/home_blog/"~~~~~ where QS is question mark ("?") = urlQuerySeprator [home_blog] => ?i/home/ [home] => ?i/home/ [sitehome] => ?i/sitehome/ [ldd_category] => ?i/del_category/id/ [ldd_admins] => ?i/del_admins/id/ [ldd_posts] => ?i/del_posts/id/ [ldd_comments] => ?i/del_comments/id/ [filter_page] => p/ [admins] => ?i/admins/ [loginfrm] => ?i/loginfrm/ [login] => ?i/login/ [logout] => ?i/logout/r/i|loginfrm| [read_user] => ?i/read_user/id/ [upd_user_loggedin] => ?i/upd_user_loggedin/r/i|upd_user_loggedin|id| [categories] => ?i/categories/ [posts] => ?i/posts/ [filter_postcateg] => ?i/filter_postcateg/c/ [addnewpost] => ?i/addnewpost/ [read_post] => ?i/read_post/ [editpost] => ?i/editpost/ [edmkdpost] => ?i/edmkdpost/ [readmkdpost] => ?i/readmkdpost/ [comments] => ?i/comments/ [upd_comment_stat] => ?i/upd_comment_stat/ [kalendar] => ?i/kalendar/ [about_us] => ?i/about/ [contact_us] => ?i/contact/ [features] => ?i/features/ ) $_ GET=Array ( [i/read_post/id/67] => ) $_POST=Array ( ) $_SESSION=Array ( [SuccessMessage] => Array ( ) [ErrorMessage] => Array ( ) )

/srv/disk16/3266814/www/ , line 150 SAYS:
Coding step c s 0 2. R O U T I N G ~~~~~~~~~~~~~~~~~~~~~~~~~~~~

$_SERVER['REQUEST_URI'] =/fwphp/glomodul/blog/?i/read_post/id/67

$p p1->uri_ arr is exploded string $_SERVER['REQUEST_URI'] (part1 before QS=? and part2 after QS)
part1 index 0 is $p p 1->module_ relpath=fwphp/glomodul/blog
part2 index 1 is $p p 1<>uri_ qrystring = key-value pairs ee = url parameters after QS = i/read_post/id/67
$this->p p1->uri_ arr=Array ( [0] => /fwphp/glomodul/blog/ [1] => i/read_post/id/67 )

EXPLODED $p p1->uri_ qrystring (on /) is $this->p p1->uri_ qrystring_ arr=Array ( [0] => i [1] => read_post [2] => id [3] => 67 )
method in Home_ ctr and method parameters : $p p 1->u r i q=stdClass Object ( [i] => read_post [id] => 67 [HELP_ROUTING_AND_URL_QUERY] => ~~~~~~~~~~~~~~~~~ properties = key-keyvalue pairs : LINKALIAS => ?i/HOME_METHOD_TO_CALL/param1/param1value... (? is QS=Query Separator) 1. LINKALIAS 2. URLurlqrystring 3. Router (Config_allsites) extracts (from 2.) IN VIEW SCRIPT IN Home_ ctr CALLED METHOD IN Home_ ctr ,'cre_row_frm' => QS.'i/cc/' METHOD cc or cre_row_frm or... ,'home_url' => QS.'i/home/' METHOD home : key="i", value="home" ,'ldd_category' => QS.'i/del_category/id/' id value we assign in view script after $ p p 1->ldd_category ,'loginfrm' => QS.'i/loginfrm/' METHOD loginfrm (or include script) ,'login' => QS.'i/login/' METHOD login )