On 1/28/20 6:31 PM, Anand Solomon wrote: > My sql script will look like > > /* > ####################################################################################################################################### > # Program : xxxx.sql > # Programmer : xxxxx > # Date : xxxxx > # Usage : xxxx > # Revisions : xxxxx > # Dependencies : > # 1. Sqlplus Binaries. > # > # Notes : Script will creates Oracle packages on AWS RDS. > # Author : xxxx > # Creates change passwords and lock a/c's > # after the user is done . > > ####################################################################################################################################### > */ >
So where is the SQL code?
Regards
Racke
>
> On Tuesday, January 28, 2020 at 12:18:33 PM UTC-5, Stefan Hornburg (Racke)
> wrote:
>
> On 1/28/20 6:05 PM, Anand Solomon wrote:
> > Hi,
> > I am using oracle_sql module and running a sql script. The sql script
> contains comments. The playbook fails because "
> > FAILED! => {"changed": false, "msg": "Something went wrong while
> executing sql - ORA-00911: invalid character sql:
> >
> > Is there a way I can keep the comments and execute the sql script ?
> >
>
> I suppose you could filter out the comments. How does your SQL script
> looks like?
>
> Regards
> Racke
>
> >
> > On Saturday, January 25, 2020 at 5:17:44 PM UTC-5, Dick Visser wrote:
> >
> > Hi
> >
> > Ansible doesn’t have such a module, so I assume this is a 3rd party
> module?
> > In that case you might have more luck asking the module’s authors
> for support.
> >
> >
> > On Sat, 25 Jan 2020 at 16:07, Anand Solomon <[email protected]
> <javascript:>> wrote:
> >
> > I am trying to create oracle user using oracle_user module in a
> RDS server. Here is my playbook
> >
> > - hosts: all
> > vars:
> > oracle_home: /home/ansible/instantclient_12_2
> > user: SYSDBA
> > password: ******
> > prt: "1521"
> > hostname: "RDS Instance"
> > sname: TESTDB
> > oracle_env:
> > ORACLE_HOME: "{{oracle_home}}"
> > LD_LIBRARY_PATH: "{{oracle_home}}"
> > PATH: "{{oracle_home}}"
> >
> > vars_files:
> > - vault-pass.yml
> >
> > tasks:
> > - name: This playbook will create the user.
> > oracle_user:
> > oracle_home: /home/ansible/instantclient_12_2
> > user: "{{user}}"
> > password: "{{password}}"
> > service_name: "{{sname}}"
> > port: "{{prt}}"
> > hostname: "{{hostname}}"
> > schema: *****
> > schema_password: ****
> > default_tablespace: USERS
> > # state: present
> > grants: "'create session', create any table'"
> > environment: "{{oracle_env}}"
> >
> > This fails with below error
> > FAILED! => {"changed": false, "msg": "The cx_Oracle module is
> required. 'pip install cx_Oracle' should do the
> > trick. If cx_Oracle is installed, make sure ORACLE_HOME &
> LD_LIBRARY_PATH is set"}
> >
> > DO we need to have cx_oracle installed in the target server
> too? I had this same issue with oracle_sql module
> > too, but I used "connection: local" to enforced the playbook to
> look at the local cx_oracle install. This
> is not
> > working in oracle_user module.
> >
> > --
> > 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]
> > <javascript:>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/c1c30471-934e-42e2-9e2b-991c1e57db87%40googlegroups.com
>
> <https://groups.google.com/d/msgid/ansible-project/c1c30471-934e-42e2-9e2b-991c1e57db87%40googlegroups.com>
> >
>
> <https://groups.google.com/d/msgid/ansible-project/c1c30471-934e-42e2-9e2b-991c1e57db87%40googlegroups.com?utm_medium=email&utm_source=footer
>
> <https://groups.google.com/d/msgid/ansible-project/c1c30471-934e-42e2-9e2b-991c1e57db87%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
> >
> > --
> > Sent from a mobile device - please excuse the brevity, spelling and
> punctuation.
> >
> > --
> > 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] <javascript:>
> <mailto:[email protected] <javascript:>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/7afeb9ff-12e0-4f4f-b4fc-0a86d515a694%40googlegroups.com
>
> <https://groups.google.com/d/msgid/ansible-project/7afeb9ff-12e0-4f4f-b4fc-0a86d515a694%40googlegroups.com>
> >
>
> <https://groups.google.com/d/msgid/ansible-project/7afeb9ff-12e0-4f4f-b4fc-0a86d515a694%40googlegroups.com?utm_medium=email&utm_source=footer
>
> <https://groups.google.com/d/msgid/ansible-project/7afeb9ff-12e0-4f4f-b4fc-0a86d515a694%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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]
> <mailto:[email protected]>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/fdee5e94-0ada-4be3-8fb2-72bccbcb7c80%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/fdee5e94-0ada-4be3-8fb2-72bccbcb7c80%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/e17eeb71-9ba6-034f-be2e-47722c34604b%40linuxia.de.
signature.asc
Description: OpenPGP digital signature
