Now in Application Express 3.1 installation we have two scripts to change the password of internal ADMIN account.
First one is as follows which was available before version  3.1
@UNZIP_DIR/apex/apxxepwd.sql password
Where
password is the password of the Application Express internal ADMIN account.
Second one is as follows which is new in version 3.1
@UNZIP_DIR/apex/apxchpwd.sql
When prompted enter a password for the ADMIN account.
Where:
UNZIP_DIR is the directory where you unzip your application express installation.

Bookmark this post

[…]

[Read more →]

Even though there is a document about up-gradation at Oracle, I wrote what I thought I will be following in future. There are things which one may not find in documents but learn with experience or when actually doing it.
Steps to up-gradation are as follows:
1. Change your working directory to apex where you have unzip the installation.
2. Start SQL*Plus from here and connect to the database as SYSDBA role. Thus making apex as your working directory.
3. To Install Full development environment
@apexins tablespace_apex tablespace_files tablespace_temp images
it can be something like this
@apexins SYSAUX […]

[Read more →]

Recently I forget the Application Express (version 3.0.1) internal ADMIN account of my development site.
So to change the password without knowing the old password, I login as SYS into the Database Server and run the following script.
SQLPLUS> @C:\oraclexe\apex\apxxepwd.sql new_password
Where “C:\oraclexe\apex” is APEX_HOME directory.
What this script is doing is as follows:
First it changes the current schema to “FLOWS_030000″
alter session set current_schema = FLOWS_030000;
The set the security group id and and user name using wwv_flow_security package as follows:
wwv_flow_security.g_security_group_id := 10;
wwv_flow_security.g_user := ‘ADMIN’;
The change the status as “import in progress” using wwv_flow_security package
wwv_flow_security.g_import_in_progress := true;
Then get the internal user id of the “ADMIN” […]

[Read more →]