After making a clean installation of eZ Publish 4.6, with Oracle and Service Portal I get the following in the Database Consistency Check:

The database is not consistent with the distribution database.

To synchronize your database with the distribution setup, run the following SQL commands:

CREATE TABLE ezstarrating (
contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
contentobject_id INTEGER DEFAULT 0 NOT NULL,
rating_average FLOAT DEFAULT 0 NOT NULL,
rating_count INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ( contentobject_id, contentobject_attribute_id )
);

CREATE SEQUENCE s_starrating_data;

CREATE TABLE ezstarrating_data (
contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
contentobject_id INTEGER DEFAULT 0 NOT NULL,
created_at INTEGER DEFAULT 0 NOT NULL,
id INTEGER NOT NULL,
rating FLOAT DEFAULT 0 NOT NULL,
session_key VARCHAR2(32) NOT NULL,
user_id INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ( id )
);

CREATE OR REPLACE TRIGGER ezstarrating_data_id_tr
BEFORE INSERT ON ezstarrating_data FOR EACH ROW WHEN (new.id IS NULL)
BEGIN
SELECT s_starrating_data.nextval INTO :new.id FROM dual;
END;
/

CREATE INDEX contentobject_id_co_attr_id ON ezstarrating_data ( contentobject_id, contentobject_attribute_id );

CREATE INDEX user_id_session_key ON ezstarrating_data ( user_id, session_key );

CREATE TABLE ezgmaplocation (
address VARCHAR2(150),
contentobject_attribute_id INTEGER DEFAULT 0 NOT NULL,
contentobject_version INTEGER DEFAULT 0 NOT NULL,
latitude FLOAT DEFAULT 0 NOT NULL,
longitude FLOAT DEFAULT 0 NOT NULL,
PRIMARY KEY ( contentobject_attribute_id, contentobject_version )
);

CREATE INDEX latitude_longitude_key ON ezgmaplocation ( latitude, longitude );

Steps to reproduce

1. Make a clean installation of Ez Publish 4.6
2. Activate the EzOracle extension, by adding ActiveExtensions[]=ezoracle in site.ini.append.php
3. Run ./extension/ezoracle/bin/shell/ora-initialize.sh
4. Add to site.ini.append.php

##################################
[DatabaseSettings]
DatabaseImplementation=ezoracle
User=<user>
Password=<password>
Database=<instance>
##################################

5. Register in Service Portal
6. Run Sync_Network cronjob
7. Run Monitor cronjob
8. Make a Database Consistency Check