Difference between revisions of "Oracle:Apps Anywhere"

From mi-linux
Jump to navigationJump to search
 
(43 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 - First Time ==
 
  
−
The first time you use SQL*Plus you will need to launch it from the Apps Anywhere Software Hub
+
== SQL*Plus ==
  
−
== Apps Anyhere ==
+
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. When using the software at the University, it is available via the Applications Anywhere software hub:
+
 
 +
<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]]
  
−
The first time you use Oracle, click the Apps Anywhere icon on your desktop:  
+
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
 +
 
  
−
http://mi-linux.wlv.ac.uk/~oracle/wiki/Apps.png
+
Click on '''Launch''' and it will install as a group of 3 tools.
  
−
Which will bring up the following window:
+
For this workbook we shall be using:
 +
<b>SQL*Plus</b>
  
−
http://mi-linux.wlv.ac.uk/~oracle/wiki/appsAnywhere.png
+
== Oracle Program Menu ==
  
−
Click where it says CLICK HERE. Once you have been validated, then search for <b>Oracle</b>.
+
Once SQL*Plus has been installed you should find it has been added to your program menu also:
  
−
http://mi-linux.wlv.ac.uk/~oracle/wiki/appLaunch.png
+
https://mi-linux.wlv.ac.uk/~oracle/wiki/MenuOptions.png  
−
 
−
It will install as a group of 3 tools:
 
−
http://mi-linux.wlv.ac.uk/~oracle/wiki/appOracleOptions.png  
 
  
 +
In which case you can start the program by clicking on:
  
 +
  Start>All Programs>Oracle>sqlplus
  
 +
== Next: Accessing Oracle using SQL*PLus ==
  
−
Oracle Data Modeller<br>
+
The next step is to login using the SQL*Plus software:
−
Oracle SQL Data Developer<br>
 
−
Oracle SQL*Plus
 
  
−
Note, you may have to install this for every PC that you use.
+
[[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:

  1. Apps Anywhere
  2. mi-linux.wlv.ac.uk
  3. 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:

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: [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:

AppsAnywhereV2.png


Given there are a lot of apps, use the Search Apps box to search for: Oracle

AppsAnywhere-Oracle.png


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:

MenuOptions.png

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:

Using SQL*Plus

Retrieved from "https://mi-linux.wlv.ac.uk/wiki/index.php?title=Oracle:Apps_Anywhere&oldid=10106"