TASK [Set resource manager plan] ***********************************************
skipping: [hammer.yaocm.id.au]
fatal: [dural.yaocm.id.au]: FAILED! => {"changed": true, "cmd": ["/home/oracle/set_res_mgr_plan.py", "INTERNAL_PLAN"], "delta": "0:00:00.021205", "end": "2021-01-15 14:14:29.011707", "msg": "non-zero return code", "rc": 1, "start": "2021-01-15 14:14:28.990502", "stderr": "  File \"/home/oracle/set_res_mgr_plan.py\", line 41\n    print('Plan changed to '{ sys.argv[1] }'\" )\n                            ^\nSyntaxError: invalid syntax", "stderr_lines": ["  File \"/home/oracle/set_res_mgr_plan.py\", line 41", "    print('Plan changed to '{ sys.argv[1] }'\" )", "                            ^", "SyntaxError: invalid syntax"], "stdout": "", "stdout_lines": []}

ORA 700 [pga physmem limit]

Vuser 1:Test complete: view report from SNAPID 2 to 3

TASK [Create Mount Point for Oracle Installation Software] *********************
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": false, "gid": 99, "group": "99", "mode": "0777", "msg": "chown failed: [Errno 30] Read-only file system: b'/opt/share/Software'", "owner": "99", "path": "/opt/share/Software", "secontext": "system_u:object_r:nfs_t:s0", "size": 422, "state": "directory", "uid": 99}

TASK [Configure DB for SUT] ****************************************************
skipping: [hammer.yaocm.id.au]
fatal: [dural.yaocm.id.au]: FAILED! => {"changed": true, "cmd": ["/home/oracle/configure_sut_db.py"], "delta": "0:00:48.300211", "end": "2021-01-15 11:30:38.221301", "msg": "non-zero return code", "rc": 1, "start": "2021-01-15 11:29:49.921090", "stderr": "Traceback (most recent call last):\n  File \"/home/oracle/configure_sut_db.py\", line 85, in <module>\n    cursor.execute(sql)\ncx_Oracle.DatabaseError: ORA-01109: database not open", "stderr_lines": ["Traceback (most recent call last):", "  File \"/home/oracle/configure_sut_db.py\", line 85, in <module>", "    cursor.execute(sql)", "cx_Oracle.DatabaseError: ORA-01109: database not open"], "stdout": "Local UNDO is enabled\nDatabase is in NOARCHIVELOG mode.\nDatabase changed to ARCHIVELOG mode.\nTablespace TPCCTAB does not exists.", "stdout_lines": ["Local UNDO is enabled", "Database is in NOARCHIVELOG mode.", "Database changed to ARCHIVELOG mode.", "Tablespace TPCCTAB does not exists."]}

TASK [Status of Oracle Database Instance] **************************************
skipping: [hammer.yaocm.id.au]
ok: [dural.yaocm.id.au] => {
    "start_db_inst.stdout_lines": [
        "Start listener",
        "Listener started successfully",
        "Status of CDB Instance is OPEN",
        "Status of PDB (TPCV3R3A) is READ WRITE"
    ]
}

TASK [Install Oracle Client 12.1.0.2 Software Only in Silent Mode] *************
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": false, "msg": "Unsupported parameters for (ansible.legacy.command) module: register Supported parameters include: _raw_params, _uses_shell, argv, chdir, creates, executable, removes, stdin, stdin_add_newline, strip_empty_ends, warn"}

TASK [Run configToolAllCommands after Oracle Client 12.1.0.2 Software Installation] ***
[WARNING]: As of Ansible 2.4, the parameter 'executable' is no longer supported
with the 'command' module. Not using '/bin/sh'.
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": false, "cmd": "/opt/app/oracle/product/12.1.0.2/client/cfgtoollogs/configToolAllCommands", "msg": "[Errno 8] Exec format error: b'/opt/app/oracle/product/12.1.0.2/client/cfgtoollogs/configToolAllCommands'", "rc": 8}

Launching Oracle Database Setup Wizard...

[WARNING] [INS-32047] The location (/opt/app/oraInventory) specified for the central inventory is not empty.
   ACTION: It is recommended to provide an empty location for the inventory.
[FATAL] [INS-35344] The value is not specified for Database Backup and Recovery (OSBACKUPDBA) group.
   ACTION: Specify a valid group name for Database Backup and Recovery (OSBACKUPDBA) group.
[FATAL] [INS-35344] The value is not specified for Data Guard administrative (OSDGDBA) group.
   ACTION: Specify a valid group name for Data Guard administrative (OSDGDBA) group.
[FATAL] [INS-35344] The value is not specified for Encryption Key Management administrative (OSKMDBA) group.
   ACTION: Specify a valid group name for Encryption Key Management administrative (OSKMDBA) group.
[FATAL] [INS-35344] The value is not specified for Real Application Cluster administrative (OSRACDBA) group.
   ACTION: Specify a valid group name for Real Application Cluster administrative (OSRACDBA) group.
Moved the install session logs to:
 /opt/app/oraInventory/logs/InstallActions2020-11-19_05-25-42PM

Launching Oracle Database Setup Wizard...

[FATAL] [INS-35954] The installer has detected that the Oracle home location provided in the response file is not correct.
   CAUSE: The Database Oracle home is the location from where the installer is executed. It has been detected that the value set in the response file is different (/opt/app/oracle/product/19.3.0.2/database). Value expected is: /home/oracle/linuxamd64_193000
   ACTION: It is not required to specify ORACLE_HOME in the response file for Database installation. Alternatively, set it to the location of the installer (/home/oracle/linuxamd64_193000).
Moved the install session logs to:
 /opt/app/oraInventory/logs/InstallActions2020-11-19_07-13-31AM

TASK [Install Oracle Client 12.1.0.2 Software Only in Silent Mode] *************
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": true, "cmd": ["/opt/share/Software/database/linuxamd64_12102/client/runInstaller", "-silent", "-noconfig", "-responseFile", "/opt/app/oracle/client_install.rsp", "-waitforcompletion", "-ignorePrereq"], "delta": "0:00:06.401198", "end": "2020-11-14 19:01:29.567042", "msg": "non-zero return code", "rc": 1, "start": "2020-11-14 19:01:23.165844", "stderr": "", "stderr_lines": [], "stdout": "Starting Oracle Universal Installer...\n\nChecking Temp space: must be greater than 415 MB.   Actual 43400 MB    Passed\nChecking swap space: must be greater than 150 MB.   Actual 2079 MB    Passed\nPreparing to launch Oracle Universal Installer from /tmp/OraInstall2020-11-14_07-01-23PM. Please wait ...Error occurred during initialization of VM\nUnable to load native library: libnsl.so.1: cannot open shared object file: No such file or directory", "stdout_lines": ["Starting Oracle Universal Installer...", "", "Checking Temp space: must be greater than 415 MB.   Actual 43400 MB    Passed", "Checking swap space: must be greater than 150 MB.   Actual 2079 MB    Passed", "Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-11-14_07-01-23PM. Please wait ...Error occurred during initialization of VM", "Unable to load native library: libnsl.so.1: cannot open shared object file: No such file or directory"]}

Preparing the home to patch...
Applying the patch /opt/share/Software/database/p31720396_190000_Linux-x86-64...
OPatch command failed while applying the patch. For details look at the logs from /home/oracle/linuxamd64_193000/cfgtoollogs/opatchauto/.

TASK [Install HammerDB] ********************************************************
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": true, "cmd": "/home/hammer/HammerDB-3.3-Linux-x86-64-Install", "delta": "0:00:30.181788", "end": "2020-11-14 13:12:37.083375", "msg": "command exceeded timeout", "rc": null, "start": "2020-11-14 13:12:06.901587", "stdout": "\r\r\nThis will install HammerDB on your computer.  Continue? [n/Y] ", "stdout_lines": ["", "", "This will install HammerDB on your computer.  Continue? [n/Y] "]}

ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable.

No X11 DISPLAY variable was set, but this program performed an operation which requires it.

TASK [Output from HammerDB Performance Test] ***********************************
ok: [hammer.yaocm.id.au] => {
    "test_run_result.stdout_lines": [
        "HammerDB CLI v4.0",
        "Copyright (C) 2003-2020 Steve Shaw",
        "Type \"help\" for a list of commands",
        "The xml is well-formed, applying configuration",
        "Successfully connected",
        "Number of TPCC objects=25",
        "0 Virtual Users created",
        "Loaded /home/hammer/custom_load.tcl",
        "Vuser 1 created - WAIT IDLE",
        "",
        "1 Virtual Users Created",
        "",
        "1 = WAIT IDLE",
        "",
        "Vuser 1:RUNNING",
        "",
        "Error in Virtual User 1: invalid command name \"!/usr/local/bin/tclsh8.6\"",
        "",
        "Vuser 1:FINISHED FAILED",
        "",
        "ALL VIRTUAL USERS COMPLETE",
        "",
        "runtimer returned after 1 seconds",
        "",
        "waittocomplete called script exit"
    ]
}

ERROR:
ORA-12543: TNS:destination host unreachable

Vuser 1:Test complete, Taking end AWR snapshot.

Vuser 1:End Snapshot 38 taken at 16 JAN 2021 06:56 of instance DEMO19C (1) of database DEMOCDB1 (987761581)

Vuser 1:Test complete: view report from SNAPID 37 to 38

Error in Virtual User 1: invalid bareword "file"
in expression "!(file exists $awr_dir)";
should be "$file" or "{file}" or "file(...)" or ...
Vuser 1:FINISHED FAILED

can't read "_ED(file)": no such element in array
    while executing
"if {$_ED(file) == ""} {return}"
    (procedure "customscript" line 8)
    invoked from within
"customscript '/home/hammer/custom_load.tcl'"
    (file "/home/hammer/run_hammerdb_test.tcl" line 60)
    invoked from within
"source $autostart::autoloadscript"
    invoked from within
"if { $autostart::autostartap == "true" } {
	source $autostart::autoloadscript
	} else {
    TclReadLine::interact
	}"
    (file "./hammerdbcli" line 84)

ORA-12543: TNS:destination host unreachable

Warning: duplicate service names (with and without domain) for service DEMO_DURAL
Started service DEMO_DURAL/DEMO_DURAL.YAOCM.ID.AU/DEMO_DURAL.YAOCM.ID.AU

fatal: [dural.yaocm.id.au]: FAILED! => {"ansible_facts": {}, "changed": false, "failed_modules": {"ansible.legacy.setup": {"failed": true, "module_stderr": "Shared connection to dural.yaocm.id.au closed.\r\n", "module_stdout": "/bin/sh: /usr/bin/python3: No such file or directory\r\n", "msg": "The module failed to execute correctly, you probably need to set the interpreter.\nSee stdout/stderr for the exact error", "rc": 127}}, "msg": "The following modules failed to execute: ansible.legacy.setup\n"}

TASK [Install Oracle Client 12.1.0.2 Software Only in Silent Mode] *************
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": false, "msg": "Unable to change directory before execution: [Errno 2] No such file or directory: b'/opt/share/Software/database/linuxamd64_12102/client'"}

TASK [Install HammerDB] ********************************************************
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": false, "module_stderr": "Shared connection to hammer.yaocm.id.au closed.\r\n",

Traceback (most recent call last):
  File "/home/douglas/.ansible/tmp/ansible-tmp-1605317452.4483583-1826-185032744319898/AnsiballZ_expect.py", line 102, in <module>
    _ansiballz_main()
  File "/home/douglas/.ansible/tmp/ansible-tmp-1605317452.4483583-1826-185032744319898/AnsiballZ_expect.py", line 94, in _ansiballz_main
    invoke_module(zipped_mod, temp_path, ANSIBALLZ_PARAMS)
  File "/home/douglas/.ansible/tmp/ansible-tmp-1605317452.4483583-1826-185032744319898/AnsiballZ_expect.py", line 40, in invoke_module
    runpy.run_module(mod_name='ansible.modules.expect', init_globals=None, run_name='__main__', alter_sys=True)
  File "/usr/lib64/python3.6/runpy.py", line 205, in run_module
    return _run_module_code(code, init_globals, run_name, mod_spec)
  File "/usr/lib64/python3.6/runpy.py", line 96, in _run_module_code
    mod_name, mod_spec, pkg_name, script_name)
  File "/usr/lib64/python3.6/runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "/tmp/ansible_expect_payload_8rcjyx51/ansible_expect_payload.zip/ansible/modules/expect.py", line 241, in <module>
  File "/tmp/ansible_expect_payload_8rcjyx51/ansible_expect_payload.zip/ansible/modules/expect.py", line 200, in main
  File "/usr/local/lib/python3.6/site-packages/pexpect/run.py", line 115, in run
    index = child.expect(patterns)
  File "/usr/local/lib/python3.6/site-packages/pexpect/spawnbase.py", line 342, in expect
    compiled_pattern_list = self.compile_pattern_list(pattern)
  File "/usr/local/lib/python3.6/site-packages/pexpect/spawnbase.py", line 232, in compile_pattern_list
    compiled_pattern_list.append(re.compile(p, compile_flags))
  File "/usr/lib64/python3.6/re.py", line 233, in compile
    return _compile(pattern, flags)
  File "/usr/lib64/python3.6/re.py", line 301, in _compile
    p = sre_compile.compile(pattern, flags)
  File "/usr/lib64/python3.6/sre_compile.py", line 562, in compile
    p = sre_parse.parse(p, flags)
  File "/usr/lib64/python3.6/sre_parse.py", line 855, in parse
    p = _parse_sub(source, pattern, flags & SRE_FLAG_VERBOSE, 0)
  File "/usr/lib64/python3.6/sre_parse.py", line 416, in _parse_sub
    not nested and not items))
  File "/usr/lib64/python3.6/sre_parse.py", line 553, in _parse
    raise source.error(msg, len(this) + 1 + len(that))
sre_constants.error: bad character range B-3 at position 58

ALTER SYSTEM SET resource_manager_plan='FORCE:INTERNAL_PLAN'
ORA-32017: failure in updating SPFILE
ORA-07452: specified resource manager plan does not exist in the data dictionary

[INS-32826] The software home (/opt/app/oracle/product/19.3.0.2/database) is already registered in the central inventory. Refer to patch readme instructions on how to apply.

[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2020-11-19_06-23-29PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: installActions2020-11-19_06-23-29PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

Launching Oracle Database Setup Wizard...

[WARNING] [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'
   CAUSE: No additional information available.
   ACTION: Contact Oracle Support Services or refer to the software manual.
   SUMMARY:
       - java.lang.NullPointerException
Moved the install session logs to:
 /opt/app/oraInventory/logs/InstallActions2020-11-18_08-48-11PM

Vuser 1:Rampup complete, Taking start AWR snapshot.

Error in Virtual User 1: can't read "firstsnap": no such variable

Vuser 1:FINISHED FAILED

/usr/local/HammerDB-4.0/hammerdbcli: line 8: /home/douglas/bin/tclsh8.6: No such file or directory

TASK [Download Linux Installer for HammerDB] ***********************************
[WARNING]: Module remote_tmp /home/hammer/.ansible/tmp did not exist and was
created with a mode of 0700, this may cause issues when running as another
user. To avoid this, create the remote_tmp dir with the correct permissions
manually
changed: [hammer.yaocm.id.au]

TASK [Install HammerDB] ********************************************************
An exception occurred during task execution. To see the full traceback, use -vvv. The error was: pexpect.exceptions.ExceptionPexpect: The command was not found or was not executable: /home/hammer/HammerDB-3.3-Linux-x86-64-Install.
fatal: [hammer.yaocm.id.au]: FAILED! => {"changed": false, "msg": "The command was not found or was not executable: /home/hammer/HammerDB-3.3-Linux-x86-64-Install."}

Traceback (most recent call last):
  File "/home/oracle/configure_sut_db.py", line 79, in <module>
    cursor.callproc('dbms_service.create_service', parms)
cx_Oracle.DatabaseError: ORA-44303: service name exists
ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 21
ORA-06512: at "SYS.DBMS_SERVICE", line 316
ORA-06512: at line 1

Script cleared
Building 1 Warehouses(s) with 1 Virtual User
Ready to create a 1 Warehouse Oracle TPROC-C schema
in database DEMO_DURAL under user TPCC in tablespace TPCCTAB?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:CREATING TPCC SCHEMA
Vuser 1:CREATING USER tpcc

hammerdb>Vuser 1:ORA-00959: tablespace 'TPCCTAB' does not exist create user tpcc identified by tpcc default tablespace tpcctab temporary tablespace temp
Vuser 1:ORA-01917: user or role 'TPCC' does not exist grant connect,resource,create view to tpcc
Vuser 1:ORA-01918: user 'TPCC' does not exist alter user tpcc quota unlimited on tpcctab
Error in Virtual User 1: ORA-01017: invalid username/password; logon denied
Vuser 1:FINISHED FAILED
ALL VIRTUAL USERS COMPLETE

LRM-00109: could not open parameter file '/opt/app/oracle/product/19.3.0.2/database/dbs/initDEMO19C.ora'

TASK [Create directory for Installation Software] ******************************
fatal: [dural.yaocm.id.au]: FAILED! => {"changed": false, "msg": "There was an issue creating /opt/app as requested: [Errno 13] Permission denied: b'/opt/app'", "path": "/opt/app/oracle/product/19.3.0.2/database"}

Vuser 1:Test complete: view report from SNAPID 166 to 167

Vuser 1:Start Snapshot 166 taken at 06 JAN 2021 21:00 of instance DEMO19C (1) of database DEMOCDB1 (1856558291)

HammerDB CLI v4.0
Copyright (C) 2003-2020 Steve Shaw
Type "help" for a list of commands
The xml is well-formed, applying configuration
Successfully connected
Number of TPCC objects=25
0 Virtual Users created
Loaded /home/hammer/custom_load.tcl
Vuser 1 created - WAIT IDLE

1 Virtual Users Created

1 = WAIT IDLE

Vuser 1:RUNNING

Vuser 1:Beginning rampup time of 2 minutes

Timer: 1 minutes elapsed

Vuser 1:Rampup 1 minutes complete ...

Timer: 2 minutes elapsed

Vuser 1:Rampup 2 minutes complete ...

Vuser 1:Rampup complete, Taking start AWR snapshot.

Vuser 1:Start Snapshot 166 taken at 06 JAN 2021 21:00 of instance DEMO19C (1) of database DEMOCDB1 (1856558291)

Vuser 1:Timing test period of 5 in minutes

Timer: 3 minutes elapsed

Vuser 1:1 ...,

Timer: 4 minutes elapsed

Vuser 1:2 ...,

Timer: 5 minutes elapsed

Vuser 1:3 ...,

Timer: 6 minutes elapsed

Vuser 1:4 ...,

Timer: 7 minutes elapsed

Vuser 1:5 ...,

Vuser 1:Test complete, Taking end AWR snapshot.

Vuser 1:End Snapshot 167 taken at 07 JAN 2021 10:58 of instance DEMO19C (1) of database DEMOCDB1 (1856558291)

Vuser 1:Test complete: view report from SNAPID 166 to 167

Vuser 1:0 Active Virtual Users configured

Vuser 1:TEST RESULT : System achieved 0 NOPM from 0 Oracle TPM

Vuser 1:FINISHED SUCCESS

ALL VIRTUAL USERS COMPLETE

runtimer returned after 452 seconds

waittocomplete called script exit