No question at this time
DBA Top 10
1 M. Cadot 10000
2 B. Vroman 7600
3 A. Kavsek 3900
4 J. PĂ©ran 1500
5 P. Wisse 1300
6 T. Boles 600
6 D. Johnson 600
8 D. Dave 400
9 S. Spb 300
9 J. Schnackenberg 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48635
Total active users1396
Act. users last 24h0
Act. users last hour0
Registered user hits last week161
Registered user hits last month583
Go up

Changing hostname in OCR
Next thread: urgent problem with sysdate
Prev thread: How do I manipulate part of a column values

Message Score Author Date
Hi I have a single instance DB using ASM and i'...... marquesa Mar 31, 2007, 09:08
you can try to recreat the ocr key: $ORACLE_HOM...... Score: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 Pts Freek D'Hooge Mar 31, 2007, 15:18

Follow up by mail Click here


Subject: Changing hostname in OCR
Author: marquesa , Portugal
Date: Mar 31, 2007, 09:08, 5286 days ago
Os info: HP 11.23
Oracle info: Oracle10g R2
Message: Hi

I have a single instance DB using ASM and i've moved this DB to a different machine. After the migration the line in /etc/inittab '/sbin/init.d/init.cssd' doesn't run anymore. I did some troubleshooting and i noticed that the script stops geting the nodename.

Since in OCR i have the old hostname, the CSSD daemon doesn't run anymore.

How can i change the OCR file to put my new hostname and can boot CSSD daemon?

Thanks
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Changing hostname in OCR
Author: Freek D'Hooge, Belgium
Date: Mar 31, 2007, 15:18, 5286 days ago
Score:   Score: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 Pts
Message: you can try to recreat the ocr key:

$ORACLE_HOME/bin/localconfig reset $ORACLE_HOME

I have done this for a 10gR1 database, to restore a cluster database to a single node using asm:

[root@uc4dbsrva localhost]# echo $ORACLE_HOME
/opt/oracle/product/10.1.0/db
[root@uc4dbsrva localhost]# $ORACLE_HOME/bin/localconfig reset $ORACLE_HOME
\nThe following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /opt/oracle/product/10.1.0/db
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
uc4dbsrva
CSS is active on all nodes.
Oracle CSS service is installed and running under init(1M)


regards

Freek
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here