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:<\/p>\n
Install grid-software with option “software only”<\/p>\n
Run the roothas.pl script from Grid_home using the following syntax:<\/p>\n
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\/roothas.pl<\/p>\n
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<\/p>\n
orapwd file=$ORACLE_HOME\/dbs\/orapw+ASM password=Password123 entries=5<\/p>\n
mkdir -p $ORACLE_BASE\/admin\/+ASM
\ncd $ORACLE_BASE\/admin\/+ASM
\nmkdir bdump
\nmkdir udump
\nmkdir cdump
\nmkdir pfile<\/p>\n
init+ASM.ora:
\n*.asm_power_limit=1
\n*.diagnostic_dest=’\/app\/oracle’
\n*.instance_type=’asm’
\n*.large_pool_size=12M
\n*.remote_login_passwordfile=’EXCLUSIVE’<\/p>\n
srvctl add listener
\nsrvctl start listener
\nsrvctl add asm -l LISTENER -p $ORACLE_HOME\/dbs\/init+ASM.ora -d ‘\/dev\/rdsk\/*’<\/p>\n
# disks
\nchown oracle:oinstall \/dev\/rdsk\/c9t2d0s0
\nchown oracle:oinstall \/dev\/rdsk\/c9t3d0s0
\nchown oracle:oinstall \/dev\/rdsk\/c9t4d0s0
\nchmod 660 \/dev\/rdsk\/c9t2d0s0
\nchmod 660 \/dev\/rdsk\/c9t3d0s0
\nchmod 660 \/dev\/rdsk\/c9t4d0s0
\nasmcmd> lsdsk –discovery
\nasmcmd> lsdsk
\nasmcmd> mount DATA<\/p>\n
alter system set asm_diskgroups=’DATA’ scope=spfile;<\/p>\n
create pfile with “SPFILE=+DATA\/DB\/spfiledb.ora”
\nmkdir -p \/app\/oracle\/admin\/DB\/adump
\nsrvctl add database -d DB -o \/app\/oracle\/product\/11.2.0\/dbhome_1<\/p>\n","protected":false},"excerpt":{"rendered":"
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 … Continue reading Install new database host and reuse existing ASM database…<\/span>