This documentation shows the steps covered in installing Oracle Application Express.
Refer to: http://www.oracle.com/technology/products/database/application_express/index.html
10gR1 Installation
Step 1: Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.
Step 2: Install HTML DB from Oracle Database 10g Companion CD.
Step 3: Point browser to http://oracleserver.support.com:7777/pls/htmldb
10gR2 Installation
Step 1: Install Oracle Database 10g on Windows machine using the Oracle Database 10g Release 1 (10.1.0.2) for Microsoft Windows (32-bit) CD.
Issue encountered where it was not able to write to directory. It was defaulting to D:oracleoradata for the data files. This is the CD-ROM drive, so I had to do Advanced installation and specify E:oracleoradata.
Step 2: Install HTML DB from Oracle Database 10g Companion CD.
Step 3: Point browser to http://oracleserver.support.com:7777/pls/htmldb
VIS12 Installation
Step 1: Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.
Step 2: To determine products installed, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/ and source the environment
(. ./VIS12_appslinux.env).
Step 3: Next, navigate to /u5/oracle/VIS12/db/tech_st/10.2.0/oui/bin and run runInstaller (./runInstaller)
Step 4: Download and install the apex_3.0.zip file from Oracle.com onto any directory that applmgr owns (e.g. /u0).
Step 5: Unzip apex_3.0.zip into the /u0 directory.
[applmgr@appslinux 9.2.0]$ cd /u0/
[applmgr@appslinux u0]$ unzip apex_3.0.zip
Step 6: The VIS12 instance shall be used. Navigate to the VIS12 10.2.0 Oracle Home and source the environment.
[applmgr@appslinux u0]$ cd /u5/oracle/VIS12/db/tech_st /10.2.0/
[applmgr@appslinux 10.2.0]$ . ./VIS12_appslinux.env
[applmgr@appslinux apex]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 10 18:29:00 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select tablespace_name from dba_tablespaces order by 1;
TABLESPACE_NAME
------------------------------
APPS_CALCLIP
APPS_OMO
APPS_TS_ARCHIVE
APPS_TS_DISCO
APPS_TS_DISCO_OLAP
APPS_TS_INTERFACE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TOOLS
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_UNDOTS1
B2B_DT
B2B_IDX
B2B_LOB
B2B_RT
BAM
CTXSYS
CWMLITE
DCM
DISCO_PTM5_CACHE
DISCO_PTM5_META
DSGATEWAY_TAB
GEOR_TBS
HTMLDB
IAS_META
MTR
NOETIX
NON_APPS_TS_DATA
OCATS
ODM_DATA
OLTS_ATTRSTORE
OLTS_BATTRSTORE
OLTS_CT_STORE
OLTS_DEFAULT
OLTS_SVRMGSTORE
OPMOR
ORABPEL
OWAPUB
PORTAL
PORTAL_DOC
SYNCSERVER
SYSAUX
SYSTEM
TEMP1
TEMP2
XDB
55 rows selected.
SQL>
VIS4 Installation
Step 7: Log on to the appslinux server either at the console or via VNC and load the Terminal Command Line.
Step 8: Download and install the apex_3.0.zip file from Metalink onto any directory that applmgr owns (e.g. /u0).
Step 9: Unzip apex_3.0.zip into the /u3 directory.
[applmgr@appslinux 9.2.0]$ cd /u0/
[applmgr@appslinux u3]$ unzip apex_3.0.zip
Step 10: The VIS4 instance shall be used. Navigate to the VIS4 9.2.0 Oracle Home and source the environment.
[applmgr@appslinux u3]$ cd /u3/oracle/vis4db/9.2.0/
[applmgr@appslinux 9.2.0]$ . ./VIS4_appslinux.env
Step 11: Change directory to the apex working directory.
[applmgr@appslinux u3]$ cd /u0/apex
[applmgr@appslinux apex]$ ls
apex_epg_config11.sql core
apex_epg_config.sql coreins.sql
apexins.sql doc
apexvalidate.sql images
apxconf.sql load_trans.sql
apxremov.sql owa
apxxepwd.sql utilities
builder welcome.html
Step 12: Log on to sqlplus and check if the required tablespaces exist:
[applmgr@appslinux apex]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Jun 27 10:51:04 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Pro duction
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> select tablespace_name from dba_tablespaces order by 1;
TABLESPACE_NAME
------------------------------
APPS_TS_ARCHIVE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_TX_INTERFACE
APPS_UNDOTS1
CTXSYS
TABLESPACE_NAME
------------------------------
DATA
ODM
OLAP
OWAPUB
PORTAL
SYNCSERVER
SYSTEM
TEMP
19 rows selected.
Step 13: The Temp tablespace exists, but there is no SYSAUX. This tablespace shall be created for use with APEX.
SQL> create tablespace sysaux
datafile '/u3/oracle/vis4data/sysaux.dbf' size 32M
autoextend on
maxsize unlimited
permanent
online
extent management local;
Tablespace created.
Step 14: Run the command:
SQL> @ apexins oracle sysaux sysaux temp /i/
Step 15: Run the command:
SQL> @apex_epg_config11 /u0
Step 16: Run the command:
SQL> alter user anonymous account unlock;
User altered.
Step 17: Run the command:
SQL> select dbms_xdb.gethttpport from dual;
GETHTTPPORT
-----------
0
Step 18: Run the command:
SQL> exec dbms_xdb.sethttpport(8080);
Step 19: Run the command:
[applmgr@appslinux ~]$ cd /u5/oracle/VIS12/apps/apps_st/ appl/
[applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env
[applmgr@appslinux appl]$ cp -rf /u0/apex/images/ /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/Apache/
To source 9.2.0 RDMBS environment:
cd /u5/oracle/VIS12/db/tech_st/10.2.0/
. ./VIS12_appslinux.env
[applmgr@appslinux appl]$ . ./APPSVIS12_appslinux.env
[applmgr@appslinux appl]$ echo $ORACLE_HOME
/u5/oracle/VIS12/apps/tech_st/10.1.2 (INCORRECT HTTPD HOME)
SQL to remove schemas after a failed new installation
drop user flows_030000 cascade;
drop user flows_files cascade;
SQL to remove Oracle Application Express from the Database
@apxremov.sql
drop user FLOWS_010500 cascade;
drop user FLOWS_020000 cascade;
select username from dba_users order by 1;
select owner, object_name, object_type, status from dba_objects where status = ‘INVALID’;
SQL to install Oracle Application Express from the Database
@apexins oracle sysaux sysaux temp1 /i/
THE BELOW IS CORRECT:
/u5/oracle/VIS12/inst/apps/VIS12_appslinux/ora/10.1.3
Location of updated dads.conf: /u5/oracle/VIS12/apps/tech_st/10.1.2/Apache/modplsql/conf
Log file:
/u5/oracle/VIS12/inst/apps/VIS12_appslinux/logs/ora/10.1.3/Apache/
To stop and start HTTP server:
/u5/oracle/VIS12/inst/apps/VIS12_appslinux/admin/scripts
Recent Comments