List of symptoms
- Driver loads OK, but error in log says ORA-01034:ORACLE not available
- Driver doesn't load, error in log says undefined symbol: kpummGetdbtz
- no such array : ad_security in client browser when trying to log on
- Error in serving group pages in client browser
- ORA-0675 Package or function USER_FULFILLS_REQUREMENTS is in an invalid state in client browser after registering a new user or logging in.
- In /admin pages you get ORA-01427 single-row subquery returns more than one row.
The solutions
1. AOLserver Wrapper script
Applicable to: all AOLservers
Possible symptoms:
- Driver loads OK, but error in log says
ORA-01034:ORACLE not available
- Driver doesn't load, error in log says
undefined symbol: kpummGetdbtz
Solution:
You should be using a wrapper script to start AOLserver. In Quest this is usually /usr/bin/aolup or similar. ArsDigita refer to it as nsd-oracle.
Assuming you are using Oracle 8.1.6, installed in /apps/oracle/product/8.1.6 and AOLserver 2.3.3 installed in /apps/aolserver:
Lazy copy & pasters look out! This script will be different if:#bash export NS_HOME="/apps/aolserver" export NS_DAEMON="nsd" export ORACLE_BASE=/apps/oracle export ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_SID=acs816 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_PATH=$ORACLE_HOME/bin export ORAENV_ASK=NO export TNS_ADMIN=$ORACLE_HOME/network/admin /apps/aolserver/bin/nsd -c /apps/aolserver/nsd.ini
- Oracle is installed elsewhere
- you have a different Oracle SID
- you have a different version of Oracle
- AOLserver is installed elsewhere
- you have a different version of AOLserver
2. AOLserver Hostname
Applicable to: ACS 3.4, possibly later versions
Possible symptoms:
no such array : ad_security
in client browser when trying to log on
Solution:
Check the Hostname= entry in nsd.ini or nsd.tcl (whichever you refer to in your AOLserver wrapper script).
If you aren't using DNS, try changing this to the machine's IP address.
3. ini files
Applicable to: ACS 3.4, possibly later versions
Possible symptoms:
Error in serving group pages
in client browser
Solution:
First of all check through the sections in nsd.ini and ad.ini to make sure they refer to the correct AOLserver virtual server. The initial templates assume the name "server1". If yours is different, do a global replace.
For example, if the [ns/servers] section in nsd.ini has the entry acs34=acs34, then your virtual server is called acs34. This means every section name in nsd.ini and ad.ini that refers to a server should refer to acs34. e.g. [ns/server/acs34/tcl] in nsd.ini or [ns/server/acs34/acs] in ad.ini.
NOTE: this assumes you are only using 1 virtual server. Obviously if you have multiple entries in your [ns/servers] section, you won't be making all sections the same because there will be a section for each virtual server.
If that isn't the problem, and you're using nsd.tcl as opposed to ad.ini,
try using nsd.ini instead. I'm not sure if this is the best solution, but when I was using nsd.tcl
it wasn't including the AuxConfigDir at startup (ad.ini).
4. Geo-spatial tables
Applicable to: ACS 3.4, possibly other versions
Possible symptoms:
ORA-0675 Package or function USER_FULFILLS_REQUREMENTS is in an invalid state
in client browser after registering a new user or logging in.
Solution:
The script under your pageroot called install/load-geo-tables was not run before the data model was loaded.
Run this, and then re-run doc/sql/load-data-model.sql (also under your pageroot).
5. Pull-down menus
Applicable to: ACS 3.4, possibly later versions
Possible symptoms:
- In /admin pages you get
ORA-01427 single-row subquery returns more than one row.
Solution:
In ad.ini turn off the pull-down menus like this:
[ns/server/acs34/acs/pdm] ; Flag to display the administration menu bar MenuOnAdminPagesP=0 ; Flag to display the default menu bar on non-/admin pages MenuOnUserPagesP=0
Michael Hinds, 17-NOV-2000