ERROR DESCRIPTION: (FATAL ERROR PROGRAM : (/u01/app/oracle/product/19c/orahome_1/appsutil/bin/txkCfgUtlfileDir.pl) TIME : Thu Apr 21 13:00:39 2022 FUNCTION: main::checkUtlFileDir [ Level 1 ] ERRORMSG: Directory /u01/BAHPROD/temp/BAHIFRS does not exist. ) ERRORCODE = 1 ERRORCODE_END .end std out.
.end err out.
Create directory /u01/BAHPROD/temp/BAHIFRS
run below script to add this directory in utl_file_dir
perl /u01/app/oracle/product/19c/orahome_1/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/oracle/product/19c/orahome_1/appsutil/BAHIFRS_bahdevifrdb01.xml -oraclehome=/u01/app/oracle/product/19c/orahome_1 -outdir=/u01/app/oracle/product/19c/orahome_1/appsutil/log -mode=addUtlFileDir Enter the APPS Password:
Enter the SYSTEM Password:
Enter the new OS path to be added to UTL_FILE_DIR: /u01/BAHPROD/temp/BAHIFRS
Script Name : txkCfgUtlfileDir.pl Script Version : 120.0.12020000.11 Started : Thu Apr 21 13:08:30 +03 2022
Auto login wallet can able to enable. If its enable, it will automatically open the wallet
If we suppose need to restore the database, we need to copy wallet file manually to the target server and enable wallet location, open the wallet with key and restore database .
postgres=# \d List of relations Schema | Name | Type | Owner ——–+—————+———-+———- public | person | table | postgres public | person_id_seq | sequence | postgres (2 rows)
Stack Description: java.lang.RuntimeException: Prerequisite check “CheckActiveFilesAndExecutables” failed. at oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6805) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:1002) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:372) at oracle.opatch.opatchutil.NApply.process(NApply.java:352) at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at oracle.opatch.UtilSession.process(UtilSession.java:355) at oracle.opatch.OPatchSession.process(OPatchSession.java:2660) at oracle.opatch.OPatch.process(OPatch.java:870) at oracle.opatch.OPatch.main(OPatch.java:927) Caused by: java.lang.RuntimeException: Prerequisite check “CheckActiveFilesAndExecutables” failed. … 13 more Caused by: oracle.opatch.PrereqFailedException: Prerequisite check “CheckActiveFilesAndExecutables” failed. … 13 more
Solution
net stop msdtc
The Distributed Transaction Coordinator service is stopping. The Distributed Transaction Coordinator service was stopped successfully.
One of the request running long time with pending standby. so it will conflict with some request
Solution :
select * from fnd_concurrent_requests where concurrent_program_id in (SELECT p.concurrent_program_id FROM FND_CONCURRENT_PROGRAM_SERIAL s, fnd_concurrent_programs_tl p WHERE (s.to_run_application_id in (select application_id from fnd_concurrent_programs_tl where user_concurrent_program_name=’Invoice Validation’)) and (s.to_run_concurrent_program_id in (select concurrent_program_id from fnd_concurrent_programs_tl where user_concurrent_program_name=’Invoice Validation’)) and s.running_concurrent_program_id=p.concurrent_program_id) and phase_code <> ‘C’;
Kill the blocking concurrent request. then it will work
update fnd_concurrent_requests set phase_code=’C’ , status_code=’X’ where request_id=’10358051′;
After import end user certificate using oracle wallet manager to database server (19c) still we’re facing the below errors
SQL> select utl_http.request (‘https:// URL FULL PATH’,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual; select utl_http.request (‘https:// URL FULL PATH ‘,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual * ERROR at line 1: ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1530 ORA-29024: Certificate validation failure ORA-06512: at “SYS.UTL_HTTP”, line 380 ORA-06512: at “SYS.UTL_HTTP”, line 1470 ORA-06512: at line 1
Solution :
remove end user certificate, import only root and intermediate certificates
SQL> select utl_http.request (‘ URL FULL PATH ‘,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual;
Output comes
{ “error”: “missing_client”, “description”: “client_id is missing”