Setup or Staretl Fails For All Step 24 Processes With ORA-12518: TNS:Listener Could Not Hand Off Client Connection (Doc ID 2208590.1)

Last updated on DECEMBER 13, 2016

Applies to:

Primavera Analytics - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ISSUE
=====
Setup.bat ( or staretl) is failing with an error in Step 24.


ERROR
======
All SQL processes in step 24 are failing with error:
setup [INFO] (Progress) - Starting Script W_ACTIVITY_STEP_DS.sql
setup [INFO] (Message) - ERROR:
setup [INFO] (Message) - ORA-12518: TNS:listener could not hand off client connection
setup [INFO] (Message) - SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus



STEPS To Reproduce
-----------------------
1. Run setup.bat (.sh)   - or -  staretl.bat (.sh)


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