Apex 3.2 Installation

Install http server (it’s can be found on 10g companion cd)

Dwnload and unzip

E:\oracle\apps\apex

Change your working directory to apex.

E:> cd \oracle\apps\apex

Create a table space called apex for oracle apex

Checking the shared_pool_size of the Target Database

SHOW PARAMETER PFILE;

SHOW PARAMETER SHARED_POOL_SIZE

ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;

SHUTDOWN

STARTUP

Oracle XML DB Requirement, Oracle Text Requirement

Oracle XML DB must be installed in the Oracle database that you want to use. If you

are using a preconfigured database created either during an installation or by

Database Configuration Assistant (DBCA), Oracle XML DB is already installed and

Configured.

Select comp_name “component” from dba_registry;

PL/SQL Web Toolkit

Oracle Application Express requires the PL/SQL Web Toolkit version 10.1.2.0.6 or

later.

Checking for PL/SQL Web Toolkit

Select owa_util.get_version from dual;

if current version is below this , install as follow

Installing the PL/SQL Web Toolkit 10.1.2.0.6

--------------------------------------------

1) Stop all applications using the database

2) Navigate to the directory apex/owa

3) Connect via SQL*Plus as the database user SYS

4) Run the PL/SQL Web Toolkit installation script by issuing: @owainst.sql

5) Review the output displayed from owainst.sql and ensure no errors were encountered.

6) Confirm the PL/SQL Web Toolkit version is 10.1.2.0.6 or greater by connecting to the database

select owa_util.get_version from dual;

7) Run the utlrp.sql script from the Oracle Database home to recompile all invalid PL/SQL

packages

To run utlrp.sql, issue: @?/rdbms/admin/utlrp.sql

Start SQL*Plus and connect to the database where Oracle Application Express is

installed as SYS specifying the SYSDBA role. For example:

Now we are going to run apex installation script

If you are not on apex location yet change directory to apex

E:> cd \oracle\apps\apex

Connect as sys and run the script as follows

@apexins apex apex TEMP /i/

tablespace_apex is the name of the tablespace for the Oracle

Application Express application user.

– tablespace_files is the name of the tablespace for the Oracle

Application Express files user.

– tablespace_temp is the name of the temporary tablespace.

– images is the virtual directory for Oracle Application Express images. To

support future Oracle Application Express upgrades, define the virtual

image directory as /i/.

Change the Password for the ADMIN Account

1. Change your working directory to the apex directory where you unzipped the

installation software.

On Windows:

SYSTEM_DRIVE:\ sqlplus /nolog

SQL> CONNECT SYS as SYSDBA

Enter password: SYS_password

3. Run apxchpwd.sql. For example:

@apxchpwd

When prompted enter a password for the ADMIN account.

Configure Oracle HTTP Server Distributed with Oracle Database Oracle Application Server 10g

Unlocking the APEX_PUBLIC_USER Account

The APEX_PUBLIC_USER account is locked at the end of a new installation of Oracle

Application Express. You must unlock this account before configuring the database

access descriptor (DAD) in a new installation.

Connect as sysdba

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password

Where new_password is the new password you are setting for APEX_PUBLIC_

USER. You will use this password when creating the DAD in the sections that

follow.

Copy the Images Directory

Copy E:\oracle\apps\apex\images e:\oracle\apps\http_server\apache\

Editing the dads.conf File If this is a new installation of Oracle Application Express, you

must edit the dads.conf file. The dads.conf file contains the information about the

DAD to access Oracle Application Express.

Go to the dads file location

http_home\apache\mod_plsql

open dads.conf with any text editor

replace ORACLE_HTTPSERVER_HOME, host, port,

service_name, and apex_public_user_password with values appropriate

for your environment.

Alias /i/ "ORACLE_HTTPSERVER_HOME/Apache/images/"

AddType text/xml xbl

AddType text/x-component htc

Order deny,allow

PlsqlDocumentPath docs

AllowOverride None

PlsqlDocumentProcedure wwv_flow_file_mgr.process_download

PlsqlDatabaseConnectString host:port:service_name ServiceNameFormat

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

PlsqlAuthenticationMode Basic

SetHandler pls_handler

PlsqlDocumentTablename wwv_flow_file_objects$

PlsqlDatabaseUsername APEX_PUBLIC_USER

PlsqlDefaultPage apex

PlsqlDatabasePassword apex_public_user_password

PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize

Allow from all

Locate the line containing PlsqlNLSLanguage set as follows

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

Ex:

## edited by yoonus on 7 Feb 2009

Alias /i/ "/orasoft/http_server/Apache/images/"

AddType text/xml xbl

AddType text/x-component htc

Order deny,allow

PlsqlDocumentPath docs

AllowOverride None

PlsqlDocumentProcedure wwv_flow_file_mgr.process_downloadd

PlsqlDatabaseConnectString localhost:1521:orcl ServiceNameFormat

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

PlsqlAuthenticationMode Basic

SetHandler pls_handler

PlsqlDocumentTablename wwv_flow_file_objects$

PlsqlDatabaseUsername APEX_PUBLIC_USER

PlsqlDefaultPage apex

PlsqlDatabasePassword jameela

PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize

Allow from all

After setting up save this configuration, stop http server and restart

http://hostname:7777/pls/apex

defualt port for httpserver if you changed it give the port accordingly

Comments

Post a Comment

Popular posts from this blog

Error processing request - Contact your application administrator apex 20.1

Image
After upgrading 11.2.0.4 to 19c with apex 20.1 accessing apex_admin/apex pages was throwing “Error processing request” Contact your application administrator. There were three invalid objects for APEX_200100 WWV_FLOW_SESSION_RAS WWV_FLOW_WIZARD_API WWV_FLOW_DATA_LOADER Tried compiling these objects but compile was completing with PL/SQL: ORA-00942: table or view does not exist To resolve the issue following rant needs to be given then compile (ran both grant and compile as sysdba) grant select on SYS.DBA_XS_DYNAMIC_ROLES to APEX_200100; grant select on SYS.DBA_TAB_IDENTITY_COLS to APEX_200100; alter package APEX_200100.WWV_FLOW_SESSION_RAS compile body; alter package APEX_200100.WWV_FLOW_WIZARD_API compile body; alter package APEX_200100.WWV_FLOW_DATA_LOADER compile body; Returned 0 invalid object for APEX_200100  select * from dba_objects where status = 'INVALID' and owner = 'APEX_200100' ; Now both admin and apex pages ar
Read more

APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter (R12 12.1.3)

Image
APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter After upgrading oracle application 11i(11.5.10.2) to R12(12.1.3) running concurrent program request caused this issue When concurrent program is run for a concurrent request after upgrading to R12 12.1.3 the lov, which is attached to a parameter, gives APP-FND-01436: “List of Values cannot find any values for you to choose”. When the same request is run from oracle applications 11i 11.5.10.2 the same value set is working fine. The value set is based on a table. If you go and test the value set query from the value set definition screen it returns complete successful message yet if you go to the parameter of the concurrent request program form where the particular value set is used it gives you the above error. After searching google and oracle support I found metalink note 1400963.1, EBS R12.1: Parameter for Concurrent Request Using Table Based LOV G
Read more

WEB ADI - issues encountered during initial access

Image
On accessing create document link under Desktop Integrator responsibility browser was showing following error Set BNE UIX Physical Directory profile value to proper directory at site level Location = $COMMON_TOP/html/cabo/  (11i) Location = $COMMON_TOP/webapps/oacore/html/cabo/  (R12) As this was a cloned instance the value of this profile setting was pointing to a wrong location. set as BNE UIX Physical Directory /u03/oracle/prodcomn/html/cabo/ Access to functions are controlled by function security so to access and work with web adi the user should have proper access. You should have access to particular integrator to access and work with it Find out responsibility which is created to work with web adi check the main menu for this responsibility. Modify the responsibility or Menu if default is not fitting to your needs. For instance Desktop Integration Menu has create document, Define Lay out, Define Mapping, Manage Documents, Setup options Note : you must add
Read more