In my last post, I walked you through the first part of installing the Oracle Database 12c STIG compliance standards sample code. The next step to using these compliance standards is to associate your Oracle Database 12c databases with these standards. You may recall there are two separate standards in the sample code, one for multitenant databases and the other for conventional architecture databases. The process of associating the databases is the same in each case. You simply have to choose the compliance standard that matches your architecture. In this walkthrough, I will show you how to associate a multitenant database with the “Oracle 12c PDB STIG” compliance standard.
The first step is to go to the “Compliance Standards” tab on the “Compliance Framework” page. To access this, follow the menu path “Enterprise” -> “Compliance” -> “Library”:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc01-287x300... 287w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc01-143x150... 143w" sizes="(max-width: 395px) 100vw, 395px" />
Click on the “Compliance Standards” tab, then select the “Oracle 12c PDB STIG” compliance standard and click on “Associate Targets”:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc02-300x90.jpg 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc02-768x230... 768w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc02-1024x30... 1024w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc02-250x75.jpg 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc02-150x45.jpg 150w" sizes="(max-width: 1377px) 100vw, 1377px" />
On the “Compliance Standard Target Association” page, click the “Add” button:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc03-300x116... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc03-250x96.jpg 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc03-150x58.jpg 150w" sizes="(max-width: 697px) 100vw, 697px" />
On the “Select Targets” pop-up, select the databases you want and click the “Select” button (this is my test environment so a lot of the remaining databases are down at the moment):
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc04-1-300x2... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc04-1-162x1... 162w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc04-1-150x1... 150w" sizes="(max-width: 619px) 100vw, 619px" />
Back on the “Compliance Standard Target Association” page, click “OK”:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc05-1-300x7... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc05-1-768x1... 768w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc05-1-1024x... 1024w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc05-1-250x6... 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc05-1-150x3... 150w" sizes="(max-width: 1045px) 100vw, 1045px" />
Click “Yes” on the “Save Association” pop-up:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc06-300x154... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc06-250x128... 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc06-150x77.jpg 150w" sizes="(max-width: 328px) 100vw, 328px" />
You will see an informational message that the compliance standard has been submitted to the target for processing, and the association count value for the standard is now 1. Click “OK” to close the informational window:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc07-1-300x1... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc07-1-768x2... 768w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc07-1-1024x... 1024w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc07-1-250x9... 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc07-1-150x5... 150w" sizes="(max-width: 1048px) 100vw, 1048px" />
Next, we want to look at the results of the target association, so from the “Enterprise” menu, select “Compliance” and then “Dashboard”:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc08-286x300... 286w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc08-143x150... 143w" sizes="(max-width: 395px) 100vw, 395px" />
We can see immediately that we have a lot of issues to address, as the Oracle 12c Database STIG shows an average compliance score in the “Compliance Summary” region of only 22% (please note, the number in your environment may vary from this). You can also see this graphically by selecting the framework from the dropdown list in the “Compliance Framework Summary” region:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc09-150x150... 150w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc09-300x297... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc09-151x150... 151w" sizes="(max-width: 610px) 100vw, 610px" />
TIP: If you see an average compliance score of 0%, this means the evaluation did not complete successfully. One of the main reasons for this is if the DBSNMP account is not available to login as. For example, if the account is locked, expired, or even giving a message that it is about to expire, the evaluation won’t complete. Note that the DBSNMP account can be open in a CDB, but expired in a PDB. To address that it can be easiest to simply login to the CDB, and enter the command:
ALTER USER dbsnmp IDENTIFIED BY
Clearly, you can do it container by container if you want to have different passwords for the DBSNMP user in different PDB’s.
If you click on the compliance score in the “Compliance Framework Summary” region, you get a little more information along with the ability to drill in for more details. Click on “Click here for more information …”:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc10-293x300... 293w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc10-146x150... 146w" sizes="(max-width: 573px) 100vw, 573px" />
This will take you to the “Compliance Results” page, where you can see the breakdown on a per target or per compliance standard basis (note that the per compliance standard results are just a combination of the per target results since we have only evaluated one compliance standard thus far). To see more details, click on the number of critical violations (e.g. the number “44” for the “HRdb0000_HRDBPDB1” row):
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc11-300x133... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc11-768x341... 768w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc11-1024x45... 1024w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc11-250x111... 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc11-150x67.jpg 150w" sizes="(max-width: 1209px) 100vw, 1209px" />
On the “Violations” pop-up, click on the violation count:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc12-300x70.jpg 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc12-250x59.jpg 250w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc12-150x35.jpg 150w" sizes="(max-width: 619px) 100vw, 619px" />
This will show you a list of all the compliance standard rules that have been violated, along with a violation count for each rule. While it is not immediately obvious, the numbers of each violation count are actually links to more details:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc13-300x236... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc13-191x150... 191w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc13-150x118... 150w" sizes="(max-width: 625px) 100vw, 625px" />
For example, if you click on the number 35 (for the SV-76031r1_pdbrule), you can see the following accounts have non-standard passwords:
http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc14-300x236... 300w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc14-191x150... 191w, http://petewhodidnottweet.com/wp-content/uploads/2016/10/assoc14-150x118... 150w" sizes="(max-width: 621px) 100vw, 621px" />
Click “Close” to close the “Violations” window. Resolving the violations is not part of this demo, but in this case you can see that if you change the passwords for these users to something other than the default and re-execute the compliance check, these violations would clear.
My next post in this area will cover installing the reporting capability to match the Oracle Database 12c STIG compliance framework, so stay tuned for more!
The post Associating Oracle Database 12c Databases with Compliance Standards appeared first on PeteWhoDidNotTweet.com.