Anyone please guide. On Saturday, July 22, 2023 at 8:46:08 PM UTC+5:30 Learner wrote:
> Hi All, > Using Ansible how to connect Oracle DB on Linux & run command "show pdb" > to display oracle pluggable DB, "shutdown immediate" to stop DB and start DB > <https://stackoverflow.com/questions/76742454/using-ansible-how-to-connect-oracle-db-on-linux-run-command-show-pdb-to-disp> > . > > Code: - name: Run show pdbs > shell: | > {{ oracle_home }}/bin/sqlplus / as sysdba <<EOF > show pdbs; > exit > EOF > register: query_output > > - name: Display query output > debug: > msg: "{{ query_output.stdout_lines }}" > > Its getting failed with below error: > > fatal: [10.192.90.43]: FAILED! => {"changed": true, "cmd": > "\"{'stderr_lines': [], u'changed': True, u'end': u'2023-07-22 > 15:05:49.418929', 'failed': False, u'stdout': u'/u01/app/oracle/product/ > 19.3.0.0/db_1', u'cmd': u\"cat /etc/oratab | egrep -v '^#|^$' | grep -v > ASM | cut -d ':' -f2\", u'rc': 0, u'start': u'2023-07-22 15:05:49.413535', > u'stderr': u'', u'delta': u'0:00:00.005394', 'stdout_lines': > [u'/u01/app/oracle/product/19.3.0.0/db_1']}/bin/sqlplus > <http://19.3.0.0/db_1'%5D%7D/bin/sqlplus> / as sysdba <<EOF\nshow > pdbs;\nexit\nEOF\"\n", "delta": "0:00:00.005358", "end": "2023-07-22 > 15:05:52.954037", "msg": "non-zero return code", "rc": 1, "start": > "2023-07-22 15:05:52.948679", "stderr": "/bin/sh: {'stderr_lines': [], > u'changed': True, u'end': u'2023-07-22 15:05:49.418929', 'failed': False, > u'stdout': u'/u01/app/oracle/product/19.3.0.0/db_1', u'cmd': ucat: No > such file or directory\ncut: fields are numbered from 1\nTry 'cut --help' > for more information.", "stderr_lines": ["/bin/sh: {'stderr_lines': [], > u'changed': True, u'end': u'2023-07-22 15:05:49.418929', 'failed': False, > u'stdout': u'/u01/app/oracle/product/19.3.0.0/db_1', u'cmd': ucat: No > such file or directory", "cut: fields are numbered from 1", "Try 'cut > --help' for more information."], "stdout": "", "stdout_lines": []} > > -- You received this message because you are subscribed to the Google Groups "Ansible Development" group. To unsubscribe from this group and stop receiving emails from it, send an email to ansible-devel+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-devel/cdeb3ef0-ef78-4805-93df-13ff23bb3f3en%40googlegroups.com.
