cancel
Showing results for 
Search instead for 
Did you mean: 

ECC 6.0 Ehp4 to Ehp6: Renaming table REPOSRC not allowed

Former Member
0 Kudos
147

Hi,

I am trying to upgrade a customer's sandbox system (ECC 6.0 Ehp4 SPS08 on Solaris 10, Oracle 11.2.0.3) to Ehp6 using Software Update Manager 1.0 SP5. During the MAIN_SWITCH/EU_SWITCH phase, I encounter the following error in SUM:

Severe error(s) occured in phase MAIN_SWITCH/EU_SWITCH!
Last error code set: Calling '/sap/D12/SUM/abap/exe/tp' failed with
return code 237, check /sap/D12/SUM/abap/log/TPSQLSTD.OUT for details

 

The error in TPSQLSTD.OUT points to /sap/D12/SUM/abap/log/TPSQLSTD.OU5
which shows the following:

This is tp version 380.03.82 (release 720, unicode enabled)
ERROR: Statement: RENAME "REPOSRC" TO "REPOSRC~~OLD"
ERROR: SQL ERROR 26563: ORA-26563: renaming this table is not allowed

At the moment I am unable to login to the ECC instance and the shadow instance (probably because of the switch over). Is there anything I can do to resolve this issue?

Accepted Solutions (1)

Accepted Solutions (1)

former_member264034
Active Contributor
0 Kudos

Hi,

Error ORA-26563 means that this table is replicated, an updatable
snapshot table or the master table of a snapshot for which a snapshot
log has been created. It is not possible to rename a snapshot table,
therefore you will need to drop the snapshot on this table.

To drop snapshot on the table , you can execute in sqlplus:
  drop snapshot log on sap<SID>.<tablename>

For more details, please refer Oracle Metalink note 102695.1.

Regards,

Aidan

Former Member
0 Kudos

Hi Aidan,

Thanks for the reply. I unfortunately don't have access to the Oracle Metalink docs because Oracle was purchased via SAP.

Before I drop the snapshot, how can I validate that it exists? Edit: I ask this because I'm not familiar with Oracle and just want to understand how it works before I drop the snapshot.

Regards,

Doug

former_member264034
Active Contributor
0 Kudos

Hi,

You will only drop the snapshot on the table so there will be no data loss.

The error ORA-26563 indicates that there is a snapshot log created on

this table REPOSRC.

As SAP does not create snapshots, you need to drop this

snapshot (using sqlplus: drop snapshot log on REPOSRC ).

After that you can continue the phase.

Regards,

Aidan

Former Member
0 Kudos

Hi,

I ran the command "drop snapshot log on SAPSR3.REPOSRC;" in SQL plus and was able to move forward with the upgrade.

I'll mark this as Helpful Answer for now until I complete the upgrade and validated that everything is working fine. Thanks for your help Aidan!

Regards,

Doug

Former Member
0 Kudos

Hi Doug,


ORA-26563 happens in case of an attempt to rename a replicated table, an updatable snapshot table or the master table of a snapshot for which a snapshot log has been created.  When you create a snapshot log Oracle creates an MLOG$ table to store changes made to the base table.  Renaming the base table fails because of the relationship between the base table and the MLOG$ table.


Regards,

Sachin

Answers (0)