I have configured multiple server in our AOLserver and using shared oracle
database too.
I have got problem with the database.
When I run webpage at one server which containing db is working properly,
but for the other server is not. Is this oracle driver problem?
FYI:
I have got messages from log file like this:
********************
* Working at server1
********************
[17/May/2002:11:21:17][1466.6][-conn0-] Notice: nsd.db: opening: ora8:DB
[17/May/2002:11:21:17][1466.6][-conn0-] Notice: nsd.db: sql(DB): select *
from regionaldesc
********************
* Not working at server2
********************
[17/May/2002:11:17:42][1457.6][-conn0-] Notice: nsd.db: opening: ora8:DB
[17/May/2002:11:17:43][1457.6][-conn0-] Error: ora8.c:1020:ora_open_db:
error in `OCIServerAttach ()': Error while trying to retrieve text for
error 4
SQL: [nil]
[17/May/2002:11:17:43][1457.6][-conn0-] Error: nsd.db: could not open:
ora8:DB1
[17/May/2002:11:17:43][1457.6][-conn0-] Error: nsd.tcl: could not allocate
1 handle from pool "supra"
could not allocate 1 handle from pool "supra"
while executing
"ns_db gethandle $pool"
invoked from within
"set db [ns_db gethandle $pool]..."
invoked from within chunk: 1 of
adp: /aolserver/servers/server2/pages/sh_print_order.html
our AOLserver configuration
#
ns_section "ns/servers"
ns_param server1
ns_param server2
.....
#
ns_section "ns/db/drivers"
ns_param ora ora8.so ;# oracle drive
ns_param pools mypool ;# Optionally specify list of pools
ns_section "ns/db/driver/ora"
#ns_param debug on
ns_section "ns/db/pools"
ns_param mypool "The oracle pool"
ns_section "ns/db/pool/mypool"
ns_param driver ora
ns_param connections 6
ns_param dataSource "DB"
ns_param user "user"
ns_param password "pwd"
ns_param verbose Off
ns_param ExtendedTableInfo Off
# Tell the virtual server about the pools it can use.
ns_section "ns/server/server1/db"
ns_param pools *
# Tell the virtual server about the pools it can use.
ns_section "ns/server/server2/db"
ns_param pools *
.........
TIA
