Install new database host and reuse existing ASM database…

My Database-Host was gone (don’t ask why…), but my database files are hosted by ASM (data diskgroup with 3 iSCSI disks), so i was able to install a new Solaris-Host and build up my database server with the existing ASM diskgroup and database in the following way:

Install grid-software with option “software only”

Run the script from Grid_home using the following syntax:

as root user: /app/11.2.0/grid/perl/bin/perl -I /app/11.2.0/grid/perl/lib -I /app/11.2.0/grid/crs/install /app/11.2.0/grid/crs/install/

as oracle user from the grid-home /app/11.2.0/grid/oui> ./runInstaller -updateNodeList ORACLE_HOME=/app/11.2.0/grid -defaultHomeName CLUSTER_NODES= CRS=TRUE

orapwd file=$ORACLE_HOME/dbs/orapw+ASM password=Password123 entries=5

mkdir -p $ORACLE_BASE/admin/+ASM
cd $ORACLE_BASE/admin/+ASM
mkdir bdump
mkdir udump
mkdir cdump
mkdir pfile


srvctl add listener
srvctl start listener
srvctl add asm -l LISTENER -p $ORACLE_HOME/dbs/init+ASM.ora -d ‘/dev/rdsk/*’

# disks
chown oracle:oinstall /dev/rdsk/c9t2d0s0
chown oracle:oinstall /dev/rdsk/c9t3d0s0
chown oracle:oinstall /dev/rdsk/c9t4d0s0
chmod 660 /dev/rdsk/c9t2d0s0
chmod 660 /dev/rdsk/c9t3d0s0
chmod 660 /dev/rdsk/c9t4d0s0
asmcmd> lsdsk –discovery
asmcmd> lsdsk
asmcmd> mount DATA

alter system set asm_diskgroups=’DATA’ scope=spfile;

create pfile with “SPFILE=+DATA/DB/spfiledb.ora”
mkdir -p /app/oracle/admin/DB/adump
srvctl add database -d DB -o /app/oracle/product/11.2.0/dbhome_1