...Reboot after moving shared ORACLE_HOME in ocfsv2 to local ext3 fs in each node (by copying it). So now I have an ORACLE_HOME in each node.

Certainly, ocfsv1 was more stable. Our production database RAC 9r2 is in an ocfsv1 fs with no problems for years in a SLES8 SP3. If all seems all right we will migrate to SLES10 and RAC 10.2 in a few days, first development database, and after two or three weeks, the real database. Off course, with no ocfsv2.

________________________________

Jorge López Díaz
Técnico de Gestión Informática
Consejería de Sanidad

-> -----Mensaje original-----
-> De: Alexei_Roudnev [mailto:Alexei_Roudnev@(protected)]
-> Enviado el: miércoles, 28 de febrero de 2007 19:19
-> Para: LOPEZ DIAZ, JORGE; suse-oracle@(protected)
-> Asunto: Re: [suse-oracle] Unshare ORACLE_HOME
->
-> I saw simular problem in our (non Oracle) application, which have shared
-> ocfsv2home (it runs on cold cluster with mutual resources:
-> - node1 have resource A and is standby for resource B
-> - node2 have resource B and is standby for resource A
-> - app home is shared
-> ).
->
-> Once in a history, one of OCFS mounts became read-only (and I can't
-> confirm,
-> if it was because temporary IO delay or because
-> OCFS glitch). Fortunately, we use home to startup application only (not
-> used
-> when apps is running) so I just remounted OCFS.
->
-> It's all why I clarified OCFSv2 quality and reliability _can be used for
-> backups and non important things only_. I run tests with a heavy load,
-> and
-> got an indication of numerous problems (high CPU load, out of memory,
-> very
-> high sencitivity to IO delays and temporary errors, unrealistic 10 - 12
-> seconds timeouts, single heartbeat channel /not redundatd/, selffencing
-> here
-> and there), so we dropped an idea of keeping user's data on OCFS (and run
-> headtbeat cluster instead, pretty stable).
->
-> It's a bad thing after all, because OCFSv1 was extremely stable and well
-> suited for Oracle database )I think, they sacrified some syncronization
-> for
-> the stability, and it shown to be a right approach).
->
->
->
-> ----- Original Message -----
-> From: "LOPEZ DIAZ, JORGE" <jorge.lopez@(protected)>
-> To: <suse-oracle@(protected)>
-> Sent: Wednesday, February 28, 2007 4:09 AM
-> Subject: RE: [suse-oracle] Unshare ORACLE_HOME
->
->
-> After reboot each node ASM and databases are running ok.
->
-> ________________________________
->
->
->
-> Jorge López Díaz
-> Técnico de Gestión Informática
-> Consejería de Sanidad
->
->
-> -> -----Mensaje original-----
-> -> De: LOPEZ DIAZ, JORGE [mailto:jorge.lopez@(protected)]
-> -> Enviado el: miércoles, 28 de febrero de 2007 10:04
-> -> Para: Alexei_Roudnev; suse-oracle@(protected)
-> -> Asunto: RE: [suse-oracle] Unshare ORACLE_HOME
-> ->
-> -> I created a local partition, copy $ORACLE_HOME on it, and mounted it
-> -> under $ORACLE_HOME (unmounting first ocfs2 fs, off course), but ASM
-> -> didn't start.
-> -> Remember I can't startup database because ocfs fs is in read-only mode
-> -> and I can't change it.
-> ->
-> -> "srvctl start asm -n node1" says:
-> ->
-> -> PRKS-1009 : Failed to start ASM instance "+ASM1" on node "node1",
-> [PRKS-
-> -> 1009 : Failed to start ASM instance "+ASM1" on node "node1", [CRS-
-> 1028:
-> -> Dependency analysis failed because of:
-> -> CRS-0223: Resource 'ora.node1.ASM1.asm' has placement error.]]
-> ->  [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "node1",
-> -> [CRS-1028: Dependency analysis failed because of:
-> -> CRS-0223: Resource 'ora.node1.ASM1.asm' has placement error.]]
-> ->
-> -> And "srvctl start nodeapps -n node1":
-> ->
-> -> CRS-1028: Dependency analysis failed because of:
-> -> CRS-0223: Resource 'ora.node1.LISTENER_NODE1.lsnr' has placement
-> error.
-> ->
-> -> Clusterware is ok, "crsctl check crs":
-> ->
-> -> CSS appears healthy
-> -> CRS appears healthy
-> -> EVM appears healthy
-> ->
-> -> Same in both nodes.
-> ->
-> -> Any suggestion?
-> ->
-> -> I'm thinking to reinstall RAC databasae software in local
-> ORACLE_HOME's
-> -> and try to reuse definitions and database files from asm disk groups
-> (I
-> -> have got former database imported, ready to go to production), if this
-> -> it's possible..
-> ->
-> -> ________________________________
-> ->
-> -> Jorge López Díaz
-> -> Técnico de Gestión Informática
-> -> Consejería de Sanidad
-> ->
-> ->
-> -> -> -----Mensaje original-----
-> -> -> De: Alexei_Roudnev [mailto:Alexei_Roudnev@(protected)]
-> -> -> Enviado el: martes, 27 de febrero de 2007 19:35
-> -> -> Para: LOPEZ DIAZ, JORGE; suse-oracle@(protected)
-> -> -> Asunto: Re: [suse-oracle] Unshare ORACLE_HOME
-> -> ->
-> -> -> If you have not database files there - why not? Just copy
-> oracle_home
-> -> -> onto
-> -> -> the local file systems, and set up symlink (so you even dont need
-> to
-> -> take
-> -> -> system offline).
-> -> ->
-> -> ->  (cd $ORACLE_HOME && tar cf - . ) (cd new_home && tar xf -)
-> -> ->  mv $ORACLE_HOME $ORACLE_HOME-;ln -s $new_home $ORACLE_HOME
-> -> ->
-> -> -> (restart database when you have a time to do it)
-> -> ->
-> -> -> The same with CRS.
-> -> ->
-> -> ->
-> -> -> ----- Original Message -----
-> -> -> From: "LOPEZ DIAZ, JORGE" <jorge.lopez@(protected)>
-> -> -> To: <suse-oracle@(protected)>
-> -> -> Sent: Tuesday, February 27, 2007 2:15 AM
-> -> -> Subject: [suse-oracle] Unshare ORACLE_HOME
-> -> ->
-> -> ->
-> -> ->
-> -> ->
-> -> ->  Is it possible to unshared ORACLE_HOME, each node with its own
-> -> -> ORACLE_HOME, so ocfs2 it's not needed anymore (I only use ocfs2 to
-> -> share
-> -> -> ORACLE_HOME)?
-> -> ->
-> -> ->
-> -> ->
-> -> -> Thanks.
-> -> ->
-> -> -> Jorge López Díaz
-> -> ->
-> -> -> Técnico de Sistemas
-> -> ->
-> -> -> Consejería de Sanidad de la Región de Murcia
-> -> ->
-> -> -> SPAIN
-> -> ->
-> -> ->
-> -> ->
-> ->
-> ->
-> -> --
-> -> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
-> -> For additional commands, email: suse-oracle-help@(protected)
-> -> Please see http://www.suse.com/oracle/ before posting
->
->
-> --
-> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
-> For additional commands, email: suse-oracle-help@(protected)
-> Please see http://www.suse.com/oracle/ before posting
->


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting