Difference between revisions of "Oracle:Apps Anywhere"
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> [[Oracle_Getting_Started|Getting Started]] >> Apps Anywhere | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> [[Oracle_Getting_Started|Getting Started]] >> Apps Anywhere | ||
| − | == SQL*Plus | + | == SQL*Plus == |
| − | The | + | The Oracle database can be accessed via different clients. SQL*Plus is one of the clients and can be used in a number of ways: |
| + | |||
| + | <ol> | ||
| + | <li>Apps Anywhere</li> | ||
| + | <li>mi-linux.wlv.ac.uk</li> | ||
| + | <li>Download the software from Oracle (Called Instant Client)</li> | ||
| + | </ol> | ||
| + | |||
| + | For options 2&3 please see this link for further details: [[http://ora-srv.wlv.ac.uk/info/UsingOracleAtHome.html Using Oracle from Home]] | ||
== Apps Anywhere == | == Apps Anywhere == | ||
| − | + | SQL*Plus is available via the Applications Anywhere software hub: | |
[[http://www.wlv.ac.uk/appsanywhere Apps Anywhere]] | [[http://www.wlv.ac.uk/appsanywhere Apps Anywhere]] | ||
| − | + | See this page: [[https://www.wlv.ac.uk/its/self-help/software/apps-anywhere/ Access software on and off campus]] for more information about this. | |
| + | |||
| + | If you are in one of the University labs, click the Apps Anywhere icon on your desktop: | ||
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereIcon.png | https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereIcon.png | ||
| − | |||
| − | + | === VPN and Off-Site Access === | |
| + | |||
| + | If you are using Apps Anywhere off-site, you will need to install the VPN software first. See this link for details on how to do this: | ||
| + | [[http://mi-linux.wlv.ac.uk/~oracle/wiki/Installing_the_VPN_Client.pdf Installing the VPN Client]] | ||
| + | |||
| + | Once installed, you will need to start this each time you want to use Oracle from Apps Anywhere. | ||
| + | |||
| − | + | === Oracle App === | |
| − | + | Once you have been validated, a new window will appear showing all your available apps: | |
| + | https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereV2.png | ||
| − | |||
| + | Given there are a lot of apps, use the ''Search Apps'' box to search for: '''Oracle''' | ||
| − | + | https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhere-Oracle.png | |
| − | |||
| − | + | Click on '''Launch''' and it will install as a group of 3 tools. | |
For this workbook we shall be using: | For this workbook we shall be using: | ||
<b>SQL*Plus</b> | <b>SQL*Plus</b> | ||
| − | |||
| − | |||
== Oracle Program Menu == | == Oracle Program Menu == | ||
| Line 40: | Line 53: | ||
Once SQL*Plus has been installed you should find it has been added to your program menu also: | Once SQL*Plus has been installed you should find it has been added to your program menu also: | ||
| − | https://mi-linux.wlv.ac.uk/~oracle/wiki/ | + | https://mi-linux.wlv.ac.uk/~oracle/wiki/MenuOptions.png |
In which case you can start the program by clicking on: | In which case you can start the program by clicking on: | ||
| − | Start>All Programs>Oracle > | + | Start>All Programs>Oracle>sqlplus |
== Next: Accessing Oracle using SQL*PLus == | == Next: Accessing Oracle using SQL*PLus == | ||
Latest revision as of 20:18, 28 September 2020
Main Page >> Oracle and SQL >> Workbook >> Getting Started >> Apps Anywhere
SQL*Plus
The Oracle database can be accessed via different clients. SQL*Plus is one of the clients and can be used in a number of ways:
- Apps Anywhere
- mi-linux.wlv.ac.uk
- Download the software from Oracle (Called Instant Client)
For options 2&3 please see this link for further details: [Using Oracle from Home]
Apps Anywhere
SQL*Plus is available via the Applications Anywhere software hub: [Apps Anywhere]
See this page: [Access software on and off campus] for more information about this.
If you are in one of the University labs, click the Apps Anywhere icon on your desktop:
VPN and Off-Site Access
If you are using Apps Anywhere off-site, you will need to install the VPN software first. See this link for details on how to do this: [Installing the VPN Client]
Once installed, you will need to start this each time you want to use Oracle from Apps Anywhere.
Oracle App
Once you have been validated, a new window will appear showing all your available apps:
Given there are a lot of apps, use the Search Apps box to search for: Oracle
Click on Launch and it will install as a group of 3 tools.
For this workbook we shall be using: SQL*Plus
Oracle Program Menu
Once SQL*Plus has been installed you should find it has been added to your program menu also:
In which case you can start the program by clicking on:
Start>All Programs>Oracle>sqlplus
Next: Accessing Oracle using SQL*PLus
The next step is to login using the SQL*Plus software:
