Changes between Initial Version and Version 1 of Oracle

Timestamp:

06/06/11 09:41:23 (13 years ago)

Author:

Nick Holden

Comment:

--

Oracle

@@ +1 @@
+= 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);