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.
I'm happy to announce that Bamboo 7.2 has been released and it’s overflowing with awesome new features. This will be the last major Server release before the launch of Bamboo DC. Bamboo logs We...
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