Importing the SAPDBA role (sapdba_role.sql)

[Former Member]

Hi Experts,

i am Importing the SAPDBA role (sapdba_role.sql) in my system before 12 hours still it is runninig , i want to know how much time it wil take.

Thanks in Advance!

Rgds,

Vishal Borisa

[anindya_bose · Accepted solution]

Hello

Are you doing the following steps?

Update the SAPDBA role as <dbsid>adm user as follows:

a) Copy sapdba_role.sql from the DIR_CT_RUN directory to the %ORACLE_HOME%\database directory.

b) Execute the following SQL command(s):

sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

As far as I remember, this did not take more than 5-10 minutes.

Regards

Anindya

[Former Member · Accepted solution]

Hello Sir,

I copy sapdba_role.sql file to %Oracle Home%\Database DIR.

Than Run command from command promt.

sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

but i got below error.......

C:\Documents and Settings\eccadm>sqlplus /nolog @sapdba_role sapsr3

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 2 15:40:41 2012

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SP2-0310: unable to open file "sapdba_role.sql"

SQL>

[anindya_bose · Accepted solution]

Hi

Try the command below and let me know the status.

> sqlplus /nolog @sapdba_role sr3

i.e try with SR3 not SAPSR3.

Regards

Anindya

[Former Member · Accepted solution]

Hello Sir,

In below users which user h have to used.

OPS$ECC6\SAPSERVICEECC

OPS$ECC6\SAPSERVICESR3

OPS$ECC6\ECCADM

SYS

SYSTEM

SAPSR3

SAPSR3DB

OUTLN

TSMSYS

DIP

DBSNMP

Rgds,

Vishal

[anindya_bose · Accepted solution]

Ok..

did you try my last suggestion?

Try

> sqlplus /nolog @sapdba_role SR3DB

> sqlplus /nolog @sapdba_role SR3

Also have a look at OSS Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

Regards

Anindya

[Former Member · Accepted solution]

Hello Sir,

After exe. your command, i get below error

C:\Documents and Settings\eccadm>sqlplus /nolog @sapdba_role.sql sr3

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 2 16:30:37 2012

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SP2-0310: unable to open file "sapdba_role.sql"

SQL>

Rgds,

Vishal

[anindya_bose · Accepted solution]

Hello Vishal

Please check the following.

1. You logged in as SIDADM user and SIDADM is a member of SAPDBA group

2. ORACLE_HOME is set in the environment variables of SIDADM

3. sapdba_role.sql file is present in oracle_home/database directory.

4. Then browse to oracle_home from the command prompt and then run those command.

Regards

Anindya

Edited by: Anindya Bose on Apr 2, 2010 4:45 PM

[Former Member · Accepted solution]

Hello Sir,

MySystem Name : ECC6

SID : ECC

DBID : ECC

Domain Name : ABC.COM

COmputer Name : ECC6.ABC.COM

i allready login in eccadm

And one more thing i don't have SAPDBA Group in my Active Directory Services.

[anindya_bose · Accepted solution]

I guess your server is windows.

Right click on My Computer -> Manage-->Local Users and Groups ---> Groups

Check if ORA_DBA and ORA_SID_DBA groups are available. If available then go to

Local Users and Groups ---> user and double click on eccadm user. In the member of tab you can see eccadm belongs to which groups. Make sure you have ORA_DBA ,ORA_SID_DBA, Administrators under eccadm.

[Former Member · Accepted solution]

Hello Sir,

As per your instruction all setting are Ok.

I thing u have to know about my settings,

First i install Win. 2003 Server Than Create a Domain ABC.COM

Than i am installing sap. all phases are done but at the Perform Post-Load Activity phase comes it will give error in brconnect log.

Error is

BR0801I BRCONNECT 7.00 (18)

BR0280I BRCONNECT time stamp: 2012-04-02 17.25.01

BR0301E SQL error -1017 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance ECC failed

BR0280I BRCONNECT time stamp: 2012-04-02 17.25.01

BR0804I BRCONNECT terminated with errors

After Error when i search on net than i konw import sapdba_role.sql than it will solved it

Regds,

Vishal

[anindya_bose · Accepted solution]

Try the following

from teh command prompts

sqlplus /nolog

Now you will get sql prompt. Run sapdba_role with the full path like below

> @<Drive Name>:\oracle\<SID>\102\database\sapdba_role SAPSR3 NT

[Former Member · Accepted solution]

Hello Sir,

i try but it is disconnect from oracle

C:\Documents and Settings\eccadm>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 2 17:46:46 2012

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> @d:\oracle\product\10.2.0\ecc\database\sapdba_role.sql SAPSR3

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Pr

oduction

With the Partitioning, OLAP and Data Mining options

C:\Documents and Settings\eccadm>

Rgds,

Vishal

[anindya_bose · Accepted solution]

Hello Vishal

That means it has run successfully.

If you open the sapdba_role.sql script you will find in the last line there is "exit;".

Disconnected from oracle message you are getting because the script has run successfully.

To make sure, you can login to oracle

sqlplus /nolog

connect /as sysdba

and then type "exit;". you will get the same message .

One more point , now you have done it for ABAP shcema. Same way do for java schema SAPSR3DB by running the command

Cheers.

Regards

Anindya

Edited by: Anindya Bose on Apr 2, 2010 6:01 PM

[Former Member · Accepted solution]

Hello Sir,

Ohhh......................

Thank You Very Much for fast reaply

Regds,

Vishal

[anindya_bose · Accepted solution]

Vishal

Check the log file of SAPDBA_ROLE in C:\Documents and Settings\ECCADM. In the log file you will get lots of grant success message and some "ORA-00942: table or view does not exist"

You can ignore them.

One more thing, if your question is answered then mark this thread as "Answered"

Regards

Anindya

[Former Member · Accepted solution]

Hello Sir,

Still i have same problem when i am going to install sap further ...

[anindya_bose · Accepted solution]

Vishal

You should open a new thread and tell your problem there. This should be marked as "answered" if you have successfully granted SAPDBA_Role. Please read rules of engagement http://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement.

Anyways, for your issue you can look at the below threads

you can try to change the password of SAPSR3 by BRTOOLS and then proceed.

Regards

Anindya

[Former Member]

Thank You very much for reply immediate.

Rgds,

Vishal