[daniesh]

Hi Saurabh,

Thanks for your response.

One of the interviewer asked me this question.

I am aware that the node which boots up first becomes master node.

My answer is to his question was that the instance with the most recent data will become master. he told me that i am talking regarding resource master.

I know that oracle assign the node number to each node and keep the information in voting disk.

Am I right, The instance which will have the most recent scn will become the master node if the master node goes down.

How we will be able to find out the node number information is there any command with which we can find the master node number.

Awaiting for your response.

Thanks and Regards,

[daniesh]

Hi Amit,

Thanks for very much for clearing my doubt.

I was bit confused regarding this.

Thanks and Regards,

Dan

[daniesh]

Hi,

Yes i know that.

I guess this works when both the primary and secondary database register in the same catalog.

I have already mentioned that in my question the one you are referring if both the database are in the same catalog then the standby database will automatically get registered in the catalog database if the catalog database is different then i dont think that standby database will automatically get registered in database.

Your assistance is much appreciated in this regards,

Thanks

[daniesh]

Hi,

I have already installed CRS and Oracle s/w and i want to install ASM

however when i try to install asm using DBCA.,

I am getting error.

please help me on this.

Thanks,

[daniesh]

Hi ,

thanks for the reply.

yes ORACLE and ASM home are same

please see the output below.

[oracle@rac2 bin]$./crs_stat -t

Name Type Target State Host

---

ora…SM1.asm application ONLINE OFFLINE

ora…C1.lsnr application ONLINE OFFLINE

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE OFFLINE

ora…SM2.asm application ONLINE OFFLINE

ora…C2.lsnr application ONLINE OFFLINE

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE OFFLINE

you can see from the above o/p that vip is not up.

when i try to stop and start it up.

[oracle@rac1 bin ]#./crs_stop -f ora.rac1.vip

Target set to OFFLINE for ‘ora.rac1.LISTENER_RAC1.lsnr’

Target set to OFFLINE for ‘ora.rac1.ASM1.asm’

Target set to OFFLINE for ‘ora.rac11.vip’

[oracle@rac1 bin ]#./crs_start -f ora.rac1.vip

Attempting to start ‘ora.rac1.vip’ on member ‘rac1’

start of ‘ora.rac1.vip’ on member ‘rac1’ failed.

Attempting to start ‘ora.rac1.vip’ on member on ‘rac2’

start of ‘ora.rac1.vip’ on member ‘rac2’ failed.

CRS-1006: No more members to consider

CRS-0215: Could not start resource ‘ora.rac1.vip’.

could you please help me on this?

[daniesh]

Hi,

sorry for the 2nd question in the above post.

how can we register multiple database in a RAC?

Thanks.

[daniesh]

HI,

Thanks for the reply.

suppose i have 4 instance rac database.

i want to see the information about 4th instance.

how i will do using ASMCMD command?

About the above question,

How do we register database in RAC?

suppose i have 3 instance , now i want to register 4th instance.

how i will achieve that?

Thanks

[daniesh]

hi

thanks for the reply.

the cluster version is 10.2.0.1 32 bit.

actually i am installing it on vmware.

i am not able to copy it on windows.

the LIB_PATH which i am using is export LD_LIBRARY_PATH=$ORACLE_HOME/lib

could you please tell me the corect path.

I think the probem is with patch.

Thanks

[daniesh]

Hi

yes , I ran the cluster verify utility. everyhing is showing passed.

when i try to install CRS. my setup get compete till 50%. while linking i am getting the following error.

[daniesh]

Hi,

Sorry for the last post.

Actually while upgrading in the first case, we have to start the database in startup migrate mode. however we have to execute the catupgrd.sql script.

why we need catcpu.sql script.

Thanks,

Daniesh

[daniesh]

Hi,

while upgrading from 9i to some other other 9i version we need to execute catcpu.sql script. when we upgrade from lower version to 10g at that we execute catupgrd.sql script.

[daniesh]

Hi ,

Sorry for the late reply.

was out of office.

I will implement this steps.

Thanks

[daniesh]

Hi Aarya,

Thanks for the reply.

I am a bit confused i have to make changes in the control of target database i think.

otherwise how oracle will know that new tablespace and datafile has been added to the

target database.

Thanks,

Daniesh

[daniesh]

Hi Amit,

Thanks for your time and input.

[daniesh]

Hi Amit,

Thanks for the help.

What i did in my case i applied the path of online redolog files and it worked.

my database is new. client request me to create a database and suddenly asked me to clone the DEV database with PROD DB. so archive was generated in my case. becasue of this reason i applied online redolog path and then cancel

it worked!!!

Thanks.

Daniesh

[Author]

Posts