EBS R12.2 adstpall.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong

EBS R12.2 adstpall.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong
If you are getting error like below even if listener at DB node is up.
adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

adstpall.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

[applmgr@ebs122 scripts]$ adstrtal.sh

You are running adstrtal.sh version 120.24.12020000.6
Enter the APPS username: apps
Enter the APPS password:
Enter the WebLogic Server password:
adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

USAGE: adstrtal.sh [-skipNM] [-skipAdmin] [-nothreading]
adstrtal.sh -secureapps [-skipNM] [-skipAdmin]
adstrtal.sh -nodbchk [-skipNM] [-skipAdmin]

adstrtal.sh: exiting with status 1

or 
adstpall.sh: exiting with status 1

[applmgr@ebs122 scripts]$ cd $APPL_TOP
[applmgr@ebs122 appl]$ pwd
/apps01/applmgr/TEST/fs1/EBSapps/appl

[applmgr@ebs122 appl]$ cd $APPL_TOP
[applmgr@ebs122 appl]$ . ./APPSTEST_ebs122.env
[applmgr@ebs122 appl]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebs122 scripts]$ adstrtal.sh
You are running adstpall.sh version 120.22.12020000.5
Enter the APPS username: apps
Enter the APPS password:
Enter the WebLogic Server password:
The logfile for this session is located at /apps01/applmgr/TEST/fs1/inst/apps/TEST_ebs122/logs/appl/admin/log/adstrtal.log

How to Resend OPEN, CANCELLED Workflow Notification mails

How to Resend OPEN, CANCELLED Workflow Notification mails

• Many notification mailers stuck in the mailer queue (status=’OPEN’ and mail_status=’MAIL’)
• SQL> select count(*) from wf_notifications where status=’OPEN’ and mail_status=’MAIL’;
• select notification_id, status, mail_status, subject, from_user, begin_date from WF_NOTIFICATIONS where status = ‘OPEN’ and mail_status = ‘MAIL’;
• Oracle Workflows notifications cannot be sent due to mail server problems, network problems
• We can resend the notifications by doing the following:
• 1) stop workflow mailer
• 2) cd $FND_TOP/patch/115/sql
• 3) sqlplus APPS/<pwd> @wfntfqup.sql APPS <pwd> APPLSYS
• 4) start workflow mailer and monitor the queue

RECREATE TEMP TABLESPACE

--Create Temporary Tablespace Temp2 /dba0A/oradata/R12D1/
CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE 
'/dba0A/oradata/R12D1/temp15.dbf' SIZE 50M;

--Move Default Database temp tablespace
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

--Drop temp tablespace
DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

--Recreate Tablespace Temp
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 
'/dba0A/oradata/R12D1/temp01.dbf' SIZE 10GB;

--Move Tablespace Temp, back to new temp tablespace
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

--Drop temporary for tablespace temp
DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;



If it takes too long

use this to identify queries holding it up.

SELECT b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,
a.username,a.osuser, a.status
FROM v$session a,v$sort_usage b
WHERE a.saddr = b.session_addr;

and then

ALTER SYSTEM KILL SESSION 'sid,serial#';

How to find files that contains a word in Linux

Run this on the directory you want to search in. In this example we are looking for files that contain the word artesyn.

find . -type f -exec grep "artesyn" '{}' \; -print