Category bash

New and Improved(?) Oracle Init Script

Howdy y’all! I decided to add some additional features to my Oracle Init script. In this version I added Database Backup and Archive Log delete with RMAN as well as show status. Oh…and I included start/stop for Oracle Rest Data…

Improved Oracle INIT script

So….I was reviewing my INIT script that I posted here and I noticed there was no respect if a SID was marked as NO in I’ve adjusted the script to now respect the startup status setting in oratab!!! Enjoy!…

Import and Update Plug-ins with emcli – OEMCC 12c

Here’s a quick script to import downloaded plug-ins, if you are running in an off-line mode, into your OEMCC 12c system. Tested with 12.1.0.3 [code language=”bash”] #!/bin/bash #=============================================================================================================== # # FILE: emcli_install_plugins.sh # # USAGE: run it…requires a directory where…

12c Multitenant Database…make a bunch of PDBs

Here’s a quick, simple little script to create a bunch of new PDBs in the 12c Multitenant architecture. Enjoy! Matt [code language=”bash”] #!/bin/bash -x export ORACLE_BASE=/u01/app export ORACLE_HOME= export ORACLE_UNQNAME=cloud export ORACLE_SID=cloud for i in {1..256} do echo "—————————————" echo…

Copy files out of ASM

Here’s little script to help copy a file out of ASM..enjoy —————————————————————————— [sourcecode language=”bash”] #/bin/bash -x # Query to find file_names # select file_name from dba_data_files; export ORACLE_SID=+ASM export ORACLE_HOME=/u01/app/oracle/grid #ASM home export TIMESTAMP=`date +%m%d%y%H%M` export DBNAME=orcl export DISKGROUP=data export…

Quick Remote Diagnostics…

[sourcecode language=”bash”] #!/bin/bash #=============================================================================================================== # # FILE: quick_diag.sh # # USAGE: run it # # DESCRIPTION: try to diag system # OPTIONS: # REQUIREMENTS: # AUTHOR: Matt D # CREATED: 11.27.2012 # VERSION: 1.0 # EUL : THIS CODE IS…

Quick TDE demo

[sourcecode language=”bash”] #!/bin/bash #=============================================================================================================== # # FILE: TDE_Example # # USAGE: Run it… # # DESCRIPTION: # OPTIONS: # REQUIREMENTS: ASM or Oracle Managed Files # AUTHOR: Matt D # CREATED: 10.15.2012 # VERSION: 1.0 # EUL : THIS CODE…