Skip to content

Archive for

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


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;


(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(
at oracle.opatch.opatchutil.NApply.legacy_process(
at oracle.opatch.opatchutil.NApply.legacy_process(
at oracle.opatch.opatchutil.NApply.process(
at oracle.opatch.opatchutil.OUSession.napply(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at oracle.opatch.UtilSession.process(
at oracle.opatch.OPatchSession.process(
at oracle.opatch.OPatch.process(
at oracle.opatch.OPatch.main(
Caused by: java.lang.RuntimeException: Prerequisite check “CheckActiveFilesAndExecutables” failed.
… 13 more
Caused by: oracle.opatch.PrereqFailedException: Prerequisite check “CheckActiveFilesAndExecutables” failed.
… 13 more


net stop msdtc

The Distributed Transaction Coordinator service is stopping.
The Distributed Transaction Coordinator service was stopped successfully.