I have similar challenges (because I jump between many networks).
What I did for my local database, was change the listener to listen on both the hostname *and* localhost, eg
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost )(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = my_computer_name)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
so when I'm doing stuff on my local database, everything is done via localhost.
Hope this helps.