I need to automate a SQL script against an Oracle database using a Bamboo build via PowerShell inline commands. The credentials are not to be displayed in the inline script but managed via variables.
My code looks like this
$user = "<username>"
$password = "<password>"
$tnsalias = "<TNS_ALIAS>"
$SqlQuery = "@C:\Test.sql"
$bambooExecutionLog = "C:\Test.log"
C:\sqlplus $bambooUser/$bambooPassword@$tnsalias $SqlQuery
However, it fails with the following error message
ORA-01017: invalid username/password; logon denied
Any help/suggestions would be appreciated.
G’day Bamboo customers, The wait is over! Bamboo Data Center edition you have been asking for is finally here! This self-managed enterprise offering of Bamboo has the resilience, reliability, and s...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events