My Oracle Support Banner

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

Last updated on DECEMBER 05, 2019

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.

$ ./EngineStarter.sh &
[1] 45103
$ 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.

 $ ./EngineStarter.sh <DB host address>:<port>/<service name> <user> <password> &
[1] 47381
 $ source /u01/DM/demantra/Engine/bin/setenv.sh; ./EngineStarter <DB host address>:<port>/<service name> <user> <password> <DB host address> 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.

 $ ./EngineStarter.sh <DB host address>:<port>/<service name> <user> <password> starter1 5 &
[1] 54938
 $ source /u01/DM/demantra/Engine/bin/setenv.sh; ./EngineStarter <DB host address>:<port>/<service name> <user> <password> 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.