Davis Apps DBA

Issue : ORA-20001 FND_CANT_INSERT_USER_ROLE After searching, got a Document from Oracle Support which suits this exact issue. Solution: Run concurrent program "Workflow Directory Services User/Role Validation"      with parameters : 100000, Yes, Yes, No. Once the program completed successfully, Functional Administrator Responsibility and other responsibility which is not visible in the Navigator will be available now. Issue is solved. Ref :  ORA-20001 FND_CANT_INSERT_USER_ROLE After Upgrading To Release 12.0.2 (Doc ID 454988.1)

ERROR: Failed to configure the target system – Failed to enable EBS_LOGON trigger The clone procedure for EBS R12.2 is quite different when compared with EBS R12.1. This post covers very generic   issues we may encounter while configuring the target server as a part of clone Process. ERROR : 1 Checking the port pool 6 done: Port Pool 6 is free Report file located at /u01/appl_PROD/PROD/fs2/inst/apps/PRODERP_erpnode3/admin/out/portpool.lst The new APPL_TOP context file has been created : /u01/appl_PROD/PROD/fs2/inst/apps/PRODERP_erpnode3/appl/admin/PRODERP_erpnode3.xml Check Clone Context logfile /u01/appl_PROD/PROD/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0811105848.log for details. FMW Pre-requisite check log file location : /u01/appl_PROD/PROD/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log Running: FMW pre-req check... ERROR: Run file system configuration has failed Check the logfile /u01/appl_PROD/PROD/fs1/inst/apps/PRODERP_erpnode3/admin/l...

Issue : ---------- Enter Password: REP-0004: Warning: Unable to open user preference file. REP-0069: Internal error REP-57054: In-process job terminated:Finished successfully but output is voided Report Builder: Release 10.1.2.2.0 - Production on Sat Jun 24 06:48:27 2017 Cause : Your local (customized) Oracle Reports preference file could not be opened. This is just a warning, so the product will continue to run even if this occurs. The possible causes of this error include the following: Case 1: The file was not found under the specified name in the specified location. Case 2: You lacked the necessary privileges to open the file. Case 3: A system error made it impossible to open the file. Action: ----------- You can take the following actions to rectify this error: Case 1: Make sure the file prefs.ora is located in your "home" directory. Case 2: Make sure that you have the privileges necessary to access the file. If you don't, ch...

Issue : 1 ----------- After upgradation from DB 10.2.0.3 to 11.2.0.4 in OEL 4.6 of Release 12.2.5 application, did the autoconfig and preclone process successfully in both db and apps tier. While cloning to the target instance getting error from DbTier. $perl adcfgclone.pl dbTier [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is: [filename]  [phase]  [return code where appropriate] [APPLY PHASE] AutoConfig could not successfully execute the following scripts: Directory: /u01/oracle/AJI/db/tech_st/11.2.0/perl/bin/perl -I /u01/oracle/AJI/db/tech_st/11.2.0/perl/lib/5.8.3 -I /u01/oracle/AJI/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3 -I /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/perl /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/clone ouicli.pl   INSTE8_APPLY 255 AutoConfig is exiting with stat...