Difference between revisions of "Oracle Using Oracle From Home"

From mi-linux
Jump to navigationJump to search
m (Protected "Oracle Using Oracle From Home" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)))
Line 15: Line 15:
  
 
[http://oradb-srv.wlv.ac.uk//info/UsingOracleAtHome.html http://oradb-srv.wlv.ac.uk//info/UsingOracleAtHome.html]
 
[http://oradb-srv.wlv.ac.uk//info/UsingOracleAtHome.html http://oradb-srv.wlv.ac.uk//info/UsingOracleAtHome.html]
 +
 +
 +
== Virgin Media Broadband Customers ==
 +
 +
If you use Virgin Media as your broadband provider, please note it will time-out your session if you have not used your computer for a bit. This means you will lose your connection to Oracle and will happen no matter which tool you use to interface Oracle (SQL*Plus, SQL*Developer, or via putty).
 +
 +
So, if you are inserting records do ensure you type ''COMMIT'' before leaving your computer for any length of time! You might find your table(s) are locked when you re-logon, but Oracle also has it's own time-out limit and this will clear after a bit.
 +
 +
Basically keep typing for this not to happen :-)
  
 
----
 
----
  
 
Return to the [[Oracle_Workbook|Workbook]].
 
Return to the [[Oracle_Workbook|Workbook]].

Revision as of 17:08, 12 April 2018

Main Page >> Oracle and SQL >> Workbook >> Using Oracle from home

Accessing Oracle from Home

There are several ways to access Oracle from home, or any non-FSE lab in the University:

  • Linux Server
  • Instant Client (SQL*Plus)
  • Application Express (APEX)

For a summary of how to login to Oracle and frequent problems see:

http://oradb-srv.wlv.ac.uk/info/Oracle.html

For up-to-date information on how to use the above access methods, please see:

http://oradb-srv.wlv.ac.uk//info/UsingOracleAtHome.html


Virgin Media Broadband Customers

If you use Virgin Media as your broadband provider, please note it will time-out your session if you have not used your computer for a bit. This means you will lose your connection to Oracle and will happen no matter which tool you use to interface Oracle (SQL*Plus, SQL*Developer, or via putty).

So, if you are inserting records do ensure you type COMMIT before leaving your computer for any length of time! You might find your table(s) are locked when you re-logon, but Oracle also has it's own time-out limit and this will clear after a bit.

Basically keep typing for this not to happen :-)


Return to the Workbook.