POSTGRES: Deinstall

[root@slave 9.4]# ./uninstall-postgresql
Do you want to uninstall PostgreSQL and all of its modules? [Y/n]: Y

----------------------------------------------------------------------------
Uninstall Status

 Uninstalling PostgreSQL
 0% ______________ 50% ______________ 100%
 ########################################Warning: The data directory (/Database/Postgres/9.4/data) and service user
account (postgres) have not been removed.
Press [Enter] to continue:
#

Info: Uninstallation completed
Press [Enter] to continue:
Segmentation fault (core dumped)
[root@slave 9.4]#

DB : ORA-01804: failure to initialize timezone information

Error:

[oracle@localhost ~]$ sqlplus / as sysdba
ERROR:
ORA-01804: failure to initialize timezone information


SP2-0152: ORACLE may not be functioning properly

Solution:

[oracle@localhost ~]$ unset ORA_TZFILE

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 28 15:46:48 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

DB : Oracle 11.2.0.3 Patch number

Patch 10404530: 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER

EBS : Update Workflow System Administartor to * backend

Issue:

Unable to check the workflow status

Solution:

As APPS user run the below command.

update wf_resources set text='*' where name='WF_ADMIN_ROLE';

commit;

Or

Login as SYSADMIN --> Workflow Administrator --> Administration Workflow --> Administration --> Set Workflow System Administrator to *

EBS : Find Concurrent Request id from SID

Solution:

SELECT s.inst_id,a.request_id,s.sid,s.serial#,c.spid
  FROM apps.fnd_concurrent_requests a, gv$process c, gv$session s
   WHERE s.sid in ('&sid')
  AND s.paddr = c.addr
  AND a.oracle_process_id = c.spid
  AND a.phase_code = UPPER ('R');

EBS : Update Workflow mailer details from backend

Use the below script to update Workflow mailers details from backend:

sqlplus apps/apps @$FND_TOP/sql/afsvcpup.sql