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

[patelyogesh]

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