SQL Server Setup does not have one or all of the following rights

You don't have the correct rights

Do the following

1. Goto Computer Management>Local users and groups>groups
2. Add your user to

• Backup Operators
• Debug Programs
• Distributed COM user
• Generate Security Audits

Then try to run setup again

Recover a Broken DR

Situation scooter is a DR of wheels. Scooter lost a whole /dba0c mount point which included a lot of db files and controlfile.


As far as i can recall what I did was.

1. Shutdown scooter
2. Copy pfile from wheels to scooter /dbs
3. startup nomount wheels with pfile from wheels
4. connect to rman
'rman  target sys/password@ORAP_STBY  auxiliary  sys/password@ORAP'
5.




 DUPLICATE TARGET DATABASE
  FOR STANDBY
  FROM ACTIVE DATABASE
  NOFILENAMECHECK;

6. RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

7. --Checking Logs

select max(sequence#) from v$archived_log where applied='YES';

select sequence# from v$archived_log where applied='NO';

select SEQUENCE#,DELAY_MINS,STATUS,PROCESS FROM v$managed_standby;

select 'ALTER DATABASE DATAFILE '||''''|| file_name ||''''||' AUTOEXTEND OFF;' FROM DBA_DATA_FILES WHERE tablespace_name='APPS_TS_MEDIA';

ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA01.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA02.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA03.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA04.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA05.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA06.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA07.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA08.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA09.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA10.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA11.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA12.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA13.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA14.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA15.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA16.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA17.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA18.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA19.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA20.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA21.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA22.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA23.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA24.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA25.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA26.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA27.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA28.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA29.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA30.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA31.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA32.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA33.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA34.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA35.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA36.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA37.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA38.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA39.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA40.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA41.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA42.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA43.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA44.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA45.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA46.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA47.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA48.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA49.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA50.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA51.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA52.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA53.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA54.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA55.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA56.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA57.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA58.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA59.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA60.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA61.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA62.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA63.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA64.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA65.dbf' AUTOEXTEND OFF;
ALTER DATABASE DATAFILE '/dba0C/oradata/ORAP/APPS_TS_MEDIA66.dbf' AUTOEXTEND OFF;

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