Bentley Fiber V8i SS3 and connecting to oracle 11g

I have followed the installation guide and almost got the product working with the CommsTownSpatial example data. Database installed tables, modified using SQL scripts etc.

The last step is to actually fire up the project, but I always get the error "The database: comms user: CommsTownSpatial" connot be connected." error.

I can test the database connection from "Bentey Geospatial Administrator" and it reports success using the same host,port and service and user name.

I have checked the macros in the workspace to make sure all paths are correct, to either the workspace, communications application and oracle home.

Attached is the XML saved from Geo Admin. Are there any obvious error in in here?

Or are there possible configuration errors on the server side that could cause problems?

TIA,

Stirling.

 

CommsTownSpatial.zip