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
Friday, January 30, 2009
Thursday, January 29, 2009
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
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
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
Wednesday, December 24, 2008
Oracle Moblie Application - Client
MWA CLIENT INSTALLATION/SETUP INSTRUCTIONS
Desktop Client
Perform the following steps to install GUI Client on Windows Desktop
1. Create the following directory structures
C:\mwagui\lib
C:\mwagui\log
(or)
%MWA_GUI_TOP%\lib
%MWA_GUI_TOP%\log
2. Download and install JDK 1.4.2 from http://java.sun.com/javase/downloads/index.jsp
3. Download the GUI Client patch(4205328) and unzip it to C:\Temp
e.g. PATCH_TOP=C:\Temp\4205328
4. Copy %PATCH_TOP%\j4205328.zip to %MWA_GUI_TOP%\lib
5. Create a .cmd file to run the class file oracle.apps.mwa.awt.client.StartGUI
6. Sample content of .cmd file to launch the GUI Client
set MWA_GUI_TOP=C:\mwagui
set JAVA_TOP=C:\j2sdk1.4.2_09
%JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.client.StartGUI
7. Enter the hostname and port number in the "Connect" window and hit the "Connect" button. A maximum of 10 connections can be stored. Optionally the host name and port number can be passed as parameters to oracle.apps.mwa.awt.client.StartGUI which would directly connect to the MWA Telnet Server without displaying the "Connect" window to the user.
Desktop Client
Perform the following steps to install GUI Client on Windows Desktop
1. Create the following directory structures
C:\mwagui\lib
C:\mwagui\log
(or)
%MWA_GUI_TOP%\lib
%MWA_GUI_TOP%\log
2. Download and install JDK 1.4.2 from http://java.sun.com/javase/downloads/index.jsp
3. Download the GUI Client patch(4205328) and unzip it to C:\Temp
e.g. PATCH_TOP=C:\Temp\4205328
4. Copy %PATCH_TOP%\j4205328.zip to %MWA_GUI_TOP%\lib
5. Create a .cmd file to run the class file oracle.apps.mwa.awt.client.StartGUI
6. Sample content of .cmd file to launch the GUI Client
set MWA_GUI_TOP=C:\mwagui
set JAVA_TOP=C:\j2sdk1.4.2_09
%JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.client.StartGUI
7. Enter the hostname and port number in the "Connect" window and hit the "Connect" button. A maximum of 10 connections can be stored. Optionally the host name and port number can be passed as parameters to oracle.apps.mwa.awt.client.StartGUI which would directly connect to the MWA Telnet Server without displaying the "Connect" window to the user.
Oracle Moblie Application
MWA(Mobile Web Application) Server Setup
MWA Configuration File:
Configure mwa.cfg
The following procedure lists the steps necessary to configure the mwa.cfg file.
1. Locate the mwa.cfg file in the $MWA_TOP/secure directory.
2. Copy the file Mwa_template.cfg to the file mwa.cfg.
3. Edit the mwa.cfg file and configure following parameters:
a. Set mwa.DbcFolder=full directory of folder containing the .dbc file ending with “/”.
b. Set mwa.DbcFile=dbc file name
c. Set mwa.logdir=full directory of log file
d. Set mwa.TelnetPortNumber=default port#(10310)
e. Setmwa.DropConnectionTimeout= no. of minutes
f. Set mwa.StaleSessionTimeout= no. of minutes
g. Set mwa.LogLevel=error or trace
Configure default_key.ini
The following procedure lists the steps necessary to configure the default_key.ini file.
1. Locate the default_key.ini file in the $MWA_TOP/secure directory.
2. Use the default_key.ini file if you do not need to make any changes.
3. If you need to make customizations, create a new file e.g. intermec2415_key.ini
a. Associate Server-Defined actions to Device keys:
== eg. MWA_CLEAR_FIELD=CONTROLK=Clear
b. Specify a device
Configure Device IP.ini
The following procedure lists the steps necessary to configure the deviceIP.ini file.
1. Locate the deviceIP.ini file in the $MWA_TOP/secure directory.
2. Copy the deviceIP_template.ini file to the deviceIP.ini file. This file associates a device with a key mapping file.
3. Map the device name and IP address as follows:
a. Mapping by device name: Intermec 2415=intermec2415_key.ini
b. Mapping by IP address: 130.35.112.*=intermec2415.ini
Starting the MWA Telnet Server
To start the MWA telnet server complete the following procedure (at aUNIX/LINUX prompt):
1. Source the APPLSYS.env
2. Enter the following text:
cd $MWA_TOP/bin
3. Enter the following text:
mwactl.sh start [port number]
eg $MWA_TOP/bin/mwactl.sh start 10310
MWA Configuration File:
Configure mwa.cfg
The following procedure lists the steps necessary to configure the mwa.cfg file.
1. Locate the mwa.cfg file in the $MWA_TOP/secure directory.
2. Copy the file Mwa_template.cfg to the file mwa.cfg.
3. Edit the mwa.cfg file and configure following parameters:
a. Set mwa.DbcFolder=full directory of folder containing the .dbc file ending with “/”.
b. Set mwa.DbcFile=dbc file name
c. Set mwa.logdir=full directory of log file
d. Set mwa.TelnetPortNumber=default port#(10310)
e. Setmwa.DropConnectionTimeout= no. of minutes
f. Set mwa.StaleSessionTimeout= no. of minutes
g. Set mwa.LogLevel=error or trace
Configure default_key.ini
The following procedure lists the steps necessary to configure the default_key.ini file.
1. Locate the default_key.ini file in the $MWA_TOP/secure directory.
2. Use the default_key.ini file if you do not need to make any changes.
3. If you need to make customizations, create a new file e.g. intermec2415_key.ini
a. Associate Server-Defined actions to Device keys:
b. Specify a device
Configure Device IP.ini
The following procedure lists the steps necessary to configure the deviceIP.ini file.
1. Locate the deviceIP.ini file in the $MWA_TOP/secure directory.
2. Copy the deviceIP_template.ini file to the deviceIP.ini file. This file associates a device with a key mapping file.
3. Map the device name and IP address as follows:
a. Mapping by device name: Intermec 2415=intermec2415_key.ini
b. Mapping by IP address: 130.35.112.*=intermec2415.ini
Starting the MWA Telnet Server
To start the MWA telnet server complete the following procedure (at aUNIX/LINUX prompt):
1. Source the APPLSYS.env
2. Enter the following text:
cd $MWA_TOP/bin
3. Enter the following text:
mwactl.sh start [port number]
eg $MWA_TOP/bin/mwactl.sh start 10310
Saturday, December 13, 2008
Change OC4J port number
Change OC4J port number
Many Oracle Application Server components and services use ports. As an administrator, it is important to know the port numbers used by these services, and to ensure that the same port number is not used by two services on your host.
Most port numbers are assigned during installation. Every component and service has an allotted port range, which is the set of port numbers Oracle Application Server attempts to use when assigning a port. Oracle Application Server starts with the lowest number in the range and performs the following checks:
You can change OC4J port ranges using the following steps:
1.Open the default-web-site.xml file:
ORACLE_HOME\j2ee\home\config\default-web-site.xml
or
OC4J_HOME\config\default-web-site.xml
2.Locate the element for the OC4J instance that contains the port range you want to change. For example, if you want to change a port number, locate this element:
web-site port="8888"
3.Within the OC4J instance element, there is a port element for each type of port.
For example:
web-site port="9000"
4.Modify the range parameter for the port you want to change, and then save the file.
Many Oracle Application Server components and services use ports. As an administrator, it is important to know the port numbers used by these services, and to ensure that the same port number is not used by two services on your host.
Most port numbers are assigned during installation. Every component and service has an allotted port range, which is the set of port numbers Oracle Application Server attempts to use when assigning a port. Oracle Application Server starts with the lowest number in the range and performs the following checks:
You can change OC4J port ranges using the following steps:
1.Open the default-web-site.xml file:
ORACLE_HOME\j2ee\home\config\default-web-site.xml
or
OC4J_HOME\config\default-web-site.xml
2.Locate the element for the OC4J instance that contains the port range you want to change. For example, if you want to change a port number, locate this element:
web-site port="8888"
3.Within the OC4J instance element, there is a port element for each type of port.
For example:
web-site port="9000"
4.Modify the range parameter for the port you want to change, and then save the file.
5.Restart OC4J
%OC4J_HOME%\java -jar admin_client.jar deployer:oc4j:localhost oc4jadmin xxxxx -restart
(or)
1.Shutdown OC4J
%ORACLE_HOME%\bin\oc4j -shutdown -port 23791 -password xxxxxx
2.Startup OC4J
%ORACLE_HOME%\bin\oc4j -start
Now the port Change..
%OC4J_HOME%\java -jar admin_client.jar deployer:oc4j:localhost oc4jadmin xxxxx -restart
(or)
1.Shutdown OC4J
%ORACLE_HOME%\bin\oc4j -shutdown -port 23791 -password xxxxxx
2.Startup OC4J
%ORACLE_HOME%\bin\oc4j -start
Now the port Change..
Start OC4J as Windows Service
Start OC4J as Windows Service
Create apfopstart.bat and Add following line..
----------------------------------------
@echo off
cls
echo.
echo ***********************
echo * Starting OC4J .... *
echo ***********************
echo.
SET ORACLE_HOME=C:\oc4j_extended_101340
SET JAVA_HOME=C:\j2sdk1.4.2_09
:validatefilelocation
if NOT EXIST %ORACLE_HOME%\bin\oc4j.cmd goto invalidfilelocation
goto oc4j
:invalidfilelocation
echo.
echo * Error: Invalid location for script.
echo * Cannot find the oc4j.bat file within the specified script location.
echo.
goto end
:oc4j
%ORACLE_HOME%\bin\oc4j -start
:end
------------------------------------------
After copy apfopstart.bat to C:\Documents and Settings\All Users\Start Menu\Programs\Startup
Create apfopstart.bat and Add following line..
----------------------------------------
@echo off
cls
echo.
echo ***********************
echo * Starting OC4J .... *
echo ***********************
echo.
SET ORACLE_HOME=C:\oc4j_extended_101340
SET JAVA_HOME=C:\j2sdk1.4.2_09
:validatefilelocation
if NOT EXIST %ORACLE_HOME%\bin\oc4j.cmd goto invalidfilelocation
goto oc4j
:invalidfilelocation
echo.
echo * Error: Invalid location for script.
echo * Cannot find the oc4j.bat file within the specified script location.
echo.
goto end
:oc4j
%ORACLE_HOME%\bin\oc4j -start
:end
------------------------------------------
After copy apfopstart.bat to C:\Documents and Settings\All Users\Start Menu\Programs\Startup
