Tech Touch Online

Installation Steps:

1. First create a folder named app_server in any directory
2. go to the software to install and double click install.exe
3. give proper path at the fields
   app_server
   g:\app_server (Path)
4. follow the step by step wizard

administrator username : ias_admin
instance name : ias_admin
password assad123


5. You have to 'Retry' at any stage like OC4J instance configuration assistant
6.installation complete

Configuration

1.C:\app_server\forms\java\oracle\forms\registry\Registry.dat
app.ui.lovButtons=true
app.ui.requiredFieldVA=true


2. you can copy required files from
https://drive.google.com/folderview?id=0B9MhlLcy4ecVTkJCbWxlcmtoQkE&usp=sharing
C:\app_server\forms
C:\app_server\forms\server
C:\app_server\forms\java


3. C:\app_server\forms\server\formsweb.cfg

[HRD]
form=D:\HRD\FORMS\hrm_project.fmx
userId=hrd/hrd@orcl
workingDirectory=D:\HRD
pageTitle=Lumineux ERP.
baseHTMLjinitiator=webutiljpi.htm
imageBase=Codebase
archive=frmall.jar,fjutilities.jar,rolloverbutton.jar,images.jar,getclientinfo.jar,frm

webutil.jar,jacob.jar,banner.jar,DualPDFPrint.jar
#archive_jini=frmall_jinit.jar,fjutilities.jar,rolloverbutton.jar,images.jar,getclient

info.jar,frmwebutil.jar,jacob.jar
colorScheme=blue
otherparams=useSDI=yes
separateFrame=true
logo=none
background=none
splashScreen=none
#width="style="width: expression(document.body.clientWidth/2+'px');""
#height="style="height: expression(document.body.clientHeight+'px');""
# Parameters related to webutil
WebUtilArchive=frmwebutil.jar,jacob.jar,banner.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
# Parameters related to show progress of jar files loader
java_showprogress=true
pageTitle=Lumineux ERP.
java_preloadjars=frmall_jinit.jar,frmwebutil.jar,jacob.jar,fjutilities.jar,rolloverbut

ton.jar,images.jar,getclientinfo.jar
em_mode=1

4. C:\app_server\reports\conf\rwservlet.properties
copy SERVER=rep_Programmer_app_server

5. C:\app_server\reports\conf\cgicmd.dat

paste it at the end of server ...
TEST: userid=hr/hr@erp SERVER=rep_Programmer_app_server%*

SETUP:

Create a new tablespace to act as the default tablespace for APEX.

CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/ldb/apex02.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M;

Installation

Change directory to the directory holding the unzipped APEX software.

$ cd /u01/app/oracle/product/11.2.0.3/dbhome_1/apex
Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX APEX TEMP /i/

Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apxchpwd.sql
Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_rest_config.sql

OHS Configuration

Change the password and unlock the APEX_PUBLIC_USER account. This will be used for any Database Access

Descriptors (DADs).

SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY 123 ACCOUNT UNLOCK;

Embedded PL/SQL Gateway (EPG) Configuration

Run the "apex_epg_config.sql" script, passing in the base directory of the installation software as a

parameter.

SQL> CONN sys@pdb1 AS SYSDBA
SQL> @apex_epg_config.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Unlock the ANONYMOUS account.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
If this is an upgrade to an existing APEX installation, you will also have to run the following script, to

update the images.

SQL> @apxldimg.sql /u01/app/oracle/product/11.2.0.3/dbhome_1
Check the port setting for XML DB Protocol Server.

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
          0

1 row selected.

SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.

SQL> EXEC DBMS_XDB.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL>


For future reference, to get to the Apex Administration Services:

http://127.0.0.1:8080/apex/apex_admin

n.b.:https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation

n.b.:https://oracle-base.com/articles/8i/collections-8i#index-by-tables

Oracle uses collections in PL/SQL the same way others languages use arrays. Oracle provices three basic collections,
each with an assortment of methods,

1.Index-by Tables
2.Nested Table
3.Varry

1.Index-by Tables:
i. No upper bounds
ii. the collection is indexed using BINARY_INTEGER

SET SERVEROUTPUT ON ;
Declare
Type arr_number is table of number index by BINARY_INTEGER;
v_empno arr_number;
v_index number;
v_count number:=0;
begin
for i in 1..5 loop
v_empno(i):= i;
v_count := i;
end loop;
for j in 1..v_count  loop
dbms_output.put_line (v_empno(j));
end loop;
end;


2.Nested Table
...

3.Varry
...