I enclose the results of running an install script for SAPDB 7.3.0.34 on Red Hat 9. The results of the script are shown below, and a complete story is attached.
Thanks for your help. Mike Slinn sudo /opt/sapdb/indep_prog/bin/dbmcli -d zamples -u sapdb,myPassword -i /var/opt/sapdb/zamplesCreate >param_startsession OK --- >param_init OK --- >param_put MAXUSERTASKS 5 OK --- >param_checkall OK --- >param_commitsession OK --- >param_addvolume 1 LOG LOG_001 F 2000 ERR -24977,ERR_COMMAND: unknown command "param_addvolume" Best regards, Michael Slinn Founder & CTO http://zamples.com 650-345-1140Title: SAPDB DB Admin - IT - Zamples Intranet
SAPDB Database Administration
We are currently migrating our Oracle 8i dbfs to SAPDB.
Installing SAPDB on Sanctuary
We installed SAPDB 7.3.0.34 as follows:
[EMAIL PROTECTED] mslinn]$ cd /home/mslinn/work/sapdb-all-linux-32bit-i386-7_3_0_34
[EMAIL PROTECTED] sapdb-all-linux-32bit-i386-7_3_0_34]$ sudo ./SDBINST
SAPDB runs as user sapdb in group sapsys, with password *grok. The following directories are used:
- /var/opt/sapdb/indep_data
- /opt/sapdb/indep_prog
- /opt/sapdb/depend
Creating a Database
Mike moved to the root directory to make the command line shorter. Following the instructions in
How to Install and Drop SAP DB Instances,
Mike attempted to run:
[EMAIL PROTECTED] /]$ sudo
/opt/sapdb/indep_prog/bin/dbmcli db_create zamples sapdb,*grok
root,rootPassword
The following error message appeared:
Error! Connection failed to node (local) for database (no dbname): connection refused: x_server not running.
The SAPDB listserv has the fix:
[EMAIL PROTECTED] /]$ sudo /opt/sapdb/indep_prog/bin/x_server start
12798 NISERVER server started.
10007 XSERVER started, 'X32|LINUX 7.3.0 Build 034-000-089-879'
Mike retried the dbmcli command line and it worked.
The following script was saved into /var/opt/sapdb/zamplesCreate:
param_startsession
param_init
param_put MAXUSERTASKS 5
param_checkall
param_commitsession
param_addvolume 1 LOG LOG_001 F 2000
param_addvolume 1 DATA DAT_001 F 10000
db_admin
util_connect
util_execute INIT CONFIG
util_activate sapdb,*grok
util_release
load_systab -ud *grok
The script was then run:
[EMAIL PROTECTED] /]$ sudo /opt/sapdb/indep_prog/bin/dbmcli -d zamples -u sapdb,*grok -i /var/opt/sapdb/zamplesCreate
The following messages resulted:
>param_startsession
OK
---
>param_init
OK
---
>param_put MAXUSERTASKS 5
OK
---
>param_checkall
OK
---
>param_commitsession
OK
---
>param_addvolume 1 LOG LOG_001 F 2000
ERR
-24977,ERR_COMMAND: unknown command "param_addvolume"
From Changing Volume Parameters we see that the offending line in the script was attempting to add volume #1 as a LOG volume as a file called LOG_001 and it's maximum size is 2000 units (undefined). No idea why the command is not recognized.
