Forum OpenACS Q&A: Response to Example config.tcl for Oracle in AOLserver 3.4, e.g. sample-db-ini.txt

This might be what you need. Its based on the sample-db-ini.txt file you mentioned.

; AOLServer ACS Virtual Server Configuration File Template
;
; Replace these variables with the correct values...
; Variable to Replace        Suggestion
; --------------------------+----------------------
; origacs | service_name
; origacs | database_password
; /usr/local/aolserver          | /usr/local/aolserver
; origacs       | service_name
; Experimental Service | a description of your service
; localhost.millward@open-msg.com               | email-address of maintainer
; /web/origacs                  | /web/service_name
; localhost     | your ip address
; localhost     | your dns name
; 9191              | what port to use (9191 by default)
; localhost    | disabled by default
; localhost_ssl       | disabled by default
; 9191_ssl      | disabled by default

[ns/db/drivers]
ora8=ora8.so

[ns/db/pool/main]
MaxIdle=1000000000
MaxOpen=1000000000
Driver=ora8
Connections=8
DataSource=
User=origacs
Password=origacs
Verbose=On
ExtendedTableInfo=On

[ns/db/pool/subquery]
MaxIdle=1000000000
MaxOpen=1000000000
Driver=ora8
Connections=8
DataSource=
User=origacs
Password=origacs
Verbose=On
ExtendedTableInfo=On

[ns/db/pool/log]
MaxIdle=1000000000
MaxOpen=1000000000
Driver=ora8
Connections=3
DataSource=
User=origacs
Password=origacs
Verbose=On
ExtendedTableInfo=On

[ns/db/pools]
main=main
subquery=subquery
log=log

[ns/parameters]
; This used to handled with a file under acs/parameters, but
; parameters are now stored in the database.
User=nsadmin
Group=web
ServerLog=/usr/local/aolserver/log/origacs-error.log
Home=/usr/local/aolserver
StackSize=500000
MaxKeepAlive=0

[ns/threads]
; use more than 1 processor (Solaris)
SystemScope=on

[ns/server/origacs]
PageRoot=/web/origacs/www
DirectoryFile=index.tcl,index.adp,index.html,index.htm
Webmaster=localhost.millward@open-msg.com
NoticeBgColor="#ffffff"
EnableTclPages=On
NotFoundResponse=/global/file-not-found.html
ServerBusyResponse=/global/busy.html
ServerInternalErrorResponse=/global/error.html
MaxThreads=20
MaxBusyThreads=15
MaxWait=2

[ns/server/origacs/db]
Pools=main,subquery,log
DefaultPool=main

[ns/server/origacs/adp]
Map=/*.adp
DefaultParser=fancy

[ns/server/origacs/module/nslog]
EnableHostnameLookup=Off
File=/usr/local/aolserver/log/origacs.log
LogCombined=On
LogRefer=Off
LogUserAgent=Off
MaxBackup=5
RollDay=*
RollFmt=%Y-%m-%d-%H:%M
RollHour=0
RollOnSignal=On
RollLog=On

[ns/server/origacs/module/nsperm]
model=Small
enablehostnamelookup=Off

[ns/server/origacs/module/nssock]
timeout=120
; Address=127.0.0.1
Hostname=localhost
Port=9191

; [ns/server/origacs/module/nsssl]
; Address=localhost
; Hostname=localhost_ssl
; CertFile=/usr/local/aolserver/servers/origacs/cert.pem
; KeyFile=/usr/local/aolserver/servers/origacs/key.pem
; Port=9191_ssl

[ns/server/origacs/modules]
nsperm=nsperm.so
nssock=nssock.so
nslog=nslog.so
nssha1=nssha1.so
nscache=nscache.so

; nsxml=nsxml.so
; nsssl=nsssle.so

[ns/server/origacs/MimeTypes]
Default=text/plain
NoExtension=text/plain
.pcd=image/x-photo-cd
.prc=application/x-pilot

[ns/server/origacs/tcl]
Library=/web/origacs/tcl

[ns/servers]
origacs=Experimental Service