Error 'ORA-12154: TNS could not resolve the connect identifier specified' or 'TNS:listener could not resolve SERVICE_NAME given in connect descriptor' When Connecting P6 to an Oracle Database
(Doc ID 898664.1)
Last updated on DECEMBER 03, 2019
Applies to:Primavera P6 Professional Project Management - Version 5.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
When attempting to do any of the following tasks:
- 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.
...one of the following errors occurs:
ORA-12154: TNS could not resolve the connect identifier specified
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!