database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL Tutorials 23523 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 23523
Installing SAP DB 7.3
작성자
정재익(advance)
작성일
2002-08-08 14:46:43
조회수
6,793

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

[Top]
No.
제목
작성자
작성일
조회
23526SAPDB (Debian) Linux Quickstart Howto
정재익
2002-10-11
6788
23525Sapdb standby HA Howto
정재익
2002-10-11
7510
23524Installing and Upgrading the Database Server: SAP DB 7.3
정재익
2002-08-08
6859
23523Installing SAP DB 7.3
정재익
2002-08-08
6793
23522standardjaws type mapping using SAPDB
정재익
2002-08-08
5136
23521Installation of SAP-DB including ODBC Support for PHP and Apache with Linux
정재익
2002-08-08
6311
23520SAPDB (Debian) Linux Quickstart Howto
정재익
2002-08-08
5870
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2017 DSN, All rights reserved.
작업시간: 0.066초, 이곳 서비스는
	PostgreSQL v9.6.3으로 자료를 관리합니다