Rename anyone of the report under INV_TOP and try to recreate it using adadmin. [applvision@apps US]$ ls -tlrh /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf -rw-r--r-- 1 applvision applmgr 184K Mar 9 2013 /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf [applvision@apps US]$ mv /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf_15sep2013 [applvision@apps US]$ ls -tlrh /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf ls: /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf: No such file or directory [applvision@apps US]$ [applvision@apps ~]$ adadmin Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA Oracle Applications AD Administration Version 12.0.0 NOTE: You may not use this utility for custom development unless you have written permission from Oracle Corporation. Your default directory is '/apps/vision/apps/apps_st/appl'. Is this the correct APPL_TOP [Yes] ? AD Administration records your AD Administration session in a text file you specify. Enter your AD Administration log file name or press [Return] to accept the default file name shown in brackets. Filename [adadmin.log] : practice.log ************* Start of AD Administration session ************* AD Administration version: 12.0.0 AD Administration started at: Mon Sep 16 2013 00:59:44 APPL_TOP is set to /apps/vision/apps/apps_st/appl You can be notified by email if a failure occurs. Do you wish to activate this feature [No] ? Please enter the batchsize [1000] : Please enter the name of the Oracle Applications System that this APPL_TOP belongs to. The Applications System name must be unique across all Oracle Applications Systems at your site, must be from 1 to 30 characters long, may only contain alphanumeric and underscore characters, and must start with a letter. Sample Applications System names are: "prod", "test", "demo" and "Development_2". Applications System Name [vision] : vision * NOTE: If you do not currently have certain types of files installed in this APPL_TOP, you may not be able to perform certain tasks. Example 1: If you don't have files used for installing or upgrading the database installed in this area, you cannot install or upgrade the database from this APPL_TOP. Example 2: If you don't have forms files installed in this area, you cannot generate them or run them from this APPL_TOP. Example 3: If you don't have concurrent program files installed in this area, you cannot relink concurrent programs or generate reports from this APPL_TOP. Do you currently have files used for installing or upgrading the database installed in this APPL_TOP [YES] ? YES * Do you currently have Java and HTML files for HTML-based functionality installed in this APPL_TOP [YES] ? YES * Do you currently have Oracle Applications forms files installed in this APPL_TOP [YES] ? YES * Do you currently have concurrent program files installed in this APPL_TOP [YES] ? YES * Please enter the name Oracle Applications will use to identify this APPL_TOP. The APPL_TOP name you select must be unique within an Oracle Applications System, must be from 1 to 30 characters long, may only contain alphanumeric and underscore characters, and must start with a letter. Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1". APPL_TOP Name [apps] : apps * You are about to use or modify Oracle Applications product tables in your ORACLE database 'vision' using ORACLE executables in '/apps/vision/apps/tech_st/10.1.2'. Is this the correct database [Yes] ? AD Administration needs the password for your 'SYSTEM' ORACLE schema in order to determine your installation configuration. Enter the password for your 'SYSTEM' ORACLE schema: The ORACLE username specified below for Application Object Library uniquely identifies your existing product group: APPLSYS Enter the ORACLE password of Application Object Library [APPS] : AD Administration is verifying your username/password. The status of various features in this run of AD Administration is: <-Feature version in-> Feature Active? APPLTOP Data model Flags ------------------------------ ------- -------- ----------- ----------- CHECKFILE Yes 1 1 Y N N Y N Y PREREQ Yes 6 6 Y N N Y N Y CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N PATCH_TIMING Yes 2 2 Y N N Y N Y PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y SCHEMA_SWAP Yes 1 1 Y N N Y Y Y JAVA_WORKER Yes 1 1 Y N N Y N Y CODELEVEL Yes 1 1 Y N N Y N Y Identifier for the current session is 16762 Reading product information from file... Reading language and territory information from file... Reading language information from applUS.txt ... AD Administration warning: Product Data File /apps/vision/apps/apps_st/appl/admin/zfaprod.txt does not exist for product "zfa". This product is registered in the database but the above file does not exist in APPL_TOP. The product will be ignored without error. AD Administration warning: Product Data File /apps/vision/apps/apps_st/appl/admin/zsaprod.txt does not exist for product "zsa". This product is registered in the database but the above file does not exist in APPL_TOP. The product will be ignored without error. AD Administration warning: Product Data File /apps/vision/apps/apps_st/appl/admin/jtsprod.txt does not exist for product "jts". This product is registered in the database but the above file does not exist in APPL_TOP. The product will be ignored without error. Reading database to see what industry is currently installed. Reading FND_LANGUAGES to see what is currently installed. Currently, the following language is installed: Code Language Status ---- --------------------------------------- --------- US American English Base Your base language will be AMERICAN. Setting up module information. Reading database for information about the modules. Saving module information. Reading database for information about the products. Reading database for information about how products depend on each other. Reading topfile.txt ... Saving product information. AD code level : [B.1] AD Administration Main Menu -------------------------------------------------- 1. Generate Applications Files menu 2. Maintain Applications Files menu 3. Compile/Reload Applications Database Entities menu 4. Maintain Applications Database Entities menu 5. Change Maintenance Mode 6. Exit AD Administration Enter your choice [5] :1 Generate Applications Files ---------------------------------------- 1. Generate message files 2. Generate form files 3. Generate report files 4. Generate product JAR files 5. Return to Main Menu Enter your choice [5] : 3 AD utilities can support a maximum of 999 workers. Your current database configuration supports a maximum of 84 workers. Oracle recommends that you use between 8 and 16 workers. Enter the number of workers [8] : 6 Your current character set is "US7ASCII". Do you want to generate Oracle Reports objects using this character set [Yes] ? Do you want to regenerate Oracle Reports PL/SQL library files [Yes] ? Do you want to regenerate Oracle Reports executable files [Yes] ? Enter list of products ('all' for all products) [all] : inv Generate specific reports objects for each selected product [No] ? yes The current set of installed languages is: US Please select languages for generating Oracle Reports files. You may select all of the above languages, or just a subset. Enter list of languages ('all' for all of the above) [all] : US You selected the following languages: US Is this the correct set of languages [Yes] ? You selected the following languages: US Is this the correct set of languages [Yes] ? Reading product report information... Selecting Oracle Reports PL/SQL library files to generate... Selecting library files for Inventory... List of libraries in Inventory : INVISMMX.pll inv.pll Enter libraries to generate, or enter 'all' [all] : Selecting product reports to generate... Selecting reports for Inventory... List of reports in Inventory : INVARAAS.rdf INVARADV.rdf INVARCLI.rdf INVARCPA.rdf INVARCTA.rdf INVARHMA.rdf INVARORE.rdf INVARPAR.rdf INVARPIA.rdf INVARPMT.rdf INVARPSL.rdf INVARPTP.rdf INVARPTS.rdf INVARRTA.rdf INVARUIR.rdf INVCCIER.rdf INVCCTCA.rdf INVCHGPU.rdf INVDRRSV.rdf INVGCORP.rdf INVINPSR.rdf INVIRCAT.rdf INVIRCIT.rdf INVIRCOC.rdf INVIRCXR.rdf INVIRDIS.rdf INVIRDST.rdf INVIRILC.rdf INVIRISQ.rdf INVIRITD.rdf INVIRITS.rdf INVIRRCR.rdf INVIRRIT.rdf INVIRSIQ.rdf INVIRSLO.rdf INVIRSNO.rdf INVIRTMP.rdf INVIRXRF.rdf INVISMMX.rdf INVKBCPR.rdf INVM2MQT.rdf INVMRMQT.rdf INVMSCHR.rdf INVMSWHU.rdf INVMVTEX.rdf INVONHSP.rdf INVORGES.rdf INVPOPSR.rdf INVPRFDH.rdf INVPRFRL.rdf INVRCWSR.rdf INVSRAAL.rdf INVSRFRT.rdf INVSRIOS.rdf INVSRISA.rdf INVSRLOC.rdf INVSROPT.rdf INVSRPLN.rdf INVSRSPT.rdf INVSRSUB.rdf INVSRUOM.rdf INVSTMVT.rdf INVTOPKL.rdf INVTRACS.rdf INVTRCLS.rdf INVTRDST.rdf INVTRELT.rdf INVTRHAN.rdf INVTRLNT.rdf INVTRREG.rdf INVTRSHS.rdf INVTRSNT.rdf INVTRSTS.rdf INVTRVLT.rdf Enter reports to generate, or enter 'all' [all] : Generating Oracle Reports objects... Creating the AD_UTIL_PARAMS table... Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it. Creating FND_INSTALL_PROCESSES table... Writing dependencies of jobs to run to appldep.txt file... There are now 76 jobs remaining (current phase=admin): 0 running, 2 ready to run and 74 waiting. Reading completed jobs from restart file (if any). There are now 76 jobs remaining (current phase=admin): 0 running, 2 ready to run and 74 waiting. Determining which java executables are supported by adJavaWorker... Starting worker processes. Worker process 1 started. Worker process 2 started. ************* Start of AD Worker session ************* AD Worker version: 12.0.0 AD Worker started at: Mon Sep 16 2013 02:34:08 APPL_TOP is set to /apps/vision/apps/apps_st/appl ************* Start of AD Worker session ************* AD Worker version: 12.0.0 AD Worker started at: Mon Sep 16 2013 02:34:08 APPL_TOP is set to /apps/vision/apps/apps_st/appl Worker process 3 started. ************* Start of AD Worker session ************* AD Worker version: 12.0.0 AD Worker started at: Mon Sep 16 2013 02:34:08 APPL_TOP is set to /apps/vision/apps/apps_st/appl Worker process 4 started. ************* Start of AD Worker session ************* AD Worker version: 12.0.0 AD Worker started at: Mon Sep 16 2013 02:34:08 APPL_TOP is set to /apps/vision/apps/apps_st/appl Worker process 5 started. ************* Start of AD Worker session ************* AD Worker version: 12.0.0 AD Worker started at: Mon Sep 16 2013 02:34:08 APPL_TOP is set to /apps/vision/apps/apps_st/appl Worker process 6 started. Checking if all jobs have their actual and symbolic arguments in sync.... Done. Writing jobs to run to restart file. Reading jobs from FND_INSTALL_PROCESSES table ... Done reading jobs from FND_INSTALL_PROCESSES table ... Telling workers to read 'todo' restart file. ************* Start of AD Worker session ************* Done.AD Worker version: 12.0.0 AD Worker started at: Mon Sep 16 2013 02:34:08 APPL_TOP is set to /apps/vision/apps/apps_st/appl Starting phase 1000 (admin): Generate Report Libraries There are now 76 jobs remaining (current phase=admin): 0 running, 2 ready to run and 74 waiting. Assigned: file INVISMMX.pll on worker 1 for product au username APPLSYS. Assigned: file inv.pll on worker 2 for product au username APPLSYS. Completed: file inv.pll on worker 2 for product au username APPLSYS. Completed: file INVISMMX.pll on worker 1 for product au username APPLSYS. Starting phase 1001 (admin+1): Generate Report Files There are now 74 jobs remaining (current phase=admin+1): 0 running, 74 ready to run and 0 waiting. Assigned: file INVARAAS.rdf on worker 1 for product inv username INV. Assigned: file INVARADV.rdf on worker 2 for product inv username INV. Assigned: file INVARCLI.rdf on worker 3 for product inv username INV. Assigned: file INVARCPA.rdf on worker 4 for product inv username INV. Assigned: file INVARCTA.rdf on worker 5 for product inv username INV. Assigned: file INVARHMA.rdf on worker 6 for product inv username INV. Completed: file INVARAAS.rdf on worker 1 for product inv username INV. Assigned: file INVARORE.rdf on worker 1 for product inv username INV. Completed: file INVARHMA.rdf on worker 6 for product inv username INV. Assigned: file INVARPAR.rdf on worker 6 for product inv username INV. Completed: file INVARCLI.rdf on worker 3 for product inv username INV. Completed: file INVARCPA.rdf on worker 4 for product inv username INV. Assigned: file INVARPIA.rdf on worker 3 for product inv username INV. Assigned: file INVARPMT.rdf on worker 4 for product inv username INV. Completed: file INVARADV.rdf on worker 2 for product inv username INV. Assigned: file INVARPSL.rdf on worker 2 for product inv username INV. Completed: file INVARCTA.rdf on worker 5 for product inv username INV. Assigned: file INVARPTP.rdf on worker 5 for product inv username INV. Completed: file INVARPIA.rdf on worker 3 for product inv username INV. Assigned: file INVARPTS.rdf on worker 3 for product inv username INV. There are now 67 jobs remaining (current phase=admin+1): 6 running, 61 ready to run and 0 waiting. Completed: file INVARORE.rdf on worker 1 for product inv username INV. Assigned: file INVARRTA.rdf on worker 1 for product inv username INV. Completed: file INVARPMT.rdf on worker 4 for product inv username INV. Assigned: file INVARUIR.rdf on worker 4 for product inv username INV. Completed: file INVARPTP.rdf on worker 5 for product inv username INV. Assigned: file INVCCIER.rdf on worker 5 for product inv username INV. Completed: file INVARPAR.rdf on worker 6 for product inv username INV. Assigned: file INVCCTCA.rdf on worker 6 for product inv username INV. Completed: file INVARRTA.rdf on worker 1 for product inv username INV. Assigned: file INVCHGPU.rdf on worker 1 for product inv username INV. Completed: file INVARUIR.rdf on worker 4 for product inv username INV. Assigned: file INVDRRSV.rdf on worker 4 for product inv username INV. Completed: file INVCCTCA.rdf on worker 6 for product inv username INV. Assigned: file INVGCORP.rdf on worker 6 for product inv username INV. Completed: file INVARPSL.rdf on worker 2 for product inv username INV. Completed: file INVARPTS.rdf on worker 3 for product inv username INV. Assigned: file INVINPSR.rdf on worker 2 for product inv username INV. Assigned: file INVIRCAT.rdf on worker 3 for product inv username INV. Completed: file INVCCIER.rdf on worker 5 for product inv username INV. Assigned: file INVIRCIT.rdf on worker 5 for product inv username INV. There are now 57 jobs remaining (current phase=admin+1): 6 running, 51 ready to run and 0 waiting. Completed: file INVTRLNT.rdf on worker 2 for product inv username INV. Completed: file INVTRSHS.rdf on worker 4 for product inv username INV. Assigned: file INVTRVLT.rdf on worker 2 for product inv username INV. Completed: file INVTRSNT.rdf on worker 1 for product inv username INV. Completed: file INVTRREG.rdf on worker 3 for product inv username INV. Completed: file INVTRSTS.rdf on worker 6 for product inv username INV. Completed: file INVTRHAN.rdf on worker 5 for product inv username INV. Completed: file INVTRVLT.rdf on worker 2 for product inv username INV. Telling workers to quit... 5 workers have quit. Waiting for 1 more. All workers have quit. Dropping FND_INSTALL_PROCESSES table... FND_INSTALL_PROCESSES table dropped. Dropping AD_DEFERRED_JOBS table... AD_DEFERRED_JOBS table dropped. Copying files to destination ... Done copying files to destination. Review the messages above, then press [Return] to continue. Now check generated report which we moved. ======================================== [applvision@apps US]$ ls -tlrh /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf ls: /apps/vision/apps/apps_st/appl/inv/12.0.0/reports/US/INVIRSLO.rdf: No such file or directory [applvision@apps US]$ date Mon Sep 16 02:37:02 IST 2013 [applvision@apps US]$ Note : We cannot generate reports by using above procedure. It is done through rwcon60 in oracle application 11i .
Posts Tagged ‘APPS DBA’
How Can We Generate Reports For Specific Product Top In Oracle EBS
December 19th, 2021, posted in Oracle EBS ApplicationCheck Patches Applied in Oracle Database
October 12th, 2020, posted in Oracle Queries
How to Check Latest Patch Applied To The Database
1. Listing Applied Patches
To print a summary of installed patches, you can can use opatch lspatches command.
[oracle@den03adm03 admin]$ $ORACLE_HOME/OPatch/opatch lspatches
30503372;OJVM PATCH SET UPDATE 11.2.0.4.200114
29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455)
30310975;DATABASE PATCH FOR EXADATA (Jan 2020 - 11.2.0.4.200114) : (30310975)
2. Using opatch lsinventory
[oracle@orahowdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory|grep "Patch description"
Patch description: "Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)"
Patch description: "Database Patch Set Update : 12.1.0.2.190716 (29494060)"
3. Get detailed info Using opatch lsinventory
[oracle@orahowdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /scratch/u01/app/oracle/product/12.1.0/dbhome_1 Central Inventory : /scratch/u01/app/oraInventory from : /scratch/u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.1.0.2.0 Log file location : /scratch/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10-12_11-28-58AM_1.log Lsinventory Output file location : /scratch/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-10-12_11-28-58AM.txt Local Machine Information:: Hostname: orahowdb ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 12c 12.1.0.2.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 29774383 : applied on Wed Sep 04 03:44:12 PDT 2019 Unique Patch ID: 22961858 Patch description: "Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)" Created on 7 Jun 2019, 10:02:47 hrs PST8PDT Bugs fixed: 29774383, 29774367, 29251241, 29254615, 19165673, 28790654, 28915933 28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235 27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690 26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695 25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756 24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914 23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226 22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944 19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866 19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857 19223010, 19245191, 19699946 Patch 29494060 : applied on Wed Sep 04 02:28:08 PDT 2019 Unique Patch ID: 22993235 Patch description: "Database Patch Set Update : 12.1.0.2.190716 (29494060)" Created on 28 Jun 2019, 07:47:40 hrs PST8PDT Bugs fixed: 19309466, 19902195, 18250893, 25437699, 19383839, 19781326, 16756406 18456643, 26546664, 22364044, 18845653, 19915271, 20172151, 18417036 19516448, 23713236, 24907917, 24796092, 23140259, 19243521, 19658708 18272672, 21153266, 19174430, 22243719, 19548064, 26556014, 20493163 20688221, 21387964, 13542050, 22250006, 22734547, 22243983, 21623164 19012119, 19932634, 19869255, 22232606, 18681056, 23324000, 25427662 22068305, 24589081, 19439759, 19303936, 22916353, 24835538, 22353346 19790243, 21106027, 26444887, 23088803, 22529728, 26256131, 19134173 24303148, 20447445, 21101873, 21188584, 19390567, 26513709, 25780343 19769480, 21097043, 21225209, 26245237, 20677396, 19284031, 19450314 19016730, 22517782, 20919320, 22205263, 22075064, 22551446, 22721409 18440095, 22496904, 16439813, 18354830, 20596234, 22022760, 20936905 23197103, 22515353, 21514877, 19809171, 21186167, 26111842, 18990023 25654936, 21492036, 18705806, 28420042, 19578247, 22024071, 22238921 22809871, 21184223, 19995869, 23089357, 19404068, 18921743, 19065677 19018447, 19018206, 18308268, 19777862, 29027694, 22223463, 19304354 22519146, 19445860, 26654363, 27199245, 22977256, 20890311, 27445727 21142837, 20869721, 24555417, 22179537, 21756699, 20217801, 18819908 22760595, 25483815, 23628685, 23007241, 19593445, 21080143, 27351628 20582405, 24966594, 20031873, 25489367, 18618122, 24737581, 21698350 26784509, 24739928, 18966843, 19077215, 20704450, 19068970, 20543011 19023822, 24713381, 20432873, 21756677, 22836801, 20328248, 18674047 18849537, 20087383, 25459958, 20315311, 22897344, 27534509, 25178179 19308965, 18948177, 19468991, 20868862, 21780146, 23315153, 20466628 21756661, 20397490, 19706965, 20302006, 24831514, 23240358, 22178855 19032777, 20862087, 19329654, 18974476, 20603378, 20859910, 19307662 26203182, 21847223, 20281121, 22568797, 19075256, 19076343, 18866977 28026866, 29511611, 22808310, 25635149, 20844426, 20904530, 20441797 21442094, 25079710, 24674955, 18840932, 18740837, 20294666, 25602488 21517440, 22062517, 19180394, 27337759, 19174942, 20671094, 21889720 19450116, 18411216, 20117253, 24386767, 20641666, 19931367, 25264559 19930276, 22092979, 25616268, 21625179, 20879709, 23003979, 20165574 28578164, 19272708, 19547370, 22624709, 23084507, 23184263, 20228093 21281532, 25093872, 19805359, 26324206, 19461270, 19434529, 18799063 20354900, 20378086, 29388020, 17008068, 21246723, 20831538, 20424899 24929210, 24560906, 20144308, 21620471, 19670108, 19068610, 20267166 25123585, 20476175, 18549238, 19297917, 22950945, 19385656, 23528412 19684504, 19330795, 21174504, 28357401, 20899461, 20557786, 21911701 19143550, 20118035, 19024808, 25760195, 20009833, 19604659, 16359751 26039623, 22820579, 19928926, 23314180, 20212067, 24737403, 20480209 18904062, 29030780, 26430737, 20856766, 17258582, 27169796, 21668627 20877664, 23272045, 19487147, 23149541, 24577566, 19430401, 19676905 20925795, 26482376, 21296029, 21629064, 23229229, 22865673, 20708701 25353983, 19280225, 21315084, 20613079, 19375649, 19213447, 19989009 18191823, 27314390, 26336977, 25775213, 24393981, 25639019, 17319928 14705949, 19703301, 28390273, 21626377, 20122715, 6418158, 23105538 26198926, 19258504, 21188532, 23151677, 24792678, 17890099, 21649497 26446098, 16887946, 26024732, 18791688, 19721304, 27012701, 19490948 19619732, 21164318, 23148260, 18090142, 21641760, 19818513, 23002524 20139391, 24693382, 19978542, 23543183, 22165897, 19373893, 22359063 19409212, 18373438, 23035249, 20677974, 18990693, 20470877, 21422580 21632821, 22351572, 20235511, 23220453, 18742258, 18604493, 23008056 22901797, 18610915, 20978259, 20832516, 24801152, 26089440, 20907061 19523462, 20505778, 19183343, 21787056, 21273804, 22782647, 25093739 17835294, 28708023, 24413809, 27846298, 18371441, 26714910, 24385983 20413820, 24421668, 28986231, 25897615, 25643931, 23195445, 21281607 20513399, 20558005, 20093776, 18909599, 20618595, 23572982, 19211433 20331945, 19512341, 22256431, 19637186, 19022470, 18607546, 26875822 24573817, 23115139, 19649152, 19201867, 21294938, 20898997, 18510194 21842740, 22454326, 24683149, 19534363, 25489607, 23061702 OPatch succeeded.
3.1: Detailed information on the applied patch.
[oracle@orahowdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -details
4: As a sysdba you can also execute below command from the sql prompt to get the patch detail.
SQL> set serverout on;
SQL> exec dbms_qopatch.get_sqlpatch_status;
Patch Id : 27338041
Action : APPLY
Action Time : 18-APR-2018 15:48:43
Description : DATABASE PATCH SET UPDATE 12.1.0.2.180417
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_D0
2NAQCD_CDBROOT_2018Apr18_15_46_27.log
Status : SUCCESS
Patch Id : 28259833
Action : APPLY
Action Time : 24-OCT-2018 03:29:23
Description : DATABASE PATCH SET UPDATE 12.1.0.2.181016
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/28259833/22488632/28259833_apply_D0
2NAQCD_CDBROOT_2018Oct24_03_28_14.log
Status : SUCCESS
Patch Id : 28440711
Action : APPLY
Action Time : 24-OCT-2018 03:38:12
Description : Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_apply_D0
2NAQCD_CDBROOT_2018Oct24_03_34_30.log
Status : SUCCESS
Patch Id : 28440711
Action : ROLLBACK
Action Time : 05-MAR-2019 03:12:23
Description : Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/28440711/22440644/28440711_rollback
_D02NAQCD_CDBROOT_2019Mar05_03_09_19.log
Status : SUCCESS
Patch Id : 28790654
Action : APPLY
Action Time : 05-MAR-2019 03:12:23
Description : Database PSU 12.1.0.2.190115, Oracle JavaVM Component (JAN2019)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/28790654/22620251/28790654_apply_D0
2NAQCD_CDBROOT_2019Mar05_03_10_18.log
Status : SUCCESS
Patch Id : 28729169
Action : APPLY
Action Time : 05-MAR-2019 03:12:23
Description : DATABASE PATCH SET UPDATE 12.1.0.2.190115
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/28729169/22626239/28729169_apply_D0
2NAQCD_CDBROOT_2019Mar05_03_10_18.log
Status : SUCCESS
Patch Id : 28790654
Action : ROLLBACK
Action Time : 30-APR-2019 04:50:11
Description : Database PSU 12.1.0.2.190115, Oracle JavaVM Component (JAN2019)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/28790654/22620251/28790654_rollback
_D02NAQCD_CDBROOT_2019Apr30_04_44_47.log
Status : SUCCESS
Patch Id : 29251241
Action : APPLY
Action Time : 30-APR-2019 04:50:11
Description : Database PSU 12.1.0.2.190416, Oracle JavaVM Component (APR2019)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/29251241/22839506/29251241_apply_D0
2NAQCD_CDBROOT_2019Apr30_04_46_08.log
Status : SUCCESS
Patch Id : 29141015
Action : APPLY
Action Time : 30-APR-2019 04:50:11
Description : DATABASE PATCH SET UPDATE 12.1.0.2.190416
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/29141015/22785785/29141015_apply_D0
2NAQCD_CDBROOT_2019Apr30_04_46_08.log
Status : SUCCESS
Patch Id : 29251241
Action : ROLLBACK
Action Time : 04-SEP-2019 04:09:43
Description : Database PSU 12.1.0.2.190416, Oracle JavaVM Component (APR2019)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/29251241/22839506/29251241_rollback
_D02NAQCD_CDBROOT_2019Sep04_04_06_10.log
Status : SUCCESS
Patch Id : 29774383
Action : APPLY
Action Time : 04-SEP-2019 04:09:43
Description : Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/29774383/22961858/29774383_apply_D0
2NAQCD_CDBROOT_2019Sep04_04_07_20.log
Status : SUCCESS
Patch Id : 29494060
Action : APPLY
Action Time : 04-SEP-2019 04:09:43
Description : DATABASE PATCH SET UPDATE 12.1.0.2.190716
Logfile :
/scratch/u01/app/oracle/cfgtoollogs/sqlpatch/29494060/22993235/29494060_apply_D0
2NAQCD_CDBROOT_2019Sep04_04_07_20.log
Status : SUCCESS
PL/SQL procedure successfully completed.
5: To get information on particular patch ID.
SQL> select xmltransform(dbms_qopatch.is_patch_installed('29494060'),dbms_qopatch.get_opatch_xslt) "Patch installed?" from dual; Patch installed? Patch Information: 29494060: applied on 2019-09-04T02:28:08-07:00
6: Patch detail from registry
SQL> select * from sys.registry$history; SQL> select * from sys.dba_registry_sqlpatch;
Get Current Patch Set Level of Oracle Applications Products For R12
October 11th, 2020, posted in Oracle EBS Application, Oracle Queries
1) Login to OAM
(Responsibility “Oracle Applications Manager“, menu “OAM Support Cart“)
and Navigate: Support Cart -> Applications Signature -> Collect -> Check “Product Information” box -> Click on “View” (eyeglasses)
In R12
(Responsibility “System Administrator“, Menu “Oracle Application Manager“)
and Navigate : Applications Usage >> Products Installed
This will display the following patchset information :
Application Name
Current Patch Level
Product Version
Status (Installed, Shared Product, Inactive)
2) The patchset level information can be retrieved directly via sqlplus with the following diagnostic script :
$AD_TOP/sql/adutconf.sql
3) Use the below query to pull out the details
SQL>
SELECT fav.application_id, fav.application_short_name, fav.application_name, fav.basepath, fav.creation_date, fpi.status, fpi.patch_level, fpi.product_version, fpi.TABLESPACE, fpi.index_tablespace, fpi.temporary_tablespace FROM fnd_application_vl fav, fnd_product_installations fpi WHERE fav.application_id = fpi.application_id(+) ORDER BY creation_date DESC
APP-PAY-06153:System Error. Procedure INIT_FORMS on Step 1
October 4th, 2020, posted in Oracle EBS ApplicationAPP-PAY-06153:System Error. Procedure INIT_FORMS on Step 1
Issue :
APP-PAY-06153:System Error. Procedure INIT_FORMS at Step 1 :
N:->Human Resources->Work Structures->Location
Solution :
N: System Administrator->Profile->System
Click find
Assign Site: FA: Vision Operations
Save and close
N:->Human Resource->Work Structure->Organization
Form is opened
Decoded INST_TOP Oracle R12 INSTANCE_HOME
June 13th, 2020, posted in Oracle
Features on this R12 INST_TOP
-All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top
- All configuration files have been moved to INST_TOP
like
DBc file
All the http related config files
appsweb.cfg
All the start or stop scripts
all the OC4J related config files
-we can now share the Apps and technology stack among multiple nodes and even instances (Dev,Test, Production) as all the log and config are located in this top.We will have INST_TOP for each context.
-Configuration and log files are co-located
-Easier collection of instance state
-Minimize disk usage and maximize performance
Filesystem look
/inst/apps/ ($INST_TOP)
• /admin
• /scripts ($ADMIN_SCRIPTS_HOME) All the start and stop are here
• /appl ($APPL_CONFIG_HOME) All the apps env are here
• /fnd/12.0.0/secure ($FND_SECURE) dbc file lis located here
• /certs
• /logs ($LOG_HOME) all the logs are located
• /ora ($ORA_CONFIG_HOME)
/10.1.2
/10.1.3 ($ORACLE_CONFIG_HOME) all the techstack(oacore,forms) related config files
• /pids
• /portal
• /rgf
Some more changes to variable
OA_HTML =$COMMON_TOP/webapps/oacore/html
JAVA_TOP=$COMMON_TOP/java/classes
AF_JLIB=$COMMON_TOP/java/lib
JAVA_BASE=$COMMON_TOP/java/
Advantage of INST_TOP
-Clear distinction between the shared file system and the file system unique to an instance
-Ability to share code (Apps, technology stack) among multiple nodes and even instances (Development ,Test, Production)
-Enables split ownership of applications and technology stack file systems
-Improves code safety by making shared file system read-only while not patching
-Configuration and log files are co-located
-Easier collection of instance state
-Ability to use network or local storage for various file system portions
-Minimize disk usage and maximize performance
R12.2 Changes
-R12.2 contains the Fusion Middleware 11g tech-stack. The logfile and configuration files is located in that Oracle Home
–Concurrent Manager log/out files have been moved in Non editioned File system
It is recommended to put INST_TOP on local filesystem in shared APPL_TOP filesystem architecture. This is because of the Apache mutex problem.Apache performance is highly sensitive to mutex file access latency, and at higher loads is also sensitive to I/Os per second. In case you have INST_TOP on shared filesystem, it is suggested to point these context variable to local file-system
s_lock_pid_dir
s_pids_dir
s_web_pid_file
Conclusion
Hope you like the post on R12 INST_TOP, all the advantages and R12.2 changes. Please do provide the feedback.