CSG Zorrillo 3.0
Swinburne University of Technology
Oracle Database Information
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.
For students, the username is s followed by the student ID. eg:
For staff, the username is your normal SIMS username.
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.
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 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.au NAMES.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
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.
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.au NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)
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.
mercury and ICT computer labs have sqlplus configured and ready for use.
ICT computer labs have Oracle SQL Developer available. You can also download this from the oracle sql-developer download website 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 18.104.22.168.0 (instantclient-basic-nt-22.214.171.124.0.zip). Download instant client from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. Once you have download the zip file, extract it to the location of your "sqldeveloper" folder.
Note: You must use instant client version 126.96.36.199.0.
In order to use SQL Developer you must supply the connection details manually.
There is a web interface called iSQLJunioR
Local manuals can be found http://manuals.it.swin.edu.au/oracle10.2/