summaryrefslogtreecommitdiff
path: root/db/oracle/setup
diff options
context:
space:
mode:
authorBoris Kolpackov <boris@codesynthesis.com>2011-12-06 13:45:50 +0200
committerBoris Kolpackov <boris@codesynthesis.com>2011-12-06 13:45:50 +0200
commit7944da1b2589501d104dea796fc18e3da92b54ae (patch)
tree641069be8745012650e15cd10c9ab122932937f7 /db/oracle/setup
parent97ab577a89eae84f26c60673b9ea14aeacd24bc2 (diff)
Add additional info on Oracle setup
Diffstat (limited to 'db/oracle/setup')
-rw-r--r--db/oracle/setup14
1 files changed, 14 insertions, 0 deletions
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: