Skip to Content
Technical Articles
Author's profile photo Yogesh Patel

Part 3:SAP Business objects: Let’s make installation simple with combination of Linux and ASE DB

Welcome back!!!

This is part 3 of the blog series installing Business Object on ASE+Linux

This is the link of Part 2:SAP Business objects: Let’s make installation simple with combination of Linux and ASE DB

Your DB server is ready to create DBs

Please follow steps below to create DB

1.User setup

User setup to run isql when server get restart

Create “.cshrc” file in user home path as below

Note: Hidden fields is username

Add below and save file

source /sybase/<SID>/SYBASE.csh

Restart your server

2. Start DB instance

Once server start please follow below steps to start DB

Copy “startserver” file from ‘/sybase/<SID>/ASE-16_0/bin’ to ‘/sybase/<SID>/ASE-16_0/install’ folder

Run command below in <SID> folder

  • source SYBASE.csh
  • cd ASE-16_0/install
  • startserver -f RUN_<HOST-NAME> -f RUN_<HOST-NAME>_BS

Once command riu successfully press RETURN to go back terminal

3. Connect to ASE

Run following commands connecting isql

Connect to ASE Database

hostname% cd /sybase/<SID>/

hostname% source SYCASE.csh

hostname% isql -S<hostname> -Usa

4. Create CMS DB and User

Run below commands to create DB

use master
go
disk init name=”<SID>CMS_data_001″,physname=”/sybase/<SID>/data/<SID>CMS_data_001.dat”,SIZE=”30G”
go
disk init name=”<SID>CMS_log_001″,physname=”/sybase/<SID>/log/<SID>CMS_log_001.dat”,SIZE=”10G”
go
create database <SID>CMS on <SID>CMS_data_001=’30G’ log on <SID>CMS_log_001=’10G’
go

 

Run below commands to create user and assign permission

sp_addlogin ‘CMSUSER’, ‘actualpassword’, <SID>CMS
go
exec sp_adduser ‘CMSUSER’,’CMSUSER’
go
grant all to CMSUSER
go

5. Crate Audit DB and user

Run below commands to create DB

use master
go
disk init
name=”<SID>AUDIT_data_001″,physname=”/sybase/<SID>/data/<SID>AUDIT_data_001.dat”,SIZE=”10G”
go
disk init name=”<SID>AUDIT_log_001″,physname=”/sybase/<SID>/log/<SID>AUDIT_log_001.dat”,SIZE=”3G”
go
create database <SID>AUDIT on <SID>AUDIT_data_001=’10G’ log on <SID>AUDIT_log_001=’3G’
go

Run below commands to create user and assign permission

sp_addlogin ‘CMSAUDITUSER’, ‘actualpassword’, <SID>AUDIT
go
exec sp_adduser ‘CMSAUDITUSER’,’CMSAUDITUSER’
go
grant all to CMSAUDITUSER
go

 

 

6. Additional User creation

sp_addlogin ‘sapsa’ ,’actualpassword’ ,<SID>CMS
go
exec sp_adduser ‘sapsa’,’sapsa’
go
grant all to sapsa
go

 

 

Quit ASE

 

7. Change Owner of Databases

Start ASE Cockpit

go to folder /sybase/<SID>/COCKPIT-4 folder and run ./cockpit.sh

 

Open cockpit and login with user sa

Now you navigate to Databases as shown below and select properties of DB

 

Change owner

 

Select user and press OK

 

Do the same for both DBs

Final screen will be look like below

 

This was the final step creating DBs for your system

Lets move on to Part 4:SAP Business objects: Let’s make installation simple with combination of Linux and ASE DB

This will talk about first server installation and it;s configuration

Thank you

Yogesh Patel

 

 

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.