|
Our current version is Oracle Database 10g Enterprise Edition
Release 10.2.0.2.0 - 64bit Production With the Partitioning and Data Mining options
(This page includes the current method of remote access to Oracle in IT&E through OpenVPN.
Some may want to refer to the version with the older tunneling methods.)
How do I start to use Oracle?
(from a Windows PC):
First, you need to set up your Oracle database account.
Students are eligible when registered for a course that uses Oracle or when sponsored by faculty, e.g. for research.
Students should ask their faculty sponsor to send the request to oracle@ite.gmu.edu.
(Accounts are scheduled for removal, each after the instructor posts the student's grade.)
Connect to IT&E with OpenVPN or use one of the machines in the IT&E Labs, e.g. ST2-137.
This is needed for each of the following.
Please check with your instructor for which way(s) she or he wants you to access Oracle on the IT&E cluster:
- Use command line access through SSH to zeus.ite.gmu.edu
- Use web-browser interface through apollo: https://apollo.ite.gmu.edu:4443/isqlplus/
- Install & configure the SQL Developer GUI (To be written.)
(http://www.oracle.com/technology/software/products/sql/index.html , requires Java 1.5)
Set up an Oracle database account
Open a web browser to
https://access.ite.gmu.edu/oracle2/index.html
Select "Manage account" under Oracle to the right.
Enter your IT&E username and password (matches GMU e-mail username and password)
Set your password and click 'Create Account'.
(You may change your password in the same way, or from within Oracle with the password command.)
Connect to IT&E with OpenVPN
Start OpenVPN and connect. (For more details on installation instructions, see
http://labs.ite.gmu.edu/reference/ITE-vpn.htm .)
The OpenVPN tray icon should turn green. OpenVPN runs in the background providing the network connection through the firewalls.
When connected, you can proceed with your work in any of these three ways:
- command line access through SSH to zeus.ite.gmu.edu
- the isql web-browser interface through apollo:
https://apollo.ite.gmu.edu:4443/isqlplus/
- the SQL Developer GUI (installation & configuration to be written).
(http://www.oracle.com/technology/software/products/sql/index.html )
requires Java 1.5)
When you no longer need the VPN connection, disconnect.
When it disconnects, you'll also see:
Command line access to Oracle through SSH to zeus.ite.gmu.edu
You will need to be logged onto Windows on a networked PC that has both OpenVPN and SSH installed, your IT&E unix cluster username and
password (which match your GMU e-mail username and password), your Oracle username (same as e-mail username) and your Oracle password
(different from e-mail password) (If needed, refer to the above link Set up an Oracle database account.)
Connect to IT&E with OpenVPN.
Use SSH to log in to zeus.ite.gmu.edu. (For more details on installation and use, see
http://labs.ite.gmu.edu/reference/ITE-vpn.htm#ssh-zeus.)
SSH provides a terminal window for command line entry.
In the SSH terminal at the zeus prompt, enter the command sqlplus.
Log in to oracle with your Oracle username and your Oracle password.
The help command is help or '?' and the help system also references the SQL*Plus
resources
and the Oracle Database Library
To save the output to a file, check out 'help spool'.
The isql web-browser Interface through apollo ite.gmu.edu
You must be logged onto Windows on a networked PC that has both OpenVPN and SSH installed, your IT&E unix cluster username and password
(which match your GMU e-mail username and password), your Oracle username (same as e-mail username) and your Oracle password (different from
e-mail password) (If needed, refer to the above link Set up an Oracle database account.)
Connect to IT&E with OpenVPN (link to above)
Use the web browser to access apollo at https://apollo.ite.gmu.edu:4443/isqlplus/ The web-browser provides a command interface to Oracle.
Next you'll see a series of security notices.
click OK
Log in with your Oracle username and password and the connect id provided to you.
The Save script button prompts an opening filename boxs:
Load script displays this. Click Browse (1) and choose the .sql file to use and click Load (2).
There are more settings through Preferences. To finish, click Logout at the bottom see the confirmation/login page and close the browser.
The SQL Developer GUI
(To be written.)
(requirements)
http://www.oracle.com/technology/software/products/sql/index.html
How can I print out my query?
First, before you do any query script, type spool filename at the SQL prompt.
The system will use the extension you specify with the filename or assign the extension .lst by default.
Next, enter your queries or run your script file. Then turn spooling off (or exit SQL) to close the file.
SQL> spool filename ;
perform queries and other commands
SQL> spool off
Print the file from the zeus command prompt (the same or another ssh window open to the same directory) with the command
enscript or a2ps.
For example,
-bash-3.00$ enscript -P pfp filename
where 'pfp' is the printer name.
Can I print out my query somewhere else?
Yes, you can. After saving your query file (the procedure is mentioned in the above question), you can
transfer the file back to your location;
or, if your file is not too long, copy and paste to a local editor program and then print it out.
Whom may I contact if I have a problem with Oracle?
It depends on the kind of problem. If it is related to SQL commands or query errors, please refer to your
instructor or class TA.
If it is related specifically to your oracle account or the oracle systems, please email the Oracle
administrator at oracle@ite.gmu.edu.
If the problem is related to UNIX commands or systems, please ask a lab assistant or email the problem description(s) to system@ite.gmu.edu.
What are the jdbc connection parameters for Oracle?
- Name: apollo.ite.gmu.edu
- Port: 1521
- Oracle SID: ite10g
|
