Posts

Showing posts from May, 2022

User open and grant permission as DBA

 CREATE USER SABUJ IDENTIFIED BY 123456; GRANT UNLIMITED TABLESPACE TO SABUJ ; GRANT CONNECT TO SABUJ; GRANT DBA TO SABUJ; COMMIT; host imp user/password@tnsname fromuser=SABUJ touser=SABUJ file=FC.DMP log=FC.log exp user/password@tnsname file=FC-%date%.dmp log=fc.log statistics=none

Logo change on Login page

Image
  <div style="text_align: center"> <img src="#APP_FILES#pran-logo.png" height="auto" width="100%" display="block" margin="0" auto> </div>

Backup Command

  full database backup: ================================================= run { allocate channel c1 type disk; backup as backupset format '/u01/app/oracle/rman_bk/df_%d_%s_%p' incremental level 0 database; backup as backupset format '/u01/app/oracle/rman_bk/ar_%d_%s_%p' archivelog all delete input; } differential incremental database backup: ================================================= run { allocate channel c1 type disk; backup as backupset format '/u01/app/oracle/rman_bk/df_%d_%s_%p' incremental level 1 database; backup as backupset format '/u01/app/oracle/rman_bk/ar_%d_%s_%p' archivelog all delete input; } cumulative incremental database backup: ================================================= run { allocate channel c1 type disk; backup as backupset format '/u01/app/oracle/rman_bk/df_%d_%s_%p' incremental level 1 cumulative database; backup as backupset format '/u01/app/oracle/rman_bk/ar_%d_%s_%p' archivelog all delete input; } e

Shortcut Key Row in IG

Image
  function( options ) {     //Tab and Shift-Tab will skip over cells that are read-only     options.defaultGridViewOptions = {           skipReadonlyCells: true       };            options.initActions = function( actions ) {                         //Action to focus on the Search Bar         actions.add( {             name: "focus",             label: "focus",             action: function( event, focusElement ) {                var ig$ = $(actions.context);                ig$.interactiveGrid("focus");                return true;                            }         });                  // Add a keyboard shortcut to Add a Row         actions.lookup( "row-add-row" ).shortcut = "Alt+A";         actions.update( "row-add-row" );                  // Add a keyboard shortcut to Delete a Row         actions.lookup( "row-delete" ).shortcut = "Alt+D";         actions.update( "row-delete" );