Access ACME

In this project, you need to have access to a database server for the demo in phase III (or test your phase II).

An Oracle database server is publicly available for Georgia Tech students at acme.gatech.edu. 

You need a SSH client to access ACME. In Windows, you can use SecureCRT or Putty.

SecureCRT is available through Georgia Tech which can be downloaded from www.oit.gatech.edu/software.

Putty is free and can be obtained from:
http://the.earth.li/~sgtatham/putty/latest/x86/putty.exel

Start a session using Putty:
• Execute putty.exe
• In the field hostname enter acme.gatech.edu
• Putty will ask for your username/password which is your gtg username/password.
• Now you are already connected to ACME.
• Hints: you should save the session so that you don't have to provide all the log-in information for every session.

In order to access and manipulate your Oracle database, you need to set the Oracle Environment in your ACME home directory. 

• Logging into ACME by using the log-in instructions above.
• Type pico .profile. Pico is a very simple text editor and .profile is the file that you will edit.
• Copy and paste (or type) the text from the link below into the file .profile:
	http://www.cc.gatech.edu/classes/AY2006/cs4400_summer/OracleStuff/acme-profile-bash
• Press Ctrl+O to save the file.
• Press Ctrl+X to exit.
• After quitting pico, type ls * to check if .profile is in your directory. And type cat .profile to check if the text has been entered successfully. The command cat will display the content of the file on your screen.
Hints: right-click on the mouse to paste a content copied from some other places in pico using Putty.

To manipulate the database, type: sqlplus / 

Sqlplus is a client used to remotely manipulate an Oracle Database. The slash following sqlplus tells the sqlplus client to log into Oracle using your current gtg username/password. Now, you are connected to Oracle and  ready to view and manipulate the database.

Following are some useful commands to get you started:

Change the password for the Oracle database: alter user identified by <newpassword>.  It can be different from your gtg account's password.

List all the existing tables: select * from cat;

Describe a table: desc <table name>;

Drop a table: drop table <table name>;

Execute a script file: @<filename>;

Exit sqlplus: exit.

For more command: google sql commands oracle

Hints: 
You can open two SSH clients at the same time. In the first client, you can type pico script.sql to edit the file script.sql (or any name you like) just right after log-in into acme (don't type sqlplus). You should write a set of commands in this file. Type Ctr+O to save the file. The second client is used to manipulate the database. In this client, type @script.sql to execute the set of SQL commands written in the first terminal instead of typing the SQL commands directly in sqlplus (which is error proned). 

You contain create different script files.

In the phase III, you need to create different script files for different tasks prior to the demo. During the demo, just execute the scripts to show the output of your SQL commands.

Some useful command to use in SSH client (before log-in into sqlplus):
List all files and directory: ls *
View the content of a file: cat <filename>
Edit a text file: pico <filename>
Create a new directory: mkdir <directoryname>
Enter a directory: cd <directoryname>
Remove a directory: rmdir <directoryname>
Remove a file: rm <filename>
Learn about a command: man <command> (e.g. man cd)
For more command: google bash shell commands