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

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Author: Syed Saad Ali

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]
October 5, 2017 Office 365 ProPlus Certified with EBS 12.1 and 12.2
NEWS AND UPDATES

Office 365 ProPlus Certified with EBS 12.1 and 12.2

By: Steven Chan| Senior Director

Microsoft Office 365 ProPlus versions of Excel, Word, and Outlook are certified with Oracle E-Business Suite 12.1 and 12.2. See:

This certification includes 32-bit and 64-bit versions of Office 365 ProPlus running on Windows 10, 8.1, and 7.

What is Office 365 ProPlus?

Office 365 ProPlus is a version of Microsoft Office that’s available through Office 365. It includes Word, Excel, Outlook, PowerPoint, Access, OneNote, Publisher, and Skype for Business as well as online services such as Sway and Power Query.

Office 365 ProPlus is installed on the user’s local computer using a streaming and virtualization technology called Click-to-Run. Office 365 ProPlus is not a web-based version of Office. It runs locally on the user’s computer. Users don’t need to be connected to the Internet all the time to use it.

What is not covered by this certification?

EBS 12.1 and 12.2 are certified with the Office 365 ProPlus versions of Excel, Word, and Outlook.

The following Office 365 ProPlus products are not certified with EBS 12.1 or 12.2:

  • Office on iPad and Android devices
  • Office Online browser-based versions of Excel and Word
  • PowerPoint, Access, OneNote, Publisher, and Skype for Business
  • Online services such as Sway and Power Query

Click-to-Run delivers monthly updates to Office 365 ProPlus

By default, Click-to-Run products are configured to be updated automatically every month. Users don’t have to download or install updates. The Click-to-Run product seamlessly updates itself in the background.

Microsoft also offers a semi-annual channel for updates in January and July, as well as a targeted semi-annual channel in March and September.

Certification with Click-to-Run updates

Oracle certified EBS 12.1 and 12.2 in September 2017 with the latest available versions of Excel, Word, and Outlook in Office 365 ProPlus at the time.

Microsoft’s updates to Office 365 ProPlus are intended to be backwards-compatible. This means that Oracle’s certification with the September 2017 baseline should continue to apply to Microsoft updates in October 2017, November 2017, and so on.

It is unlikely that Oracle will be able to certify all monthly Office 365 ProPlus updates with all EBS 12.1 and 12.2 updates. Given Microsoft’s stance towards backwards-compatibility, this is theoretically unnecessary.

It is expected that Oracle will continue to certify selected updates to Office 365 ProPlus versions of Excel, Word, and Outlook with updates to EBS 12.1 and 12.2.

Source: https://blogs.oracle.com/stevenchan/office-365-proplus-certified-with-ebs-121-and-122