It goes soon after the comments
/*
#######################################################################################################################################
# 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 .
#######################################################################################################################################
*/
set serveroutput on;
select username from dba_users;
/
..
On Tuesday, January 28, 2020 at 12:34:00 PM UTC-5, Stefan Hornburg (Racke)
wrote:
>
> 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:>
> <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] <javascript:> <mailto:
> [email protected] <javascript:>>.
> > 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/d9b7e7bb-8a8e-4469-96a4-8b9412abf7f6%40googlegroups.com.
