ORAPARTSEED Program Fails With "ORA-1034: ORACLE Not Available" Error When Batch Server and Database Server Are Separate Machines (Doc ID 1628259.1)

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.

Symptoms

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:

  1. Run the ORAPARTSEED batch from different server than the database server.
  2. Batch fails, producing the error “Invalid Username/password”. 
  3. 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).
  4. 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.

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