1
I have a script that connects on an Oracle basis and makes the following select:
select count(*) from V$ASM_DISK;
This script is in a . sql file, then I make the following call in the OS:
"$ORA_HOME/bin/sqlplus -L -S xxxx/xxxx @query.sql";
When Running 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’t find the reason for this difference in return.
I imagine that the root can read the script, of course, but when you use sqlplus to only log in using the root, without running the script, it gives you an oracle prompt?
– nunks