Last updated on AUGUST 21, 2015
Applies to:Oracle Retail Data Warehouse - Version 13.0.5 and later
Information in this document applies to any platform.
We recently moved our database to an Exadata machine, resulting in a situation where the batch server and the database server are two different machines. The ORAPARTSEED batch now fails with the below error when executed from a different server than the database server:
Steps to Reproduce:
- Run the ORAPARTSEED batch from different server than the database server.
- Batch fails, producing the error “Invalid Username/password”.
- Also, note that appropriate error handling is not present in the program (i.e., it has been running and failing to connect via SQL*Plus, but not returning the failure code to the calling job scheduler).
- Expected Result: Batch should be able to connect to the database on the other server. The shell script needs to check the return code from the SQL*Plus command.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms