Tag Archives: Application Express

Unable to access Application Express

In web browser, navigated to http://shrivastava.test.int:7777/pls/apex. Received message:

Forbidden
You don't have permission to access /pls/apex/apex on this server.
----------------------------------------------------------
Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at SHRIVASTAVA.TEST.INT Port 7777

Solution:

Password in the dads.conf (C:oracleproduct10.2.0http_1Apachemodplsql confdads.conf ) file is incorrect. Confirm by logging on to SQL*Plus as user APEX_PUBLIC_USER. Correct password, then bounce Apache web server.

Installing Oracle Application Express

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