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.

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..

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

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: 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

Upgrade Oracle iAS 10.1.3.1.0 to 10.1.3.4

Upgrade Oracle iAS Steps 10.1.3.1.0 to 10.1.3.4

Download Oracle iAS 10.1.3.4

Run Setup.exe

Click Next
Select 10.1.3.1 ORACLE HOME

Click Install

Click Exit

http://sys50/

http://sys50.doyen.in/

Oracle Enterprise Manager

http://sys50/em

Startup iAS Console
%ORACLE_HOME%\bin\runstartupconsole.bat start
or
%ORACLE_HOME%\opmn\bin\opmnctl startall
Stop iAS Console
%ORACLE_HOME%\bin\runstartupconsole.bat stop
or
%ORACLE_HOME%\opmn\bin\opmnctl stopall
iAS Status
%ORACLE_HOME%\opmn\bin\opmnctl status
%ORACLE_HOME%\opmn\bin\opmnctl status -l

Oracle iAS 10.1.3.1.0 windows

Oracle iAS(10.1.3.1.0) Installing Step on Windows

Download Oracle iAS(10.1.3.1.0)

Run Setup.exe

Select Advanced Install and Click Next

Select J2EE Sever and Web Server and Click Next

AS Instance Name : ias

AS Administrator Password : xxxxxx

Click Next
Click Install


Click Exit

iAS Home page

http://sys50/




Startup iAS Console
%ORACLE_HOME%\bin\runstartupconsole.bat start
or
%ORACLE_HOME%\opmn\bin\opmnctl startall

Stop iAS Console
%ORACLE_HOME%\bin\runstartupconsole.bat stop
or
%ORACLE_HOME%\opmn\bin\opmnctl stopall

iAS Status
%ORACLE_HOME%\opmn\bin\opmnctl status
%ORACLE_HOME%\opmn\bin\opmnctl status -l

Oracle Apps R12 (EBS) - Demantra Integration

Oracle Demantra Overview
Oracle Apps R12 (EBS) - Demantra Integration

1.Install Oracle 10g database or Install Oracle 10g Client
2.Install Oracle iAS 10.1.3 Middle Tier
3.Install Oracle Demantra 7.2
4.Upgrade Oracle R12 to Oracle R12.0.4 (SCP is at the 12.0.3)
5.Install Oracle EBS-Demantra Integration Patch
6.Create and Deploy demantra.war file to Oracle AS 10.1.3 Middle Tier
7.Startup Oracle Demantra Steps

Oracle Apps R12 (EBS) - Demantra Integration Installing Steps

1.Install Oracle 10g Database

Pls see the Post Install Oracle 10g Database installing Step

After Database installed Create Required Tablespaces.

For Default DATA tablespace
create tablespace TS_DP datafile '.../ts_dp01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES tablespace
create tablespace TS_SALES_DATA datafile '.../ts_sales_data01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES INDEX tablespace
create tablespace TS_SALES_DATA_X datafile '.../ts_sales_data_x01.dbf' size 300M autoextend on maxsize 2000M;

For Default SIMULATION DATA tablespace
create tablespace TS_SIM datafile '.../ts_sim01.dbf' size 300M autoextend on maxsize 2000M;

For Default SIMULATION INDEX tablespace
create tablespace TS_SIM_X datafile '.../ts_sim_x01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES DATA ENGINE tablespace
create tablespace TS_SALES_DATA_ENGINE datafile '.../ts_sales_data_engine01.dbf' size 300M autoextend on maxsize 2000M;

For Default SALES DATA ENGINE INDEX tablespace
create tablespace TS_SALES_DATA_ENGINE_X datafile '.../dmants_sales_data_engine_x01.dbf' size 300M autoextend on maxsize 2000M;
alter system tablespace ....(Required Size)

2.Installing Oracle iAS 10.1.3 Middle Tier

Pls See the Post Oracle iAS(10.1.3.1.0) Installing Step on Windows

3.Install Oracle Demantra 7.2
Download Oracle Demantra 7.2.0(6617634)
Installing Steps for Oracle Demantra 7.2
Run Setup.exe

Select Complete


Select Oracle

Oracle DBA Username: system
Oracle DBA Password : xxxxxx
TNS Name : orcl

Oracle Dramntra Username : dp Password : xx

Select Tablespace Name For Demantra





Click Install





Click Done.

Run Tamcat WebServer

%DEMANTRA_HOME%\Collaborator\Tomcat\bin\startup.bat

Demantra Home Page

http://sys50.doyen.in:8080/demantra

4.Upgrade R12 to R12.0.4

Pls See the Post Upgrade Oracle E-Business Suite (EBS) R12 to R12.0.4

5.Install Oracle EBS-Demantra Integration Patch

Download Oracle EBS-Demantra Integration Patch(6606568)
1. Apply this patch in Your Oracle R12 EBS

2. If Demantra is installed after this patch has been applied, please run msddemcrsyn.sql from $MSD_TOP/patch/115/sql.

After Apply Patch
1. Login System Administrator Responsibility
2. Nav: Profile -> System
3. Query profile MSD_DEM: Host URL.
4. Change value to http://hostname:port/demantra e.g (http://sys50.doyen.in:8080/demantra)
5. Save.
6. Run the following script on the ASCP/MSC instance which also contains the Demantra Schema to determine the actual schema name for Demantra:

select owner
from all_tables
where table_name = 'SALES_DATA';

7. Set profile option MSD_DEM: Schema = to the value returned from the script in step 1 at the site level and save. System Administrator/Profiles/System - query for MSD_DEM:% - select the Find button - Find/scroll to the profile option MSD_DEM: Schema - set the correct value at the site level - save

8.SQL>select fnd_profile.value('MSD_DEM_SCHEMA') from dual;

9.SQL>select fnd_profile.value('MSD_DEM_HOST_URL') from dual;

10.Login Demand Management System Administrator

6.Create and Deploy demantra.war file to Oracle AS 10.1.3 Middle Tier
Run Create_war.bat (%DEMANTRA_HOME%\Collaborator\demantra)

Copy b2b.war (%DEMANTRA_HOME%\Collaborator\demantra) to temp folder or use same folder
Open Oracle iAS Enterprise Manager
http://sys50/em

Click Applications
Click Deploy
Click Next

Change Application Name : demantra
Click Deploy

After open Page

http://sys50/demantra/portal/loginpage.jsp (iAS)

7.Oracle Demantra Strartup Steps

1.Startup Oracle Database Listener.
2.Startup Oracle Database.
3.Startup Tamcat Webserver.
4.Startup Oracle iAS Services.

Demantra Login Page

http://sys50.doyen.in:8080/demantra/portal/loginpage.jsp

Collaborator Workbench
http://sys50.doyen.in:8080/demantra/portal/loginpage.jsp

Web client
http://sys50.doyen.in:8080/demantra/portal/partnerLogin.jsp

Oracle Demantra Anywhere version of Collaborator Workbench
http://sys50.doyen.in:8080/demantra/portal/remoteloginpage.jsp

Oracle Demantra Anywhere version of Web client alone
http://sys50.doyen.in:8080/demantra/portal/anywhereLogin.jsp

Offline access to Oracle Demantra worksheets
http://sys50.doyen.in:8080/demantra/portal/launchDPWeb.jnlp

Dynamic Open Link (DOL) access for third-party reporting tools
http://sys50.doyen.in:8080/demantra/portal/DOL_HTML.htm

User Management
http://sys50.doyen.in:8080/demantra/portal/userManagement.jsp

Collaborator Workbench Administration
http://sys50.doyen.in:8080/demantra/portal/adminLogin.jsp

Workflow Manager
http://sys50.doyen.in:8080/demantra/workflow/login.jsp

Technical Administration
http://sys50.doyen.in:8080/demantra/admin

Metalink ID: 434991.1 - EBS-Demantra Integration Installation Overview and Diagram