|| at Dec 1, 2009 at 11:03 pm
Sven Aluoor wrote:
I have here a CentOS box where i need to setup cronjob (with session
to remote Oracle instance). On the remote DB i have no access, expect
With sqlplus and oracle I pretty much always ran scripts
from one of my scripts that fires up Oracle ASM:
# Set variables for ASM sid (first)
su $ORACLE_USERNAME -c "echo "startup" | sqlplus / as sysdba" | tee
another example -
su $ORACLE_USERNAME -c "sqlplus / as sysdba
tee -a $FINAL_SQL_LOG
If I needed to login as a specific user to oracle I would login
as sysdba and run
alter session set current_schema=OTHER_USER_NAME;
to change the user name after login.
So no passwords needed.
For servers, everything automated relies on ssh key based auth.
I'm no Oracle expert by any means!