Difference between revisions of "Oracle:Apps Anywhere"
| Line 22: | Line 22: | ||
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 === | === 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: | 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]] | [[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. | Once installed, you will need to start this each time you want to use Oracle from Apps Anywhere. | ||
| + | |||
=== Oracle App === | === Oracle App === | ||
| Line 34: | Line 37: | ||
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereV2.png | 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''' | 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 | https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhere-Oracle.png | ||
| + | |||
Click on '''Launch''' and it will install as a group of 3 tools. | Click on '''Launch''' and it will install as a group of 3 tools. | ||
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:
