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

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.