openmeetings-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ioannis Vlachos <ioannis.vlac...@gmail.com>
Subject Re: Connect to Oracle DB with Service name instead of SID
Date Wed, 25 May 2016 07:15:16 GMT
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 <solomax666@gmail.com>:

> 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" <ioannis.vlachos@gmail.com>
> 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 <solomax666@gmail.com>:
> >
> > > 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" <ioannis.vlachos@gmail.com>
> > > 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 <solomax666@gmail.com>:
> > > >
> > > >> 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 <
> > > >> ioannis.vlachos@gmail.com>
> > > >> 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
> > > >>
> > > >
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message