diff options
| -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: |