Difference between revisions of "Oracle Using Oracle From Home"
| (One intermediate revision by the same user not shown) | |||
| Line 10: | Line 10: | ||
For a summary of how to login to Oracle and frequent problems see: | For a summary of how to login to Oracle and frequent problems see: | ||
| − | [http:// | + | [http://ora-srv.wlv.ac.uk/info/Oracle.html http://ora-srv.wlv.ac.uk/info/Oracle.html] |
For up-to-date information on how to use the above access methods, please see: | For up-to-date information on how to use the above access methods, please see: | ||
| − | [http:// | + | [http://ora-srv.wlv.ac.uk//info/UsingOracleAtHome.html http://ora-srv.wlv.ac.uk//info/UsingOracleAtHome.html] |
| − | |||
== Virgin Media Broadband Customers == | == 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 | + | 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 few minutes. 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 its own time-out limit and any locks will clear after a bit. | 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 its own time-out limit and any locks will clear after a bit. | ||
Latest revision as of 10:36, 17 September 2019
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://ora-srv.wlv.ac.uk/info/Oracle.html
For up-to-date information on how to use the above access methods, please see:
http://ora-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 few minutes. 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 its own time-out limit and any locks will clear after a bit.
Basically to avoid this, keep typing!
Return to the Workbook.
