according to the stackowerflow connection string should be "*jdbc:oracle:thin:@//oracle.hostserver2.mydomain.ca:1522/ABCD <http://oracle.hostserver2.mydomain.ca:1522/ABCD>*" OM requires host port db
could you please try the following: host = "*//oracle.hostserver2.mydomain.ca <http://oracle.hostserver2.mydomain.ca>*" (don't forget "//" in the beginning) port = 1521 (or other valid port) db = "Service Name" same options are available for command line admin On Wed, May 25, 2016 at 1:15 PM, Ioannis Vlachos <[email protected]> wrote: > I've done that and the web installer gives the error I've sent you. > Command line admin doesn't work either. There is no way (?) to specify > whether you want to use SID or Service name and the persistence.xml created > uses the SID syntax. > > 2016-05-25 9:34 GMT+03:00 Maxim Solodovnik <[email protected]>: > > > Can you try to manually copy and modify oracle specific persistense.xml > > And run installer? > > In this case db properties should not be patched > > > > WBR, Maxim > > (from mobile, sorry for the typos) > > On May 25, 2016 12:27, "Ioannis Vlachos" <[email protected]> > > wrote: > > > > > screenshot: https://www.dropbox.com/s/k0ocnkwitak7dq3/install.PNG?dl=0 > > > > > > log: https://www.dropbox.com/s/xe3jf9791j8h4bb/openmeetings.log?dl=0 > > > > > > > > > > > > 2016-05-25 9:14 GMT+03:00 Maxim Solodovnik <[email protected]>: > > > > > > > Mailing list seems to drop your attachment > > > > Can you share the image via link? > > > > > > > > WBR, Maxim > > > > (from mobile, sorry for the typos) > > > > On May 25, 2016 12:12, "Ioannis Vlachos" <[email protected]> > > > > wrote: > > > > > > > > > I've already tried that (I've searched before I asked). > > > > > Unfortunately, openmeetings' web installer does not recognise that > > > syntax > > > > > and shows an error when you try to set the db (see attached image). > > If > > > > you > > > > > try to fill out the form, then the connection is made with SID. > > > > > > > > > > I haven't tried the command line admin though. I'll try it and come > > > back > > > > > with the results. > > > > > > > > > > > > > > > > > > > > 2016-05-24 14:41 GMT+03:00 Maxim Solodovnik <[email protected] > >: > > > > > > > > > >> I believe this is the answer to your question: > > > > >> > > > > >> > > > > > > > > > > http://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid > > > > >> > > > > >> On Tue, May 24, 2016 at 3:34 PM, Ioannis Vlachos < > > > > >> [email protected]> > > > > >> wrote: > > > > >> > > > > >> > Hi. > > > > >> > In my organization we use Oracle, but we can only connect > through > > > > >> Service > > > > >> > Name and not SID. > > > > >> > Is there any way to specify Service Name instead of SID in the > > > > >> connection > > > > >> > configuration? > > > > >> > All the efforts I have made result in an ora-12505 error: tns > > > listener > > > > >> does > > > > >> > not currently know of sid given in connect descriptor. > > > > >> > > > > > >> > Thanks > > > > >> > > > > > >> > Ioannis Vlachos > > > > >> > > > > > >> > > > > >> > > > > >> > > > > >> -- > > > > >> WBR > > > > >> Maxim aka solomax > > > > >> > > > > > > > > > > > > > > > > > > > > -- WBR Maxim aka solomax
