11gR2 oracle restart 单机使用asm存储 主机名发生更改并且主机重启后处理过程:

以下为解决方案

1. Remove Oracle Restart configuration

This step should be performed as privileged (root) user.ITPUB个人空间)\$g X\C{^
ITPUB个人空间U Q}e3l,v;Z
 
 
    
 
     # $GRID_HOME/crs/install/roothas.pl -deconfig -force 
    
 
    ITPUB个人空间8TnZno9q|-[!S&|j X
The expected result is "Successfully deconfigured Oracle Restart stack".ITPUB个人空间6^hn^ gk)q
 
    
2. Reconfigure Oracle RestartITPUB个人空间L[}:xD4VX R]
 
    This step should also be performed as privileged (root) user.
)z \Xec*xU5u0ITPUB个人空间$?7M7H#j8W
 
    
 
    
 
     # $GRID_HOME/crs/install/roothas.pl 
    
 
     
    
 
    
The expected result is "Successfully configured Oracle Grid Infrastructure for a Standalone "ITPUB个人空间uTr2q\JK dG
 
     
    
3. Add ASM back to Oracle Restart configuration
 
    This step should be performed as Grid Infrastructure owner (grid user).
PF!T)xl'oSV0ITPUB个人空间h,o kM!kv7P]
 
    
 
    
 
     $ srvctl add asm 
    
 
    
}1M&uj*h&L9jD0 
    
The expected result is no output, just a return to the operating system prompt.ITPUB个人空间,M1cv!m!x}'}"a$V)j-g]
 
     
    
4. Start up ASM instance
 
    This step should be performed as Grid Infrastructure owner (grid user).
JPVo!c$zf0ITPUB个人空间6K@Yib
 
    
 
     $ srvctl start asm 
    
 
    
4h$pT0\G6sXQ2P%V0That should start ASM. Note that at this time there will be no ASM initialization or server parameter file.
}Pt(^/tP0 
    
5. Recreate ASM server parameter file (SPFILE)
jl6bt3w0
 
    This step should be performed as Grid Infrastructure owner (grid user).
L7r"A$ga%V1b0ITPUB个人空间E*}6dZNjv6j$B
Create a temporary initialization parameter file (e.g. /tmp/init+ASM.ora) with the following content (specify your own disk group names):ITPUB个人空间kb[+CHki7dn)@
 
    
 
    
 
     asm_diskgroups='DATA','RECO'
N$|0pI/f0instance_type='asm'ITPUB个人空间u:mY'?!@YL.F BAj0f
large_pool_size=12MITPUB个人空间6K"}X.G yL?
remote_login_passwordfile='EXCLUSIVE' 
    
 
    ITPUB个人空间5{LUJ7G
Mount the disk group where the new server parameter file (SPFILE) will reside (e.g. ) and create SPFILE:
:]#|GJ_0 
    
 
    
 
     $ sqlplus / as sysasmITPUB个人空间2Uf&Xq#]R,~Uc%n
ITPUB个人空间AJ|:uCj8\7W
SQL> alter diskgroup DATA mount;
SPN^.ua }0_0Diskgroup altered.ITPUB个人空间'S^&MkM"~/q'sC
ITPUB个人空间y/NT.c&V G.lc
SQL> create spfile='+DATA' from pfile='/tmp/init+ASM.ora';
}F"L,l'^}*y0I)O2p0File created.
Qu4iy!d#`F0
0R@Gk.c0SQL> show parameter spfileITPUB个人空间1L SY Y{ 
       
NAME TYPE VALUE
.^ok ~QDp.T0------- ------- -------------------------------------------------
4OQq${v9qT [n0spfile string +DATA/asm/asmparameterfile/registry.253.707737977 
    
 
    ITPUB个人空间1E,f{#b?%jaLd1p;T
 
    
6. Restart HAS stack
f5Ch%\[/|P(q0
 
     
    
 
     crsctl stop hasITPUB个人空间s}:pn$Bc.BK
crsctl start has 
    
 
    
Kq)F_s*C-e0 
    
7. Add components back to Oracle Restart Configuration
 
    If you had the database, listener and other components, add them back to the Oracle Restart Configuration.ITPUB个人空间(S*SG&B&KJ:y7e(_
 
    
7.1. Add database component
 
    This step should be performed as RDBMS owner (oracle user).ITPUB个人空间WBwBa/`+`A-U
ITPUB个人空间6Y~9D'nEZa(wOu
 
    
 
     srvctl add database -d <db_unique_name> -o <oracle_home> 
    
 
     
    
7.2. Add listener component
 
    This step should be performed as Grid Infrastructure owner (grid user).
(UZZ Ij,l_k0
Q?dMy3h:B?SQC0 
    
 
     srvctl add listener 
    
 
     
    
7.3. Add other components
 
    For information on how to add back additional components, please review:ITPUB个人空间H5h|;_1U"j w
Oracle Database Administrator's Guide Release 2 (11.2)ITPUB个人空间/B"C6o#qt+G
Chapter 4 Configuring Automatic Restart of an Oracle Database
y}/_(~h0Section Configuring Oracle Restart