sapdba_role.sql

[Former Member]

Hi All,

Need to run this into our ECC 6.0 system.

I have executed sapdba_role.sql couple of times, but all of them were NW system so executed sapdba_role.sql with schema SID, But for ECC 6.0 system where tablespace name starts with PSAPSR3, I am not sure of the schema SID of my ECC system.

Kindly let me know, what should follow this script for my ECC 6.0 system(DBSID or SR3 as my tablespace name is PSAPSR3)

Thanks,

Rableen

[Former Member · Accepted solution]

Hello Rableen,

You should always check the OSS note 134592 before executing this script. For starters download the script from this note (just in case a change has been made )!!

As you would notice the syntax for this script is pretty simple:

sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

In case of your ECC system Schema ID is SR3. So you will use SR3 or syntax wise:

sqlplus /nolog @sapdba_role SR3.

Further one correction:

"DBSID or SR3 as my tablespace name is PSAPSR3"... And also "where tablespace name starts with PSAPSR3"

PSAPSR3 is your schema name !! It is not asolutely  imperative that tablespace names have to get derived from schema name.. Never go by tablespace names... .Check the schema name always.

Also the term is schema ID and not schema SID.

Regards.

Ruchit.

[Former Member]

Hi Rableen,

You can just execute command:

sqlplus /nolog @sapdba_role SR3

If you also have java stack, also execute this command:

sqlplus /nolog @sapdba_role SR3DB

Regards,

Asfan

http://sapbasistips.com/blogs