diff options
| author | Boris Kolpackov <boris@codesynthesis.com> | 2011-12-06 13:45:50 +0200 |
|---|---|---|
| committer | Boris Kolpackov <boris@codesynthesis.com> | 2011-12-06 13:45:50 +0200 |
| commit | 7944da1b2589501d104dea796fc18e3da92b54ae (patch) | |
| tree | 641069be8745012650e15cd10c9ab122932937f7 | |
| parent | 97ab577a89eae84f26c60673b9ea14aeacd24bc2 (diff) | |
Add additional info on Oracle setup
| -rw-r--r-- | db/oracle/setup | 14 |
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: |