Create Fusion Applications Schema using RCU : fusion & otbi

This is sixth post in series “Learn Oracle Fusion Applications with onlineAppsDBA.com” and covers steps to create/load Fusion Applications Schema’s in Transactional Database.  For first five posts check

.

Steps to load/create Fusion Applications Schema

1. Create below directories under $ORACLE_BASE (These directories can be anywhere on database server) of Oracle Database provisioned in earlier post here

a) $ORACLE_BASE/FADP  (This directory contains dump files for fusion applications used during schema creation)
b) $ORACLE_BASE/applcp  (Used by Oracle Enterprise Scheduler (similar Concurrent Manager in 11i/R12) to store the log and output files)
c) $ORACLE_BASE/appllog  (Used to store PL/SQL log file from Oracle Fusion Applications PL/SQL procedures)
d) $ORACLE_BASE/keyflexcombfilter  (Filter XMLSchema, used for re-loading in case of a patch)
e) $ORACLE_BASE/otbi (This directory contains dump files for business intelligence used during schema creation)

2. Extract and copy the dump files

a) cd $fusion_software/installer/apps_rcu/linux/rcu/integration/fusionapps
b) unzip export_fusionapps_dbinstall.zip
c) cp *.dmp $ORACLE_BASE/FADP
d) cd $fusion_software/installer/apps_rcu/linux/rcu/integration/biapps/schema/otbi.dmp $ORACLE_BASE/otbi

3.Start Fusion RCU installation from $fusion_software/installers/apps_rcu/linux/bin/rcu

4. Select “Create” and click “Next”

5. On “Database Connection Details screen” Fill Database details created during Database provisioning in earlier post at here

username : sys (or user with sysdba priviliges)

6. On “Select Components” screen, select “Fusion Applications” as shown in below image


.

7. On custom variable screen, provide full path to directory created in step 1 above . (Make that that *.dmp files are copied from fusion_software in to $ORACLE_BASE/FADP  & $ORACLE_BASE/otbi as explained in step 2 above)
.


.

8. On summary screen click “Create” (depending on CPU and memory available this process may take couple of hours)

Finally you should see status as “Success” against all components as shown below

For any issues check RCU logs under $fusion_software/installers/apps_rcu/linux/rcu/log/logdir.YYYY-MM-DD_HH-MM/*.log

Next step for Fusion Applications installation is to install, Identity and Access Management components (OID, OVD, OAM) coming soon ….

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

26 comments
sailesh says July 20, 2011

hi atul….recently i have joined in mnc company…i got oracle apps stream…i am a fresher…can u suggest me how it will be…

Reply
Atul Kumar says July 21, 2011

@ sailesh,
Good as long as you work hard and try to learn different things (including middleware)

Reply
Krishna says August 9, 2011

Thanks Atul for the great posts. Looking forward to the next article!

Reply
Sajith S says August 22, 2011

Hi Atul,

I got an error during the table space and schema creation of fusion applications using apps_rcu. It failed after 2 hours. The error is given below.

“Detected 1 diffs. Please see. /home/oracle/app/oracle/logdir.2011-08-10_23-30/fusionapps_verify.log for diff exceptions”.

I have checked the logs. I couldn’t find any useful information from this log.

Please help me to solve this issue. Thanks in advance. 🙂

Reply
sudheer says October 9, 2011

I am installing Oracle Fusion Application 11.1.1.5.1 on Linuxx86-64 bit. While installing RCU for Fusion Application i am getting follwoing error while running fusionapps_preimport_latest.sql

ORA-04063 : FUSION_ORA_ESS.REQUEST_HISTORY_VIEW has errors

ORA-06512 :line 18
ORA-06512 :line 29

Please advise

Reply
Klaas says October 20, 2011

Hi Atul,

Thanks for the blog, it is really helpful!

Is this already available:”Next step for Fusion Applications installation is to install, Identity and Access Management components (OID, OVD, OAM)”

Reply
Atul Kumar says October 20, 2011

@ Klass,
No , as Fusion Apps 11.1.1.5.1 is out now which has OAM 11g instead of OAM 10g (as required by Fusion Apps 11.1.1.5.0) I am planning to now do 11.1.1.5.1 FA and post OID/OVD/OAM/OIM steps here for 11.1.1.5

Most of them are already there in this blog for 11.1.1.3/4 all you need to now do is 11.1.1.5 now .

Reply
Klaas says October 20, 2011

Hi Atul,

Thanks for your quick reaction.

Actually I’m installing 11.1.1.5 and I’m doing that with the help of your posts.

Reply
saumil says November 6, 2011

hi Atul,

i stuck at #5, i am not able to connect sys, did not change the password while installation, do i need to pass fusionapps or sys if sys then what password should i use. though I have changed the default one but seems default install_by_change is not working, i too tried with system/manager, no luck , will you able to help/advice.

5. On “Database Connection Details screen” Fill Database details created during Database provisioning in earlier post at here
username : sys (or user with sysdba priviliges)

Thanks

Reply
Atul Kumar says November 6, 2011

@saumil,
On database tier create TNS alias to connect to this database and see if you can run

sqlplus sys/@TNS_Alias

If this fails then reset password as

sqlplus “/as sysdba”

alter user sys identified by welcome1;

Try again with sqlplus sys/welcome1@TNS_Alias

If this still fails then check if you have password file (or create password file in database)

Reply
kabilson says January 12, 2012

I got an error during the table space and schema creation of fusion applications using apps_rcu:

“Detected 354 diffs. Please see. /home/oracle/app/oracle/logdir.2012-01-10_15-52/fusionapps_verify.log for diff exceptions”.

I have checked the logs. I found errors like:
“Diff error SOURCEONLY : GRANT: DELETE ON FUSION.INV_GENERIC_DISPOSITIONS TO FUSION_APPS_READ_AND_WRITE”

can you help me to solve this issue.
Thanks in advance.

Reply
Atul Kumar says January 12, 2012

@ Kabilson,
Is this FA 11.1.1.5.0 or 11.1.1.5.1 or 11.1.2 ?

You specify dump file location, what file did you use ?

$ORACLE_BASE/FADP

Reply
kabilson says January 12, 2012

I am using FA 11.1.1.5.1
I put dump files(otbi and apps_dbinstall) in /tmp, do you think this is the source of the problem?

Reply
kabilson says January 12, 2012

I tried again using $ORACLE_HOME/FADP, but still have the same error.
linux 64/oracle DB 11.2.0.2/FA 11.1.1.5.1

Help pllllllllz

Reply
Atul Kumar says January 12, 2012

@ Kabilson ,
please confirm if this step on above post was followed

Extract and copy the dump files

a) cd $fusion_software/installer/apps_rcu/linux/rcu/integration/fusionapps
b) unzip export_fusionapps_dbinstall.zip
c) cp *.dmp $ORACLE_BASE/FADP

How many
fusionapps_dbinstall_latest_*.dmp files do you see in your folder ?

Reply
kabilson says January 12, 2012

Yes, I did it before the install. after decompression, i see 8 dump files

Reply
Atul Kumar says January 13, 2012

@ kabilson ,
Yeah 8 dmp files are fine. I could see 3-4 bugs in MOS which are all around use of wrong dmp file.

Lets see if you have any other errors before error you mentioned above

Reply
kabilson says January 13, 2012

before these errors, i see some errors in the import log, i am suspecting the dump files.
wich timestamp do you have in your export_fusionapps_dbinstall dump files?

Reply
Atul Kumar says January 15, 2012

@ kabilson,

-rwxr-xr-x 1 fusionapps dba 278944166 Dec 4 08:03 export_fusionapps_dbinstall.zip

-rw-rw-r– 1 fusionapps dba 24412160 Sep 7 10:21 fusionapps_dbinstall_latest_01.dmp

-rw-rw-r– 1 fusionapps dba 446210048 Sep 7 10:21 fusionapps_dbinstall_latest_02.dmp

-rw-rw-r– 1 fusionapps dba 41504768 Sep 7 10:21 fusionapps_dbinstall_latest_03.dmp

-rw-rw-r– 1 fusionapps dba 61927424 Sep 7 10:21 fusionapps_dbinstall_latest_04.dmp

-rw-rw-r– 1 fusionapps dba 65548288 Sep 7 10:21 fusionapps_dbinstall_latest_05.dmp

-rw-rw-r– 1 fusionapps dba 210382848 Sep 7 10:21 fusionapps_dbinstall_latest_06.dmp

-rw-rw-r– 1 fusionapps dba 178388992 Sep 7 10:21 fusionapps_dbinstall_latest_07.dmp

-rw-rw-r– 1 fusionapps dba 30261248 Sep 7 10:21 fusionapps_dbinstall_latest_08.dmp

Reply
kabilson says January 16, 2012

I have the same ones. I still trying, i have the same error

Reply
amr says March 21, 2012

Very Urgent my friend

while install the fusion in these stpes every think has “Success” against except fusion application see this pictures under this link

http://www.4shared.com/photo/pxR4Rf4h/file.html

i am installed under winserver 2008

Reply
amr says March 28, 2012

Please replay to me Please

Reply
Atul Kumar says March 28, 2012

@ amr,
Do you see dump file (.dmp) under c:\oracle_basics\fusd\ as shown in your error message ?

Reply
sudhakardba09 says April 26, 2012

I am installing RCU and got Error FUSION_ORA_ESS.REQUEST_HISTORY_VIEW has error.please advice.

Reply
navjit says August 12, 2012

I was running RCU,and found 3 errors as follows:

GRANT :EXECUTE ON SEARCHSYS.EQ_JOB TO FUSION_RUNTIME
ROLE:EQUSER
USER:SEARCHSYS

CAN YOU PLEASE REPLY AT THE EARLIEST?
Thanks in advance…

Reply
Priya says October 12, 2012

Its Highly Urgent for me And
I Would be Highly Obliged if you could suggest anything on the following Issue that i am facing.

While Running Fusion Applications Repository Creation Utility (Apps RCU)

I am facing these rcu related error.
RCU-6130:Action failed – RCU-6135 Error while trying to execute java action

I am installing Oracle Fusion Applications 11g Release 4 (11.1.4) on 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. & i ‘ve Downloaded the Oracle Fusion Applications 11g Release 4 (11.1.4)
Media Pack for Linux x86-64.
The directories for custom environment variables that i ‘ve specified during rcu phase :

/data/fusionapps/installers/apps_rcu/linux/dp_dir
[root@ddb1501 dp_dir]# ls
export_fusionapps_dbinstall.zip fusionapps_dbinstall_latest_06.dmp
fusionapps_dbinstall_latest_01.dmp fusionapps_dbinstall_latest_07.dmp
fusionapps_dbinstall_latest_02.dmp fusionapps_dbinstall_latest_08.dmp
fusionapps_dbinstall_latest_03.dmp import_20121011_074125.log
fusionapps_dbinstall_latest_04.dmp import_20121011_074822.log
fusionapps_dbinstall_latest_05.dmp otbi.dmp

[root@ddb1501 applcp]# pwd
/data/fusionapps/database/applcp

[root@ddb1501 appllog]# pwd
/data/fusionapps/database/appllog

[root@ddb1501 keyflexcombfilter]# pwd
/data/fusionapps/database/keyflexcombfilter

[root@ddb1501 obieebkp]# pwd
/data/fusionapps/database/obieebkp

Really Appreciate if could Identify anything that i can rectify here…

Also while Running Fusion Applications Repository Creation Utility (Apps RCU) after the Tablespaces creation phase
i got the following error while creating the required Schemas .
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 /

Please Advise..

Thanks & regards

Reply
Add Your Reply

Not found