The Team Member Deployment Fails to Start With Errors "ORA-12505 TNS:Listener Does Not Currently Know of SID Given in Connect Descriptor" OR "ORA-01017: invalid username/password; logon denied"
Last updated on JUNE 26, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
When attempting to start the Team Member deployment, the following error occurs.
WARNING: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shared.context' defined in class path resource [META-INF/shared-context.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configurationPropertyConfigurer' defined in class path resource [META-INF/jpa-context.xml]: Cannot resolve reference to bean 'configurationAccessor' while setting bean property 'configurationAccessor'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configurationAccessor' defined in class path resource [META-INF/jpa-context.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
ERROR #2 shows in the WebLogic Console:
Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
CORRESPONDING ERROR #2 found in the Team Member P6WebAccess.html file:
ERROR com.primavera.tm.authentication.BREConnector ?:? Could not initialize the BRE on startup
java.lang.IllegalArgumentException: No enum constant com.primavera.tm.usersession.to.AuthenticationMode.INVALID_DB
The issue can be reproduced at will with the following steps:
1. Login to the WebLogic Console.
2. Go to 'Deployments'.
3. Attempt to start the Team Member deployment.
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