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

[former_member300218]

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.

[former_member661927]

Hello.

This is a new connect procedure called SSFS (Secure Storage in File System), used in new kernel version and Oracle 11.2.

Check the Note 1639578 - SSFS as password storage for primary database connect

"Refer to the relevant platform note for the name of the database connect user, for the information about whether the parameter DB_CONNECT/DEFAULT_DB_CON_ENV is required, and its exact format, if required.

Proceed as follows:

• Log on to SAPGLOBALHOST as the <sid>adm user.
• Make sure that the environment variables RSEC_SSFS_DATAPATH and RSEC_SSFS_KEYPATH are set.
• Use the command line tool of the secure storage rsecssfx from the SAP kernel to add entries for the user <name> and the password <pwd>, and to add any information about the target database as follows:
  
  rsecssfx put DB_CONNECT/DEFAULT_DB_USER <name> -plain
  rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <pwd>"

e.g. As root user:

rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD abc123

I hope that solves this issue

Regards!

Mauricio

[Former Member]

I have the same error, anyone have the solution to it?

[former_member661927]

Hello Maria,

Try to set the parameter SEC_CASE_SENSITIVE_LOGON=FALSE in init<SID>.ora, restart the database and try again.

More information in Note 1617976 - Case sensitive logon with Oracle 11g

I always set this for installation that no need password complexity.

regards,

Mauricio

[former_member300218]

Hi Mauricio,

After set this parameter as false, the error continues. What else can I try?

[Former Member]

Hi,

could you provide the log from file sapinst_dev.log?

it might be your password policy, have you password with special character, line @, *.. please remove. these wont be recognized.

Pleease update.

Thanks

Jansi

[former_member300218]

Of course,

sapinst_dev.log

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

TRACE      2013-04-16 15:49:28.362 [iaxohsqlx.hpp:1026]

           COraSQLScriptExec<LoggingStrategy>::executeScript()

Executable started and waited successfully. Return code = 1935

TRACE      2013-04-16 15:49:28.362 [iaxohsqlx.hpp:1053]

           COraSQLScriptExec<LoggingStrategy>::executeScript()

COraSQLScriptExec<LoggingStrategy>::executeScript: Script executed with error return code or executable terminated abnormally.

TRACE      2013-04-16 15:49:28.362

OraSqlScript3.execute: Result of SQL:

{errorMessage: "Executable G:\\oracle\\<SID>\\11203/bin/sqlplus returns 1935.", executionWasSuccessful: false}

ERROR      2013-04-16 15:49:28.362 [iaxxinscbk.cpp:277]

CJS-00084  SQL statement or script failed. DIAGNOSIS: Error message: Executable G:\oracle\<SID>\11203/bin/sqlplus returns 1935.. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.

TRACE      2013-04-16 15:49:28.362 [iaxxejsbas.hpp:424]

           handleException<ESAPinstException>()

Converting exception into JS Exception Exception.

TRACE      2013-04-16 15:49:28.362

Function setMessageIdOfExceptionMessage: modlib.jslib.caughtException

ERROR      2013-04-16 15:49:28.362

           CJSlibModule::writeError_impl()

MUT-03025  Caught ESAPinstException in module call: .

TRACE      2013-04-16 15:49:28.378 [iaxxejsbas.hpp:503]

           EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

ERROR      2013-04-16 15:49:28.425 [sixxcstepexecute.cpp:995]

FCO-00011  The step createJavaSchemaUser with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind|ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|ora|0|NW_OraDBMain|ind|ind|ind|ind|main|0|NW_OraDBStd|ind|ind|ind|ind|std|0|NW_OraDbSchema|ind|ind|ind|ind|schema|0|createJavaSchemaUser was executed with status ERROR ( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: Executable G:\oracle\<SID>\11203/bin/sqlplus returns 1935.. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.).

TRACE      2013-04-16 15:49:28.643 [kdxxctaco.cpp:224]

           CKdbTableContainerImpl::syncToContainerFile lib=iakdblib

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2013-04-16 15:49:29.737 [kdxxctaco.cpp:256]

           CKdbTableContainerImpl::syncToContainerFile lib=iakdblib

after creating out stream

TRACE      2013-04-16 15:49:30.706 [kdxxctaco.cpp:290]

           CKdbTableContainerImpl::syncToContainerFile lib=iakdblib

CKdbTableContainerImpl::syncToContainerFile stop ...

INFO       2013-04-16 15:49:30.737 [synxcpath.cpp:814]

           CSyPath::createFile() lib=syslib module=syslib

Creating file C:\Program Files\sapinst_instdir\SOLMAN71\SYSTEM\ORA\CENTRAL\AS\__instana_tmp.xml.

TRACE      2013-04-16 15:49:33.940

SAPInst calls the LogInquirer. The output of the LogInquirer can be found in file sapinst_loginquirer.log.

TRACE      2013-04-16 15:49:34.378 [iaxxgenimp.cpp:745]

            CGuiEngineImp::showMessageBox

<html> <head> </head> <body> <p> An error occurred while processing option <i>SAP Solution Manager 7.1 Support Release 1 > SAP Systems > Oracle > Central System > Central System( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: Executable G:\oracle\<SID>\11203/bin/sqlplus returns 1935.. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.)</i>. You can now: </p> <ul> <li> Choose <i>Retry</i> to repeat the current step. </li> <li> Choose <i>Log Files</i> to get more information about the error. </li> <li> Stop the option and continue with it later. </li> </ul> <p> Log files are written to <code>C:\Program Files/sapinst_instdir/SOLMAN71/SYSTEM/ORA/CENTRAL/AS</code>. </p> </body></html>

TRACE      2013-04-16 15:49:34.378 [iaxxgenimp.cpp:1259]

           CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

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

The password doesn't contain any special characters, only letters and numbers.

Thank you for your quick answer.

[former_member189797]

Hello,

Could you please let me know which tool are you using?? Is it a system copy or Fresh installation?

Regards,

Gaurav

[former_member300218]

I'm using Software Provisioning Manager 1.0 and it's a fresh installation.