Hello, this is my first time posting here.
I have an issue with the application HP Operations Manager, version 9.21.130, which is running on top of Oracle 12c (12.1.0.2.0).
I have a legacy instance of the same application, which is running on top of Oracle 11g (11.2.0.3.0).
The only difference between the instances is the underlying Oracle version.
The new server has not entered live service yet (so not much load on it), the old one has been in service for about a year.
I started seeing the error ORA-00020: maximum number of processes (200) exceeded, which is stopping new connections to the database, and hence is a big problem.
And sure enough, looking at the openview processes starting with 'ora', I was seeing 200 of them
(ps aux|grep openview|grep ora|wc yielded 200 lines)
Compared with the system running on 11g, which has 66 running openview processes as of now, I think there must be a problem!
Looking at the differences between process names on the two systems, the main difference is the processes named ora_p<nnn>_openview, which I am currently seeing 175 of.
These seem to be parallel processing processes, but they don't appear to be doing anything (process time sitting at 0:00 or 0:01), and all sleeping every time I've looked.
So could this be a natural consequence of moving to 12c?
I have tried upping the maximum processes to 400 (alter system set processes=400 scope=spfile), then bounce, but then I started getting different errors.
ORA-04031: unable to allocate x bytes of shared memory
So I tried doubling the size of the shared pool and large pool in init.ora, but was still getting the ORA-04031 errors.
At one point, sqlplus gave me the error "Unsafe to continue", so I got scared and reverted everything back to where it was, so that's where I am, and why I am asking for help!
Can anyone give me any pointers?