Thursday, October 30, 2008

Deploy HTB in 10gAS

In this post, I shall talk about deploying HTB in 10gAS.


1. Oracle Applications E-Business Suite (EBS)
2. Oracle 10g AS
3. Standalone OC4J


1. Apply ATG RUP 4 patches (pre and post requisites).

2. Apply the HTB v5.3 patches (4178883 -- Patch 11i.HC_PF.E and 5178799 -- HC_PF: 11I.HC_PF.E ROLLUP 3 and their pre and post requisites).

Note: Ensure that standalone OC4J is installed (unzipped) and the OC4J environment variable is set before applying patches 4178883 (Patch 11i.HC_PF.E) and 5178799 (HC_PF: 11I.HC_PF.E ROLLUP 3). See previous post for explanation.

3. Install Oracle 10gAS on a server other than that hosting Oracle Apps (EBS). If it is installed on the same server as EBS (web tier - if one has a multi-node install), it does make life simple!

4. Copy over the APPL_TOP and the JAVA_TOP from the Oracle Applications EBS web tier to the Oracle 10g AS server.

5. Create a new OC4J Instance in the newly installed Oracle 10g AS.

6. Enter the OC4J Instance name (say HTB) and click on CREATE.

7. Click "OK" on the confirmation page.

8. New OC4J Instance HTB seen in the front page.

9. Replace the JDBC library files in <10gas_oracle_home>/jdbc/lib with the JDBC library files from $JAVA_TOP using the following commands:

mv $10gAS_ORACLE_HOME/jdbc/lib/classes12dms.jar $10gAS_ORACLE_HOME/jdbc/lib/classes12dms.jarO

mv $10gAS_ORACLE_HOME/jdbc/lib/nls_charset12.jar $10gAS_ORACLE_HOME/jdbc/lib/nls_charset12.jarO

cp -p $JAVA_TOP/ $10gAS_ORACLE_HOME/jdbc/lib/classes12dms.jar

cp -p $JAVA_TOP/ $10gAS_ORACLE_HOME/jdbc/lib/nls_charset12.jar

10. Copy the dbc file from $FND_TOP/secure/<CONTEXT_NAME>/<sid>.dbc to $10gAS_ORACLE_HOME/j2ee/<APPLICATION_NAME>/.

11. Navigate to the new OC4J Instance and modify the server properties.

HTB (New OC4J Instance) ==> Administration ==> Server Properties

Under the section Command Line Options,
add the below in the field java options and click on apply.

-server -Xmx1024M -Xms1024M<10gAS_ORACLE_HOME>/j2ee/<NEW_OC4J_INSTANCE>/config/java2.policy -Djava.awt.headless=true -DClientMode=local -DworkflowSupported=N -Djbo.323.compatible=true -DDBCFile=<10gAS_ORACLE_HOME>/j2ee/<NEW_OC4J_INSTANCE>/<SID>.dbc -DJTFDBCFILE=<10gAS_ORACLE_HOME>/j2ee/<NEW_OC4J_INSTANCE>/<SID>.dbc -DLONG_RUNNING_JVM=true -Ddedicated.rmicontext=true -Djbo.connectfailover=false -DAFLOG_ENABLED=true -DAFLOG_LEVEL=EXCEPTION -DAFLOG_MODULE=%ctb%,%hct% -DAFLOG_FILENAME=./aflog_c

12. Modify the application.xml under $10gAS_ORACLE_HOME/j2ee/<NEW_OC4J_INSTANCE>/config file to include the $CTB_TOP and $JAVA_TOP.

<library path="/oracle/ashtb/htbappl/ctb/11.5.0"/>
<library path="/oracle/ashtb/htbcomn/java"/>

13. Start the new OC4J Instance.


Click on the Start button.

14. Once the new OC4J instance is started, deploy the htb.ear file.

a. Download the htb.ear under $CTB_TOP/java/ear file to the local desktop to any location (say C:\htb).

b. Navigate to <HOST_NAME.DOMAIN> ==> OC4J:<NEW_OC4J_INSTANCE> ==> Applications

c. Click on "Deploy EAR File".

d. Enter the below information:

J2EE Application = <PATH to the htb.ear file on the local machine>

Application Name = HTB

Parent Application = Defualt

Click on Continue.

e. In the next screen - URL Mapping for Web Modules - click Next.

f. Click on "Next" without changing anything in the Resource Reference Mappings window.

g. In the User Manager window, all the data is entered by default apart from the DBC_FILE_PATH. Enter the path to the DBC file under $10gAS_ORACLE_HOME/j2ee/<NEW_OC4J_INSTANCE> and click on Next.

h. In the Review window, click on "Deploy".

g. Click on OK in the confirmation screen.

15. Modify the file data-sources.xml (10gAS_ORACLE_HOME/j2ee/<NEW_OC4J_INSTANCE>/config):

Add the below line:

password="apps" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOST_NAME.DOMAIN>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<SID>)))"

We are done as far as deployment of HTB in 10gAS is concerned.


Vani said...


how do u clone a R12 HTB instance to a test ?

is it same as ebiz R12 cloning?

Praveen said...

Yes, Vani. It should be the same as normal cloning. Once the cloning is complete, for the HTB in the cloned instance to be utilised, you have to deploy it in a separate 10gAS Oracle Home.

Caveat: I've done it it and not for R12 but I presume it might be the same. Do look up the documentation, to be on the safer side!