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 .
#######################################################################################################################################
*/
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?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?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/fdee5e94-0ada-4be3-8fb2-72bccbcb7c80%40googlegroups.com.
