How to Import Oracle databases in Control Compliance Suite (CCS) v11.0
In CCS 11.0 , we can import assets in two ways , which are described below :
Method 1: Importing Oracle database asset using the "Add Asset" option in the Manage > Asset System view .
Things to know ( post asset addition in CCS 11.0 as described in the above steps)
Once the Oracle asset is imported , we can test the connectivity of the Oracle database with the CCS 11.0 console by running a test Oracle query from the Queries view. When a test query is executed against the newly added Oracle configured database , we might face the below mentioned issue , which is described below :
Error message: < Server_Name> : The data collection will only work if following fields have valid values: ORCL.CONFIGUREDDATABASES.OSVERSION, ORCL.CONFIGUREDDATABASES.OSSystem. These values can be specified from the asset management in the CCS console
The above error message can appear if the ‘Operating System Version’ and ‘Database Version’ fields are not accurate in the Asset-type properties tab for the concerned Oracle configured database . This can be resolved by providing the accurate information for the mentioned fields and saving the changes for the same in the asset properties.\
Method 2 : This method of importing the oracle database requires an asset import job to be created and executed in the CCS console. Note : For Oracle databases residing on the Windows platform , there needs to be trust between the CCS’s domain and the target Oracle Server’s domain.
Once the asset is imported using the above mentioned steps , provide the credentials for the Oracle database using the Credentials view .