I have written an extensive (more than 250 pages) self-service Studio application that talks to an Oracle database. More than 100 Oracle calls.
It's no problem to put the Oracle jar in place, set up the JNDI in the Tomcat server.xml, context.xml and use the built-in Database Element. If you are used to doing this against a MS SQL Server there are some things you may be doing in SQL that Oracle won't like, and you will have to be more precise.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.