I have a script that connects to an Oracle database and then selects:
select count(*) from V$ASM_DISK;
This script is in a .sql file, so I make the following call in the OS:
"$ORA_HOME/bin/sqlplus -L -S xxxx/xxxx @query.sql";
When executing the script as root , the result is 0, but when executing the same query as user oracle , the return is different.
Both users log in to Oracle.
I can not find the reason for this difference in return.