cancel
Showing results for 
Search instead for 
Did you mean: 

import sapdba_role on 10g

Former Member
0 Kudos

Hello,

I'm following the Oracle Upgrade Guide_211 for Oracle upgrade to 10.2.0.2 of our test system. It's SAP R/3 4.6C with 4.6D_EXT supp. pack 2271, HP-UX 11.11 and Oracle 9.2.0.5

I have successfully upgraded the DB and now I'm on the Updating BR*Tools step.

I have to update the sapdba_role like in the Note 134592 - Importing the SAPDBA role ( sapdba_role.sql)

"Oracle 10g: sqlplus /nolog @sapdba_role <SAPSCHEMA_ID>

Where <SAPSCHEMA_ID> is the schema ID of the SAP database user:

- for User SAPR3: R3.

- for User SAP<SID>: <SID>

- for User SAP<SID>DB: <SID>DB"

Can you PLS help me understand what should be the command in my case?

  1. sqlplus /nolog @sapdba_role SAPR3

or like I always used for 9i environment

  1. sqlplus /nolog @sapdba_role <SID> UNIX

Thanks in advance,

Many regards,

Ruzica

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ruzika,

After Oracle 10g upgrade to update SAPDBA role, use

For ABAP schema:

  1. sqlplus /nolog @sapdba_role <SAPSCHEMA ID>

eg: if your schema is SAPR3E

  1. sqlplus /nolog @sapdba_role R3E

For JAVA schema:

  1. sqlplus /nolog @sapdba_role <SAPSCHEMA ID>DB

eg: if your schema is SAPJ2E

  1. sqlplus /nolog @sapdba_role J2EDB

If you have ABAP+Java, you will have to run both the commands.

Cheers,

Nisch

Former Member
0 Kudos

Hi Nisch,

thanx for the example.

I always used for 9i environment

  1. sqlplus /nolog @sapdba_role <SID> UNIX

What is the difference?

Regards,

Ruzica

Former Member
0 Kudos

Hi Ruzica,

The difference is that with 10g you are passing only one parameter to the script, it is made easier and applies to all platforms.

Hope this helps.

Cheers,

Nisch

Former Member
0 Kudos

Hello,

I also need to update BR*Tools to release 700, but when I tried to extract:

/sapmnt/TST/exe/SAPCAR -xvf DBATL700O10_24-20001032.SAR

<b>format error in header</b>

Can you pls help me where can I found corect DBATOOLS with the brtools 700?

I downloaded from:

Support Packages and Patches

Support Packages and Patches" Additional Components" SAP Kernel" SAP KERNEL 64-BIT" SAP KERNEL 7.00 64-BIT

Many regards,

Ruzica

Former Member
0 Kudos

Hi,

Probably you have an outdated SAPCAR version. Download the latest at SapNet and retry the extraction.

Best Regards,

JC Llanes.

Former Member
0 Kudos

Hi,

No, I tried with two diferent SAPCAR versions and the same format error

Regards,

Ruzica

Former Member
0 Kudos

Hi,

I just can see two possible reasons:

-Sapcar incorrect --> execute "SAPCAR" with no option, and watch the 2 final lines from output.

-Package downloaded with errors --> Try downloading it again (the path you use is the correct).

Best Regards,

JC Llanes.

Former Member
0 Kudos

Hi,

I downloaded again and tried, again format error.

I tried to unpack something else with the SAPCAR:

/sapmnt/TST/exe/SAPCAR -xvf sapdba_role_ora10.SAR

SAPCAR: processing archive sapdba_role_ora10.SAR

x sapdba_role.sql

SAPCAR: 1 file(s) extracted

I don't have any other way.

Regards,

Ruzica

Former Member
0 Kudos

Hi,

Sorry if I'm too insistent, but: can you attach the last 2 lines of "SAPCAR" output?

I suspect that's not the required version...

Regards,

JC Llanes.

Former Member
0 Kudos

Hi Ruzica, what is the problem ? it is extracted one file anyways.. I dont see any errors.

Former Member
0 Kudos

Hi Juan,

the last line from SAPCAR output is:

<b>

SAPCAR 2.0, build</b>

It's from the SAP Kernel 46D_EXT (2271) from 9 April 2006

Regards,

Ruzica

Former Member
0 Kudos

Hi manohar,

I need to extract the DBATOOLS, there is the problem.

That was example where SAPCAR unpack that sar file without errors.

Former Member
0 Kudos

Hi,

I downloaded the last version for SAPCAR and I unpacked it

THANKS

Many regards,

Ruzica