= 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);

[[BackLinks]]