Run EngineStarter.sh When No Parameters Are Passed Gives Error ORA-12578: TNS:wallet open failed (Doc ID 2121302.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Demand Management - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

Upgraded to Demantra 12.2.5. After upgrading systems and deploying on Linux there are issues with starting the engine. When try to run EngineStarter.sh, it gives errors when no parameters are passed or 3 parameters are passed. But all 5 parameters it starts up fine. Customer has set up Oracle Wallet and there are no issues.

When test connection using “tnsping $ENG_CONNECTION" or “sqlplus /@$ENG_CONNECTION".

Gone through 12.2.5.1 Engine Deployment Guide ( Doc ID 2069139.1 ) and everything has been setup correctly. Please see the output below for all 3 options.

1.No parameters passed, gives error.

[oracle@lxckrdb1x bin]$ ./EngineStarter.sh &
[1] 45103
[oracle@lxckrdb1x bin]$ source /u01/DM/demantra/Engine/bin/setenv.sh; ./EngineStarter
2016-03-08.09:35:43 ORA-12578: TNS:wallet open failed
2016-03-08.09:35:43 Terminating OCCI Environment ...
2016-03-08.09:35:43 Done


2. Three parameters are passed, gives error.

[oracle@lxckrdb1x bin]$ ./EngineStarter.sh lxckrdb1x.leviton.inc:1526/ASCPT demantra demantra &
[1] 47381
[oracle@lxckrdb1x bin]$ source /u01/DM/demantra/Engine/bin/setenv.sh; ./EngineStarter lxckrdb1x.leviton.inc:1526/ASCPT demantra demantra lxckrdb1x.leviton.inc 1
2016-03-08.09:36:06 ERROR: Failed to initialize notification queue for Engine Starter ID: krdb1x.leviton.inc, Status: FAILURE: -24000 ORA-24000: invalid value DEMANTRA.XX, QUEUE_TABLE should be of the form [SCHEMA.]NAME, Exiting...


3. Five parameters are passed, no errors.

[oracle@lxckrdb1x bin]$ ./EngineStarter.sh lxckrdb1x.leviton.inc:1526/ASCPT demantra demantra starter1 5 &
[1] 54938
[oracle@lxckrdb1x bin]$ source /u01/DM/demantra/Engine/bin/setenv.sh; ./EngineStarter lxckrdb1x.leviton.inc:1526/ASCPT demantra demantra starter1 5
2016-03-08.09:37:46 WARNING: Old eng_starter1 was removed from ENGINE_STARTER_LIST
2016-03-08.09:37:47 Engine Starter (ID:eng_starter1, Number of Engines:5) is listening ...
 

Solution

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