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

HOME – old downloads are here, but better https://github.com/slavkoss/fwphp/

07. August 2018

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

So https://github.com/slavkoss/fwphp/tree/master/glomodul/help_sw/oracle 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.pdf is 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 good user 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
https://danielsitblog.wordpress.com/tag/oracle-forms-12c/
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
C:\oracle\midw\home_midw\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\default.env
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 could run my tipdok.fmx so :
— URL in firefox shows my tipdok.fmx screen :
http://sspc1:9001/forms/frmservlet?config=webstart&form=tipdok&userid=usr/psw@XE

https://blogs.oracle.com/proactivesupportDevTools/entry/forms_reports_12c_lifetime_support
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

https://blogs.oracle.com/proactivesupportDevTools/entry/browser_less_access_to_forms
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 :

http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html
http://docs.oracle.com/middleware/1221/formsandreports/index.html

help: https://oracle-base.com/
https://oracle-base.com/articles/12c/articles-12c
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

NEXT STEPS & ACTIONS WORK FOR ME :

  1. Also can be step 2. POSTINST 1  :
    Fusion Middleware Control: Weblogic Server Adminis.Console 12c
    action1111111   start Weblogic (Administration) Server:
    C:\oracle\midw\home_midw\user_projects\domains\base_domain\bin\startWebLogic.cmd
    To stop admin server, close the command shell in which it is running.action2222222  start  Weblogic Server Adminis.Console 12c :
    http://host:port/console
    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 :
    C:\oracle\midw\home_midw\user_projects\domains\base_domain\bin\startNodeManager.cmd
    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
    http://sspc1:9001/forms/frmservlet?config=webutil_webstart

 

Forms 12c installation

Refer to documentation

  1.  Deinstall older java SW. Install 64bit JDK (v8U51+)
    01_jdk-8u74-windows-x64.exe 191803 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.2.1.0.0_infrastructure.jar 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.2.1.0.0_infrastructure.jar
    c:\oracle\midw\home_midw
    (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 nodemanager.properties file is present in WebLogic_Home\common\nodemanager directory.
    C:\oracle\midw\home_midw\user_projects\domains\base_domain\nodemanager\
    a. If the nodemanager.properties file is not present, continue installing Oracle Forms and Reports.
    b. If the nodemanager.properties 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 nodemanager.properties 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:
    ListenPort=NODE_MANAGER_LISTEN_PORT
  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.2.1.0.0_fr_win64.exe  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:
    c:\oracle\midw\home_midw
    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 https://oracle-base.com/articles/12c/standalone-forms-builder-12c-installation-on-windows-1221)
    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
    C:\oracle\midw\home_midw\oracle_common\bin\rcu.bat
    host name: localhost (127.0.0.1  ?)
    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” button
    11.2.0.4+ Ora.DB required, but XE DB is not 11.2.0.4 :
    select banner from v$version where banner like ‘Oracle Database%’;
    outputs: Oracle Database 11g Express Edition Release 11.2.0.2.0 – 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 :
    C:\oracle\midw\home_midw\oracle_common\common\bin\config.cmd
       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 (dbhost.example.com)  port 1521created domain : base_domain
    C:\oracle\midw\home_midw\user_projects\domains\base_domainWebLogic Admin server URL:
    http://sspc1:7001/console
  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

1. http://www.snapdba.com/2013/04/installing-apex-4-2-and-configuring-embedded-plsql-gateway-epg/
2. https://community.oracle.com/thread/2344127?tstart=0
3. http://dbswh.webhop.net/apex/f?p=BLOG:HOME:0

1a. http://www.oracle.com/technetwork/developer-tools/apex/application-express/upgrade-apex-for-xe-154969.html  — upgrade was unsuccessfull

Here:
– 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:
ALTER TRIGGER XDB.XDB_PV_TRIG COMPILE;
ALTER PACKAGE BODY XDB.DBMS_XSLPROCESSOR COMPILE;
ALTER VIEW XDB.PATH_VIEW COMPILE;

Goal details
==========

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

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 11.2.0.3 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.
  1. Download apex_4.2.5.zip from :
    http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
  2. Drag apex folder from apex_4.2.5.zip, to drop to C:
  3. C:\apex> sqlplus /nolog
    SQL> CONNECT SYS/YOURSYSPSW@XE as SYSDBA
  4. 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;
  5. @apexins APEX APEX TEMP /i/
    Usage: @apexins <apex_tbs> <apex_files_tbs> <temp_tbs> <images>
    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.
  6. Log back into SQL*Plus (as above)
    C:\apex> sqlplus /nolog
    CONNECT SYS/YOURSYSPSW@XE as SYSDBA
    change ADMIN account password:
    @apxchpwd
    NOTE: password must min length=6, and contain at least :
    one uppercase letter, one lowercase, one number
    one punctuation character: ( !”#$%&()“*+,-/:;?_ )
  7. ALTER USER anonymous ACCOUNT UNLOCK;
    alter user ANONYMOUS identified by NULL;
    Changed ANONYMOUS password to NULL.
    ALTER USER xdb ACCOUNT UNLOCK;
    ALTER USER apex_public_user ACCOUNT UNLOCK;
    ALTER USER flows_files ACCOUNT UNLOCK;
  8. 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;
  9. 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
    SET SERVEROUTPUT ON
    DECLARE
    l_configxml XMLTYPE;
    l_value VARCHAR2 (5) := ‘true’; — (true/false)
    BEGIN
    l_configxml := DBMS_XDB.cfg_get ();IF l_configxml.
    EXISTSNODE (
    ‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access’) =
    0
    THEN
    — Add missing element.
    SELECT INSERTCHILDXML (
    l_configxml,
    ‘/xdbconfig/sysconfig/protocolconfig/httpconfig’,
    ‘allow-repository-anonymous-access’,
    XMLType (
    ‘<allow-repository-anonymous-access xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”>’
    || l_value
    || ‘</allow-repository-anonymous-access>’),
    ‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘)
    INTO l_configxml
    FROM DUAL;DBMS_OUTPUT.put_line (‘Element inserted.’);
    ELSE
    — Update existing element.
    SELECT UPDATEXML (
    DBMS_XDB.cfg_get (),
    ‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()’,
    l_value,
    ‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘)
    INTO l_configxml
    FROM DUAL;DBMS_OUTPUT.put_line (‘Element updated.’);
    END IF;DBMS_XDB.cfg_update (l_configxml);
    DBMS_XDB.cfg_refresh;
    END;
    /outputs: Element inserted.
    start C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\epgstat.sql
    — Now is: Allow repository anonymous access? TRUE !!!
  10. and load images:
    SQL> @apxldimg.sql APEX_HOME
    -> SAME ERR UPGRADE AS AFTER DROP APEX_ & FLOW_ USERS:
    ======================================================
    PL/SQL: ORA-04045: errors during recompilation/revalidation of XDB.PATH_VIEW
  11. 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;
  12. 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);
    BEGIN
    — Look for the ACL currently assigned to ‘*’ and give APEX_040200
    — the “connect” privilege if APEX_040200
    — does not have the privilege yet.
    SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
    WHERE HOST = ‘*’ AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
    IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(
    ACL_PATH, ‘APEX_040200’, ‘connect’
    ) IS NULL THEN
    DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
    ACL_PATH, ‘APEX_040200’, TRUE, ‘connect’
    );
    END IF;
    EXCEPTION
    — When no ACL has been assigned to ‘*’.
    WHEN NO_DATA_FOUND THEN
    DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(‘power_users.xml’,
    ‘ACL that lets power users to connect to everywhere’,
    ‘APEX_040200’, TRUE, ‘connect’);
    DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(‘power_users.xml’,’*’);
    END;
    /
    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:
    “SYS.DBMS_NETWORK_ACL_ADMIN”
    ORA-06512: at line 19   ORA-01403: no data found

 

OTHER USEFULL (?) COMMANDS

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

COMP_NAME                         VERSION      STATUS
Oracle Application Express     4.2.5.00.08    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

1. Install Apache, PHP, Oracle DB 11g XE & 11g, Oracle Forms 6i and 12c & Reports on Win 10 (all 64bit)

HOME   Downloads are now:  https://github.com/slavkoss/fwphp

26.oct.2019 I use 64 bit XAMPP: PHP 7.3.7 AND APACHE 2.4.38. on Windows 10 64 bit. PDO: mysql, oci, sqlite ARE WORKING.Oracle db 11gXE (no more E. Rangel pdooci – pdo sintax on oci8 program layer).

I tried 4-5 WAMP server SW WAMP and ZWAMP are ok but XAMPP unzip is  simplest – almost 1 click . WAMP has problem with composer installations from Windows command line. Next shows more details (I do not use ZWAMP recently) :

  1. Unzip zwamp-x64-2.2.1-full.zip to J:\zwamp64
  2. Rename old J:\zwamp64\vdrive\.sys\Apache2 dir to Apache2_2_4_16
  3. Download Apache : http://www.apachelounge.com
    Create dir J:\zwamp64\vdrive\.sys\Apache2.
    Unzip httpd-2.4.20-win64-VC14.zip – it’s Apache24 folder content to :
    ServerRoot J:/zwamp64/vdrive/.sys/Apache2 (or c:/Apache24 = ServerRoot) in httpd.conf
    Default folder for your your webpages is DocumentRoot
    DocumentRoot J:/zwamp64/vdrive/.sys/Apache2/htdocs
    Directories
    ScriptAlias – also when you use extra folder config file(s) change to your location there
  4. No changes in J:\zwamp64\vdrive\.sys\Apache2_2_4_16\conf\extra
  5. changes in J:\zwamp64\vdrive\.sys\Apache2\conf :
    copy here own httpd.conf ver 2.4.16 to conf dir (rename original before copying)
    copy here own vhosts.conf ver 2.4.16 to conf dir
  6. J:\zwamp64\vdrive\.sys\Apache2\conf\httpd.conf :
    LoadModule php7_module /.sys/php/php7apache2_4.dll
    AddType application/x-httpd-php .php# without this OCI8 and PDO MySQL and PDO sqlite are not visible in inet browser
    are visible in php CLI
    PHPIniDir /.sys/php
  7. Download PHP:  http://windows.php.net/download/
    php-7.0.8-Win32-VC14-x64.zip
     same unzip as apache zip above.
  8. Downloadnewest oci8-2.1.1 Extension for php 7.0.8 64 bit on Windows 10 64 bit – april 2016 (older does not work) :
    OCI8 is also for E.Rangels PDOOCI.
    https://pecl.php.net/package/oci8/2.1.1/windows  – Windows dll-s
    https://pecl.php.net/package/oci8   – for Linux
    released by [email protected]
    https://blogs.oracle.com/opal/entry/php_7_oci8_2_1
    php_oci8-2.1.1-7.0-ts-vc14-x64_Jones_pecl.php.net.zip
    Unzip it’s dll-s to: 
    J:\zwamp64\vdrive\.sys\php\ext
    Christopher Jones’s oci8-2.1.1 for php 7 :
    dir J:\zwamp64\vdrive\.sys\php\ext\php_oci*.*
    18.04.2016.  05:20   155.136 php_oci8.dll
    18.04.2016.  05:20   790.528 php_oci8.pdb – WHAT IS THIS ?
    18.04.2016.  05:20   157.184 php_oci8_11g.dll
    18.04.2016.  05:20   790.528 php_oci8_11g.pdb
    18.04.2016.  05:20   158.208 php_oci8_12c.dll
    18.04.2016.  05:20   790.528 php_oci8_12c.pdb
    7 File(s)      2.997.248 bytes
  9. J:\zwamp64\vdrive\.sys\php\php.ini
  10. 2click J:\zwamp64\zwamp.exe -> right click house icon -> restart
    -> started Apache and MySQL. If not both started very useful is :
    J:\zwamp64\vdrive\.sys\Apache2\bin>httpd.exe
    – this report errors, same as :
    php -v
    PHP 7.0.8 (cli) (built: Jun 21 2016 15:15:15) ( ZTS )
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    or
    php -r “var_dump(function_exists(‘oci_connect’));”
    or
    C:\WINDOWS\system32>php -r “if (! $dbc = oci_pconnect(‘hr’, ‘hr’, ‘ora7’, ‘UTF8’)) echo ‘***** 1. UNSUCCESSFULL db connect *****’; else {echo \”\n\”; echo ‘~~~~~~~~~~~  PARSE-BIND-EXECUTE-FETCH ~~~~~~~~~~’; echo \”\n\”; echo ‘SUCCESSFULL db connect’; echo \”\n\”;  $dml=’SELECT first_name, phone_number FROM (SELECT first_name, phone_number FROM employees ORDER BY first_name) where rownum < 3′; echo $dml; echo \”\n\”; $parse_stid = oci_parse($dbc, $dml);  if (!$parse_stid) {   $m = oci_error($conn);    echo ‘skripta: ‘ . __FILE__ ;   echo’ says neuspio oci_parse : ‘ ;   echo $m[‘message’]; }   $exec_ret =  oci_execute($parse_stid);       echo ‘oci_execute returned: ‘;     print_r($exec_ret);        echo \”\n\”; echo ‘oci_fetch_array returned: ‘;  $row = oci_fetch_array($parse_stid, OCI_ASSOC + OCI_RETURN_NULLS); print_r($row); }”WHICH DISPLAYS:~~~~~~~~~~~  PARSE-BIND-EXECUTE-FETCH ~~~~~~~~~~
    SUCCESSFULL db connect
    SELECT first_name, phone_number FROM (SELECT first_name, phone_number FROM employees ORDER BY first_name) where rownum < 3
    oci_execute returned: 1
    oci_fetch_array returned: Array
    (
    [FIRST_NAME] => Adam
    [PHONE_NUMBER] => 650.123.2234
    )
  11. Not needed if we use ZWAMP :
    Install Apache as a service:
    httpd.exe -k install   httpd.exe -k restart, or stop
    ApacheMonitor: (not needed if we use ZWAMP):
    Double click ApacheMonitor.exe, or put it in your Startup folder.

 

 

28.11.2015 INSTALLATION APACHE 2.4.16 (Win64)  & PHP 7.0.0 RC5 MSVC14 (Visual C++ 2015) x64 ON J:\zwamp\vdrive\.sys\Apache2 (& …\php) OR ON C DISK

Install as a service (not needed if using XAMPP or ZWAMP or WAMP):
httpd.exe -k install
httpd.exe -k  restart

httpd.exe -k stop  
ApacheMonitor: Double click ApacheMonitor.exe, or put it in your Startup folder.

Use PGP Signature and/or the SHA Checksums to verify the integrity.
C:\gnuwin32\bin\sha1sum.exe -help
sha1sum.exe -b J:\0downl\1_instalirano\Apache_httpd-2.4.16-win64-VC14.zip :
d917094cf13ecea83938aa58058ea7c5c6ef2756
Checksums created with GPGHash by SmartJuwel
Creation date: 22.07.2015 with GnuPG Version: 1.4.18
SHA1-Checksum for: httpd-2.4.16-win64-VC14.zip:
D917094CF13ECEA83938AA58058EA7C5C6EF2756
or SHA224-Checksum or SHA256-Checksum or SHA384-Checksum

php http://windows.php.net/qa/ For Apache on Windows: Thread Safe

I did not used Instant Client :
Oracle Database drivers for popular languages and environments including Node.js, Python and PHP can use Instant Client to connect to local or remote DBs.
https://community.oracle.com/thread/1051752 :
1. Download 64 or 32-bit Oracle Instant Client – there is no MSVC14 build 6.8.2015
2. put it somewhere useful (I put it under my php directory)
3. Add it to your system’s PATH. (A quick & dirty fix on Windows is to copy
all of the *.dll files   from the 11g InstantClient package* into same dir
as your webserver’s executable (e.g. httpd.exe).)
http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html
4. Edit your php.ini and uncomment extension=php_oci8_11g.dll

I did not 1. to 4. above !

Stories on WEB that excellent (but never finished and abandoned) old 32 bit F6i, R6i SW and new Windows do not work together are not true. See also – they managed same as I (good site, could give more details):
Installing Oracle Developer (forms & reports 6i) on Windows 7 64bit
and
Oracle Developer 6i & Oracle database 11g R2 (11.2.0.1.0)
Great question to Oracle who says “we do not leave our customers who still use F6i & R6i” – but F6i & R6i can not even be downloaded from Oracle:
Why 32 bit F6i & R6i can not be patched to be certificated on 64 bit 11g and 64 bit Windows ? Oracle Power Objects (SW simmilar to F6i & R6i ) is also abandoned SW.
Today is modern to make new SW, worse than old (nobody begins new project with F11 & R11 – they are rather applications than development SW) and forget poor bastards who bought abandoned SW. So they cut their expenses (and our lifes). Simmilar stories are Microsoft ASP-VS2008-Silverlight, Google AngularJS 1.x – 2.x, over 100 development SW around…
Incompetent managers and trade departments cut our lifes, but they should know that life is not child joke.

APACHE – USE THREAD SAFE (TS) VERSIONS OF PHP BINARIES FOR WINDOWS
MULTITHREAD CAPABLE BINARIES BUILDS – INTERACTION WITH A MULTITHREADED SAPI AND PHP LOADED AS A MODULE INTO A WEB SERVER.

Use Apache builds provided by Apache Lounge – PHP official site use their binaries to build Apache SAPIs.

VC9 builds require you to have the Visual C++ Redistributable for Visual Studio 2008 SP1 x86 or x64 installed.
VC11 builds require to have the Visual C++ Redistributable for Visual Studio 2012  x86 or x64 installed. and so on

PECL FOR WINDOWS:PECL extensions for Windows is being worked on. Windows DLL can be downloaded right from thePECL website.
PECL extension release and snapshot build directories are browsable directly.

Not needed for 64 bit Apache, PHP, 11XE all three on home PC..
Download from http://www.oracle.com/technetwork/topics/winx64soft-089540.html
instantclient-basic-windows.x64-12.1.0.1.0.zip (64,939,911 bytes) (cksum – 3658834848)
extract to:  C:\Windows\SysWOW64\instantclient_12_1
and set it on Win PATH variable + H:\Apache24\bin,
(NO:    THERE ARE MORE PHP INSTALLATIONS  (only 1 Apache):    + H:\php)

C:\Apache24\bin>echo %SystemRoot%
outputs: C:\Windows

C:\Apache24\bin>path

extension=php_oci8_11g.dll (remove the “;” from the start of the line)

Restart Apache (XAMPP or WAMP server)

Open  file to see database name as
C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora
// D:\app\Farhan\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.168.1.2)
)
)

Service name is “orcl.168.1.2”,  my is: XE :

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sspc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  ) 
ora7 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sspc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  ) 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

See  https://github.com/slavkoss/fwphp/blob/master/fwphp/glomodul/z_examples/index.php
for  httpd.conf, vhosts.conf, C:\Windows\System32\drivers\etc\hosts, php.ini