Erro during the SAP System Copy - unable to assign default tablespace to user: SAPSR3 (ORA-01920)

[joo_migueldimas]

Hello,

DB: Oracle 11.2g (11.2.0.4)

OS: Windows Server 2012 (R2)

I´m doing a homogeneous system copy and during the software provisioning manager tool, in target server, it stopped with the following error in the phase "Adapt database schema":

I checked the log files and this is the output of them:

- ora_sql_results.log:

...

.  Oracle Version:

11.2.0.4.0

.  Parametervalue os_authent_prefix:   OPS$

.  Schema Id:			SR3
.  Database User (Schema):	SAPSR3
.  SAP R/3 Administrator:	OPS$PTDIR\DEVADM
.  SAP R/3 Serviceuser:	OPS$PTDIR\SAPSERVICEDEV

.  ASM Parameter:

.  Create SAPUSER env:		0
.  Domain/Host:		PTDIR

.

CREATE user done: SAPSR3

unable to assign default tablespace to user: SAPSR3

begin

*

ERROR at line 1:

ORA-01920: user name 'SAPSR3' conflicts with another user or role name

ORA-06512: at line 103

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SAPINST: End of output of SQL executing program E:\oracle\DEV\11204/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2016-03-14, 12:07:56 SAPINST ORACLE stop logging

- alert_<sid>.log:

...

USER (ospid: 2100): terminating the instance due to error 119

Instance terminated by USER, pid = 2100

Mon Mar 14 11:36:26 2016

Starting ORACLE instance (normal)

Specified value of sga_max_size is too small, bumping to 872415232

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

...

I also checked the dba_users table and this is the output:

Can you please help me to correct this error?

Best regards,

João Dimas

[Former Member · Accepted solution]

Hallo,

maybe 1933308 - ORA-28007 error in System Copy??

Regards

Thomas

[joo_migueldimas · Accepted solution]

Hello Thomas,

Thanks for your help, but I believe that SAP note is not related with my error! I had read that sap note but doesn´t seems the solution for my problem because, for example, I don´t see in my case the error ORA-28007 and besides of that I checked the output of the following command and it seems that normal output:

select profile, limit from dba_profiles where RESOURCE_NAME='PASSWORD_LIFE_TIME;

Thanks,

BR,

João Dimas

[Sriram2009 · Accepted solution]

Hi Joao

Could you share the full log?

Regards

SS

[joo_migueldimas · Accepted solution]

Hello SS,

Of course... here it is, attached to this message.

BR,

João Dimas

oradbusr.txt.zip

alert_dev.txt.zip

ora_sql_results.txt.zip

[Sriram2009 · Accepted solution]

Hi

Thanks for info. I think its related to Share memory issue. Is it possible do the full system restart and then retry again in the same phase.

Regards

SS

[joo_migueldimas · Accepted solution]

Hello SS,

You´re the man

I did exactly what you recommended.

1. Stop the oracle database (shutdown immediate;)

2. Start the oracle database (startup;)

3. Retry the SWPM tool from the same phase.

Solved!

Thank you SS

BR,

João Dimas