Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Month: October 2017

October 6, 2017 Generating AWR Reports
Database ScriptsOracle Database Material

Generating AWR Reports

You can generate AWR reports by running SQL scripts, as described below :-

# Generating an AWR Report

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

 

# To generate an AWR report on a specific database instance:

@$ORACLE_HOME/rdbms/admin/awrrpti.sql

 

# To generate an AWR report in an Oracle RAC environment: 

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

 

#To generate an AWR report on a specific database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgrpti.sql

 

# To generate an AWR report for a particular SQL statement:

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

 

# To generate an AWR report for a particular SQL statement on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

 

#To generate an AWR Compare Periods report:

@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

 

# To generate an AWR Compare Periods report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

 

# To generate an AWR Compare Periods report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

 

# To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql

 

# To generate an ASH report:

@$ORACLE_HOME/rdbms/admin/ashrpt.sql

 

# To generate an ASH report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

# To generate an ASH report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

 

October 6, 2017 RMAN Backup Script for Windows
Uncategorized

RMAN Backup Script for Windows

Create Batch file named as rmanbackup.cmd and copy the below given script in that batch file.

set oracle_sid=orcl
rman target sys/passwd nocatalog cmdfile=’c:\app\rman\rmanbkp.cmd’ log=’c:\app\rman\bkp_log.log’

—————

–rmanbackup.cmd

run
{
allocate channel d1 type disk;
backup
tag whole_database_open
format ‘c:\app\archive\db_%t_%s_p%p’
database;
sql ‘alter system archive log current’;
sql ‘alter system archive log current’;
backup archivelog all
format ‘c:\app\archive\al_%t_%s_p%p’
delete all input;
delete noprompt obsolete;
backup current controlfile
tag =cf1
format ‘c:\app\archive\cf_%t_%s_p%p’;
}

 

 

October 6, 2017 Find and Delete Older Files in Linux
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Delete Older Files in Linux

 

Files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \;

 

Move files older than 25 hours

find /rman/arch/*.dbf -mmin +1500 -exec mv {} /rman/archbkp/ \;

 

List files older than 2hours

find /rman/arch/*.dbf -mmin +120 -exec ls -ltr {} \;

 

Delete files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec rm {} \;

 

Delete files older than 1 hours

find /rman/arch/*.dbf -mmin +60 -exec rm {} \;

 

 

October 5, 2017 Where Can I Find EBS 12.2.7 Documentation?
NEWS AND UPDATES
[et_pb_section][et_pb_row][et_pb_column type=”4_4″][et_pb_text]

Where Can I Find EBS 12.2.7 Documentation?

By: Steven Chan| Senior Director
EBS 12.2.7 is the latest update to E-Business Suite 12.2. It can be applied online — you do not need to take your EBS environment down to apply this update. Our online E-Business Suite Documentation Web Library always contains the latest versions of all of our guides, including our Installation Guides, Upgrade Guides, and Readme Notes: The following Roadmap Note is also a critical reference, since it is a master index of all official Notes for advanced topics that complement our guides in the Documentation Library: All EBS sysadmins should bookmark this Note.  The indexed Notes are essential for nearly all EBS installations.  Here are some examples:
  • Load-balancers and DMZs
  • Real Application Clusters for E-Business Suite
  • Upgrade Sizing and Best Practices
  • VM Templates
  • Customizing EBS 12.2
  • OA Framework Developer’s Guide
  • Backup and Recovery with Online Patching
  • Oracle Access Manager and Oracle Internet Directory integration
  • BPEL and SOA Suite 11g Integration
  • Workflow Mailer with Outlook and other cloud email servers
  • Recommended Browsers
  • JAR file signing
  • Upgrading the JDK for EBS servers
  • Encrypting the EBS database with Transparent Data Encryption (TDE)
  • Security Best Practices and FAQ
Source: https://blogs.oracle.com/stevenchan/where-can-i-find-ebs-1227-documentation
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

All Rights Reserved