E-DPK: Setup Of Prcs Domain Using DPK Script Fails with "Reason: Could not sign on to database <database_name> with user PS." (Doc ID 2375609.1)

Last updated on MARCH 27, 2018

Applies to:

Symptoms

ENVIRONMENT
================
PT 8.56.06


When attempting to install process scheduler using dpk the following error occurs.


ERROR
=======
2018-02-22 13:00:16 +0200 Puppet (debug): Executing of AE failed: Execution of 'su -s /bin/bash - psptrun -c ". /tmp/ae-env-403.sh && /u01/app/oracle/psft/pt/ps_home8.56.06/bin/psae /tmp/temp_ae_cmd_244.txt "' returned 8: Error in sign on
  Database Type: 7 (ORACLE)
  Database Name: hr91dmo
  Server Name:
  OperID: PS
  ConnectID: people
  Process Instance: 0
  Reason: Could not sign on to database hr91dmo with user PS.
2018-02-22 13:00:16 +0200 Puppet (debug): PTEM property file /tmp/ae-ptem-174.prop is present
2018-02-22 13:00:16 +0200 Puppet (debug): Removing property file /tmp/ae-ptem-174.prop
2018-02-22 13:00:16 +0200 Puppet (debug): Phase 1 of AE run failed: , Execution of 'su -s /bin/bash - psptrun -c ". /tmp/ae-env-403.sh && /u01/app/oracle/psft/pt/ps_home8.56.06/bin/psae /tmp/temp_ae_cmd_244.txt "' returned 8: Error in sign on
  Database Type: 7 (ORACLE)
  Database Name: hr91dmo
  Server Name:
  OperID: PS
  ConnectID: people
  Process Instance: 0
  Reason: Could not sign on to database hr91dmo with user PS.
2018-02-22 13:00:18 +0200 /Stage[main]/Pt_profile::Pt_tools_preboot_config/Pt_acm_plugin[preboot_reportdistribution]/returns (debug): , Execution of 'su -s /bin/bash - psptrun -c ". /tmp/ae-env-33.sh && /u01/app/oracle/psft/pt/ps_home8.56.06/bin/psae /tmp/temp_ae_cmd_67.txt "' returned 8: Error in sign on


STEPS
======
The issue can be reproduced at will with the following steps:
1. Run ./psft-dpk-setup.sh --env_type midtier --domain_type prcs
2. create psft_customizations.yaml
3. Run /opt/puppetlabs/bin/puppet apply --confdir=/u01/app/oracle/psft/dpk/puppet site.pp --debug --trace --logdest "/u04/sw/puppet_run1hra.log"

Cause