Integration Oracle Apex With Weblogic Server
1. Download Oracle WebLogic
2. Goto the Admin console.
3. Choose "Deployments"
4. Click Install
5. load apex.war (available for download on the APEX Listener Download Page)
6. Choose all the defaults
7. visit : http://host:port/apex/Config and setup the db
(host:port Your weblogic server host:port example: http://localhost:7001/)
8. Recursively copy the apex/images directory to the webserver's /i
Note : I have copy apex/images folder to (/home/oracle/Oracle/Middleware/wlserver_10.3/samples/server/examples/build/mainWebApp/i)
Showing posts with label Oracle Apex. Show all posts
Showing posts with label Oracle Apex. Show all posts
Thursday, November 5, 2009
Friday, October 9, 2009
Oracle Application Express enable SSL
Oracle Apex configure SSL
Oracle Application Express enable SSL (http to https)
Goto Application Server
$ORACLE_HOME/opmn/conf/opmn.xml
find for ssl-disabled
change to ssl-enabled
Save opmn.xml
Add the entry in httpd.conf file.
RewriteEngine On
RewriteCond %{SERVER_PORT} !^443$
RewriteRule ^/pls/apex/(.*)$ https://example.com/pls/apex/$1 [L,R]
Oracle Application Express enable SSL (http to https)
Goto Application Server
$ORACLE_HOME/opmn/conf/opmn.xml
find for ssl-disabled
change to ssl-enabled
Save opmn.xml
Add the entry in httpd.conf file.
RewriteEngine On
RewriteCond %{SERVER_PORT} !^443$
RewriteRule ^/pls/apex/(.*)$ https://example.com/pls/apex/$1 [L,R]
Apache2.0 proxy for Oracle Apex
Apache2.0 proxy for Oracle Apex
User => HTTP2.x => OHS => APEX
Add the entry in httpd.conf file.
ProxyPass /apex http://192.168.5.25:8080/apex
ProxyPassReverse /apex http://192.168.5.25:8080/apex
ProxyPass /i http://192.168.5.25/i
ProxyPassReverse /i http://192.168.5.25/i
User => HTTP2.x => OHS => APEX
Add the entry in httpd.conf file.
ProxyPass /apex http://192.168.5.25:8080/apex
ProxyPassReverse /apex http://192.168.5.25:8080/apex
ProxyPass /i http://192.168.5.25/i
ProxyPassReverse /i http://192.168.5.25/i
Sunday, June 28, 2009
XDB SCHEMA INSTALL STEPS
XDB SCHEMA INSTALL STEPS:
1. Connect as sysdba and run the catqm.sql script. Maintain a spool of the
script running:
UNIX: $ORACLE_HOME/rdbms/admin subdirectory
WINDOWS: $ORACLE_HOME\rdbms\admin subdirectory
The catqm.sql script requires the following parameters be passed to it when
run:
A. XDB user password
B. XDB user default tablespace (You can use any tablespace other than system undo and temp. This tablespace has to exist prior to running the script.)
C. XDB user temporary tablespace
Therefore the syntax to run catqm.sql will be:
SQL> catqm.sql A B C
For Example:
SQL> set echo on
SQL> spool xdb_install.log
SQL>@?/rdbms/admin/catqm.sql XDB XDB TEMP
SQL> select comp_name, status, version from DBA_REGISTRY where comp_name= 'Oracle XML Database'
1. Connect as sysdba and run the catqm.sql script. Maintain a spool of the
script running:
UNIX: $ORACLE_HOME/rdbms/admin subdirectory
WINDOWS: $ORACLE_HOME\rdbms\admin subdirectory
The catqm.sql script requires the following parameters be passed to it when
run:
A. XDB user password
B. XDB user default tablespace (You can use any tablespace other than system undo and temp. This tablespace has to exist prior to running the script.)
C. XDB user temporary tablespace
Therefore the syntax to run catqm.sql will be:
SQL> catqm.sql A B C
For Example:
SQL> set echo on
SQL> spool xdb_install.log
SQL>@?/rdbms/admin/catqm.sql XDB XDB TEMP
SQL> select comp_name, status, version from DBA_REGISTRY where comp_name= 'Oracle XML Database'
Thursday, May 7, 2009
Oracle Apex AnyChart 5.1.2 Installing Steps
Oracle Apex AnyChart 5.1.2 Installing Steps
1.Download Apex AnyChart 5.1.2
http://anychart.apex-evangelists.com/download/apex_anychart_512.zip
2. Backup flashchart folder
cp -rf $IAS_ORACLE_HOME/Apache/Apache/images/flashchart $IAS_ORACLE_HOME/Apache/Apache/images/flashchart.bak
3. unzip apex_anychart_512.zip
4. copy unzipped all file to flashchart folder
cp *.* $IAS_ORACLE_HOME/Apache/Apache/images/flashchart
5. Backup imagelist.xml
cp $IAS_ORACLE_HOME/Apache/Apache/images/imagelist.xml $IAS_ORACLE_HOME/Apache/Apache/images/imagelist.xml.bak
6. Add the following line to $IAS_ORACLE_HOME/Apache/Apache/images/imagelist.xml (search for /flashchart/ and add it in this section)
/flashchart/AnyChart.swf (eg : {file}/flashchart/AnyChart.swf{file} )
Note: this is a trial version of Anychart. You need to buy the full product let the Trial watermark disappear
7. Copy AnyChart.swf(license Version) to $IAS_ORACLE_HOME/Apache/Apache/images/flashchart
8. Now Check AnyChart
1.Download Apex AnyChart 5.1.2
http://anychart.apex-evangelists.com/download/apex_anychart_512.zip
2. Backup flashchart folder
cp -rf $IAS_ORACLE_HOME/Apache/Apache/images/flashchart $IAS_ORACLE_HOME/Apache/Apache/images/flashchart.bak
3. unzip apex_anychart_512.zip
4. copy unzipped all file to flashchart folder
cp *.* $IAS_ORACLE_HOME/Apache/Apache/images/flashchart
5. Backup imagelist.xml
cp $IAS_ORACLE_HOME/Apache/Apache/images/imagelist.xml $IAS_ORACLE_HOME/Apache/Apache/images/imagelist.xml.bak
6. Add the following line to $IAS_ORACLE_HOME/Apache/Apache/images/imagelist.xml (search for /flashchart/ and add it in this section)
/flashchart/AnyChart.swf (eg : {file}
Note: this is a trial version of Anychart. You need to buy the full product let the Trial watermark disappear
7. Copy AnyChart.swf(license Version) to $IAS_ORACLE_HOME/Apache/Apache/images/flashchart
8. Now Check AnyChart
Oracle Apex (Middle Tier) port number Change 7777 to 80
Oracle Apex (Middle Tier) port number Change 7777 to 80
1. Login Oracle IAS Home.
cd $IAS_ORACLE_HOME/Apache/Apache/conf
2. Take a backup httpd.conf
cp httpd.conf httpd.conf.bak
3. Open httpd.conf and chage Port Number
change follow bellow entry
Port 7777
Listen 7777
to
Port 80
Listen 80
4. Save httpd.conf
5. Go into the directory $IAS_ORACLE_HOME/Apache/Apache/bin
cd $IAS_ORACLE_HOME/Apache/Apache/bin
6. Login root user
su root
7. Execute following line chown root .apachectl
$chown root .apachectl
8. Execute following line chmod 6750 .apachectl
$chmod 6750 .apachectl
9. Restart the OHS with the command $IAS_ORACLE_HOME/opmn/bin/opmnctl restartproc ias-component=HTTP_Server
Before http://192.168.0.104:7777/pls/apex
After http://192.168.0.104/pls/apex
1. Login Oracle IAS Home.
cd $IAS_ORACLE_HOME/Apache/Apache/conf
2. Take a backup httpd.conf
cp httpd.conf httpd.conf.bak
3. Open httpd.conf and chage Port Number
change follow bellow entry
Port 7777
Listen 7777
to
Port 80
Listen 80
4. Save httpd.conf
5. Go into the directory $IAS_ORACLE_HOME/Apache/Apache/bin
cd $IAS_ORACLE_HOME/Apache/Apache/bin
6. Login root user
su root
7. Execute following line chown root .apachectl
$chown root .apachectl
8. Execute following line chmod 6750 .apachectl
$chmod 6750 .apachectl
9. Restart the OHS with the command $IAS_ORACLE_HOME/opmn/bin/opmnctl restartproc ias-component=HTTP_Server
Before http://192.168.0.104:7777/pls/apex
After http://192.168.0.104/pls/apex
Oracle Application Express Upgrade 3.1.1 to 3.1.2
APEX Upgrade 3.1.1 to 3.1.2 Steps
SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.1.00.09
1.Download from metalink p7313609_11106_GENERIC.zip
2.Unzip and extract p7313609_11106_GENERIC.zip
3.Stop Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
4.Login Oracle Database
sqlplus "/as sysdba"
5.Run apxpatch.sql
SQL>@patch\apxpatch.sql
6.Copy image folder.
cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache
7.Start Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server
SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.2.00.02
SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.1.00.09
1.Download from metalink p7313609_11106_GENERIC.zip
2.Unzip and extract p7313609_11106_GENERIC.zip
3.Stop Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
4.Login Oracle Database
sqlplus "/as sysdba"
5.Run apxpatch.sql
SQL>@patch\apxpatch.sql
6.Copy image folder.
cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache
7.Start Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server
SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.2.00.02
Monday, March 23, 2009
Oracle Application Express 3.1 New Features
Oracle Application Express 3.1 New Features
1.Interactive Reports
2.Declarative BLOB Support
3.Enhanced Report Printing
4.Adding to the Theme Repository
5.Optional Runtime-Only Installation
6.Improved Security
7.Documented JavaScript libraries
8.Application Date Format
9.Application Builder refinements
1.Interactive Reports
2.Declarative BLOB Support
3.Enhanced Report Printing
4.Adding to the Theme Repository
5.Optional Runtime-Only Installation
6.Improved Security
7.Documented JavaScript libraries
8.Application Date Format
9.Application Builder refinements
Oracle Application Express 3.0 Features
Oracle Application Express 3.0 Features:
1.PDF Printing
2.Access Migration
3.Flash Charts
4.Drag and Drop Item Layout
5.Improved Web Services
6.New Item Types
7.Calendar Enhancement
8.Supporting Objects Enhancements
9.Page and Region Caching
10.Shared Components Enhancements
11.Item Finder Enhancements
12.Other Item Enhancements
13.New Multi-Delete Functions
14.Null Sort Order for Reports
15.Navigation Improvements
16.Application and Schema Comparison
17.Application Home Page - Additional Display Types
18.Application Builder Defaults
19.Developer Preferences
20.Developer Toolbar Additions
21.Friendly URL Syntax to Facilitate Bookmarks
22.Support of Locking with WAIT/NOWAIT in Automatic DML
23.SQL Workshop - Saved SQL and Scripts Change
24.SQL Workshop - Other Enhancements
25.APEX Views Exposed
26.New Password and Account Controls
27.Improved Workspace Management
28.New Look for Managing Users
1.PDF Printing
2.Access Migration
3.Flash Charts
4.Drag and Drop Item Layout
5.Improved Web Services
6.New Item Types
7.Calendar Enhancement
8.Supporting Objects Enhancements
9.Page and Region Caching
10.Shared Components Enhancements
11.Item Finder Enhancements
12.Other Item Enhancements
13.New Multi-Delete Functions
14.Null Sort Order for Reports
15.Navigation Improvements
16.Application and Schema Comparison
17.Application Home Page - Additional Display Types
18.Application Builder Defaults
19.Developer Preferences
20.Developer Toolbar Additions
21.Friendly URL Syntax to Facilitate Bookmarks
22.Support of Locking with WAIT/NOWAIT in Automatic DML
23.SQL Workshop - Saved SQL and Scripts Change
24.SQL Workshop - Other Enhancements
25.APEX Views Exposed
26.New Password and Account Controls
27.Improved Workspace Management
28.New Look for Managing Users
Friday, January 30, 2009
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
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
Saturday, December 13, 2008
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
Friday, December 12, 2008
PDF Printing in Application Express (Apex)
PDF Printing in Application Express (Apex)
1.Download Oracle Containers for J2EE (10.1.3.4)
http://www.oracle.com/technology/software/products/ias/htdocs/utilsoft.html
2. Installing Oracle Containers for J2EE (10.1.3.4)
Unzip oc4j_extended_101340.zip
SET ORACLE_HOME=c:\oc4j_extended_101340
SET JAVA_HOME = (Download Jdk)
Start oc4j
cd bin
oc4j -start
C:\oc4j_extended_101340\bin>oc4j -start
Starting OC4J from C:\oc4j_extended_101340\j2ee\home ...
08/12/12 13:46:04 Set OC4J administrator's password (password text will not be displayed as it is entered)
Enter password:xxxxxx
Confirm password:xxxxxx
The password for OC4J administrator "oc4jadmin" has been set.
08/12/12 13:46:17 The OC4J administrator "oc4jadmin" account is activated.
08/12/12 13:46:26 Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
Stop oc4j
oc4j -shutdown -port 23791 -password xxxxxx
3.Configure PDF Printing in Apache FOP
Deploy fop.war
Place the fop.war file (located in apex_install_directory/utlities/fop) in an accessible location on your local machine
Navigate to your OC4J Oracle Enterprise Manager Console eg: http://localhost:8888/em/
Select the Applications Tab
Select Deploy Button
On the "Deploy: Application Attributes" page set the "Application Name" option to "fop" and clear the "Context Root " option and click "Next" Button
On the Deploy: Deployment Settings click the "Deploy" button
4.Configure Oracle Application Express to use the JSP for PDF printing
Once you have the FOP installed, access the Report Printing parameters:
Access the Administration Services home page
Select Manage Service
Select Instance Settings, under Manage Environment Settings
Click Report Printing to focus on just the Report Printing attributes
Now, specify the following attributes:
Oracle BI Publisher: Standard Support
Print Server Protocol: HTTP or HTTPS (depends on your configuration)
Print Server Host Address:192.168.0.22 (the hostname for the machine where the java container is running )
Print Server Port: 8888 (the port that the OC4J is listening on - e.g. 8888)
Print Server Script: /fop/apex_fop.jsp
1.Download Oracle Containers for J2EE (10.1.3.4)
http://www.oracle.com/technology/software/products/ias/htdocs/utilsoft.html
2. Installing Oracle Containers for J2EE (10.1.3.4)
Unzip oc4j_extended_101340.zip
SET ORACLE_HOME=c:\oc4j_extended_101340
SET JAVA_HOME = (Download Jdk)
Start oc4j
cd bin
oc4j -start
C:\oc4j_extended_101340\bin>oc4j -start
Starting OC4J from C:\oc4j_extended_101340\j2ee\home ...
08/12/12 13:46:04 Set OC4J administrator's password (password text will not be displayed as it is entered)
Enter password:xxxxxx
Confirm password:xxxxxx
The password for OC4J administrator "oc4jadmin" has been set.
08/12/12 13:46:17 The OC4J administrator "oc4jadmin" account is activated.
08/12/12 13:46:26 Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
Stop oc4j
oc4j -shutdown -port 23791 -password xxxxxx
3.Configure PDF Printing in Apache FOP
Deploy fop.war
Place the fop.war file (located in apex_install_directory/utlities/fop) in an accessible location on your local machine
Navigate to your OC4J Oracle Enterprise Manager Console eg: http://localhost:8888/em/
Select the Applications TabSelect Deploy Button
On the "Deploy: Select Archive" page use the option "Archive is present on local host. Upload the archive to the server where Application Server Control is running." Use the file browse to select the fop.war file and click "Next" button
On the "Deploy: Application Attributes" page set the "Application Name" option to "fop" and clear the "Context Root " option and click "Next" Button
On the Deploy: Deployment Settings click the "Deploy" button
4.Configure Oracle Application Express to use the JSP for PDF printing
Once you have the FOP installed, access the Report Printing parameters:
Access the Administration Services home page
Select Manage Service
Select Instance Settings, under Manage Environment Settings
Click Report Printing to focus on just the Report Printing attributes
Now, specify the following attributes:
Oracle BI Publisher: Standard Support
Print Server Protocol: HTTP or HTTPS (depends on your configuration)
Print Server Host Address:192.168.0.22 (the hostname for the machine where the java container is running )
Print Server Port: 8888 (the port that the OC4J is listening on - e.g. 8888)
Print Server Script: /fop/apex_fop.jsp
Thursday, December 11, 2008
Converts XSL-FO to PDF
Converts XSL-FO to PDF
- To produce a PDF file from this XML file, we need an XSLT stylesheet that converts the XML to XSL-FO
- FOP when it reads the generated XSL-FO document and formats it to a PDF document.
1.Download Apache FOP
http://xmlgraphics.apache.org/fop/download.html
2.Create name.xml and add the following line..
3.Create name2fo.xsl and Add the Bellow line..
4. After run command
fop -xml name.xml -xsl name2fo.xsl -pdf name.pdf
Now name.pdf file created..
Tuesday, November 4, 2008
Oracle Application Express Authentication with Oracle E-Business Suite (EBS)
Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i)
1.Login Oracle Application Express Workspace.
http://192.168.0.9:7777/pls/apex
2.Click SQl Workshop
3.Click SQL Commands
a.Create DB link in Oracle E-Business Suite (Apps 11i)
b.Create function apex_ebs_login
create or replace function apex_ebs_login (p_username IN VARCHAR2, p_password IN VARCHAR2)
return boolean
as
begin
if fnd_web_sec.validate_login@apps(p_username, p_password) = 'Y' then
return true;
else
return false;
end if;
end;
Note :- DB Link Name (@apps)
4.Select Application (exiting Application)
5.Click Shared Components
Select Authentication Schemes
6.Click Create
7.Select For scratch and Click Next
8.Name : EBS_APEX_LOGIN
Description :Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i) Click Next
9.Click Next
10.Click Next
11.Select Application Express Built-in Login Page Click Next
12.Click Next
13. Select Use my custom function to authenticate
Authentication Function : return apex_ebs_login;
14.Click Next
15.Click Next
15.Logout URL
wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1:&SESSION
Click Next
16.Click Create Scheme
17.Click Chanage current
18.Available Authentication Schemes: EBS_APEX_LOGIN
19.Click Make Current
20.Click Run Application
21. Username : sysadmin Password : xxxxxx
1.Login Oracle Application Express Workspace.
http://192.168.0.9:7777/pls/apex
2.Click SQl Workshop
3.Click SQL Commands
a.Create DB link in Oracle E-Business Suite (Apps 11i)
b.Create function apex_ebs_login
create or replace function apex_ebs_login (p_username IN VARCHAR2, p_password IN VARCHAR2)
return boolean
as
begin
if fnd_web_sec.validate_login@apps(p_username, p_password) = 'Y' then
return true;
else
return false;
end if;
end;
Note :- DB Link Name (@apps)
4.Select Application (exiting Application)
5.Click Shared Components
Select Authentication Schemes
6.Click Create 7.Select For scratch and Click Next
8.Name : EBS_APEX_LOGIN
Description :Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i) Click Next
9.Click Next10.Click Next
11.Select Application Express Built-in Login Page Click Next
12.Click Next 13. Select Use my custom function to authenticate
Authentication Function : return apex_ebs_login;
14.Click Next15.Click Next
15.Logout URL
wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1:&SESSION
Click Next
16.Click Create Scheme17.Click Chanage current
18.Available Authentication Schemes: EBS_APEX_LOGIN
19.Click Make Current
20.Click Run Application
21. Username : sysadmin Password : xxxxxx
Monday, November 3, 2008
PDF Printing in Oracle Application Express
PDF Printing in Oracle Application Express (APEX)
Configuring Oracle Application Express to use BI Publisher
To use BI Publisher as your Report Server, first, access the Report Printing parameters:
Access the Administration Services home page
Select Manage Service
Select Instance Settings, under Manage Environment Settings
Click Report Printing to focus on just the Report Printing attributes
Now, specify the following attributes:
Oracle BI Publisher: Advanced Support
Print Server Protocol: HTTP or HTTPS (depends on your configuration)
Print Server Host Address: the hostname for the machine where you installed BI Publisher - e.g. sys9.doyen.in (or) 192.168.0.9
Print Server Port: the port given at the end of the BI Publisher installation - e.g. 9704
Print Server Script: /xmlpserver/convert
Configuring Oracle Application Express to use BI Publisher
To use BI Publisher as your Report Server, first, access the Report Printing parameters:
Access the Administration Services home page
Select Manage Service
Select Instance Settings, under Manage Environment Settings
Click Report Printing to focus on just the Report Printing attributes
Now, specify the following attributes:
Oracle BI Publisher: Advanced Support
Print Server Protocol: HTTP or HTTPS (depends on your configuration)
Print Server Host Address: the hostname for the machine where you installed BI Publisher - e.g. sys9.doyen.in (or) 192.168.0.9
Print Server Port: the port given at the end of the BI Publisher installation - e.g. 9704
Print Server Script: /xmlpserver/convert
Tuesday, October 28, 2008
Installing Oracle Apex
Oracle Apex Installing Step
1.Installing Oracle 10g Database.
2.Installing Oracle AS 10.1.3 Middle Tier (or) Oracle 10g Compation
3.Installing Oracle Apex
4.Integration Oracle Apex in Web Server
1. Install Oracle 10g Database.
Pls See Post Installing Oracle 10g On Linux 4.5
2. Installing Oracle iAS 10.1.3.
Pls See Post Oracle iAS 10.1.3.1.0 windows
3. Installing Oracle Apex
Download Oracle Apex
Per Request
SQL>CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/orcl/APEX01.DBF ' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K SEGMENT SPACE MANAGEMENT auto;
SQL>show parameter shared_pool_size
SQL>ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;
SQL>SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes';
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20;
SQL>SELECT COMP_NAME,STATUS FROM DBA_REGISTRY WHERE SCHEMA='XDB';
connect ctxsys
Enter password: password
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/drdefus.sql
SQL> SELECT COMP_NAME,STATUS FROM DBA_REGISTRY ;
COMP_NAME STATUS
----------------------------------- --------------------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
SQL>@apexins.sql APEX APEX TEMP /i/
SQL>SELECT COMP_NAME,STATUS FROM DBA_REGISTRY ;
COMP_NAME STATUS
----------------------------------- --------------------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
Oracle Application Express VALID
18 rows selected.
4.Integration Oracle Apex in Web Server
export ORACLE_HOME
PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/Apache/modplsql/conf:$PATH; export PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1; export PERL5LIB
Copy image folder to iAS_ORACLE_HOME
cp -R images $ORACLE_HOME/Apache/Apache
(images ==> Oracle Apex Download folder apex/images)
Copy tnsnames.ora to iAS_ORACLE_HOME
cp $ORACLE_HOME/network/admin/tnsnames.ora $iAS_ORACLE_HOME/network/admin
$ORACLE_HOME/Apache/modplsql/conf
edit dads.conf and Add Following Lines
Alias /i/ "/u01/app/oracle/product/10.2.0/ohs/Apache/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc
<<Location /pls/apex>>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword apexpwd
PlsqlDatabaseConnectString sys34.doyen.in:1521:ORCL
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
<>
====END DADS.CONF
cd $ORACLE_HOME/Apache/modplsql/conf
$perl dadTool.pl -o
$ORACLE_HOME/opmn/bin/opmnctl restartproc ias-component=HTTP_Server
Change Apex admin Password
SQL>@apxchpwd.sql
Oracle Apex Admin Page
http://sys9.doyen.in:7777/pls/apex/apex_admin
Oracle Apex Workspace Name
http://sys9.doyen.in:7777/pls/apex
1.Installing Oracle 10g Database.
2.Installing Oracle AS 10.1.3 Middle Tier (or) Oracle 10g Compation
3.Installing Oracle Apex
4.Integration Oracle Apex in Web Server
1. Install Oracle 10g Database.
Pls See Post Installing Oracle 10g On Linux 4.5
2. Installing Oracle iAS 10.1.3.
Pls See Post Oracle iAS 10.1.3.1.0 windows
3. Installing Oracle Apex
Download Oracle Apex
Per Request
SQL>CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/orcl/APEX01.DBF ' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K SEGMENT SPACE MANAGEMENT auto;
SQL>show parameter shared_pool_size
SQL>ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;
SQL>SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes';
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20;
SQL>SELECT COMP_NAME,STATUS FROM DBA_REGISTRY WHERE SCHEMA='XDB';
connect ctxsys
Enter password: password
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/drdefus.sql
SQL> SELECT COMP_NAME,STATUS FROM DBA_REGISTRY ;
COMP_NAME STATUS
----------------------------------- --------------------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
SQL>@apexins.sql APEX APEX TEMP /i/
SQL>SELECT COMP_NAME,STATUS FROM DBA_REGISTRY ;
COMP_NAME STATUS
----------------------------------- --------------------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
Oracle Application Express VALID
18 rows selected.
4.Integration Oracle Apex in Web Server
export ORACLE_HOME
PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/Apache/modplsql/conf:$PATH; export PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1; export PERL5LIB
Copy image folder to iAS_ORACLE_HOME
cp -R images $ORACLE_HOME/Apache/Apache
(images ==> Oracle Apex Download folder apex/images)
Copy tnsnames.ora to iAS_ORACLE_HOME
cp $ORACLE_HOME/network/admin/tnsnames.ora $iAS_ORACLE_HOME/network/admin
$ORACLE_HOME/Apache/modplsql/conf
edit dads.conf and Add Following Lines
Alias /i/ "/u01/app/oracle/product/10.2.0/ohs/Apache/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword apexpwd
PlsqlDatabaseConnectString sys34.doyen.in:1521:ORCL
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
<>
====END DADS.CONF
cd $ORACLE_HOME/Apache/modplsql/conf
$perl dadTool.pl -o
$ORACLE_HOME/opmn/bin/opmnctl restartproc ias-component=HTTP_Server
Change Apex admin Password
SQL>@apxchpwd.sql
Oracle Apex Admin Page
http://sys9.doyen.in:7777
Oracle Apex Workspace Name
http://sys9.doyen.in
