Installing SAPDB 7.3
원본출처 : http://www.crionics.com/projects/faq/sapdb.html
Click here (http://www.crionics.com/projects/faq/sapdb72.html) for SapDB 7.2 install procedure.
Note: This procedure has been fully tested under RedHat 6.2. I recently got rumours that it also works under RH 7.x.
Download packages sapdb-ind-126.96.36.199-1.i386.rpm and sapdb-srv-188.8.131.52-1.i386.rpm from sapdb.org
Create user sapdb : useradd sapdb -d /opt/sapdb
Assign a password : passwd sapdb (input a password)
rpm -i sapdb-ind-184.108.40.206-1.i386.rpm
rpm -i sapdb-srv-220.127.116.11-1.i386.rpm
tar xzvf <PATH-TO>/sapdbconfig_orefalo.tgz
This package contains some usefull scripts to manage your database. The SapDB rpm now installs the database daemon correctly, but you still have to add it in your rcX.d (where X is your run level) folder. The version bundled in my archive provides presentation enhancements specific to RedHat systems.
When the procedure is over you get:
Binary directory /opt/sapdb
Document directory /usr/doc/sapdb*
Database directory /var/opt/sapdb
JDBC drivers (Type 2 and Type 4) /opt/sapdb/depend/misc
Create a database
Log in the system as user sapdb and use script createsapdb to create the database (use dropsapdb to remove a database).
The script automatically creates a standard user (dummy/dummy), backup data and log devspaces. By default, the database manager is dbm (password: dbm) and the database administrator is dba (password: dba). You may want to change and edit the script in order to change default database configuration parameters.
If you need to add more users to your database, run the following SQL command under user dba:
CREATE USER <USER> PASSWORD <PASSWORD> RESOURCE NOT EXCLUSIVE
Each database must be started manually at bootup time. Let's say you created a database called TEST. Here are the commands to run in order to boot start/stop it.
ln -s '/etc/rc.d/init.d/sapdb:template' '/etc/rc.d/rcX.d/S86sapdb:TEST'
ln -s '/etc/rc.d/init.d/sapdb:template' '/etc/rc.d/rcX.d/K10sapdb:TEST'
where X is the system's runlevel (usually 3 or 5)
Remark: Please make sure those scripts are started after the sapdb deamon.
If you have an NT box, consider installing DBMgui and SQLstudio, they are great GUI tools.