Skip to content

postgresql \i import sql file permission denied

postgresql \i import sql file permission denied in windows

postgres=# \i C:\app\orauser\person.sql
C:: Permission denied

Solution:

use ‘/’ instead of use ‘\’

postgres=# \i C:/app/orauser/person.sql

postgres=# \d
List of relations
Schema | Name | Type | Owner
——–+—————+———-+———-
public | person | table | postgres
public | person_id_seq | sequence | postgres
(2 rows)

postgres=# select count(*) from person;

count

1000
(1 row)

java.lang.RuntimeException: Prerequisite check “CheckActiveFilesAndExecutables” failed

While applying Opatch

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.

EBS Apache Log4J Vulnerabilities

Ref :

CVE-2021-44228/CVE-2021-45046 Advisory for Oracle E-Business Suite (Apache log4j Vulnerabilities) (Doc ID 2827804.1)

Impact of December 2021 Apache Log4j Vulnerabilities on Oracle Products and Services (CVE-2021-44228, CVE-2021-45046) (Doc ID 2827611.1)

Invoice validation pending standby

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′;

ORA-29024: Certificate validation failure

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”

*URL FULL PATH means — certificates url

Unable to connect to the mail account. Check the host, user name, password and connection security

When we trying to configure workflow, the following error we’re getting

Unable to connect to the mail account. Check the host, user name, password and connection security

We checked that IMAP, SMTP port opened already. but still we’re getting the issue

Solution :

Functional Administrator – Clear cache and then bounce the service. its working now.

Database frequently stop connecting after upgrade 19c

We’re facing the issue database frequently stop connecting after upgrade to 19c (19.3). this database which is running on windows server 2016.

Errors in listener.log file

TNS-12518: TNS:listener could not hand off client connection
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
64-bit Windows Error: 5: Input/output error

Core dump should created on somewhere in your database server locations.

Solution :

Apply database 19.7 or latest patches. the issue will be fixed

ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+594] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x7FFA9B633C52] [UNABLE_TO_READ] []

We’re getting the below error while running utlrp.sql script after we applied 19.9 patch to database 19.3 which is running on windows server 2016.

2021-01-05T23:16:39.538245+03:00
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x8] [PC:0x7FFA9B633C52, ph2sf_scan_fields()+594]
Errors in file D:\APP\ORACLE\diag\rdbms\ezymir\ezymir\trace\ezymir_j000_94264.trc (incident=136519):
ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+594] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x7FFA9B633C52] [UNABLE_TO_READ] []
Incident details in: D:\APP\ORACLE\diag\rdbms\ezymir\ezymir\incident\incdir_136519\ezymir_j000_94264_i136519.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Initially we thinking that its seems to be bug. But After we analyzed the trace file, there is one package body having issue for compilations.

Trace file :

name=XXXXX.CLK_CLM_PROCESS
Symbol file D:\app\WINDOWS.X64_193000_db_home\BIN\orasql19.SYM does not match binary.
Symbol TimeStamp=5cef5a1d, Module TimeStamp=5f8f4599 are different
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x8] [PC:0x7FFA9B633C52, ph2sf_scan_fields()+594]
Encountered exception while getting args for function:0x00007FFA9B685811
Symbol file D:\app\WINDOWS.X64_193000_db_home\BIN\orasql19.SYM does not match binary.
Symbol TimeStamp=5cef5a1d, Module TimeStamp=5f8f4599 are different
Encountered exception while getting args for function:0x00007FFA9B690D40
Encountered exception while getting args for function:0x00007FFA9B685811

*** 2021-01-05T23:16:40.272618+03:00
2021-01-05T23:16:40.272618+03:00
Incident 136519 created, dump file: D:\APP\ORACLE\diag\rdbms\ezymir\ezymir\incident\incdir_136519\ezymir_j000_94264_i136519.trc
ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+594] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x7FFA9B633C52] [UNABLE_TO_READ] []

Solution :

We found that we have master schema there . this schema having lot of objects. those objects having read/write permission to other schemas. But we have missed some permission to some particular schema when we’re creating or importing. once we provided the particular privilege to the schema. we can able to compile the packages using utlrp.sql as well.

permission given like

GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, READ, DEBUG, FLASHBACK ON MASTERSCHEMA.table to xxxxx;

Unable to load resource jar files in ebs 12.2

We’re facing the some of the users are trying to open the forms after login ebs 12.2.9 with jre1.8.0_271, the forms are not pop up and says ” unable to load resource fndforms.jar and like other jar files”.

we have checked the group policy for trusted websites added, yes its added

We have checked the java exception site list policy, yes its there.

But still we’re facing the issues for some of the users. so its not a problem of java. it should be something blocking the site to reach servers whenever load jar files.

Yes finally, we got it. Our company firewall blocking rule is blocking JAR files by default. For EBS we have to allow JAR files.

Flexfield role assign to user in EBS 12.2

User Management

select user

assign the below role to user

code : UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE

run workflow background engine after assigned