DevOps and System Administration Discussions
Dive into SAP DevOps and system administration. Join discussions to collaborate on optimizing workflows, share knowledge, and leverage resources effectively.
cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans -d shows error Ora - 38802 edition does not exist

0 Kudos
971

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'

7 REPLIES 7

S_Sriram
Active Contributor
0 Kudos
594

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

0 Kudos
594

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.

S_Sriram
Active Contributor
0 Kudos
594

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

0 Kudos
594

Thanks Sriram,

We followed given link as well, but still error exists.

kaus19d
Active Contributor
0 Kudos
594

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

0 Kudos
594

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.

kaus19d
Active Contributor
0 Kudos
594

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