Futher to the Portal 6.1.5 set up – these steps were required from an ORACLE DB point of view to get the DB configured :
Grant create session to community
Create likeminds user
Grant create table to community
Grant create view to jcr
Grant unlimited tablespace to community
and also these
grant select on sys.dba_pending_transactions to public;
grant select on sys.pending_trans$ to public;
grant select on sys.dba_2pc_pending to public;
grant execute on sys.dbms_system to public;
if you don’t do this then it just doesn’t work 🙂