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