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".
Enter the following command at the operating system prompt:
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);