Hi,
Using:
Connected To: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Recognized As: Oracle12c Database Release 1
This question is out of my domain but I see my team struggling and would like to contribute with a solution rather than continue being part of the problem;
We use automated scripts to deploy a web application which includes deployment to DB (scripts). One of the conditions for this is that no other user is connected to the DB otherwise the deployment fails. So what is happening is that tester trigger the build, and then it fails because 'johndoe' has an active session. Normally these sessions come from SQL Developer or JDeveloper that developers use to troubleshoot, etc.
Every time I ask why they don't kill it they say the scripts tries, but then the IDE re-connects itself automatically hence the session is never killed. So we need to wait for the developer to actually disconnect him/herself from the DB. This is costing us time as sometimes the developer goes home and forgets to disconnect. Also, I don't think this is how it should be handled. There ought to be a better way.
Could you please advise what would be a potential solution to this small but yet expensive issue?
Regards,