Connecting to a Primavera Database: "Error ORA-12154: TNS could not resolve the connect identifier specified" or "Description:ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor"
Last updated on DECEMBER 05, 2017
Applies to:Primavera P6 Professional Project Management - Version 5.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
The following message may occur while attempting to log in to P6 Professional client application, "Could not connect to the database. Would you like to configure the connection now?"
The message "ORA-12154: TNS could not resolve the connect identifier specified" or "ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor" when performing any of the following actions:
For Project Management or Methodology Management:
- Creating or configuring a database alias.
- Creating or upgrading a database (configasst.exe or dbsetup.bat)
- Running a schema validation (valsch.exe or validate.bat)
- Starting the TPGS Windows service and the error is shown in the Windows event viewer.
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