I am trying to move a on-prem database to aws rds. I currently have automated scripts running on the database. The authentication for the scripts on the database happens through OS Authentication.
The parameter currently
OS_AUTHENT_PREFIX=OPS$
remote_os_authent=TRUE
The parameter is not modifiable in AWS RDS as per the below documentation
https://forums.aws.amazon.com/thread.jspa?threadID=118221
If I change the authentication line in the script
from
sqlplus -s / >> test.log <<EOF
to
sqlplus -s username/password@hoststring >> test.log <<EOF
The scripts will work but I don't want to use clear text password in scripts.
I was checking the Advanced security module but that requires the above parameters to be set as well.
https://docs.oracle.com/cd/E11882_01/network.112/e40393/asokerb.htm#ASOAG9651
Is there a workaround for this