[sourcecode language=”sql”] run { allocate channel sbt1 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate channel sbt2 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; CONFIGURE DEFAULT…
Category Script
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
Sometimes to have a funky time on the BASH shell you can run the below shell script [code language=”bash”] #!/bin/bash…
— Create ACFS filesystem on 12c Linux Exadata — 1. Create a volume in ASM ASMCMD [+] > volcreate -G…
— Enable Password-less SSH between Linux Servers Before using PSSH — In the Server (192.168.100.55) from where you want to…
Below is the Filesystem on our VM Filesystem Size Used Avail Use% Mounted on /dev/mapper/ol-root 18G 11G 7.0G 61% /…
Often when you have a Linux up and running you run out of space. I use VMware Fusion on my…
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
The below simple shell script will check all filesystems and create output file for only filesystems which are more than…
The Below Shell Script checks the Filesystem mount points and using AWK outputs all filesystem exceeding 90% space to a…
While installing Oracle 12c on Linux you can get this error. The solution is very easy just unset the ORA_CRS_HOME…
Script to check no. of cores being utilized by a process in linux. Save the script below as a shell…
Solution: This happens when you havea RAC setup and you are backing up the Snapshot of the controlfile to a…
1. On Server 1 (192.168.1.67) ssh-keygen -t rsa cd .ssh/ scp -r id_rsa.pub root@192.168.1.68:/root/.ssh/authorized_keys 2. On Server 2 (192.168.1.68) ssh-keygen…
The Exadata Smart Flash Cache is a great Performance optimizer. The contents of the flash cache can be read fro…
So you are an Oracle DBA and have got used to the luxury of BASH shell in nix systems. Where…
Create SSH User Equivalence Between 2 Servers Linux Lets say you have 2 servers : server1, server 2 and you…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
Very well explained article why Storage Snapshots are not the best way for backing up an Oracle database. http://www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html?utm_content=buffer67053&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer
1. Start XVNC11 on the Linux Server $ x11vnc -forever Add a line like x11vnc -forever to the end…
Install VSFTP RPM from the DVD media *Mount the Media and go to Directory cd /media rpm -ivh vsftpd-2.2.2-11.el6.x86_64.rpm Configure…
One of the best books I have read on any Oracle technology. Must read if you need to know practical…
Most of the times DBA’s need to edit blocks of PL/SQL or SQL scripts and perform some modifications. Notepad++ is…