Question
If you have SAP on Oracle, then do you have a standby database?
Yes, SAP with physical standby
Yes, SAP with logical standby
Yes, SAP with physical and logical standby
No standby database for SAP
No SAP running
No idea or not applicable
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 52 now available
Jul 12, 2010
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 M. Cadot 147200
2 F. Pachot 130900
3 B. Vroman 75950
4 A. Kavsek 63050
5 T. Boles 52750
6 P. Wisse 52700
7 Z. Hudec 42100
8 A. Chavan 25100
9 A. Deledda 23700
10 V. Swamy 20525
About
DBA-Village
Site Statistics
Ever registered41892
Total active users26382
Act. users last 24h75
Act. users last hour7
Hits last week4657
Hits last month21775
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
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

Follow up by mail Click here

Subject: Changing hostname in OCR
Author: marquesa , Portugal
Date: Mar 31, 2007, 1252 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, 1252 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