I did some searching but I don't find a solution to this error. Has anyone run dbsat since October, gotten this error, and know how to get around this?
I ran it with -n option to remove
There were some issues with the collect but nothing that looks like it should make the report fail. Details below:
>./dbsat collect -n "/ as sysdba" /tmp/collect_result
...
Connecting to the target Oracle database...
Elapsed: 00:00:00.00
Elapsed: 00:00:00.00
Elapsed: 00:00:00.00
Database Security Assessment Tool version 1.0.2 (October 2016)
Elapsed: 00:00:00.01
Elapsed: 00:00:00.00
Setup complete.
Elapsed: 00:00:00.00
SQL queries complete.
Elapsed: 00:00:00.00
Elapsed: 00:00:00.00
/opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -b
Usage: /opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -a | -d | -o
Warning: Exit status 256 from OS rule: sysbackup_group
/opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -g
Usage: /opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -a | -d | -o
Warning: Exit status 256 from OS rule: sysdg_group
/opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -k
Usage: /opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -a | -d | -o
Warning: Exit status 256 from OS rule: syskm_group
/opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -r
Usage: /opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp -a | -d | -o
Warning: Exit status 256 from OS rule: sysrac_group
OS commands complete.
Elapsed: 00:00:00.00
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
DBSAT Collector completed successfully.
Also, the binary is there but I don't know about the -g/k/r/b options.
>which osdbagrp
/opt/oradata/sysvol/product/11.2.0.4/bin/osdbagrp
>./dbsat report -n /tmp/collect_result
...
Database Security Assessment Tool version 1.0.2 (October 2016)
Unable to process input file: collect_result.json
Expecting property name enclosed in double quotes: line 61451 column 1 (char 3632061)
Error: Unexpected error occurred while running DBSAT Reporter.
File looks there
>ls -ltr /tmp/collect_result.json
-rw-------. 1 oracle dba 3728180 Mar 7 10:08 /tmp/collect_result.json
I tried chmod 777 on the json file also but no change.
Thanks!