MassExecuteSQL

I have some standard SQL that I want to run against multiple databases on a single server to help me report informations or diagnose problems. This script intended for Oracle DBA, executes an sql statement on all Oracle 18c databases running on a Unix server. First example:       On all databases. Second example: On […]

crontab examples

* * * * * command to be executed – – – – – | | | | | | | | | +—– day of week (0 – 6) (Sunday=0) | | | +———- month (1 – 12) | | +————— day of month (1 – 31) | +——————– hour (0 – 23) +————————- […]

oracle.xml

########################################################### # Creator: Cyrille Modiano # Created: 2011/24/02 # Compatible: Solaris update 6 and higher ########################################################### # # An example of SMF file: Service Management Facility # Replacement of /etc/init.d/oracle file for Solaris 10 Update 6 and higher # Folder: /var/svc/manifest/application/database # Variables to change: user, exec # ###########################################################

Move db to another host (scp, rename)

REM ################################################ REM # Creator: Didier Vince REM # Created: 2009/10/01 REM # Name: MoveDB.sql REM ################################################ REM # REM # Compatible: Oracle 9i 10g 11g REM # REM ################################################ REM # REM # Move DB to a new machine REM # 1:  creates scp commands for all the db files (but no init, spfile) […]

cpu_apply_Mass.sh

#!/usr/bin/ksh # SCRIPT: cpu_apply_Mass.sh ################################################ # Creator: Yoann Mainguy # Update: Vincent Fenoll # Created: 2009/01/01 # Compatible: 10g 11g ################################################ # # Apply cpu patch on several Oracle databases # using a for loop # ################################################ for NO_SID in SID1 SID2 SID3 do export ORACLE_SID=$NO_SID export ORAENV_ASK=NO . oraenv echo  » set echo off […]