Forum OpenACS Q&A: Re: TNS Problem on Oracle 10g / Solaris x86 / Aolserver 4.5

Hello S, I don't know if this is your problem but you need 3 pools for OpenACS. Here's a sample from one of my AOLservers:
#
# Database Pools: This is how AOLserver  ``talks'' to the RDBMS. You need
# three for OpenACS: main, log, subquery. Make sure to replace ``yourdb''
# and ``yourpassword'' with the actual values for your db name and the
# password for it.

# AOLserver can have different pools connecting to different databases
# and even different different database servers.
#
ns_section ns/db/pools
ns_param   pool1     "Pool 1"
ns_param   pool2     "Pool 2"
ns_param   pool3     "Pool 3"

ns_section ns/db/pool/pool1
ns_param   maxidle            0
ns_param   maxopen            0
ns_param   connections       10
ns_param   verbose            $verbose
ns_param   extendedtableinfo  true
ns_param   logsqlerrors       $sqldebug
ns_param   driver             ora10
ns_param   datasource         $datasource
ns_param   user               $db_name
ns_param   password           $db_password

ns_section ns/db/pool/pool2
ns_param   maxidle            0
ns_param   maxopen            0
ns_param   connections       10
ns_param   verbose            $verbose
ns_param   extendedtableinfo  true
ns_param   logsqlerrors       $sqldebug
ns_param   driver             ora10
ns_param   datasource         $datasource
ns_param   user               $db_name
ns_param   password           $db_password

ns_section ns/db/pool/pool3
ns_param   maxidle            0
ns_param   maxopen            0
ns_param   connections       10
ns_param   verbose            $verbose
ns_param   extendedtableinfo  true
ns_param   logsqlerrors       $sqldebug
ns_param   driver             ora10
ns_param   datasource         $datasource
ns_param   user               $db_name
ns_param   password           $db_password

ns_section ns/server/${server}/db
ns_param   pools              "*"
ns_param   defaultpool        pool1