Difference between revisions of "Oracle:Apps Anywhere"
(37 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[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 == | |
− | + | 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: | |
− | The Oracle database can be accessed via different clients. | + | |
+ | <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 == | ||
+ | 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 | ||
+ | |||
+ | |||
+ | === 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 == | |
+ | |||
+ | 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/MenuOptions.png | ||
+ | |||
+ | In which case you can start the program by clicking on: | ||
+ | |||
+ | Start>All Programs>Oracle>sqlplus | ||
− | == Next: | + | == Next: Accessing Oracle using SQL*PLus == |
− | The next step is to | + | The next step is to login using the SQL*Plus software: |
[[Oracle:SQLPlus|Using SQL*Plus]] | [[Oracle:SQLPlus|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: