Home » Server Options » RAC & Failsafe » Rac Database (oracle,11.1.0 ,OEL5.0)
Rac Database [message #414842] Thu, 23 July 2009 15:09 Go to next message
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.
Re: Rac Database [message #414843 is a reply to message #414842] Thu, 23 July 2009 15:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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?
Re: Rac Database [message #414845 is a reply to message #414843] Thu, 23 July 2009 15:35 Go to previous messageGo to next message
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
Re: Rac Database [message #414846 is a reply to message #414845] Thu, 23 July 2009 15:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: Rac Database [message #414849 is a reply to message #414846] Thu, 23 July 2009 15:58 Go to previous messageGo to next message
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
Re: Rac Database [message #414857 is a reply to message #414842] Thu, 23 July 2009 17:51 Go to previous messageGo to next message
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.
Re: Rac Database [message #414861 is a reply to message #414857] Thu, 23 July 2009 20:04 Go to previous message
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.
Previous Topic: OCFS install: load_ocfs
Next Topic: recommendation for oracle10g rac on open solaris for x86
Goto Forum:
  


Current Time: Thu Mar 28 10:57:57 CDT 2024