Tag Archives: Application Express

Unable to access Application Express

Posted by on March 10, 2009 No comments

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

Posted by on July 10, 2007 No comments

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