I have not had the problem you describe. However, I can think of some other ways to solve the problem.
1/ if you have sqlplus installed on your windows machine you might be able to use script module to run sqlplus commands. If you do though, you will likely need to use 'chcp' to change code page before running the sqlplust script as sqlplus (I think) doesn't expect Unicode. 2/ If you do not have to use sqlplus, I have an oracle_sql module which I could share with you. It needs cx_Oracle installed and the oracle instant client on a *ux host. The module is a bit basic but supports 'creates' and 'deletes' so you can write sort-of-idempotent ansible tasks with it. We use it a bit for changing certain configuration settings that are stored in our database. For database structure changes we use flyway at it helps ensure structure changes are only every applied once. Hope this helps, Jon On Friday, September 1, 2017 at 1:59:35 PM UTC+1, Peter Prisekin wrote: > > I'm running ansible from cygwin on a Windows machine to a linux box (could > be AIX or RHEL) which I'm using mainly for the oracle client software which > will be running sqlplus to yet a third machine (Oracle server, no ssh > access necessarily). I don't necessarily need root for this, so I'm using > my own login for the oracle client box, and I've solved the Unreachable > problem by just shelling ssh -q to do the sqlplus scripts. Is this really > because of the banner, or is that a red herring? Am I bypassing a bad > return code by using shell? So I am thinking of somehow permanentizing the > -q with perhaps a separate module (sshq or somesuch). I presume I'm not > the first person to have thought of this, is there a way to search for this > amongst all the branches? > > Please and thanks in advance for any pointers... > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/9ad65d0b-dc84-45cb-a5fb-f8f407a5b36e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
