Author Archives: SandeepSingh DBA

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

ORA-00068: invalid value 7000 for parameter _max_services

ORA-00068: invalid value 7000 for parameter _max_services

Max_services parameter value setting version-wise: which had a limit of 118 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 - 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
sys.x$ksppi a,
sys.x$ksppcv b
where a.indx = b.indx
and a.ksppinm like '\_max_service%' escape '\'
order by name;

_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;