Article - CS345453

Windchill installation fails with error: "ORA-12560: TNS: protocol adapter error" in <oracle instance>.log file in Windchill PDMLink

Modified: 21-May-2021   


Applies To

  • Windchill PDMLink 11.0 to 12.0

Description

 
  • Windchill installation fails with below error in <oracle instance>.log file:
DBCA_PROGRESS : 2%
ORA-12560: TNS: protocol adapter error

ORA-12560: TNS: protocol adapter error
  • Use DBCA.bat to create oracle instance still has error:
ORA-12560: TNS: protocol adapter error
 
  • Oracle Listener is running
  • OCU_PtcInstall.log logs:
C:\Users\Administrator\AppData\Local\Temp\I1620877494\Windows>"D:\ptc\Windchill_11.0\ocu\Conf\create_db.cmd"

C:\Users\Administrator\AppData\Local\Temp\I1620877494\Windows>set ORACLE_HOME=D:\app\oracle\product\12.1.0\dbhome_1 

C:\Users\Administrator\AppData\Local\Temp\I1620877494\Windows>set PATH=D:\app\oracle\product\12.1.0\dbhome_1\bin;D:\app\oracle\product\12.1.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\ 

C:\Users\Administrator\AppData\Local\Temp\I1620877494\Windows>SET USER_PWD_REQ=1 

C:\Users\Administrator\AppData\Local\Temp\I1620877494\Windows>IF "1" NEQ "0" goto Oracle12cOSUserPwdReq 

C:\Users\Administrator\AppData\Local\Temp\I1620877494\Windows>"D:\app\oracle\product\12.1.0\dbhome_1\bin\dbca" -silent -createDatabase -templateName D:\ptc\Windchill_11.0\ocu\db_util\create_db\templates\12c\production\production_template.dbt -gdbName wind -sid wind -datafileDestination D:\ptc\Windchill_11.0\ocu\oradata -characterSet AL32UTF8 -nationalCharacterSet UTF8 -listeners LISTENER -systemPassword "manager" -sysPassword "manager" -serviceUserPassword "Wcadmin@2021@plm" 
Creating and starting Oracle instance
2% complete
DBCA Operation failed
Look at the log file "D:\app\oracle\cfgtoollogs\dbca\wind\wind.log" for further details.
 
output:  
exit code: 1 
DEBUG  2021-05-13 11:45:28 - checkStreams: product_log_file_name = OCU_PtcInstall.log 
DEBUG  2021-05-13 11:45:28 - checkStreams: ia_product_log_file_name = OCU_InstallLog.xml 
DEBUG  2021-05-13 11:45:28 - --- Start: com.ptc.windchill.ocu.install.SearchErrors @ 501293975 ----- 
DEBUG  2021-05-13 11:45:28 - Product install dir is D:\ptc\Windchill_11.0\ocu. 
DEBUG  2021-05-13 11:45:28 - Fixing up variable arrays... 
DEBUG  2021-05-13 11:45:28 - Done fixing up variable arrays. 
DEBUG  2021-05-13 11:45:28 - CHOSEN_INSTALL_SET=Custom 
DEBUG  2021-05-13 11:45:28 - CHOSEN_INSTALL_FEATURE_LIST=createSCHEMA,createDB 
DEBUG  2021-05-13 11:45:28 - Setting variable WC.validationFailed=null. 
DEBUG  2021-05-13 11:45:28 - Setting variable OCU_EXECUTE_ERROR=1. 
DEBUG  2021-05-13 11:45:28 - <p>Error occurred during OCU execution.  Information about the failure can be found in the log file:</p><ul><li>D:\ptc\Windchill_11.0\ocu\installer\logs\OCU_PtcInstall.log</li></ul> 
DEBUG  2021-05-13 11:45:28 - Exiting with return code -1 
DEBUG  2021-05-13 11:45:28 - Installation Aborting 
DEBUG  2021-05-13 11:45:28 - The following 2 logs contain information that may be useful for diagnosing installation problems. Include them in your support requests.  Shutdown the installer before accessing any logs to ensure that they are up to date. 
DEBUG  2021-05-13 11:45:28 -  - D:\ptc\Windchill_11.0\ocu\installer\logs\OCU_PtcInstall.log 
DEBUG  2021-05-13 11:45:28 -  - D:\ptc\Windchill_11.0\ocu\installer\logs\OCU_InstallLog.xml 
DEBUG  2021-05-13 11:45:28 - <p>Error occurred during OCU execution.  Information about the failure can be found in the log file:</p><ul><li>D:\ptc\Windchill_11.0\ocu\installer\logs\OCU_PtcInstall.log</li></ul>
 
This is a printer-friendly version of Article 345453 and may be out of date. For the latest version click CS345453