Skip to main content

Posts

Showing posts from November, 2018

Configuring VMWARE snapshot backups for Oracle databases.

Oracle databases require 'begin backup mode' to freeze datafile headers and consistency of backups. VEEAM is backup, replication and restore solution for Virtual machines. We will consider understanding steps involved in running veeam backups for live Oracle database vm machines. We will start with VMWARE tools installation steps (if not already installed). This will be done on vmware host machine. Prepare your virtual machine to install VMware Tools. Choose VM > Install VMware Tools. Logon to Linux as root - [root@clone ~]# mount /dev/cdrom /mnt/cdrom mount: block device /dev/cdrom is write-protected, mounting read-only [root@clone ~]# cd /tmp [root@clone tmp]# tar zxpf /mnt/cdrom/VMwareTools-9.0.0-782409.tar.gz [root@clone tmp]# [root@clone tmp]# Install vmware tools on virtual machine - [root@clone tmp]# cd vmware-tools-distrib [root@clone vmware-tools-distrib]# ls -ltr total 272 drwxr-xr-x 14 root root   4096 Jul 14  2012 lib drwxr-xr-x  2 ro...

Query to fetch Function assigned to which responsibility

1. Check for which function needs to be assigned to which responsibility. 2. Check for responsibility's menu sytem administrator-> Secutiry -> responsibilty -> Define 3. Search for responsiblity (% Inventory User) 4. Get default Menu name and search for that menu System Administrator -> Application->Menu 5.Once you get Function name, go for function short name as follows - System Administrator -> Application->Function Enter Function Short code for below query SELECT frtl.responsibility_name,        fr.responsibility_key,        fm.menu_id,        fm.menu_name,        menu.function_id,        menu.prompt,        menu.grant_flag,        fffv.user_function_name,        fffv.function_name,      ...