Difference between revisions of "Oracle:Apps Anywhere"
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
== SQL*Plus == | == SQL*Plus == | ||
| − | SQL*Plus can be | + | 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]] | 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]] | ||
| Line 23: | Line 23: | ||
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: | Once you have been validated, a new window will appear showing all your available apps: | ||
| Line 30: | Line 38: | ||
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''' | ||
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhere-Oracle.png | https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhere-Oracle.png | ||
| − | |||
| − | |||
| − | |||
| Line 42: | Line 48: | ||
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 == | ||
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:
