Upgrading form Oracle 10g to 11g and Configuring Oracle Apex

After Upgrade 10g to 11g Oracle Apex
Note : Oracle Application express comes default with Oracle 11g Database,we have to configure ..


Install Oracle 11g Apex

cd $ORACLE_HOME/apex

create apex tablespace
(eg. create tablespace apex datafile '/db/orcl/apex01.dbf' size 1024M;)

sqlplus '/as sysdba'
SQL>@apexins apex apex apex TEMP /i/ none

Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the FLOWS_030000 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

-- Updating user account expiration. -------
timing for: Upgrade
Elapsed: 00:00:00.13
JOB_QUEUE_PROCESSES: 10

Performing Application Express component validation - please wait...

Completing registration process.
Validating installation.
timing for: Validate Installation
Elapsed: 00:02:43.26
timing for: Complete Installation
Elapsed: 00:13:14.01
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @apxconf.sql
PORT
----------
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.


Enter a password for the ADMIN user [] oracle
Enter a port for the XDB HTTP listener [ 8080] 8080
...changing HTTP Port

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

SQL> @apex_epg_config.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Enter value for 1: /u02/app/product/11.1.0/db_1
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/u02/app/product/11.1.0/db_1/apex/images'

Directory created.

PL/SQL procedure successfully completed.

Commit complete.

PL/SQL procedure successfully completed.

timing for: Load Images
Elapsed: 00:03:04.41

Session altered.

PL/SQL procedure successfully completed.

Commit complete.

Session altered.

Directory dropped.

SQL>Col Comp_name Format a35
Col Status Format a12
Select Comp_name, status, Version
From Dba_Registry
Order by Comp_name;



COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
JServer JAVA Virtual Machine VALID 11.1.0.6.0
OLAP Analytic Workspace VALID 11.1.0.6.0
OLAP Catalog VALID 11.1.0.6.0
Oracle Application Express VALID 3.0.1.00.08
Oracle Data Mining VALID 11.1.0.6.0
Oracle Database Catalog Views VALID 11.1.0.6.0
Oracle Database Java Packages VALID 11.1.0.6.0
Oracle Database Packages and Types VALID 11.1.0.6.0
Oracle Enterprise Manager VALID 11.1.0.6.0
Oracle Expression Filter VALID 11.1.0.6.0
Oracle Multimedia VALID 11.1.0.6.0

COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
Oracle OLAP API VALID 11.1.0.6.0
Oracle Rules Manager VALID 11.1.0.6.0
Oracle Text VALID 11.1.0.6.0
Oracle Workspace Manager VALID 11.1.0.6.0
Oracle XDK VALID 11.1.0.6.0
Oracle XML Database VALID 11.1.0.6.0
Spatial VALID 11.1.0.6.0

Oracle Apps EBS R12 Rapidwiz actually do

Oracle Apps EBS R12 Rapidwiz actually do

What does Rapidwiz actually do?

RapidWiz Installations of Oracle Applications Release 12 uses Rapid Clone and AutoConfig functionality.

The basics of how this Rapid Wizard installation works are:-

1.RapidWizard collects user information required for configuration of system, and creates a configuration file
2.RapidWizard checks Port availability and file space required
3.Zip files from the "oraDB and oraAppDB" DVD stage area are then uncompressed onto the file system
4.Each Disk directory contains a driver which is read to control the unzip phase
5.The DB Techstack is relinked and reconfigured using an install driver, templates and the configuration file
6.Control files are created
7.The RDBMS ORACLE_HOME is registered into the Global Inventory
8.The DB is started, and further configuration is performed
9.Zip files from the "oraAS" (Developer Tools and As10g" DVD stage area are then uncompressed onto the file system
10.The Apps Techstack is relinked and reconfigured using the install driver, templates and the configuration file
11.The Developer Tools and As10g ORACLE_HOMEs are registered into the Global Inventory
12.Zip files from the "oraApps" (APPL_TOP, COMMON_TOP etc) stage are uncompressed onto the file system
13.APPL_TOP is reconfigured with system using values in the configuration file and services are started
14.Post install checks are performed to check success of the installation

Oracle Apps EBS R12 Installing Log Files

Oracle Apps EBS R12 Installing Log Files

Where are the log files?

The following are referenced in this document

{MMDDHHMM} : MM (Month) DD (Day) HH (Hour) MM (Minute)
{Timestamp} : {This may include Year, Month, Day, and Time}
{Base Install} : Location chosen during the RapidWiz configuration phase
$CONTEXT_NAME : {SID}_{hostname}
RDBMS $ORACLE_HOME} : {Base Install}/db/tech_st/10.2.0
$IAS_ORACLE_HOME : {Base Install}/apps/tech_st/10.1.3
Tools $ORACLE_HOME : {Base Install}/apps/tech_st/10.1.2
$INST_TOP : {Base Install}/inst/apps/$CONTEXT_NAME
$APPL_TOP : {Base Install}/apps/apps_st/appl

Before the installation starts:

$TMP/{MMDDHHMM}/{MMDDHHMM}.log$TMP/{MMDDHHMM}/{hostname}_{SID}.xml
$TMP/{MMDDHHMM}/{hostname}_{SID}_apps.xml

The Rapidwiz Configuration File is saved in 3 locations:-

$TMP/{MMDDHHMM}/conf_{SID}.txt$INST_TOP/conf_{SID}.txt{RDBMS ORACLE_HOME}/appsutil/conf_{SID}.txt

Database Tier:

RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_{SID}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_{MMDDHHMM}.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/{MMDDHHMM}/adconfig.log
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/{MMDDHHMM}/NetServiceHandler.log

Applications Tier(s):

$INST_TOP/logs/{MMDDHHMM}.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/logs/ora/10.1.2/install/make_{MMDDHHMM}.log
$INST_TOP/logs/ora/10.1.3/install/make_{MMDDHHMM}.log
$INST_TOP/admin/log/ApplyAppsTechStack.log
$INST_TOP/admin/log/ohclone.log
$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_{MMDDHHMM}.log
$APPL_TOP/admin/$CONTEXT_NAME/log/{MMDDHHMM}/adconfig.log
$APPL_TOP/admin/$CONTEXT_NAME/log/{MMDDHHMM}/NetServiceHandler.log

Inventory Registration:

{GlobalInventory}/logs/cloneActions{timestamp}.log{GlobalInventory}/logs/oraInstall{timestamp}.log{Global Inventory} /logs/silentInstall{timestamp}.log