Connecting hippo cms 10.2 to local Oracle database

I run the hippo cms with default H2 database on my local and works perfectly fine, but because of requirement, I have to run it with Oracle database on my local.

I did changes to repository.xml, context.xml, added ojdbc driver config and added repo.config property in cargo.run profile in POM.
I did setup Oracle DB along with production data on my local too.

After all these steps, I saw RepositoryNotAvailable exception and then , I could see the instance up and running as expected after a few retries with some minor (but not so relevant) changes.

I then realized that the issue is happening intermittently and I see a ‘Access is Denied’ for segments.gen file:

java.io.FileNotFoundException: C:\GIT2\gmlcms\target\storage\workspaces\default\index_29\segments.gen (Access is denied)

but sometimes it works just fine on server restart.
FYI, I remove storage folder before every restart.

@woonsanko, Sorry to bother you, but, Do you have any insights in this issue?
This is the only impediment we facing in setting up a process.

Brief stack trace is:

[INFO] [talledLocalContainer] #component==GML# #sourcetype==log4j# [08 Aug 2018 14:38:16,070] [ERROR] [org.hippoecm.repository.jackrabbit.RepositoryImpl]: [Unable to register RepositoryStat]
[INFO] [talledLocalContainer] javax.management.InstanceNotFoundException: org.hippoecm.repository:type=Repository,name=statistics
[INFO] [talledLocalContainer] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.getMBean(DefaultMBeanServerInterceptor.java:1095)
[INFO] [talledLocalContainer] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.exclusiveUnregisterMBean(DefaultMBeanServerInterceptor.java:427)
[INFO] [talledLocalContainer] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.unregisterMBean(DefaultMBeanServerInterceptor.java:415)
[INFO] [talledLocalContainer] at com.sun.jmx.mbeanserver.JmxMBeanServer.unregisterMBean(JmxMBeanServer.java:546)
[INFO] [talledLocalContainer] at org.hippoecm.repository.jackrabbit.RepositoryImpl.unregisterJmxRepositoryStatistics(RepositoryImpl.java:129)
[INFO] [talledLocalContainer] at org.hippoecm.repository.jackrabbit.RepositoryImpl.doShutdown(RepositoryImpl.java:82)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl.shutdown(RepositoryImpl.java:1113)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:591)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:365)
[INFO] [talledLocalContainer] at org.hippoecm.repository.jackrabbit.RepositoryImpl.(RepositoryImpl.java:75)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository$LocalRepositoryImpl.(LocalHippoRepository.java:242)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:264)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:120)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:110)
[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[INFO] [talledLocalContainer] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[INFO] [talledLocalContainer] at java.lang.reflect.Method.invoke(Method.java:498)
[INFO] [talledLocalContainer] at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:178)
[INFO] [talledLocalContainer] at org.hippoecm.repository.RepositoryServlet.init(RepositoryServlet.java:189)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4914)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5201)
[INFO] [talledLocalContainer] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
[INFO] [talledLocalContainer] at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
[INFO] [talledLocalContainer] at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
[INFO] [talledLocalContainer] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[INFO] [talledLocalContainer] at java.lang.Thread.run(Thread.java:745)
[INFO] [talledLocalContainer] #component==GML# #sourcetype==log4j# [08 Aug 2018 14:38:16,118] [ERROR] [org.apache.jackrabbit.core.RepositoryImpl]: [failed to start Repository: Unable to initialize query handler: org.hippoecm.repository.FacetedNavigationEngineImpl@54f66333]
[INFO] [talledLocalContainer] javax.jcr.RepositoryException: Unable to initialize query handler: org.hippoecm.repository.FacetedNavigationEngineImpl@54f66333
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$1.getQueryHandler(RepositoryConfigurationParser.java:686)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.config.WorkspaceConfig.getQueryHandler(WorkspaceConfig.java:251)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.SearchManager.(SearchManager.java:171)
[INFO] [talledLocalContainer] at org.hippoecm.repository.jackrabbit.HippoSearchManager.(HippoSearchManager.java:78)
[INFO] [talledLocalContainer] at org.hippoecm.repository.jackrabbit.RepositoryImpl$HippoWorkspaceInfo.getSearchManager(RepositoryImpl.java:317)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doPostInitialize(RepositoryImpl.java:2173)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:2076)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:582)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:365)
[INFO] [talledLocalContainer] at org.hippoecm.repository.jackrabbit.RepositoryImpl.(RepositoryImpl.java:75)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository$LocalRepositoryImpl.(LocalHippoRepository.java:242)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:264)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:120)
[INFO] [talledLocalContainer] at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:110)
[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[INFO] [talledLocalContainer] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[INFO] [talledLocalContainer] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[INFO] [talledLocalContainer] at java.lang.reflect.Method.invoke(Method.java:498)
[INFO] [talledLocalContainer] at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:178)
[INFO] [talledLocalContainer] at org.hippoecm.repository.RepositoryServlet.init(RepositoryServlet.java:189)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4914)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5201)
[INFO] [talledLocalContainer] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
[INFO] [talledLocalContainer] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
[INFO] [talledLocalContainer] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
[INFO] [talledLocalContainer] at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
[INFO] [talledLocalContainer] at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1768)
[INFO] [talledLocalContainer] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[INFO] [talledLocalContainer] at java.lang.Thread.run(Thread.java:745)
[INFO] [talledLocalContainer] Caused by: java.io.IOException: Error indexing workspace
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createInitialIndex(MultiIndex.java:394)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.SearchIndex.doInit(SearchIndex.java:582)
[INFO] [talledLocalContainer] at org.hippoecm.repository.FacetedNavigationEngineImpl.doInit(FacetedNavigationEngineImpl.java:650)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.AbstractQueryHandler.init(AbstractQueryHandler.java:78)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$1.getQueryHandler(RepositoryConfigurationParser.java:683)
[INFO] [talledLocalContainer] … 35 more
[INFO] [talledLocalContainer] Caused by: java.io.FileNotFoundException: C:\GIT2\gmlcms\target\storage\workspaces\default\index_29\segments.gen (Access is denied)
[INFO] [talledLocalContainer] at java.io.RandomAccessFile.open0(Native Method)
[INFO] [talledLocalContainer] at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
[INFO] [talledLocalContainer] at java.io.RandomAccessFile.(RandomAccessFile.java:243)
[INFO] [talledLocalContainer] at org.apache.lucene.store.FSDirectory$FSIndexOutput.(FSDirectory.java:441)
[INFO] [talledLocalContainer] at org.apache.lucene.store.FSDirectory.createOutput(FSDirectory.java:306)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.directory.FSDirectoryManager$FSDir.createOutput(FSDirectoryManager.java:201)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.PersistentIndex.copyIndex(PersistentIndex.java:137)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex$VolatileCommit.execute(MultiIndex.java:2119)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.executeAndLog(MultiIndex.java:1131)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.commitVolatileIndex(MultiIndex.java:1180)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.checkVolatileCommit(MultiIndex.java:1154)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1226)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1242)
[INFO] [talledLocalContainer] at org.apache.jackrabbit.core.query.lucene.MultiIndex.createInitialIndex(MultiIndex.java:386)
[INFO] [talledLocalContainer] … 39 more
[INFO] [talledLocalContainer] #component==GML# #sourcetype==log4j# [08 Aug 2018 14:38:16,126] [ERROR] [org.hippoecm.repository.HippoRepository]: [Error while setting up JCR repository: ]

The problem sounds not related to the Oracle database, may be related to your storage file permission instead.
Can you try to restart server with the option -Drepo.path=anyOtherPath where you are the owner of the directory.

That’s correct @ThoLe. At times, I could see the application running just fine , as expected (connected to oracle DB.)
Also, the same directory location worked fine for H2 database. Not sure why it creating problem for oracle config only.

Now that I tried with Downloads location (which is like open directory with relaxed permissions) , It works just fine.
Thanks for the suggestion. :slightly_smiling_face:

You are welcome @sarthak.sharma

@sarthak.sharma trying to use different directory was already suggest by us

“You could try different folder for your storage and see if it works. If that fails, try turning off your anti virus software completely and check if it works and maybe try turning UAC off”