Hi!,
We have been calling OS command from PLSQL packages for quite a few years. We are currently upgrading our Application to 12.2.11 from 12.1.3. Our DB is same however 19C. While testing we find out OS command calls not executing the command. The package execution says successful but the command in the OS call is not executed.
For simplicity sake I am trying to copy a file.

exec apps.XX_Call(p_command => '/usr/bin/cp /home/oracle/dp123.txt /home/oracle/dp1234.txt');

Java Class contains
===================
CREATE OR REPLACE JAVA SOURCE NAMED APPS."xx_Call" as
import java.io.*;
public class xx_Call {
/*AmitRC This Source can be used to call any OS command the full path has to be given */
public static void executeCommand(String command) {
try {
String[] finalCommand;
if (isWindows()) {
finalCommand = new String[4];
finalCommand[0] = "C:\\winnt\\system32\\cmd.exe";
finalCommand[1] = "/y";
finalCommand[2] = "/c";
finalCommand[3] = command;
}
else {
finalCommand = new String[3];
finalCommand[0] = "/bin/sh";
finalCommand[1] = "-c";
finalCommand[2] = command;
}
final Process pr = Runtime.getRuntime().exec(finalCommand);
new Thread(new Runnable() {
public void run() {
try {
BufferedReader br_in = new BufferedReader(new
InputStreamReader(pr.getInputStream()));
String buff = null;
while ((buff = br_in.readLine()) != null) {
System.out.println(buff);
try {Thread.sleep(100); } catch(Exception e) {}
}
br_in.close();
}
catch (IOException ioe) {
System.out.println("Exception caught printing process output.");
ioe.printStackTrace();
}
}
}).start();
new Thread(new Runnable() {
public void run() {
try {
BufferedReader br_err = new BufferedReader(new
InputStreamReader(pr.getErrorStream()));
String buff = null;
while ((buff = br_err.readLine()) != null) {
System.out.println(buff);
try {Thread.sleep(100); } catch(Exception e) {}
}
br_err.close();
}
catch (IOException ioe) {
System.out.println("Exception caught printing process error.");
ioe.printStackTrace();
}
}
}).start();
}
catch (Exception ex) {
System.out.println(ex.getLocalizedMessage());
}
}
public static boolean isWindows() {
if (System.getProperty("os.name").toLowerCase().indexOf("windows") != -1)
return true;
else
return false;
}
};
===================

I am actually unaware of finding out the access permission status. How do I find out?

[oracle@dbaas21c home]$ ls -lah
total 24K
drwxr-xr-x  6 root   root     4.0K Dec  8  2020 .
dr-xr-xr-x 19 root   root     4.0K Mar 24 17:45 ..
drwx------  3 grid   oinstall 4.0K Apr 27  2021 grid
drwx------  3 mysql  mysql    4.0K Dec  8  2020 mysql
drwx------  3 opc    opc      4.0K Dec 16  2020 opc
drwx------  3 oracle oinstall 4.0K Mar 21 09:59 oracle

or you could create a library based on OS libraries and create a procedure as given below to execute OS command

create or replace PROCEDURE execute_shell(
cmdstring IN CHAR)
IS
external NAME "system" library exec_shell LANGUAGE C;

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED SYS."xx_Call"
as
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.concurrent.atomic.AtomicReference;

public class xx_Call {
/*
* AmitRC This Source can be used to call any OS command the full path has to be
* given
*/

// private volatile static String result = "";

public static AtomicReference<String> result = new AtomicReference<>();

public static String executeCommand(String command) {
// final String[] result = {"Default"};
String init = "Inital Value";
result.set(init);

try {
String[] finalCommand;
finalCommand = new String[3];
finalCommand[0] = "/usr/bin/sh";
finalCommand[1] = "-c";
finalCommand[2] = command;
final Process pr = Runtime.getRuntime().exec(finalCommand);

try {
BufferedReader br_in = new BufferedReader(new InputStreamReader(pr.getInputStream()));
String buff = null;
while ((buff = br_in.readLine()) != null) {
System.out.println(buff);

try {
Thread.sleep(100);
} catch (Exception e) {
result.set(e.getMessage());
}
}
br_in.close();

BufferedReader br_err = new BufferedReader(new InputStreamReader(pr.getErrorStream()));
String buff2 = null;
while ((buff2 = br_err.readLine()) != null) {
System.out.println(buff2);
result.set(buff2);
try {
Thread.sleep(100);
} catch (Exception e) {
result.set(e.getMessage());
}
}
br_err.close();

if(buff2 ==null){
result.set("File Transfer Successful");
}

} catch (IOException ioe) {
System.out.println("Exception caught printing process output.");
ioe.printStackTrace();

result.set(ioe.getMessage());

}

} catch (Exception ex) {
System.out.println(ex.getLocalizedMessage());

result.set(ex.getMessage());

}
return result.get();
}

}
;
/