on 04-23-2007 1:44 PM
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?
sqlplus /nolog @sapdba_role SAPR3
or like I always used for 9i environment
sqlplus /nolog @sapdba_role <SID> UNIX
Thanks in advance,
Many regards,
Ruzica
Hi Ruzika,
After Oracle 10g upgrade to update SAPDBA role, use
For ABAP schema:
sqlplus /nolog @sapdba_role <SAPSCHEMA ID>
eg: if your schema is SAPR3E
sqlplus /nolog @sapdba_role R3E
For JAVA schema:
sqlplus /nolog @sapdba_role <SAPSCHEMA ID>DB
eg: if your schema is SAPJ2E
sqlplus /nolog @sapdba_role J2EDB
If you have ABAP+Java, you will have to run both the commands.
Cheers,
Nisch
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.