Hi,
OS: Redhat 7.5
shell: Bash
Wrote below script to login into oracle via shell script and trying to reset locked account..It works as expected. But I need specific output << EOF should go to target terminal not all out put
running below script from ansible command line..
#!/bin/bash
source $1
sqlplus '/as sysdba' << EOF
ALTER USER $2 ACCOUNT UNLOCK;
select username,account_status from dba_users where username='$2'
EXIT;
EOF
I am getting screen output like below
ora | CHANGED => {"changed": true, "rc": 0, "stderr": "Shared connection to closed.\r\n", "stderr_lines": ["Shared connection toclosed."], "stdout": "\r\nSQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 7 16:41:25 2018\r\n\r\nCopyright (c) 1982, 2014, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\n\r\n16:41:25 SYS @ ORCL:ORCL:>\r\nUser altered.\r\n\r\n16:41:25 SYS @ ORCL:ORCL:>\r\nUSERNAME\r\n--------------------------------------------------------------------------------\r\nACCOUNT_STATUS\r\n--------------------------------\r\nABTESTLOCK\r\nOPEN\r\n\r\n\r\n16:41:25 SYS @ ORCL:ORCL:>Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\n", "stdout_lines": ["", "SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 7 16:41:25 2018", "", "Copyright (c) 1982, 2014, Oracle. All rights reserved.", "", "", "Connected to:", "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production", "With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options", "", "16:41:25 SYS @ ORCL:ORCL:>", "User altered.", "", "16:41:25 SYS @ ORCL:ORCL:>", "USERNAME", "--------------------------------------------------------------------------------", "ACCOUNT_STATUS", "--------------------------------", "ABTESTLOCK", "OPEN", "", "", "16:41:25 SYS @ ORCL:ORCL:>Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production", "With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options"]}
What i need only above output is only
", "USERNAME", "--------------------------------------------------------------------------------", "ACCOUNT_STATUS", "--------------------------------", "ABTESTLOCK", "OPEN"
to the terminal in table column format i.e I need only out put of select username,account_status from dba_users where username='$2' to the terminal output in table format, how can i achieve this
Thanks in advance