Technical Articles
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