ORA-12154: TNS:could not resolve the connect identifier specified while connecting

[Atul]

Hi There,

This is with respect to one of issue we have faced in our bamboo plan.

we have created the task with inline script to connect to database and run sql script where interpreter is cmd.exe or /bin/sh.

sqlplus ${username}/${password}@${database} @Example.sql ;

but it seems it is not recognizing ${database} and throwing the TNS error. Same sqlplus command seems working when we try through command prompt(run--> cmd)

Can someone help on this? This is new error we faced.

Thanks.