Sven Aluoor wrote:
> Hi folks
>
> 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
> limited user.
With sqlplus and oracle I pretty much always ran scripts
as sysdba
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
$ASM_STARTUP_LOG
another example -
su $ORACLE_USERNAME -c "sqlplus / as sysdba
@/home/oracle/sql/snapshot-restore/restore-from-prod-oracle-change-passwords.sql"
| 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!
nate