2020 Feb 07 10:37 PM
During DB refresh from Production to Quality, R3trans -d ended with RC-12 and log shows the error Ora -38802 : edition does not exist error. Below are log details.
4 ETW000 R3trans was called as follows: E:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3trans.exe -d
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Fri Feb 07 01:13:31 2020
4 ETW000 [ dev trc,00000] Loading DB library 'dboraslib.dll' ...
4 ETW000 [ dev trc,00000] Library 'dboraslib.dll' loaded
4 ETW000 [ dev trc,00000] Version of 'dboraslib.dll' is "721.02", patchlevel (0.600)
4 ETW000 [ dev trc,00000] con_info_ext_support(): DBSL supports extended connect protocol
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] dbs/ora/stmt_cache_size = 250
4 ETW000 [ dev trc,00000] Register application info.
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.3.0, (dbsl 721 180915, UNICODE[2])
4 ETW000 [ dev trc,00000] Detailed Oracle client (patch) info not available.
4 ETW000 [ dev trc,00000] Fri Feb 07 01:13:32 2020
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@QAS on connection 0 (nls 0) ... (dbsl 721 180915, UNICODE[2])
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=040C8970 created, rc=0
4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=040C8970): New server hdl. srv=040C8F30 attached to 'QAS'
4 ETW000 [ dev trc,00000] Fri Feb 07 01:13:33 2020
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 38802:
4 ETW000 [ dev trc,00000] ORA-38802: edition does not exist
4 ETW000 [ dev trc,00000] OCISessionBegin(con=0, svc=040C8970, srv=040C8F30='QAS'): start session usr=040D8040='SAPSR3', rc=38802
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=040C8970): Free session hdl usr=040D8040
4 ETW000 [ dev trc,00000] OCIServerDetach(stale2 con=0, svc=040C8970, srv=040C8F30='QAS') successfully detached
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=040C8970): Server handle srv=040C8F30 freed
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service svc=040C8970 freed (i=0).
4 ETW000 [ dev trc,00000] rc=38802 -> Trying to reattach to server 'QAS'
4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0): Service svc=040C8970 created, rc=0
4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=040C8970): New server hdl. srv=040C8F30 attached to 'QAS'
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 38802:
4 ETW000 [ dev trc,00000] ORA-38802: edition does not exist
4 ETW000 [ dev trc,00000] OCISessionBegin(con=0, svc=040C8970, srv=040C8F30='QAS'): start session usr=040D29F8='SAPSR3', rc=38802
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=040C8970): Free session hdl usr=040D29F8
4 ETW000 [ dev trc,00000] OCIServerDetach(stale2 con=0, svc=040C8970, srv=040C8F30='QAS') successfully detached
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=040C8970): Server handle srv=040C8F30 freed
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service svc=040C8970 freed (i=1).
4 ETW000 [dbsloci.c ,00000] *** ERROR => CONNECT failed with SQL error '38802'
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 38802 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>ORA-38802: edition does not exist
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'QAS'
2020 Feb 08 6:04 AM
Hi Basis Team.
1. Are you executed the command r3trans -d from SIDADM user id?
2. How you did the refresh from Prod to Qas ?
Regards
SS
2020 Feb 08 9:39 AM
Hi Sriram,
Yes, command executed through sidadm. All DB post processing steps completed and this error occurred just starting before SAP application.
We did refresh through BR backup and restore method.
2020 Feb 08 2:31 PM
Hi Basis Team.
Refer the blog it may help you
https://blogs.sap.com/2013/05/31/step-by-step-system-copy-backup-restore/
Regards
SS
2020 Feb 08 9:00 PM
Thanks Sriram,
We followed given link as well, but still error exists.
2020 Feb 08 2:35 PM
Hi basis111,
Could you inform us about the DB users grant privileges details. Also please check your QAS system env values. Please let us know the if the schema conversion happened from Prod to QAS
What is the source & target Oracle version
Thanks,
Kaushik
2020 Feb 08 8:59 PM
Hi Kaushik,
Thanks for your reply. DB user were assigned grant, connect & sapdba priveleges as suggested in notes. Env variables are set properly. dbs_ora_schema is already set to SAPSR3.
Source and target are running on oracle 11.2.0.4.0.
Database: 11g Release 2
Error code: ORA-38802
Description: edition does not exist
Cause: This error occurred because a reference was made to an edition that does not exist or that the current user does not have privileges on.
Action: Check the edition name and verify that the current user has appropriate privileges on the edition.
Above is the solution from oracle side, when check on our database ora$base is the only edition, which is same in source system as well.
Not sure which user it is referring to and what privileges are required for this edition.
2020 Feb 09 11:21 AM
Hi basis111,
It would seem that in your refresh steps you may have missed replacing the PRD sid with the QAS sid, so all the ways that I can think of to approach, its better to do the restore process again, or else, its better to do the refresh via SWPM, saving your time on the correction process
Also, please provide us below output details,
select * from dba_editions;
select sys_context('userenv','current_edition_name') from dual;
what is the schema in the below query,
select UFLAG, BNAME, MANDT from <SAPschema>.USR02 where MANDT='000';
Thanks,
Kaushik