Re: Connect to Oracle DB with Service name instead of SID

I moved discussion to user list, let's continue there On Thu, May 26, 2016 at 2:57 PM, Ioannis Vlachos wrote: > This is a big email, sorry: > I was able to connect to the DB through the command line admin. I just had > to remove all parameters that had to do with the

Re: Connect to Oracle DB with Service name instead of SID

This is a big email, sorry: I was able to connect to the DB through the command line admin. I just had to remove all parameters that had to do with the database (e.g. --db-type) and then the script uses the persistence.xml as it is, so it can read the /SERVICE_NAME at the end. I used the command:

Re: Connect to Oracle DB with Service name instead of SID

according to the stackowerflow connection string should be "*jdbc:oracle:thin:@//oracle.hostserver2.mydomain.ca:1522/ABCD *" OM requires host port db could you please try the following: host = "*//oracle.hostserver2.mydomain.ca

Re: Connect to Oracle DB with Service name instead of SID

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

Re: Connect to Oracle DB with Service name instead of SID

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" wrote: > screenshot:

Re: Connect to Oracle DB with Service name instead of SID

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 : > Mailing list seems to drop your attachment > Can you share the image via link? > >

Re: Connect to Oracle DB with Service name instead of SID

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" wrote: > I've already tried that (I've searched before I asked). > Unfortunately, openmeetings' web

Re: Connect to Oracle DB with Service name instead of SID

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

Re: Connect to Oracle DB with Service name instead of SID

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 wrote: > Hi. > In my organization we use Oracle, but we can

Connect to Oracle DB with Service name instead of SID

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