ASM Flex Password | Computer Cluster

Please download to get full document.

View again

of 3
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Instruction manuals

Published:

Views: 7 | Pages: 3

Extension: PDF | Download: 0

Share
Related documents
Description
Real application cluster 12c need password file for ASM access as this is important aspect of FLEX asm.
Tags
Transcript
   Are you using Oracle 12c Flex ASM? If yes - do you have ASM password file bacup?! ober# $iale So, Okt 26 2014 22:56 %i#h a 12c  Standard ASM  &or a pre 12c 'rid Infras#ruc#ure( all ASM clients  connec# locally using Oracle Bequeath NT rotocol  &bypassing #hlis#ener process() *xa+ple fro+ a 2-node 12c S#andard ,lus#er wi#h S#andard ASM &O, clien#( SELECT s.inst_id, s.osuser, s.username, s.program, i.network_service_bannerFROM gvsession s, gvsession_connect_in!o i #ERE s.sid $ i.sid%&' s.inst_id $ i.inst_id%&' s.program (ike )crsd.bin*)%&' i.network_service_banner (ike )*+rotoco(*)OR'ER - / 0&ST_0' OS1SER 1SER&%ME +RO2R%M &ET OR3_SER40CE_%&&ER5555555555 555555 55555555 55555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555  root S-S crsd.bin@clstdb01.trivadis.com   6T&S 45478 Oracle Bequeath NT Protocol Adapter for Linu! ersion 1#.1.0.#.0 $ Production  9 root S-S crsd.bin@clstdb0#.trivadis.com   6T&S 45478 Oracle Bequeath NT Protocol Adapter for Linu! ersion 1#.1.0.#.0 $ Production  As you see in #he exa+ple above. in a non! le# ASM  environ+en# #he ASM password file generally does not  play an i+por#an# role for #he clus#and can be easily re-crea#ed)$u# #hings change wi#h Flex ASM))) $ecause #he ASM le#  ins#ance is no# always available on all clus#er nodes. #here is a chan$e  in #he way #hclien#s connec# #o ASM ins#ance)%i#h 12c Flex ASM all local clients  s#ill connec# #o ASM using #he Oracle $e/uea#h 0 ro#ocol &bypassing #he lis#ener process() 3owever. all r clients  connec# using #he ,4I 0 ro#ocol via a new ASM 5is#ener process &a new resource s#ar#ed on every 36$ node in a clus#er() For #hiarchi#ec#ure #o wor. #he ASM password file needs #o be placed in a dis group &shared s#orage( and #he dis group ASM co+pa#ibili#y&co+pa#ible)as+( need #o be se# #o a# leas# #he version 12)1)!)!)!) srvct( con!ig asm%SM :ome; <CRS :ome= Pass%ord file! &'()*+orap%A,-  %SM (istener; L0STE&ER%SM instance count; 7 luster A,- listener! A,-N/T1L,N(A,-  %i#h #he Flex ASM configura#ion #he ASM password file plays a su&stantial role  for #he clien# connec#ivi#y and is a critical cluster co%'onent  -which is no# #he case wi#h older releases &or 12c S#andard ASM() 7uring #he clus#er s#ar#. #he crsd(&in  process on all nodes &bu# #he O, %ri#er( connec# re+o#ely #o #he ASM Flex ins#ance) *xa+ple fro+ a 8-node S#andard ,lus#er wi#h Flex ASM &#he O, %ri#er is ac#ive on #hecldb!8)#rivadis)co+ clus#er node( SELECT s.inst_id, s.osuser, s.username, s.program, i.network_service_bannerFROM gvsession s, gvsession_connect_in!o i #ERE s.sid $ i.sid%&' s.inst_id $ i.inst_id%&' s.program (ike )crsd.bin*)%&' i.network_service_banner (ike )*+rotoco(*)OR'ER - / 0&ST_0' OS1SER 1SER&%ME +RO2R%M &ET OR3_SER40CE_%&&ER5555555555 555555 55555555 55555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555 > root S-S crsd.bin@cldb0.trivadis.com   6T&S 45478 Oracle Bequeath NT Protocol Ad for Linu! ersion 1#.1.0.#.0 $ Production  > root S-S crsd.bin@cldb0#.trivadis.com   6T&S 45478 TP+)P NT Protocol Adapter forLinu! ersion 1#.1.0.#.0 $ Production  > root S-S crsd.bin@cldb01.trivadis.com   6T&S 45478 TP+)P NT Protocol Adapter forLinu! ersion 1#.1.0.#.0 $ Production  > root S-S crsd.bin@cldb02.trivadis.com   6T&S 45478 TP+)P NT Protocol Adapter forLinu! ersion 1#.1.0.#.0 $ Production %ha# happens in#ernally during #he clus#er s#ar# ?7uring #he s#ar# #he crsd(&in  process on all nodes &bu# #he O, %ri#er(. will connec# re%otel)  #o #he ASM Flex ins#ance using a new ASM user  crsuser**as%*001  Are you using Oracle 12c Flex ASM? If yes - do you have ASM passwor...hp! #log.rivadis.co$ # ro#er#iale% archive 2&1' 1& 2( are-you-using...1 of )( 1& 2&1* 1&!1* +M  S?L= SELECT @ FROM vpw!i(e_users/1SER&%ME S-S' S-SO+ S-S%S S-S% S-S'2 S-S3M CO&_0'5555555555555555 55555 55555 55555 55555 55555 55555 5555555555S-S TR1E TR1E TR1E F%LSE F%LSE F%LSE A (,3,/(A,-001 T(3/ 4AL,/ T(3/ 4AL,/ 4AL,/ 4AL,/ 0 %SMS&M+ TR1E F%LSE F%LSE F%LSE F%LSE F%LSE AOR%CLE_AA TR1E F%LSE F%LSE F%LSE F%LSE F%LSE A he creden#ials are s#ored no# only in #he ASM password file. bu# also in #he O5 &Oracle 5ocal egis#ry() %i#h #he curren# i+ple+en#a#ion &versi12)1)!)2 plus S6 12)1)!)2)1( re-crea#ing #he ASM password file af#er a failure &e)g) re-crea#ing #he ASM dis group hos#ing #he password file( wil suffice #o recover #he sys#e+) here is curren#ly also no 'rocedure  #o re-crea#e #he creden#ials for #he crsuser99as+9!!1 user &ASM password well as O5 () In such a case. you will be able #o  start  #he clus#er onl)  on #he O+ -rite r node. on other   clus#er nodes during #he unsuccessful # s#ar# #he ora(stora$e  resource. you will see #he following errors repor#ed in #he ohasd9oraroo#agen#9roo#)#rc #race file 9A>5A59B 9;7;.7DAD@;kg!n.cBD>; kg!nRecordErr+riv; rec$9A>5A59B 9;7;.AABA ; de!au(t;99BAAA9; c(sCred'omC(ose; CredctG de(eted AG!dBA7edH9A9A>5A59B 9;7;.AABA@;kg!n.c>DBD; kg!nConnect9; !ai(ed to connect9A>5A59B 9;7;.AABA@;kg!n.c>DD; kg!nConnect; conn$6ni(89A>5A59B 9;7;.AABA@;kg!p.cBBH; kg!p0nitComp(ete9 :d($AG!dBA!>!!D conn$AG!dBA!AA ok$A9A>5A59B 9;7;.AABA@;kg!o.cH>; kg!o_kge9s(os error stack at kg!o%(AB; O(A$01015! invalid username+pass%ord6 lo7on denied  9A>5A59B 9;7;.B77@;kg!n.cB7B; kg!n2et&odeTIpe; !(ags$AGA9A>5A59B 9;7;.B77@;kg!n.cB7BH; kg!n2et&odeTIpe; ntIp$9A>5A59B 9;7;.B77@;kg!n.c>B>>; kg!nConnect9; kg!n2eteJ'ata !ai(ed9A>5A59B 9;7;.B77@;kg!n.c>BDA; kg!nConnect; srvr va(id9A>5A59B 9;7;.B77@;kg!n.cH9; kg!nConnect90nt; sIsasm$A env!(ags$AGA srvr!(ags$AG unam8crsuserasm001  password is &OT &1LL pstr$_ocr9A>5A59B 9;7;.B77@;kg!n.cB9; kg!nConnect90nt; :osts$9A>5A59B 9;7;.B77@;kg!n.cB7>; kg!nConnect90nt; cstr89*/,()PT)ON89T(AN,PO(TONN/TT)-/O3T8:0;9/<P)(/T)-/81;9LOA*BALAN/8ON;9A**(/,,L),T89A**(/,,89P(OTOOL8tcp;9=O,T810.10.0.15;9PO(T81>##;;;9ONN/T*ATA89,/( )/NA-/8&A,-;;; +onclusion In case you use a Flex ASM configura#ion. +ae sure #ha# you incorpora#e #he ASM password file in#o your 'rid Infras#ruc#ure bacup4recoverys#ra#egy. as i# canno# be si+ply re-crea#ed wi#h #he necessary creden#ials) he password file can be baced up wi#h #he following co++and %SMCM'=  p%cop? &'()*+orap%A,-   <ackup_Location=Korapw%SM_<timestamp= cop?in7 &'()*+orap%A,-   5= <ackup_Location=Korapw%SM_<timestamp= For #he res#ore use #he pwcopy ASM,M7 co++and &use #he --as+ para+e#er. especially if you change #he ASM password file loca#ion - #hecorresponding ,lus#erware resources will be upda#ed au#o+a#ically( %SMCM'=  p%cop?$$asm   <ackup_Location=Korapw%SM_<timestamp= &'()*+orap%A,-  copIing <ackup_Location=Korapw%SM_<timestamp= 5= &'()*+orap%A,-   An enhance+en# re/ues# &$ug 1:;<;2=; - 12,9ASM9>8 0**7 A %A@ O *-S*6 3* , *7*0IA5 FO , S6S* 99ASM9!!1 6Shas been already filed) %i#h #he fu#ure i+ple+en#a#ion #he ASM password file should be baced up au#o+a#ically. us# lie O, and vo#ing diss) .'date on 2014(12(0/ If you were forced #o re-crea#e #he ASM password file and do no# have a valid bacup of i#. #here is s#ill a way #o recover) @ou need #o find ou# fro clus#er configura#ion #he au#o+a#ically genera#ed password for #he user crsuser__asm_001 )Firs# of all. you need #o find ou# #he correc# pa#h #o #he creden#ial gridc(dbA;K N%SM crsctl quer? credmaint $path A,-+,elf +at: CredtIpe 0' %ttrs +A,-+,elf+1>b5::d5ca>f:2bf2e:0f0abf2#  userpass A create_time$9A> 5A5A D;>9;D, modi!I_time$9A> 5A5A D;>9;D, eGpiration_time$ &E4ER,bootstrap$ F%LSE %i#h #he correc# pa#h you can /uery #he user password gridc(dbA;K N%SM crsctl 7et credmaint $path  P= +A,-+,elf+1>b5::d5ca>f:2bf2e:0f0abf2#  P= $credt?pe userpass $id 0 $attr pass%d $local Are you using Oracle 12c Flex ASM? If yes - do you have ASM passwor...hp! #log.rivadis.co$ # ro#er#iale% archive 2&1' 1& 2( are-you-using...2 of )( 1& 2&1* 1&!1* +M  AmJtCg%DQ77:B2'CBgFv#(o>O:% B W0mqtCgA8Zj33h6GDC6gFvHlo4OhA B s#ring is in +y #es# environ+en# #he au#o+a#ically genera#ed password for #he user crsuser__asm_001 Cnowing #he correc# password allows you #o re-crea#e correc#ly #he user crsuser__asm_001  &af#er re-crea#ing #he ASM password() A# #he end doforge# #o gran# #he roles s)sas%  and s)sd&a  #o #he user crsuser__asm_001 ) re you using Oracle 12c Flex ASM? If yes - do you have ASM passwor...hp! #log.rivadis.co$ # ro#er#iale% archive 2&1' 1& 2( are-you-using...) of )( 1& 2&1* 1&!1* +M
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks