Does Not Connect From OSM 7.2 To Oracle Database 11.2.0.3 With TDE Encrypted Tablespace? (Doc ID 1514674.1)

Last updated on DECEMBER 04, 2014

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to 7.2.0 [Release 7.2]
Information in this document applies to any platform.
***Checked for relevance on 05-12-2014***

Symptoms

When starting install OSM 7.2 on TDE encrypted tablespace, can not connect causing by java.sql.SQLException: ORA-28365: wallet is not open
But if connect by sqlplus on database server or my laptop, wallet is open and database open

BUILD FAILED

/app/oracle/osm/Database/dbinstall/install/instplb.xml:47: com.mslv.install.db.util.DbManagerException: ORA-28365: wallet is not open
sql: CREATE TABLE om_I18n_description(
 ENTITY_TYPE varchar2(50)  NOT NULL,
 ENTITY_ID number(9)  NOT NULL,
 LANG_CODE varchar2(50)  NOT NULL,
 DESCRIPTION varchar2(4000 char) NOT NULL)
TABLESPACE TS_OSM_DATANested Exception: ORA-28365: wallet is not open
Nested Exception: java.sql.SQLException: ORA-28365: wallet is not open

at com.mslv.install.db.util.SqlHelper.execute(SqlHelper.java:198)
at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processSqlStatement(AbstractObjectRootProxyImpl.java:408)
at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processSql(AbstractObjectRootProxyImpl.java:397)
at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processDDL(AbstractObjectRootProxyImpl.java:224)
at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processObject(AbstractObjectRootProxyImpl.java:168)
at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processObject(AbstractObjectRootProxyImpl.java:136)
at com.mslv.install.db.processor.ApplicationProcessor.processCreateAction(ApplicationProcessor.java:559)
at com.mslv.install.db.processor.ApplicationProcessor.processCreationActions(ApplicationProcessor.java:587)
at com.mslv.install.db.processor.ApplicationProcessor.importApplicationItems(ApplicationProcessor.java:455)
at com.mslv.install.db.processor.ApplicationProcessor.installApplicationModel(ApplicationProcessor.java:728)
at com.mslv.install.db.processor.ApplicationProcessor.importApplicationModel(ApplicationProcessor.java:141)
at com.mslv.install.db.ImportDBTask.execute(ImportDBTask.java:39)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:390)
at org.apache.tools.ant.Target.performTasks(Target.java:411)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397)
at org.apache.tools.ant.Project.executeTarget(Project.java:1366)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1249)
at com.mslv.oms.installation.AntExecAction.run(AntExecAction.java:352)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-28365: wallet is not open

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms