|
Replies:
6
-
Pages:
1
-
Last Post:
Mar 1, 2008 2:05 AM
Last Post By: Rajak
|
|
|
Posts:
16
Registered:
01/18/07
|
|
|
|
After successful installation clusterware mountpoint is corrupted bothnodes
Posted:
Feb 23, 2008 4:19 AM
|
|
|
|
Hi,
I successfully installed oracle 10g RAC on Sun solaris 10 on QFS mountpoint.
node1: having 2 local mountpoints "/oracle" and "/crsapp"
and
node2: having 2 local mountpoints "/oracle" and "/crsapp"
ocr, voting disks and database is on "QFS" file system.
Clusterware software is installed on "/crsapp" mountpoint and
oracle software is installed on "/oracle" mountpoint.
clusterware and oracle versions are 10.2.0.2.
"/oracle" and "/crsapp" mountpoints in both the nodes (node1 and nod2) are corrupted.
all the files in these mountpoints are deleted.
but i am having ocr and voting disks and datafiles on QFS, which are not corrupted.
How can I overcome this situation?
whether I need to install entire thing again?
before installing whether I need to delete or remove some files?
(for installation of CRS and oracle software)
how can I register the database which is already available in QFS mountpoint?
|
|
|
Posts:
1,301
Registered:
06/04/06
|
|
|
|
Re: After successful installation clusterware mountpoint is corrupted bothn
Posted:
Feb 23, 2008 9:21 AM
in response to: Rajak
|
|
|
|
The only option seems like you have to reinstall the CRS software, and during that process you will have to overwrite the existing voting devices and OCR. You can take a backup of OCR and restore it once you have a functional CRS. You also need to reinstall the RAC RDBMS as well.
You may have to clean up some config files under /etc ....follow instructions in ML Note:239998.1
To add the existing databases to the OCR, use srvctl add database -d <db_name>, use srvctl add database -h for the exact syntax.
HTH
Thanks
-Chandra Pabba
|
|
|
Posts:
85
Registered:
03/28/01
|
|
|
|
Re: After successful installation clusterware mountpoint is corrupted bothn
Posted:
Feb 25, 2008 3:51 AM
in response to: ChandraP
|
|
|
|
You do not have to go through the whoel installation process.
If you just want to recreate the ocr and voting disks in the same location, because they got corrupted (and you do not have a backup), you can simple rerun root.sh (after wiping ocr and voting with dd) from the nodes in serial order (one after the other). This will reformat the OCR and the voting disk.
After that continue as Chandra has described.
Message was edited by:
ssolbach
|
|
|
Posts:
1,301
Registered:
06/04/06
|
|
|
|
Re: After successful installation clusterware mountpoint is corrupted bothn
Posted:
Feb 25, 2008 4:58 AM
in response to: ssolbach
|
|
|
You do not have to go through the whoel installation process.
I thought the OP was mentioning about a corrupted CRS and RAC RDBMS home, not sure how would you restore the CRS home without a backup and without going through the whole install process. Not sure, if I got the original question wrong!
Thanks
-Chandra
|
|
|
Posts:
213
Registered:
01/10/01
|
|
|
|
Re: After successful installation clusterware mountpoint is corrupted bothn
Posted:
Feb 25, 2008 11:28 AM
in response to: ssolbach
|
|
|
|
Hello,
while I agree with Chandra that the original problem was a corrupted Clusterware (DB) home and not the re-creation of corrupted Voting Disks or OCRs, I would like to remind us all that the re-run of the root.sh after a successfull installation is strongly discouraged. Please, refer to ML 220970.1 (Public RAC FAQ), where it says:
Is it supported to rerun root.sh from the Oracle Clusterware installation ?
Rerunning root.sh after the initial successful install of the Oracle Clusterware is expressly discouraged and unsupported. We strongly recommend not doing it.
In case where root.sh is failing to execute for the on an initial install (or a new node joining an existing cluster), it is OK to re-run root.sh after the cause of the failure is corrected (permissions, paths, etc.). In this case, please run rootdelete.sh to undo the local effects of root.sh before re-running root.sh.
Concluding, to recover from an entire loss of the OCRs and Voting Disks, please, take backups as described in the Oracle Clusterware Administration and Deployment guide.
If your Voting Disks and OCRs are corrupted after the initial install, you may want to find the root cause rather than just re-creating them.
Anyways, for the original problem, I would agree with Chandra's earlier post.
Thanks.
|
|
|
Posts:
85
Registered:
03/28/01
|
|
|
|
Re: After successful installation clusterware mountpoint is corrupted bothn
Posted:
Feb 26, 2008 4:10 AM
in response to: ChandraP
|
|
|
|
Yes Chandra you are totally right. (I got it wrong)... I don't know why I read just OCR and Voting Disk got corrupted...
And furthermore as Markus explained rerunning root.sh is unsupported.
|
|
|
Posts:
16
Registered:
01/18/07
|
|
|
|
Re: After successful installation clusterware mountpoint is corrupted bothn
Posted:
Mar 1, 2008 2:05 AM
in response to: ssolbach
|
|
|
|
Hi,
Thanks all.
I have done follwoing things.
For CRS
1-CRS is cleaned using note 239998.1 10g RAC: How to Clean Up After a Failed CRS Install (to clean privous installation )
2-Install CRS
3-Apply patch set 10.2.0.2
For RDMS
1-Install RDBMS software only and run netca to create listener
2-Apply patch set 10.2.0.2
Reconfigure existing database
recreate init file,password file bdump,udump, etc
after this steps I can able to start instances using SQLPLUS from both nodes
Readd resources to CRS
Run srvctl add command to add database and instance back
|
|
|
|
Legend
|
|
Guru : 2500
- 1000000
pts
|
|
Expert : 1000
- 2499
pts
|
|
Pro : 500
- 999
pts
|
|
Journeyman : 200
- 499
pts
|
|
Newbie : 0
- 199
pts
|
|
Oracle ACE Director
|
|
Oracle ACE Member
|
|
Oracle Employee ACE
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|