Oracle XE

Oracle XE (the free limited version of Oracle DB) is used in BRICCS for the database back-end to i2b2.

To start SQL Command Line from a terminal session or command window and connect locally:

If the required environment variables are not already set for your session, set them as described in "Setting Environment Variables on the Linux Platform".

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.csh

Enter the following command at the operating system prompt:

sqlplus /nolog

SQL> CONNECT username/password

To permit remote connections (disabled by default):

At the SQL Command Line prompt, enter the following command:

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'