Student accounts on this database are created for any student registered for any CCI class.   Typically, accounts are created the day after drop/add registration is over.

All CCI Faculty/Staff have an oracle account as well, these are created as needed.

Your oracle account will match your university login ID.   For students, your initial password will be “qwe123”.   You should change your password on your first login.

For faculty/staff you should contact cci-techsupport (at) listserv.uncc.edu to get your initial password, if you do not already know it.

At the end of each semester (after final exams) ALL student accounts and ALL associated data are permanently DELETED.   You should save your work elsewhere if you would like to keep it.

If you are working on any sort of CCI project that requires long term access to a database, and the data needs to be preserved, have your professor send an email to cci-techsupport (at) listserv.uncc.edu to request a database account for this.   Student accounts will not be used for this purpose.

You can connect to the database via a web interface from on or off campus.

Below is an example of connecting to the database with internet explorer.

Connect to this URL in your web browser:

http://coit-ora01.uncc.edu:8080/isqlplus/

You should see this…

Fill in the username, password, and Connect identifier(class) appropriately as below..

Click Login, and you should see..

SQL commands you would type once logged in are the subject of your coursework and your professor will instruct you.

The command to change your password is:

alter user USERNAME identified by NEWPASS;

You should change your password to prevent unauthorized use of your oracle account.

Each student account is granted a 5MB disk space quota in the USERS tablespace and a 1MB disk space quota in the TEMP tablespace.

Each Faculty/Staff account is granted a 100MB disk space quota in the USERS tablespace and a 20MB disk space quota in the TEMP tablespace.

If you have forgotten or lost your password (initially it is “qwe123”), please send an email to cci-techsupport (at) listserv.uncc.edu.

Please note that connection to the Oracle server from an off-site (off-campus) location or through an on-campus, wireless connection is not possible without use of the HTTP service. You must be on campus using a wired, registered connection - such as one of the lab computers - for any other connections to work.

If you are interested in connecting to the database using JDBC, you will need a working JDBC driver version which is available at:

http://servlet.java.sun.com/products/jdbc/drivers

If you want to setup your own sql connection and/or client on your own machine, the relevant information you need to know besides your userid and password is:

Oracle Database version 10g

Hostname:        coit-ora01.uncc.edu

Database:         class

IP Port:            1521    (default)

Any other questions?   Please email cci-techsupport (at) listserv.uncc.edu