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
- Installing Fusion Applications Provisioning Framework
- Installing Oracle 11g Database (Applications Transactional Database)
- Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
- Creating another database for Oracle Identity Management Infrastructure (optional)
- Running Repository Creation Utility (RCU) for Oracle Identity Management components
- Installing Oracle Identity and Access Management Components
- Configuring Oracle Identity and Access Management components
- Integrate Oracle Identity Manager (OIM) and Oracle Access Manager (OAM)
- Creating a New Provisioning Plan
- Provisioning an Applications Environment
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.
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?
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
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
Rajesh any luck on the issue, I have the same issue like you…
@Rajesh
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