on 04-15-2010 9:01 AM
Hi,
I installed a new sandbox system and did a restore from our DEV system. I changed the xuser SAPR3 entry to match that of the DEV system but the workprocess trace is telling me user SAPR3 is using the wrong schema and so the system will not start.
C *** ERROR => the connected user (SAPR3) does not work with the right user/schema
[dbslsdb.cpp 4846]
C *** ERROR => application has to work with schema SAPSNB (dbs/ada/schema)
[dbslsdb.cpp 4848]
How do I change the schema for the SAPR3 user ? (I couldn't find any notes/docs on this)
Thanks !
Regards,
Nelis
ps. using MaxDB 7.6.06.09 64bit on Linux.
Hi,
Try to use profile parameter dbs/ada/schema=SAPR3
also check Note 39439 - XUSER entries for SAP DB and MaxDB
regards,
kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I actually found the answer in [Note 129352 - Homogeneous system copy with MaxDB (SAP DB)|https://service.sap.com/sap/support/notes/129352] to replace profile parameter dbs/ada/schema with SAPR3. So Kaushal was correct
Thanks !
Nelis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nelis,
Are you sure that SAPR3 is not the sql mode in the xuser entries?
Can you post the output of: select username from all_users
You probably have to add SAPDEV (if DEV is your development SID) to the xuser file.
Kind regards,
Mark Dijsselbloem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
26 | |
10 | |
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.