BSM will not start after oralce 12c upgrade

After upgrading to bsm 9.25 we upgraded to oracle 12c.  After the upgrade we could not connect to hte DB.  This first issue was fixed by

setting

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

then the startup passed hte initial databae connection verification but hung up on trying to access oen of the database tables.  Whats interesting is the dba did not see any errors in teh oracle logs when htis occurs.

from the hardening.log   

2016-09-07 16:18:02,865 [main] (HardeningConfigurationFacade.java:46) ERROR - Failed to read hardening configuration. Possibly database connection problem.
com.mercury.infra.setting.utils.SettingException: Can't read setting from settings db table(setting_parameters). Context: security Got SQLException for Context: security

     at com.mercury.infra.setting.base.context.DBContextHolder.getContext(DBContextHolder.java:149)
        at com.mercury.infra.setting.base.context.DBContextHolder.getOverwriteContext(DBContextHolder.java:113)
        at com.mercury.infra.setting.base.context.DBContextHolder.getMerge(DBContextHolder.java:98)
        at com.mercury.infra.setting.base.context.DBContextHolder.getContextAPI(DBContextHolder.java:51)
        at com.mercury.infra.setting.base.settingApi.SettingServiceAPIImpl.getGlobalVariable(SettingServiceAPIImpl.java:170)
        at com.mercury.infra.setting.base.settingApi.SettingServiceExternalDelegatorDecorator.getGlobalVariable(SettingServiceExternalDelegatorDecorator.java:188)
        at com.hp.bsm.platform.security.hardening.configuration.persistency.HardeningConfigurationSettings.readFromSetting(HardeningConfigurationSettings.java:32)
        at com.hp.bsm.platform.security.hardening.configuration.persistency.HardeningConfigurationFacade.<init>(HardeningConfigurationFacade.java:44)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:877)

       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:839)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:880)
        at com.mercury.infra.adapter.SpringManager.loadBean(SpringManager.java:223)
        at com.mercury.infra.adapter.SpringManager.loadBean(SpringManager.java:197)
        at com.mercury.infra.adapter.AdapterFactory.createAdapter(AdapterFactory.java:102)
        at com.mercury.infra.adapter.AdapterFactory.createAdapter(AdapterFactory.java:42)
        at com.mercury.infra.utils.jmx.PasswordFileSecurity.getHardeningConfig(PasswordFileSecuri

ty.java:39)
        at com.mercury.infra.utils.jmx.PasswordFileSecurity.<init>(PasswordFileSecurity.java:35)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87)
        at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(De

Parents Reply Children
No Data