Error: When attempting to run command adcfgclone.pl appsTier dualfs while cloning the following error occurs. Exception in getting inventory Loc : null StackTrace: java.lang.NullPointerException at java.io.File.<init>(File.java:251) … continuous…. Command returned…
Read MoreRMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLFILE; rman> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE SBT; or…
Read MoreDescription: These two tables FND_ENV_CONTEXT FND_CONCURRENT_REQUESTS grown to 4 GB size . To speed up. Solution: 1. First Purge and then De-fragmentation to improve the performance of the DML fired…
Read MoreProblem: Concurrent program are running from long time and are not getting completed. $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132×66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace Get error: Environment:Environment java.lang.UnsatisfiedLinkError: Can’t…
Read MoreExecute the below in Application Tier: Run adpreclone on Application Tier $ perl ./adpreclone.pl appsTier Execute the following on the Database Tier: Logon as oracle database user and set envirnoment…
Read MoreAPPLIES TO: Oracle Cloud Infrastructure - Database Service - Version N/A and later SYMPTOMS: OCI VMDB system automatic backup failed with DCS-10434:Control file and/or spfile handles could not be retrieved…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2] Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud…
Read MoreSELECT NVL (attribute_value, ‘N’) FROM jai_item_templ_hdr_v jih, jai_item_templ_dtls_v jid WHERE 1 = 1 AND jih.template_hdr_id = jid.template_hdr_id AND jid.attribute_code = ‘RECOVERABLE’ AND jih.inventory_item_id = 73838 AND jih.organization_id = 101
Read MoreSELECT count(*) into v_asl_site_count FROM po_lookup_codes plc, hr_org_units_no_join hou, hr_org_units_no_join hou1, hr_all_organization_units_tl hout, hr_all_organization_units_tl hout1, po_vendors pv, po_vendor_sites_all pvs, mtl_manufacturers mm, mtl_manufacturers mm1, mtl_parameters mp, mtl_parameters mp1, po_asl_statuses past, po_approved_supplier_list…
Read MoreThe below is the query for AR Transaction Register details at Distribution Level SELECT RCTL.CUSTOMER_TRX_line_ID, hou.name ou_name, c.account_number “Customer Number”, ( SELECT party_name FROM apps.hz_parties WHERE party_id = c.party_id )…
Read More