PPM and Function Service Hang On Start Up, 'Login failed' attempting to connect to RDBMS - FIPS Security Policy, ORA-1005 (Doc ID 1156224.1)

Last updated on APRIL 04, 2024

Applies to:

Primavera Portfolio Management - Version 8.0 and later
Information in this document applies to any platform.
Currency Review on 12/23/2015

After installing PPM 8.x, 9.x or 15.x, PPM Service and Function service hang on start up.
When attempting to connect to a PPM database in the PPM Console, the message 'Login failed' is displayed.
Error in prosight.log: ORA-1005: null password given; logon denied
When attempting to add a new connection (using the PPM Console) to an Oracle database using TNS, the following error occurs. Note that the database can be pinged from the PPM application server and the db can be connected to via sqlplus. Further, the user (specified in the connection) was created using the Oracle Database Configuration Utility which indicates that the user 'PPM' exists and is properly configured.

ERROR
-----------------------
Connections failed.
Failed to connect to the database.
Value cannot be null.
Parameter Name: type

	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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.