We had some issues with tools trying to connect to our Oracle GTREP repository in DEV environment.
We realized the cause was too much sessions opened on that repository server. The only way to release those sessions was to restart the TDM Portal service on one of our application server. Once done, the repository database was accepting connections again.
This is what we use as a query to pull of opened sessions on the database.
Although, the whole query I like to use is this one:
group by username,service_name,program,module,machine
order by machine;
Why are there so much sessions opened espacially for user SCRAMBLE?
It seems also that these sessions don't get released for 3 days and that is not normal I think.
We talked to a DBA about this and he told us that the maximum processes(sessions) that are set for our database is 2000. And sometimes processes(sessions) go over 1500 and this is where we start having connection issues.
The query for process is : select count(*) from v$process
We don't have this issue in PROD environment because the are not that much people using the tools and we have doubled the process limit for our repository database.
Release : 4.9.1
Component : Repository (GTREP)