OraMatt: YABAOracle

Here’s a quick, simple little script to create a bunch of new PDBs in the 12c Multitenant architecture.

Enjoy!
Matt

#!/bin/bash -x

export ORACLE_BASE=/u01/app
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export ORACLE_UNQNAME=cloud
export ORACLE_SID=cloud

for i in {1..256}  
do
echo "---------------------------------------" 
echo "           Run number" ${i}
echo "---------------------------------------"
sqlplus "/ as sysdba" <<EOF
CREATE PLUGGABLE DATABASE PDB_${i} ADMIN USER MATT IDENTIFIED BY *ROLES=(CONNECT)  FILE_NAME_CONVERT=NONE;
exit;
EOF

sqlplus "sys/oracle12c@brutus:1521/PDB_${i} as sysdba" <<EOF
ALTER database PDB_${i} open;
exit;
EOF
#sleep 3
done