From 7944da1b2589501d104dea796fc18e3da92b54ae Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Tue, 6 Dec 2011 13:45:50 +0200
Subject: Add additional info on Oracle setup

---
 db/oracle/setup | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'db')

diff --git a/db/oracle/setup b/db/oracle/setup
index 87964bd..53e8e80 100644
--- a/db/oracle/setup
+++ b/db/oracle/setup
@@ -15,6 +15,20 @@ UNLIMITED TABLESPACE TO odb_test;
 
 =======
 
+If you are getting "ORA-12516: TNS:listener could not find available
+handler with matching protocol stack" (this seems to be the case with
+10.2 XE), you will need to increase the number of connections/processes:
+
+col name format A30
+col value format A30
+select name, value from v$parameter where name in ('processes','sessions');
+alter system set processes=300 scope=spfile;
+alter system set sessions=300 scope=spfile;
+
+Then restart the database (via init.d).
+
+=======
+
 If running an OCI-based client under valgrind you get "ORA-12546: TNS:
 permission denied", then you need to set the TWO_TASK environment
 variable:
-- 
cgit v1.1