TechExuberance

References- 1.     Creating Duplicate database in RMAN using password-mode encrypted backups (Doc ID 464832.1) Objective – 1.     RMAN backups on NAS are at risk and can be copied easily on intranet. 2.     They can be restored, and critical information can be fetched easily. 3.     Encryption of these backups is need of the hour. 4.     Need to find a simple yet reliable solution to solve this security breach. Security risk Proposed Solution – RMAN backups are now password protected and we are safe even if backup files are stolen. This feature of Oracle will stop hackers restore our backup files and will ask for a password before restoring onto any other server. Real-time sample Use-case Complete level-0 backup taken on Friday as highlighted – post estimation for s3 storage ...

References- 1.     Customizing Keymapping and Resource Files for Forms on the Web -fmrweb.res, fmrpcweb.res (Doc ID 1367967.1) Objective – 1.     One of the customer’s requirement is to change shortcut keys when using Oracle forms 2.     Typical example is using shortcut key “F10” instead of traditional “Ctrl+s” for saving/committing changes done in a form. 3.     This document applies to all version of Forms on the web from Forms 6i through Forms 11g. 4.     File fmrpcweb.res is something that needs to be studied and understood before modifying. Understanding file fmrweb.res Location – typical ebs r12 environment /data/prod/apps12/apps/tech_st/10.1.2/forms/admin/resource/US For 10gR2 (forms version) UNIX -> ORACLE_HOME/forms/admin/resource/<country>/fmrweb.res Windows -> ORACLE_HOME\forms\fmrweb.res FMRWEB.RES is the key definition file for webforms. It foll...

About this Document Background This document covers overview of SCAN and troubleshooting listener issues. It also covers relation implications of running autoconfig on SCAN listeners. Intended Audience This document is primarily meant for database administrators, system administrators, Team Leaders, Technical Managers, etc. References SCAN Registration Issue: Services Fail to Register to SCAN Listeners (Doc ID 1448717.1 Bug 12946495: SERVICES FAIL TO REGISTER TO ALL SCAN LISTENERS 12.13 RAC Setup, Why Scan IPs Are Generated Instead of Scan Name In tnsnames.ora (Doc ID 2141287.1) Assumptions We are considering ebs environment with minimum base version of database as 11gr2 (11.2.0.1) and onwards. Understanding SCAN and complications with ebs r12 SCAN was introduced by Oracle starting from 11gr2 and stands for Single Client Access Name. Oracle introduced this new feature in a RAC environment to overcome challenge of changing client-side connec...