My Oracle Support Banner

E-DPK: "Puppet Apply Of [pt_profile::pt_psft_db] Failed" Error When Installing DPK (Doc ID 2750201.1)

Last updated on FEBRUARY 09, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, Updates and Fixes

When attempting to install HCM 9.2 PUM 36 PeopleTools 8.56.03 on Windows 2012R2,
the following error occurs.

ERROR
-----------------------
2020-12-15 12:36:18 -0500 Puppet Debug: [FATAL] Error while cataloging RMAN Backups
2020-12-15 12:36:22 -0500 Puppet Debug: 10% complete
2020-12-15 12:36:23 -0500 Puppet Debug: 0% complete
2020-12-15 12:36:23 -0500 Puppet Debug: Look at the log file "C:\PeopleSoft\HCM\db\oracle-server\cfgtoollogs\dbca\CDBHCM\CDBHCM.log" for further details.
2020-12-15 12:36:23 -0500 Puppet Debug: Command status: pid 496 SIGSEGV (signal 11)
2020-12-15 12:36:23 -0500 Puppet Debug: Command executed successfully, output: [Prepare for db operation10% completeCopying database files12% complete[WARNING] ORA-12638: Credential retrieval failed40% complete100% complete[FATAL] Error while cataloging RMAN Backups10% complete0% completeLook at the log file "C:\PeopleSoft\HCM\db\oracle-server\cfgtoollogs\dbca\CDBHCM\CDBHCM.log" for further details.]
2020-12-15 12:36:23 -0500 Puppet Debug: DBCA 19c - Container database creation successful
2020-12-15 12:36:23 -0500 Puppet Debug: Failed to delete service OracleJobSchedulerCDBHCM
2020-12-15 12:36:23 -0500 Puppet Debug: Failed to stop service OracleVssWriterCDBHCM
2020-12-15 12:36:23 -0500 Puppet Debug: alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL=TCP)(HOST=ABC.org)(PORT=XXXX))' scope=both;
2020-12-15 12:36:23 -0500 Puppet
2020-12-15 12:36:23 -0500 Puppet Debug: Executing SQL command file: sqlplus.exe -S -L / as sysdba @C:/Users/DEV/AppData/Local/Temp/listener-502.sql
2020-12-15 12:36:24 -0500 Puppet Debug: SQL command output: ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
, error:
2020-12-15 12:36:24 -0500 Puppet Error: Error updating listener info on container database : CDBHCM
c:/Program Files/Puppet Labs/Puppet/sys/ruby/lib/ruby/vendor_ruby/puppet/util/errors.rb:157:in `fail'

--------------------------------

2020-12-15 12:36:24 -0500 Puppet Error: /Stage[main]/Pt_profile::Pt_psft_db/Pt_setup_psftdb[HR92U036]/ensure: change from 'absent' to 'present' failed: Error updating listener info on container database : CDBHCM

--------------------------------
2020-12-15 12:35:48 -0500 Puppet Debug: Failed to stop database service for CDB CDBHCM: The specified service does not exist as an installed service. - OpenService: The specified service does not exist as an installed service.
2020-12-15 12:35:48 -0500 Puppet Debug: Failed to delete database service for CDB CDBHCM: The specified service does not exist as an installed service. - OpenService: The specified service does not exist as an installed service.
2020-12-15 12:35:48 -0500 Puppet Debug: Executing command: C:\PeopleSoft\HCM\db\oracle-server\19.3.0.0\bin\dbca -createDatabase -silent -responseFile C:\PeopleSoft\HCM\db\oracle-server\19.3.0.0\assistants\dbca\dbca.rsp -J-Doracle.assistants.dbca.validate.ConfigurationParams=false
2020-12-15 12:35:49 -0500 Puppet Debug: Started thread PID: 496
2020-12-15 12:35:49 -0500 Puppet Debug: Waiting for the thread PID: 496 to finish
2020-12-15 12:36:05 -0500 Puppet Debug: Prepare for db operation
2020-12-15 12:36:06 -0500 Puppet Debug: 10% complete
2020-12-15 12:36:06 -0500 Puppet Debug: Copying database files
2020-12-15 12:36:17 -0500 Puppet Debug: 12% complete
2020-12-15 12:36:17 -0500 Puppet Debug: [WARNING] ORA-12638: Credential retrieval failed
2020-12-15 12:36:17 -0500 Puppet Debug:
2020-12-15 12:36:18 -0500 Puppet Debug: 40% complete
2020-12-15 12:36:18 -0500 Puppet Debug: 100% complete
2020-12-15 12:36:18 -0500 Puppet Debug: [FATAL] Error while cataloging RMAN Backups
2020-12-15 12:36:22 -0500 Puppet Debug: 10% complete
2020-12-15 12:36:23 -0500 Puppet Debug: 0% complete
2020-12-15 12:36:23 -0500 Puppet Debug: Look at the log file "C:\PeopleSoft\HCM\db\oracle-server\cfgtoollogs\dbca\CDBHCM\CDBHCM.log" for further details.
2020-12-15 12:36:23 -0500 Puppet Debug: Command status: pid 496 SIGSEGV (signal 11)
2020-12-15 12:36:23 -0500 Puppet Debug: Command executed successfully, output: [Prepare for db operation10% completeCopying database files12% complete[WARNING] ORA-12638: Credential retrieval failed40% complete100% complete[FATAL] Error while cataloging RMAN Backups10% complete0% completeLook at the log file "C:\PeopleSoft\HCM\db\oracle-server\cfgtoollogs\dbca\CDBHCM\CDBHCM.log" for further details.]
2020-12-15 12:36:23 -0500 Puppet Debug: DBCA 19c - Container database creation successful
2020-12-15 12:36:23 -0500 Puppet Debug: Failed to delete service OracleJobSchedulerCDBHCM
2020-12-15 12:36:23 -0500 Puppet Debug: Failed to stop service OracleVssWriterCDBHCM
2020-12-15 12:36:23 -0500 Puppet Debug: alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL=TCP)(HOST=ABC.org)(PORT=XXXX))' scope=both;
2020-12-15 12:36:23 -0500 Puppet
2020-12-15 12:36:23 -0500 Puppet Debug: Executing SQL command file: sqlplus.exe -S -L / as sysdba @C:/Users/DEV/AppData/Local/Temp/listener-502.sql
2020-12-15 12:36:24 -0500 Puppet Debug: SQL command output: ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
, error:
2020-12-15 12:36:24 -0500 Puppet Error: Error updating listener info on container database : CDBHCM




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.