Java程序辅导

The server runs Oracle 11g Release 2 (11.2). Connections to the server must be made by an Oracle client and must use the correct TNS information.

Username

For students, the username is s followed by the student ID. eg:

s100123456

For staff, the username is your normal SIMS username.

Password

For students, your password is your date of birth in the format ddmmyy. You will be force to change your password on first login. If you forget your password, contact the service desk who can reset it for you.

Staff, please contact the service desk to have your password reset.

TNS

The TNS information tells oracle clients how to connect to the oracle server. ICT provide the information in two different formats. The prefered format is LDAP and the alternate format is tns file.

The value of $ORACLE_HOME will vary from host to host. Windows users may be using C:\OraHome1\

LDAP

LDAP connections are controlled by two files, SQLNET.ORA and LDAP.ORA, both of which live in $ORACLE_HOME/network/admin

When using LDAP you do not need to make any changes to your client if the server details change.

The contents of SQLNET.ORA is

NAMES.DEFAULT_DOMAIN = ict.swin.edu.auNAMES.DIRECTORY_PATH = (LDAP,TNSNAMES)

The contents of LDAP.ORA is

DIRECTORY_SERVERS = (ldap.ict.swin.edu.au:389:636)DEFAULT_ADMIN_CONTEXT = "dc=ict,dc=swin,dc=edu,dc=au"DIRECTORY_SERVER_TYPE = OID

You can download these files from and

This source of TNS data also includes the connections from the O: drive.

You must be on the Swinburne network or using the Swinburne VPN client in order to connect to LDAP and Oracle.

TNSNAMES

TNS connections are controlled by two files, SQLNET.ORA and TNSNAMES.ORA, both of which live in $ORACLE_HOME/network/admin

When using TNSNAMES you must check periodically for new versions of the files. The connection details can change from time to time.

The contents of SQLNET.ORA is

NAMES.DEFAULT_DOMAIN = ict.swin.edu.auNAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

You can download these files from and

This source of TNS data does not include the connections from the O: drive.

You must be on the Swinburne network or using the Swinburne VPN client in order to connect to Oracle.

Client Programs

sqlplus

mercury and ICT computer labs have sqlplus configured and ready for use.

sqlplus s1234567@projects.ict.swin.edu.au

SQL Developer

ICT computer labs have Oracle SQL Developer available. You can also download this from the oracle for use on Windows, OS X and Linux.

Note: SQL Developer does not have a change password function. If you receive the error 'Account is locked' then try logging in via iSQLjr first.

Note: If you want to use SQL Developer from home, you must use the Swinburne VPN.

Before using SQL Developer, you will also need to install Oracle instant client version 11.2.0.2.0 (instantclient-basic-nt-11.2.0.2.0.zip). Download instant client from . Once you have download the zip file, extract it to the location of your "sqldeveloper" folder.

Note: You must use instant client version 11.2.0.2.0.

In order to use SQL Developer you must supply the connection details manually.

• Right click on Connections
• Select + New Connection...
• Enter the connection details
  • Connection Name: dms (recommended value)
  • Username: (your oracle username)
  • Password: (your oracle password)
  • Connection type: TNS
  • Role: default
  • Connect Identifier: (as per subject notes, eg: dms)
• Once the fields are completed, click on Test
• If you see Status: Success then the details are correct
• Click Save
• Click Connect

Web interface

There is a web interface called

Manuals

Local manuals can be found