Leave a Comment:
26 comments
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@ sailesh,
Good as long as you work hard and try to learn different things (including middleware)
Thanks Atul for the great posts. Looking forward to the next article!
ReplyHi 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. 🙂
ReplyI 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
ReplyHi 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@ 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 .
ReplyHi 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.
Replyhi 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@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)
ReplyI 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.
@ 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
ReplyI 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?
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@ 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 ?
Yes, I did it before the install. after decompression, i see 8 dump files
Reply@ 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
Replybefore 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?
@ 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
ReplyVery 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,
Do you see dump file (.dmp) under c:\oracle_basics\fusd\ as shown in your error message ?
I am installing RCU and got Error FUSION_ORA_ESS.REQUEST_HISTORY_VIEW has error.please advice.
ReplyI 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…
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