Connecting to academic network computers using bast.hpc.fau.edu server (Recommended)

see the details: link

Students can individually request access here

Access to bast.hpc.fau.edu using ssh (e.g., ssh yangk@bast.hpc.fau.edu)

FAU Oracle Database Access

We will use the FAU Oracle database system to practice SQL queries. Please see the following steps to access the oracle DBMS.

1) Access bast.hpc.fau.edu server IF YOU ARE OUT OF CAMPUS. (Optional)

2) Access to oraclelinux.eng.fau.edu using ssh (e.g., Windows Terminal, MobaXterm, or putty). For example, my id is yangk. Therefore, I can use the following command to access the Linux server: ssh yangk@oraclelinux.eng.fau.edu (The default password is 'oracle')

3) (Optional) Change your Linux passsword using the 'passwd' command.

4) Enter the SQL*Plus command: sqlplus. For example, my id is yangk. Therefore I can use the following command to access the Oracle database server: sqlplus yangk

5) When prompted, enter your Oracle Database username and password. (The default password is 'oracle')

6) (Optional) Change your Oracle password using the 'password' command.

If you want to install the Oracle database in your computer, please use the following download link here (Optional, but not recommended).

Homework Submission

Your submission consists of two parts: 1) all answers for Question and Lab parts (e.g., SQL statements) and 2) spool file for outcomes of queries.

Please note that the first file should include the SQL statements in the Lab part.

How to create a spool file

SPOOL [file_name] : Stores query results in a file.

(e.g., SQL> spool Z00000001_KwangSoo_Yang_HW01_spool.txt)

The SPOOL command creates the spool file on the current directory.

(Optional) You can create the spool file to a specific directory

(e.g., SQL> spool /home/yangk/spool/Z00000001_KwangSoo_Yang_HW01_spool.txt)

See the details: here

How to see the contents of a spool file

CAT [file_name] : Reads data from the file and gives their content as output.

(e.g., cat Z00000001_KwangSoo_Yang_HW01_spool.txt)

Please check if the spool file contains all SQL statemtnes and outputs.

How to download a spool file

Use the sftp command

SFTP (SSH File Transfer Protocol) is a secure file protocol that is used to access, manage, and transfer files over an encrypted SSH transport.

• Establish an SFTP connection (e.g., yangk@oraclelinux.eng.fau.edu).
• Once connected, you will be presented with the sftp prompt, and you can start interacting with the remote server.
• (Optional) To list the files and directories, use the 'ls' command.
• (Optional) To navigate to another directory, use the 'cd' command.
• To download a single file from the remote server, use the 'get' command (e.g., get Z00000001_KwangSoo_Yang_HW01_spool.txt)
• (Optional) To upload a file from the local machine to the remote SFTP server, use the 'put' command (e.g., put tb201.sql).
• To logout the sftp server, use the 'exit' command.
• After logout, you can find the downloaded file on the current directory.

Please note that if you use sftp in the linux server (i.e., oraclelinux.eng.fau.edu), then the downloaded file overwrites the orignal file.

See the deatils: here

Sample DataSet

1) Reservation

2) Company

Primary and Foreign key

Retrieve primary keys

Retrieve foreign keys

How to access VMWare (Optional, but not recommended)

1) Access VMware through https://portal.eng.fau.edu to an external site.

    Two-factor and multi-factor authentication (i.e, Duo) is required to access VMware. Please see the following attached files.

• Enable_Duo_Multifactor_Authentication.pdf
• Reactivate_Duo_Mobile.pdf
• Change_Duo_default_to_Automatic_Push.pdf
• VMware_logon_with_Duo_Push.pdf
• VMware_logon_with_Phone.pdf
• VMware_logon_with_SMS.pdf
• VMware_logon_with_Token.pdf

See the CoECS VMWare Guilde here