Davis Apps DBA

When trying to apply opatch on Oracle Apps Tier faced the following Issue. The Issue exactly occured when trying to run opatch lsinventory Error: OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred: Can not get a list of inventory on this home. ERROR: OPatch failed because of Inventory problem. Exact Scenario: bash-3.00$ opatch lsinventory Oracle Interim Patch Installer version 1.0.0.0.57 Copyright (c) 2007 Oracle Corporation. All Rights Reserved.. We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com Oracle Home           : /t02/d02/DEV/apps/tech_st/10.1.2 Oracle Home Inventory : /t02/d02/DEV/apps/tech_st/10.1.2/inventory Central Inventory     : /etc/oraInventory ...

The CROSSCHECK statement compares backup files on disk with entries in the catalog or controlfile.If a file is found in the catalog, but does not exist on disk it is marked as "EXPIRED". To crosscheck all backups use: RMAN> CROSSCHECK BACKUP; To list any expired backups detected by the CROSSCHECK command use: RMAN> LIST EXPIRED BACKUP; To delete any expired backups detected by the CROSSCHECK command use: RMAN> DELETE EXPIRED BACKUP; To crosscheck all archive logs use: RMAN> CROSSCHECK ARCHIVELOG ALL; To list all expired archive logs detected by the CROSSCHECK command use: RMAN> LIST EXPIRED ARCHIVELOG ALL; To delete all expired archive logs detected by the CROSSCHECK command use: RMAN> DELETE EXPIRED ARCHIVELOG ALL; To crosscheck all datafile image copies use: RMAN> CROSSCHECK DATAFILECOPY ALL; To list expired datafile copies use: RMAN> LIST EXPIRED DATAFILECOPY ALL; To delete expired datafile copies use: RMAN> DELETE ...

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...