OraFAQ Forum: RAC & Failsafe

Home » Server Options » RAC & Failsafe » Rac Database (oracle,11.1.0 ,OEL5.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rac Database [message #414842]

Thu, 23 July 2009 15:09

yvssuryan
Messages: 6
Registered: August 2008
Location: mumbai

Junior Member

I have one Rac database with 2 instances.

Is it possible to create one more RAC database on the same servers?
If so, can any one tell me what are the steps?

Because when i try to create one more RAC database it is throwing an error related to listener.

Can any one suggest on this?

Thanks,
Surya.

Report message to a moderator

Re: Rac Database [message #414843 is a reply to message #414842]

Thu, 23 July 2009 15:20

Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Is it possible to create one more RAC database on the same servers?
Yes.
Simplest method is to use DBCA. Exact steps are in documentation.
It is almost the same as a single instance database.
>>Because when i try to create one more RAC database it is throwing an error related to listener.
And what might that be?

Report message to a moderator

Re: Rac Database [message #414845 is a reply to message #414843]

Thu, 23 July 2009 15:35

yvssuryan
Messages: 6
Registered: August 2008
Location: mumbai

Junior Member

Thanks for your response.

I used DBCA utility to create 2 rac database.
But i encountered the following errors ata a time:

ORA-00119 invalid specifications of remote listener.
ORA-00132
ORA-01078

But database got created.

Is it possible to create on more listener or we have to add new database details in previous rac database listener?

Regards,
Surya

Report message to a moderator

Re: Rac Database [message #414846 is a reply to message #414845]

Thu, 23 July 2009 15:38

Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Upto you.
You can use the same listener (same port)
or
New listener on a new port.

Edit listener.ora on both the nodes and add appropriate entries.

Report message to a moderator

Re: Rac Database [message #414849 is a reply to message #414846]

Thu, 23 July 2009 15:58

yvssuryan
Messages: 6
Registered: August 2008
Location: mumbai

Junior Member

I have created a listener, but when i start it, saying

"CRS-0215 cannot start resource on node2".

What is this actually related to?

How to resolve it?

Thanks

Report message to a moderator

Re: Rac Database [message #414857 is a reply to message #414842]

Thu, 23 July 2009 17:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

215,    0, "Could not start resource '%s'."
// *Cause:  There was an internal error while starting the resource.
// *Action: Check the CRS daemon log file.

Report message to a moderator

Re: Rac Database [message #414861 is a reply to message #414857]

Thu, 23 July 2009 20:04

yvssuryan
Messages: 6
Registered: August 2008
Location: mumbai

Junior Member

Creation of rac database is complete no errors

Thanks to every one who ever help .

Surya.

Report message to a moderator

Previous Topic:	OCFS install: load_ocfs
Next Topic:	recommendation for oracle10g rac on open solaris for x86

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 24 06:26:18 CDT 2021