Alex, Thanks for the "hints"; I look at these as diagnostic hints, not subject to the same limitation of guessing as say, problem resolution. *grin* To that end, I am finding that I am easily overwhelmed by all the diagnostics. What am I looking for? It seems to me that my Oracle Support Analyst should setup an OWC and step through these diagnostics with me, pointing out what I need to look for so we can both find the problem together, and from there discover (not guess) a resolution. When I use srvctl remove asm, what modules of CRS touched? Or rather, what modules do I need to turn tracing on to get the whole picture? I can see how the CRSOCR module would be relevant, but what about the CRSRES? Any more? I have used SRVM_TRACE, but again, not knowing what I am looking for, I did not discover much. Looks like crs_unregister returns an error, but I am not sure why. Yet. I will keep hitchhiking along this road. Thanks for all the feedback, from all of you. On 7/24/07, Alex Gorbachev <ag@xxxxxxxxxxxx> wrote:
Charles, When you look for the logs - you should look for the logs in Oracle Home (where srvctl is running from) and in CRS home (since OCR updates are done by crsd). Just in case it was missed. Btw, you want to make sure that you run srvctl from Oracle Home and not CRS Home and, perhaps, even from ASM Oracle Home if you installed it separately. I guess all this can be marked as done already anyway. I think I might have few more guesses that would qualify for hints ;-) unless there would be no way to debug it so I try to give some hints how to debug it. There is tracing facility that is interfaced by crsctl. I would try to look at tracing CRSOCR and CRSRES modules: $ORA_CRS_HOME/bin/crsctl log crs CRSOCR:255,CRSRES:255 I'm not sure about trace levels you need. Default should be 0 if I recall correctly. If you don't find anything useful - try other modules (use crsctl lsmodules crs). Even before doing that you might want to enable tracing/debug in srvctl that you call from oracle home - it's a shell script and there are couple variables that you might want to research - ORA_CRSDEBUG and SRVM_TRACE If you find anything interesting - let us know. Cheers, Alex On 7/24/07, Charles Schultz <sacrophyte@xxxxxxxxx> wrote: > I posed this question over at the oracle ASM forum as well. > > We are trying to wipe out ASM. We have been trying to follow a couple > metalink notes, and threads both here and in oracle-l, not to mention > reading some books (K Gopal and Julian Dyke). Google is not giving us much > help, either. > > We had a couple RAC databases, but those have already been removed, and the > shared ASM disks have been wiped clean (with dd). We have not touched the > OCR or voting disks directly at all, only via srvctl and the crs commands. I > have removed as many dependencies as I can think of (entry in oratab, > running processes, ?dump directories). > > Oracle EE 10.2.0.3 running on RHEL4. Below are a series of commands we have > used. I attempted to find the "CRS daemon log file", but it is not updated > with any relevant information. The ocssd log file has some interesting > stuff, but nothing that leads me to a solution. > > > <urbdb1> /u01/app/oracle: srvctl remove asm -n urbdb1 > PRKS-1033 : Failed to remove configuration for ASM instance "+ASM1" on node > "urbdb1" from cluster registry, > > [PRKS-1023 : Failed to remove CRS resource for ASM instance "+ASM1" on node > "urbdb1", > [CRS-0214: Could not unregister resource 'ora.urbdb1.ASM1.asm'.]] > [PRKS-1023 : Failed to remove CRS resource for ASM instance "+ASM1" on node > "urbdb1", > > [CRS-0214: Could not unregister resource 'ora.urbdb1.ASM1.asm'.]] > <urbdb1> /u01/app/oracle: crs_unregister ora.urbdb1.ASM1.asm > CRS-0214: Could not unregister resource 'ora.urbdb1.ASM1.asm'. > > <urbdb1> /u01/app/oracle: oerr crs 214 > 214, 0, "Could not unregister resource '%s'." > // *Cause: There was an internal error while unregistering the resource. > // *Action: Check the CRS daemon log file. > > <urbdb1> /u01/app/oracle: find . -type f -mmin -1 -exec ls -alt {} \; > -rw-r----- 1 oracle oinstall 183445 Jul 24 09:29 > ./product/crs/cv/log/cvutrace.log.0 > -rw-r--r-- 1 oracle oinstall 7072151 Jul 24 09:29 > ./product/crs/log/urbdb1/cssd/ocssd.log > > -rw-r--r-- 1 oracle oinstall 186 Jul 24 09:29 > ./product/crs/log/urbdb1/client/css4348.log > -rw-r--r-- 1 oracle oinstall 809409 Jul 24 09:29 > ./product/asm/network/log/listener.log > -rw-r----- 1 oracle oinstall 9292901 Jul 24 09:29 > ./product/agent10g/network/log/sqlnet.log > > > As always, I am hoping the answer to this trickiness is easy and staring me > in the face. =) > > -- > Charles Schultz -- Alex Gorbachev, Oracle DBA Brewer, The Pythian Group http://www.pythian.com/blogs/author/alex http://www.oracloid.com BAAG party - www.BattleAgainstAnyGuess.com
-- Charles Schultz