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.

As root:

Download packages sapdb-ind-7.3.0.8-1.i386.rpm and sapdb-srv-7.3.0.8-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-7.3.0.8-1.i386.rpm

rpm -i sapdb-srv-7.3.0.8-1.i386.rpm

Download sapdbconfig_orefalo73.tgz

cd /

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

Database startup

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.

Last word

If you have an NT box, consider installing DBMgui and SQLstudio, they are great GUI tools.

Enjoy !

Olivier Refalo

http://www.crionics.com