Skip to Content
0
Apr 17, 2013 at 08:31 AM

SolMan 7.1 SPS 08 installation: Error -> ORA-01935: missing user or role name

270 Views

Hi all,

I'm installing SolMan 7.1 SPS 08 with SPM 1.0 SP 01 on W2k8R2 64 bits and Oracle 11.2.03.

In the Execution step, in the task "Create database schema", I have an error.

Seeing ora_sql_results.log...

==============================================================

2013-04-16, 15:49:27 SAPINST ORACLE start logging for

@@ORA_CREATE_DBUSR.SQL

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 15:49:27 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

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

Connected.

old 4: :sSchema := upper('&&1');

new 4: :sSchema := upper('SAPSR3DB');

old 5: :passwd := '&&2';

new 5: :passwd := 'SAP';

old 6: :defTablespace := upper('&&3');

new 6: :defTablespace := upper('PSAPTEMP');

Enter value for 4:

SP2-0546: User requested Interrupt or EOF detected.

using following Parameters:

.

. Database User (Schema):

. Password: **********

. Default tablespace:

. Temporary tablespace:

.

unable to assign default tablespace to user:

begin

*

ERROR at line 1:

ORA-01935: missing user or role name

ORA-06512: at line 40

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

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

SAPINST: End of output of SQL executing program G:\oracle\<SID>\11203/bin/sqlplus.

SAPINST found errors.

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

2013-04-16, 15:49:28 SAPINST ORACLE stop logging

Any idea?

Kind regards.