View previous topic :: View next topic |
Author |
Message |
tuXXer Tux's lil' helper
Joined: 23 Apr 2003 Posts: 83
|
Posted: Sun Jul 06, 2003 12:32 pm Post subject: SAP DB How To |
|
|
1. Download SAP DB and install SAP DB with SDBINST
2. Create file /etc/init.d/sapdb, source:
#!/sbin/runscript
depend() {
need net
use dns
}
start() {
ebegin "Starting SAP DB"
echo "Starting SAP DB database server..."
su - ${SAP_USER} -c "${SAP_INDEP_PROG_PATH}/bin/x_server ${SAP_START} >/dev/null 2>&1"
if [ "${SAP_DATABASES}" != "" ]; then
for DATABASE in ${SAP_DATABASES}; do
echo -n "Starting SAP DB database instance '${DATABASE}'..."
su - ${SAP_USER} -c "${SAP_DEPEND_PATH}/bin/dbmcli -d ${DATABASE} -u ${SAP_DBM_USER},${SAP_DBM_PASSWORD} db_warm 2>&1"
done
fi
if [ "${SAP_START_WEBTOOLS}" == true ]; then
echo "Starting SAP DB Webtools..."
su - ${SAP_USER} -c "${SAP_INDEP_PROG_PATH}/web/pgm/wahttp -f ${SAP_WEBTOOLS_CONFIG} >/dev/null 2>&1 & sleep 2"
fi
eend $?
}
stop () {
ebegin "Stopping SAP DB"
if [ "${SAP_START_WEBTOOLS}" == true ]; then
echo "Stopping SAP DB Webtools..."
killall wahttp >/dev/null 2>&1
fi
if [ "${SAP_DATABASES}" != "" ]; then
for DATABASE in ${SAP_DATABASES}; do
echo -n "Stopping SAP DB database instance '${DATABASE}'..."
su - ${SAP_USER} -c "${SAP_DEPEND_PATH}/bin/dbmcli -d ${DATABASE} -u ${SAP_DBM_USER},${SAP_DBM_PASSWORD} db_stop 2>&1"
done
fi
echo "Stopping SAP DB database server..."
su - ${SAP_USER} -c "${SAP_INDEP_PROG_PATH}/bin/x_server ${SAP_STOP} >/dev/null 2>&1"
eend $?
}
3. Create file /etc/conf.d/sapdb and change according to your settings, source:
# Where your SAP DB database server is located
SAP_DEPEND_PATH=/opt/sapdb/depend
SAP_INDEP_DATA_PATH=/opt/sapdb/indep_data
SAP_INDEP_PROG_PATH=/opt/sapdb/indep_prog
# SAP DB's User
SAP_USER=sapdb
# Start/Stop commands
SAP_START=start
SAP_STOP=stop
# Start Webtools
SAP_START_WEBTOOLS=true
# Location of Webtools configuration file
SAP_WEBTOOLS_CONFIG=/usr/spool/sql/ini/WebAgent74.ini
# Loading SAP DB database instances
SAP_DATABASES=""
# SAP DB DBM user
SAP_DBM_USER="dbm"
SAP_DBM_PASSWORD="dbm"
4. Create /etc/env.d/40sapdb and change according to your settings, source:
PATH=/opt/sapdb/depend/bin:/opt/sapdb/depend/pgm:/opt/sapdb/indep_prog/bin:/opt/sapdb/indep_prog/pgm:/opt/sapdb/indep_prog/web/pgm
ROOTPATH=/opt/sapdb/depend/bin:/opt/sapdb/depend/pgm:/opt/sapdb/indep_prog/bin:/opt/sapdb/indep_prog/pgm:/opt/sapdb/indep_prog/web/pgm
LDPATH=/opt/sapdb/depend/lib:/opt/sapdb/indep_prog/lib:/opt/sapdb/indep_prog/web/lib
5. Run env-update
Ét voilà it should run. |
|
Back to top |
|
|
tuXXer Tux's lil' helper
Joined: 23 Apr 2003 Posts: 83
|
Posted: Tue Jul 08, 2003 8:33 am Post subject: Now working on an ebuild |
|
|
I'm working on an ebuild for SAP DB, now, but it takes a while, because the SAP installer isn't usefull for manual install. Here are the steps and states:
1st Phase:
Runlevel scripts and environment variable
=> done
2nd Phase:
Base server install
=> inprogress
3rd Phase:
Writing database instance installer
=> standby
4th Phase:
Webtools install
=> standby
5th Phase:
JDBD driver install
=> standby
6th Phase:
ODBC driver install
=> open
7th Phase:
Python modules install
=> open |
|
Back to top |
|
|
starbecks n00b
Joined: 30 Mar 2003 Posts: 45
|
Posted: Wed Aug 27, 2003 10:24 am Post subject: SAPDB ebuild |
|
|
I was working with SAPDB on a project last year. Once I finally got it running (on MSW and Suse), it seemed to work very well. I liked the mix of the power and tuning like Oracle and the open source spirit like MySQL. A new project is coming up that looks like SAPDB may be a good fit. I've since moved all boxen to Gentoo and would like to know...
tuXXer,
You mentioned you are working on an ebuild for SAPDB. How's the progress? Anything I can do to help?
Is anyone else working on an ebuild for SAPDB?
- |
|
Back to top |
|
|
pennedinil Tux's lil' helper
Joined: 08 Aug 2003 Posts: 95
|
Posted: Sat Aug 30, 2003 8:39 am Post subject: |
|
|
anyone compile SAP DB from source? |
|
Back to top |
|
|
tuXXer Tux's lil' helper
Joined: 23 Apr 2003 Posts: 83
|
Posted: Mon Sep 01, 2003 4:48 pm Post subject: The problem is... |
|
|
Today, I've hadn't found a way to create the SAP DB registry which would be created through the installer (combined with perl). The registry is rewritten every time when a program or tool of SAP DB is updated, added, removed aso. Compiling wasn't the problem, but a compiled SAP DB without registry didn't work. So no ideas for getting on... |
|
Back to top |
|
|
pilla Bodhisattva
Joined: 07 Aug 2002 Posts: 7729 Location: Underworld
|
Posted: Tue Sep 02, 2003 11:54 am Post subject: |
|
|
moved to Docs, Tips & Tricks
thanks, pYrania _________________ "I'm just very selective about the reality I choose to accept." -- Calvin |
|
Back to top |
|
|
berarul Tux's lil' helper
Joined: 12 Apr 2004 Posts: 75 Location: Bucuresti
|
Posted: Sun Apr 25, 2004 2:18 pm Post subject: |
|
|
There seems to be a prallel building effort of a maxdb ebuild
Code: |
http://forums.gentoo.org/viewtopic.php?t=122009&highlight=maxdb
|
However, in my experience MaxDB is too unstable (MySQL says that it is to be used only by developers).
I would like to help out with an ebuild for SapDB. I tried it alone and I failed, though. _________________ You need to stand up to your mother, smack her in the face and say "That's enough of your shit, you fucking bitch!" |
|
Back to top |
|
|
mundi n00b
Joined: 27 Jun 2003 Posts: 60
|
Posted: Wed May 26, 2004 10:12 pm Post subject: |
|
|
berarul wrote: | There seems to be a prallel building effort of a maxdb ebuild
Code: |
http://forums.gentoo.org/viewtopic.php?t=122009&highlight=maxdb
|
However, in my experience MaxDB is too unstable (MySQL says that it is to be used only by developers).
I would like to help out with an ebuild for SapDB. I tried it alone and I failed, though. |
Hi!
As you allready have noticed i did an ebuild for maxdb to build it from sources - you can find it in the bug system as described in the link that you gave above.
Right now i am working on a version for 7.5.00.12 - will be finished soon.
We are having problems compiling from sources on systems that where installed from 2004.x gentoo distributions. If you want to help, every testing effort would be appreciated.
Just one remark - calling maxdb unstable is a rather daring statement. We are running large SAP installations with hundreds of users on the basis of maxdb and linux. In my experience it is as stable as any other enterprise grade db-system (including ORACLE).
have fun - mundi |
|
Back to top |
|
|
berarul Tux's lil' helper
Joined: 12 Apr 2004 Posts: 75 Location: Bucuresti
|
Posted: Thu May 27, 2004 12:06 am Post subject: |
|
|
Well actually you're right. At the time I was very pissed off at MySQL at the time since the Windows version worked without any hassle MaxDB v 7.5.00.05 was a bitch to get going on Linux systems, while SapDB v 7.4 worked beautifully on Linux.
Will try your e-build as soon as the free-time package finishes emerging .
Since you run such big installations, have you ever compared the SAP on Linux to SAP on windows? Performance and stability alike?
Just being curious.[/quote] _________________ You need to stand up to your mother, smack her in the face and say "That's enough of your shit, you fucking bitch!" |
|
Back to top |
|
|
mundi n00b
Joined: 27 Jun 2003 Posts: 60
|
Posted: Thu May 27, 2004 5:55 am Post subject: |
|
|
berarul wrote: |
Since you run such big installations, have you ever compared the SAP on Linux to SAP on windows? Performance and stability alike?
Just being curious. |
Dont missunderstand this as an offical statement its just my personal statement. SAP installation are significant faster and more relyable on the linux/maxdb platform compared to the windows/maxdb platform. It is definitly my prefered scenario for large SAP installations.
Nowadays i prefer this platform over all other possible supported os/db-system combinations. Only in high load 24/7 all year situations oracle might still be a better choice because of the redo-log system that is a bit more flexible.
have fun (btw. the ebuild for 7.5.0.12 is finished and can be found in bugs.gentoo.org) |
|
Back to top |
|
|
|