The attached is a SCAP OVAL example Check for Oracle RDBMS. Please use it for testing and demonstration purposes only. To use the attached, rename the .txt extension to .xml and if you have questions and/or comments please direct them to: email@example.com.
The key points you will know is for the JOVAL connection string for Oracle:
Engine: oracle Version values: 11.2.0, 11.1.0, 10.2.0, 10.1.0, 9.2.0, 9.0.1 Connection string (do not use JDBC syntax): user=your_username;password=your_password;SID=your_instance_name