RETL Batch Job Rmsl_forecast.ksh Fails With ORA-01034: ORACLE Not Available
(Doc ID 2076176.1)
Last updated on MARCH 08, 2019
Applies to:Oracle Retail Extract Tranform and Load - Version 13.2.4 and later
Information in this document applies to any platform.
In Oracle Retail Extract, Transform, and Load (RETL) Release 13.2.X
Script rmsl_rpas_forecast.ksh fails to execute when the password has a special character "#" included.
Steps To Recreate:
- Include special character "#" in the batch user password.
- Save the password in RMS DB Wallet and RETL Wallet.
- Execute rmsl_rpas_forecast.ksh weekly
- Notice the below error:
SQL*Loader: Release 188.8.131.52.0 - Production on Mon Oct 26 16:43:51 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-128: unable to begin a session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
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