ORACLE Access

This page contains the information that you need to access the ORACLE server of our department.

Quick links: Accounts/passwords, Accessing ORACLE

ORACLE accounts

For non-CSE department:

Stu ID	User name	Passwd
5718693	db001	kdowd6zu
5755063	db002	ofaiz81w
5763631	db003	ouowenfa
5822964	db004	pnhpng83
6554722	db005	q1w41uni
5823384	db006	qgaig91w
6767421	db008	sniqng94
7625861	db009	tgbzg92x
5617384	db010	tvpdvogb
6593832	db011	u94s92vq

For CSE students:

Stu ID	User name	Passwd
7632014	db016	xbaivzpy
7613622	db017	xavgemc
7603392	db018	gfldhhz
7614711	db019	dpythhf
6841673	db020	deejyfm
7632143	db021	kfmhpcy
5555404	db022	uxwhhua
7614522	db023	bzqtwsvo
7619264	db024	ayjiie
7614541	db025	ijuhzlz
7630672	db026	flxfnhp
7626303	db027	tqsxzrr
7623233	db028	tlthjgx
7602713	db029	gezmuq
7614082	db030	lfidlp
7613393	db031	kefwin
7612352	db032	rijvafeg
7633192	db033	obdlwmk
7630582	db034	gxdahzsh
7616513	db035	exnblily
7608292	db036	szkjfscd
8601414	db037	znmfkmoe
8601624	db038	jdfwrh
7609713	db039	xuhgjces
7610883	db040	dzorjayf
8601713	db041	khbgezip
8601732	db042	rbtpgpvb

Accessing ORACLE

1. Use ssh to connect to gw.cse.cuhk.edu.hk. After successful log-in, type "ssh sparc1" and type your password again.

For non-CSE students, your account and password are the same as your ORACLE account, as shown in the above table.
For CSE students, use your department account names.

2. Add the following line in ~/.cshrc:
       source /usr/local/oracle8i/setup

3. Start ORACLE:
    sqlplus db###@db11
                \\Here, db### is your username (see the above table). You will then need to input your Oracle password.

4. In ORACLE, change your password with the command:
password

Note that ORACLE passwords are not case sensitive and can contain only alphanumeric characters and underscore (_), dollar sign ($), and pound sign (#).

5. Online manual is here: http://db11.cse.cuhk.edu.hk.