Here’s a quick and simple script to help migrate a database over to Automatic Storage Management (ASM). The script implements the Oracle Documentation found here: You can download the script from GitHub here: [code language=”bash”] #!/bin/bash #=============================================================================================================== #…
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…
For those who don’t know what DBFS (DataBase FileSystem) is, here’s a little snippet: The Oracle Database File System (DBFS) enables the database to be used as a POSIX-compatible file system on Linux. This feature includes a PL/SQL package on…
Thought I’d share some VBox goodness. Adding additional disks to VBox is simple with the following scripts From the VBox host: [sourcecode language=”bash”] #!/bin/bash # # Add ASM storage to a VBox Image # echo "How many ASM disks would…