If you have the rep and are so inclined, can you visit this question and vote to unclose if it seems reasonable (as it does to me)?
I feel like I should answer this question somehow. Basically, I work with Python & Oracle and this is my territory.
I do not think that this question should be re-opened and have, in fact, voted to close it again. I'm going to attempt to explain my reasoning...
I don't think you can claim that this is a "good" question; you've fallen into the trap of most self-answers and concentrated more on the answer than you have the question. Whilst this may have been a great question at the time I believe it wouldn't, currently, be received in the same way. In your question you would be expected to show a rudimentary knowledge of the subject and an attempt to do something for yourself; neither of which are in evidence.
I agree with LittleBobbyTables in that I'm not sure that your edit makes anything better. If anything, it makes the question "not constructive" because you're now asking for recommendations. As there is only one PEP 249 (to my knowledge) Python package to connect to Oracle it also makes it kind of pointless.
The answer, while giving a good, quick, overview of how to connect to Oracle doesn't actually provide any explanation of what is happening, or more importantly why. You also ignore some of the more important parts of a database-interface, namely bind variables and SQL injection. In any case, no matter the quality of the answer, an answer should not be used as a reason to keep a question open.
My own, personal, feeling is that this question should be, and remain, closed. I do not think it should be deleted. It's a helpful question and will be of use to future visitors but it is not a good question and I do not think we should be indicating to new users that a question, so lacking in details, is acceptable.
I also agree with Bart's comment that your edit has effectively invalidated the other answers (though I don't think this one should be around at all). In such a case it's best to keep the question as is and ensure that any edits made keep all answers understandable in the context of the question.
Personally, I think that's actually a subtle, yet substantial edit.
Before, you were asking
Now, you're asking
You've not only invalidated most of the other answers (since you're now asking for package/module suggestions), but now that you're asking for suggestions, I feel it can be closed as "Not constructive", unless there's only a single package that does what you're looking for.