Running Fusion Applications RCU

Oracle Fusion Applications Installation: Running Fusion Applications Repository Creation Utility (Apps RCU)

Previous: Installing Oracle 11g Database (Applications Transactional Database)

Important Note: This is OLD guide for old version 11.1.1.5. Please follow instructions at http://www.oratraining.com/blog/2012/12/oracle-fusion-applications-installation-step-by-step-guide-11-1-5/ for latest guide for current version i.e. 11.1.5

 

Create a directory on physical partition and call it APPS_RCU_HOME

[oracle@fusion linux]$ mkdir /app/fusion/provisioning/apps_rcu

 

Go to repository_location/installers/apps_rcu and locate the rcuHome_fusionapps_linux.zip file. This file was staged when you created the installer repository.

 

Extract the contents of rcuHome_fusionapps_linux.zip to a directory (APPS_RCU_HOME) on the database server. All dependent components that Applications RCU needs are included in this zipped file.

 

[oracle@fusion apps_rcu]$ cd /app/fusion/provisioning/apps_rcu

[oracle@fusion apps_rcu]$ unzip /mnt/fusion/installers/apps_rcu/linux/rcuHome_fusionapps_linux.zip

 

Create a temporary directory on the database server. Make a note of the location.

You will need to enter this location when you specify a value for FUSIONAPPS_DBINSTALL_DP_DIR

 

[oracle@fusion apps_rcu]$ mkdir /app/fusion/provisioning/apps_rcu/dp_dir

 

Locate and copy APPS_RCU_HOME/rcu/integration/fusionapps/export_

fusionapps_dbinstall.zip to the directory you specified for FUSIONAPPS_

DBINSTALL_DP_DIR.

 

Unzip export_fusionapps_dbinstall.zip to FUSIONAPPS_DBINSTALL_DP_DIR.

 

[oracle@fusion dp_dir]$ cd /app/fusion/provisioning/apps_rcu/dp_dir

[oracle@fusion dp_dir]$ unzip /app/fusion/provisioning/apps_rcu/rcu/integration/fusionapps/export_fusionapps_dbinstall.zip

 

Go to APPS_RCU_HOME/rcu/integration/biapps/schema and locate the

otbi.dmp file.

Copy otbi.dmp to FUSIONAPPS_DBINSTALL_DP_DIR (where you unzipped the

contents of export_fusionapps_dbinstall.zip).

 

[oracle@fusion dp_dir]$ cp -p ../rcu/integration/biapps/schema/otbi.dmp /app/fusion/provisioning/apps_rcu/dp_dir/

 

Launch Repository Creation Utility (RCU)

 

[oracle@fusion bin]$ cd /app/fusion/provisioning/apps_rcu/bin

[oracle@fusion bin]$ ./rcu

Click Next

Click Next

Enter same details as entered while creating the database in previous step. Click Next

This screen will check pre-requisites. Click Ok once successful.

Select all components in this Window.

It will look as above when you collapse all parent values. Click Next

 

Important Note: If you had reduced SGA and PGA size after DB installation then this prerequisites check may fail with following error.

RCU-6083:Failed – Check prerequisites requirement for selected component:FUSIONAPPS

RCU-6107:DB Init Param Prerequisite failure for: pga_aggregate_target

Current Value is 2147483648. It should be greater than or equal to 4294967296.

RCU-6107:DB Init Param Prerequisite failure for: sga_target

Current Value is 2147483648. It should be greater than or equal to 9663676416.

 

To fix this issue, we need to modify the minimum requirement of SGA and PGA in installer pre-requisite config file located at /app/fusion/provisioning/apps_rcu/rcu/integration/fusionapps/fusionapps.xml

 

Change these values as follows.

<DBPrerequisite COMPARE_OPERATOR=”GE” DATA_TYPE=”NUMBER” PREREQ_TYPE=”InitParameter”>

<ValidIf DBTYPE=”ORACLE”/>

<PrereqIdentifier>sga_target</PrereqIdentifier>

<PrereqValue>2147483648</PrereqValue>

</DBPrerequisite>


<DBPrerequisite COMPARE_OPERATOR=”GE” DATA_TYPE=”NUMBER” PREREQ_TYPE=”InitParameter”>

<ValidIf DBTYPE=”ORACLE”/>

<PrereqIdentifier>pga_aggregate_target</PrereqIdentifier>

<PrereqValue>2147483648</PrereqValue>

</DBPrerequisite>

 


The prerequisites check should finish successfully. Click Ok

 


Enter same password Oracle123 for keeping it simplefor now. Click Next

 


Open another terminal window. Create following directories for custom environment variables.

[oracle@fusion database]$ mkdir /app/fusion/database/applcp

[oracle@fusion database]$ mkdir /app/fusion/database/appllog

[oracle@fusion database]$ mkdir /app/fusion/database/keyflexcombfilter

[oracle@fusion database]$ mkdir /app/fusion/database/obieebkp

 

Specify these following values in the same screen under Fusion Applications Component (expect first value which is the temporary DP directory created before /app/fusion/provisioning/apps_rcu/dp_dir)

 

Supervisor Password: You must enter the same password you set up as ODI SUPERVISOR in Applications RCU. Since we kept all passwords as Oracle123, nothing much to remember. Enter the same password.

Work Repository Password: Default = None. You must enter the same password set up as ODI SUPERVISOR in Applications RCU.

Oracle Transactional BI

Directory on the database server where Oracle Transactional Business Intelligence import and export files are stored. Enter /app/fusion/provisioning/apps_rcu/dp_dir again.


Change nothing in this page. Click Next

 


Click OK

 


 


Now it will create the required tablespaces. Click OK


Once Tablespaces are created, next Summary screen will appear for creating the required Schemas. Click Create


It may take a couple of hours or even more based on the available memory and CPU for the VM and host machine.

 

 


 

Once finished, a completion summary screen will appear. It will show details for each components and completion states. Click Close

Next: Running Repository Creation Utility (RCU) for Oracle Identity Management components

Installing Oracle Fusion Applications – steps

  1. Installing Fusion Applications Provisioning Framework
  2. Installing Oracle 11g Database (Applications Transactional Database)
  3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
  4. Creating another database for Oracle  Identity Management Infrastructure (optional)
  5. Running Repository Creation Utility (RCU) for Oracle Identity Management components
  6. Installing Oracle Identity and Access Management Components
  7. Configuring Oracle Identity and Access Management components
  8. Integrate Oracle Identity Manager (OIM) and Oracle Access Manager (OAM)
  9. Creating a New Provisioning Plan
  10. Provisioning an Applications Environment
  1. Dhanraj Nikam
    Jan 22nd, 2013 at 10:53 | #1

    Hi I am installing Fusion Application on the Windows server 2008.

    I have followed all the steps till Installing Database.
    I have also created all the maintain directories and copied all the dmp file to there.

    while Running Fusion Applications Repository Creation Utility (Apps RCU)

    I have received following error when i select Fusion Application for fusionapps_Storage.xml file.
    Is anybody have any Idea about this?

    The Error is :

    2013-01-19 23:53:43.746 ERROR rcu: oracle.sysman.assistants.rcu.backend.xmldata.handlers.RCUValidator::error: RCUValidator caught a SAXParseException.
    org.xml.sax.SAXParseException: file:/C:/ptc-dn-fusion/appbase/database/rcuHome/rcu/integration/fusionapps/fusionapps_Storage.xml: XML-20147: (Error) Invalid element ‘DatafilesList’ in content of ‘TablespaceAttributes’, expected closing tag.

  2. PriyaGupta
    Oct 12th, 2012 at 08:48 | #2

    Just to Add..

    I encountered these Error while executing the above rcu steps that u ‘ve mentioned here.

    I am installing Oracle Fusion Applications 11g Release 4 (11.1.4) single node server.. The Linux server is 64 bit & RAM is 135 gb & disk space is 800 gb.

    There is No Oracle database previously installed on this server. & we ‘ve Downloaded the Oracle Fusion Applications 11g Release 4 (11.1.4) Media Pack for Linux x86-64.

    Thanks !!

    • vali
      Nov 9th, 2012 at 13:15 | #3

      PriyaGupta :
      Just to Add..
      I encountered these Error while executing the above rcu steps that u ‘ve mentioned here.
      I am installing Oracle Fusion Applications 11g Release 4 (11.1.4) single node server.. The Linux server is 64 bit & RAM is 135 gb & disk space is 800 gb.
      There is No Oracle database previously installed on this server. & we ‘ve Downloaded the Oracle Fusion Applications 11g Release 4 (11.1.4) Media Pack for Linux x86-64.
      Thanks !!

      Hi have you found a way to handle this error?

  3. PriyaGupta
    Oct 12th, 2012 at 08:36 | #4

    Hi
    Excellent work…Appreciate your work…thanks very much for sharing
    Its very Useful Docs.
    You ‘ve explained Oracle Fusion Installation steps in easy to understand
    & easier to follow format

    I am following the Installation steps that you ‘ve mentioned

    I am facing these rcu related error.

    RCU-6130:Action failed – RCU-6135 Error while trying to execute java action

    Please Advise..

    Thanks !!!
    Priya

  4. Mazhar
    Oct 11th, 2012 at 15:40 | #5

    I am doing Oracle Fusion Applications 11g Installation while Running Fusion Applications Repository Creation Utility (Apps RCU) after the Tablespaces creation phase

    I am getting the following error while creating the required Schemas which is the last steps of rcu.

    ora-24010: Queue fusion.acr_ads_ims_queue does not exist
    ora-06512 at SYS.DBMS_AQADM LINE 270
    ORA-6512 AT LINE 98

    Can we Ignore the Error.

    Here is the content of fusionapps_postimport_latest.sql which is the Error file under/oracle/fusionapps/installers/apps_rcu/lrcu/integration/fusionapps/sql Direct.
    132 FA_DBINSTALL_CREATE_TRIG(‘logon_trigger_for_fusion after logon on
    133 fusion_runtime.schema
    134 ‘,’begin
    135 execute immediate ”ALTER SESSION SET CURRENT_SCHEMA = FUSION”;
    136 end;
    137 ‘);
    138 FA_DBINSTALL_CREATE_TRIG(‘logon_trigger_for_fusion_bi after logon on fus ion_bi.schema
    139 ‘,’begin
    140 execute immediate ”ALTER SESSION SET CURRENT_SCHEMA = FUSION”;
    141 end;
    142 ‘);
    143 END;
    144 DECLARE
    145 num_cpus NUMBER;
    146 BEGIN
    147 –################################# RECOMPILE SCHEMAS ################## ###############
    148 SELECT value INTO num_cpus FROM v$osstat WHERE stat_name = ‘NUM_CPUS’;
    149 SYS.UTL_RECOMP.RECOMP_PARALLEL(threads => num_cpus, schema => NULL);
    150 END;
    151 END;
    152 /

    Appreciate if you could suggest … Can we Ignore the Error ?
    Thanks & regards
    MZ

  5. sam
    May 20th, 2012 at 05:10 | #6

    Rajesh any luck on the issue, I have the same issue like you…
    @Rajesh

  6. Rajesh
    May 4th, 2012 at 16:37 | #7

    Dear Sir,
    I am getting the below error when creating Fusion Application.

    Please advise.

    2012-05-04 00:45:07.473 NOTIFICATION rcu: oracle.apps.fnd.dbinstall.DataPumpUtils::importSchema: importSchema done.
    2012-05-04 00:45:09.118 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method: Excepton:
    java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:462)
    at java.lang.Thread.run(Thread.java:662)
    Caused by: java.sql.SQLException: No more data to read from socket
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:490)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1053)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:588)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3840)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
    at oracle.apps.fnd.dbinstall.DataPumpUtils.getStatus(DataPumpUtils.java:685)
    at oracle.apps.fnd.dbinstall.DataPumpUtils.importSchema(DataPumpUtils.java:530)
    … 6 more

    2012-05-04 00:45:09.500 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: No more data to read from socket

    2012-05-04 11:47:28.049 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
    oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6135:Error while trying to execute Java action.
    at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:300)
    at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
    at java.lang.Thread.run(Thread.java:662)
    Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6135:Error while trying to execute Java action.
    at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:489)
    … 1 more
    Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:462)
    … 1 more
    Caused by: java.sql.SQLException: No more data to read from socket
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:490)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1053)
    at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:588)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3840)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
    at oracle.apps.fnd.dbinstall.DataPumpUtils.getStatus(DataPumpUtils.java:685)
    at oracle.apps.fnd.dbinstall.DataPumpUtils.importSchema(DataPumpUtils.java:530)
    … 6 more

    2012-05-04 11:47:28.406 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: Executing Task: Execute post create operations
    2012-05-04 11:47:28.406 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.CustomCompManager::getActionList: CustomCompManager.getActionList: CUSTOM_COMP_POSTLOAD_CLEANUP
    2012-05-04 11:47:28.581 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: Execution time for Execute post create operations : 175 milliseconds
    2012-05-04 11:48:04.951 NOTIFICATION rcu: oracle.sysman.assistants.rcu.ui.InteractiveRCUModel::showCompletionMessage: Repository Creation Utility: Create – Completion Summary
    Database details:
    Host Name : fusion
    Port : 1521
    Service Name : FUSIONDB
    Connected As : sys
    Prefix for (prefixable) Schema Owners : DEFAULT_PREFIX
    RCU Logfile : /app/fusion/provisioning/apps_rcu/rcu/log/logdir.2012-05-03_16-21/rcu.log
    RCU Checkpoint Object : /app/fusion/provisioning/apps_rcu/rcu/log/RCUCheckpointObj
    Component schemas created:
    Component Status Logfile
    Fusion Applications Failed /app/fusion/provisioning/apps_rcu/rcu/log/logdir.2012-05-03_16-21/fusionapps.log

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>