Great info, thanks!
--
Martin Klier | Performing Databases GmbH
Managing Partner | Senior DB Consultant
Oracle ACE
martin.klier@xxxxxxxxxxxxxxxxx | http://www.performing-databases.com ;
Von: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
An: rjanuary@xxxxxxxxx, "martin klier" <martin.klier@xxxxxxxxxxxxxxxxx>
CC: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Gesendet: Montag, 23. Januar 2017 19:27:39
Betreff: Re: Limited number of DB Services in RAC / Grid Infrastructure /
Listener 12.1?
You would be limited to number of services based on whichever of the two
limits
you hit first.
1. Maximum number of 1024 servers per instance in 12c.
2. Or limit of 4000 characters in V$SYSTEM_PARAMETER.VALUE column, which is
used
to store comma separated services values per instance set by CRS.
Regards,
Vishal Gupta
From: <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of Ryan January
<rjanuary@xxxxxxxxx>
Reply-To: <rjanuary@xxxxxxxxx>
Date: Monday, 23 January 2017 at 14:17
To: <martin.klier@xxxxxxxxxxxxxxxxx>
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Limited number of DB Services in RAC / Grid Infrastructure /
Listener 12.1?
On 11.2 I remember running into a character limit. (all service names are
concatenated together and stored in a parameter)
I've not yet utilized a high number of services on 12. Per
http://docs.oracle.com/database/121/REFRN/GUID-213CC210-4B96-420C-B5B8-3A217F17FC2C.htm#REFRN0044
this may not be an issue and has a limit of 1024 services.
On Jan 23, 2017, at 8:12 AM, Martin Klier - Performing Databases GmbH <
martin.klier@xxxxxxxxxxxxxxxxx > wrote:
Hi listers,
is there a maximum number of DB services a Grid Infrastructure, Listener and
RAC
Database 12.1 can maintain?
I'm asking because of load managing purposes in a consolidated RAC system. We
have many schemas there, and discussed the option to have one service for
each
schema, to be able to shift them around independently. Unfortunately there is
not much on the net about it, or at least I searched for the wrong
keywords...
Thank you very much in advance, any hints are appreciated.
Regards
Martin
--
Martin Klier | Performing Databases GmbH
Managing Partner | Senior DB Consultant
Oracle ACE
martin.klier@xxxxxxxxxxxxxxxxx | http://www.performing-databases.com