P6 Standalone Environment Using XE Database Error "ORA-12545 Connect failed because target host or object does not exist" (Doc ID 1196729.1)

Last updated on AUGUST 02, 2017

Applies to:

Primavera P6 Professional Project Management - Version 7.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 7.0 and later
Information in this document applies to any platform.
***Checked for relevance 09-Mar-2012***


Symptoms

The following error is encountered when attempting to access the Oracle XE database via Project Management on a standalone installation:
"ORA-12545 - Connection failed because target host or object does not exist"

The oracle listener (OracleTNSListener) starts and stops and yields the following exception:
"Some services stop automatically if they have no work to do"

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