sap errors and solutions

Just another SAP blog

SAP Adaptive Server Enterprise 16.0 Post installation steps

This document is to explain steps which I performed for Post Installation steps of SAP Sybase installation. 

 

Click here to see the Installation document

 

Basically I Performed this installation for SAP BOBJ installation. So Performing Post steps as per that.

 

  1. Creating CMS DB.

Login in to the Sybase with below syntax

Synatx: Isql –S [sybase server name] –U sa

Steps to follow:

SIDCMS

–CMS DB Creation–

use master

go

disk init name=”SIDCMS_data_001″,physname=”/sybase/data/SIDCMS_data_001.dat”,SIZE=”30G”

go

disk init name=”SIDCMS_log_001″,physname=”/sybase/data/SIDCMS_log_001.dat”,SIZE=”10G”

go

create database SIDCMS on SIDCMS_data_001=’30G’ log on SIDCMS_log_001=’10G’with COMPRESSION = page, LOB_COMPRESSION = 100, INROW_LOB_LENGTH = 1000

go

 

sap sybase34

 

Enable the Compression ratio

Syntax: sp_configure ‘enable compression’, 1




 

sap sybase35

 

sap sybase36

 

Creating Audit DB

SIDAUDIT – Syntax Below

use master

go

disk init
name=”SIDAUDIT_data_001″,physname=”/sybase/data/SIDAUDIT_data_001.dat”,SIZE=”10G”

go

disk init name=”SIDAUDIT_log_001″,physname=”/sybase/data/SIDAUDIT_log_001.dat”,SIZE=”3G”

go

create database SIDAUDIT on SIDAUDIT_data_001=’10G’ log on SIDAUDIT_log_001=’3G’ with COMPRESSION = page, LOB_COMPRESSION = 100, INROW_LOB_LENGTH = 1000

go

 

sap sybase37

 

Now Create user “sapsa” in DB Level:

 

sap sybase38

 

 

Now grant all authorizations to user “sapsa” using below command

 

 

sap sybase39

 

 

Now create User – CMSUESR for CMS in SIDCMS Database.

 

Command: sp_addlogin ‘CMSUSER’, ‘password’, SIDCMS (DB name)

sap sybase40

 

Now add full authorization.

 

sap sybase41

 

Now Create CMSUESR for Audit in SIDAUDIT database.

 

Command:

Use SIDAUDIT

go

exec sp_adduser ‘CMSUSER’,’CMSUSER’

go

Result: New User added

 

Now Grant authorization with below command:

 

grant all to CMSUSER

go

Post Installation steps completed.

Updated: September 29, 2016 — 12:07 pm

5 Comments

Add a Comment
  1. Very usesull Info

  2. Very usefull Info

  3. Dear All,
    grant to all command not working
    showing error user/role not exist,Please help regarding this

Leave a Reply

Your email address will not be published. Required fields are marked *

sap errors and solutions © 2016 Frontier Theme
Copy Protected by Chetan's WP-Copyprotect.