What are the proper steps for reconnecting to a database once the connection is lost?
I generally have SQL Developer open with multiple worksheets all day long. I go from meeting to meeting, sometimes going from wired to wireless, and multiple sleep/awake cycles in between. I lose connection to the database multiple times throughout the day.
I never know the proper way to reconnect to the database. I generally don't even think about it until I try running a query from one of the open worksheets and it tells me there is an IO error or closed connection.
I have tried going to the Connections and right-clicking and choosing "Connect" or "Reconnect" since "Disconnect" is normally grayed out. Neither seems to work. The thing that does work is using Alt-F10 to open a new worksheet, choosing a connection, waiting for the new worksheet to open then go back to the original worksheet that was already open and executing my query. After doing all of this, the query will normally run.
I assume there is a faster, or more reliable way of reconnecting and I just don't know about it since I'm a new SQL Developer user.
I appreciate your patience with my question while I'm still learning. Thanks.