ORA-00068: invalid value 7000 for parameter _max_services

Max_services parameter value setting version-wise:

11.2.0.2 which had a limit of 118

11.2.0.3 which had a limit of 150

12c R1 has a limit of 1024.

12c R2 has a limit of 8200.

-- For upper version 12201 support up to 8200
alter system set "_max_services"=9000 scope=spfile;
ERROR at line 1:
ORA-00068: invalid value 9000 for parameter _max_services, must be between 150
and 8200

--For lower 12101 version support up to 1024
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


select a.ksppinm name, b.ksppstvl value, b.ksppstdf deflt,
decode (a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file', a.ksppity) type,
a.ksppdesc description
from
sys.x$ksppi a,
sys.x$ksppcv b
where a.indx = b.indx
and a.ksppinm like '\_max_service%' escape '\'
order by name;


NAME VALUE DEFLT TYPE DESCRIPTION
------------------------------------------------------------------------------
_max_services 1024 TRUE number maximum number of database services

Check the value with the following query:

select a.ksppinm, b.ksppstvl "SESSION", c.ksppstvl instance from x$ksppi a, x$ksppcv b, x$ksppsv c 
where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '%max_services%';

We can check the services and active services and reduce the service by deleting:

set lines 200 pages 2000
select * from v$services;
select * from v$active_services;
select * from dba_services;