Skip to Content
author's profile photo
Former Member

Error during Phase "Create database schema" - ORA-01940: cannot drop a user

I have installed SolutionManager 4 on Linux SLES 10 that uses Oracle 10.2 (all patches and patch sets have been applied). After the installation I did not the database and sap were up and running. I was able to access them through the Windows GUI.

Next I wish to install ERP on the same machine that has the SolutionManager installed. For the input parameters of the installation, I chose Central Instance (instance 00), Existing SLD, default ABAP schema and user SAPSR3.

During the installation phase 10 "Create database schema", I am getting the following error:

##########################

Content of sapinst.log:

INFO 2007-09-28 16:33:21

Working directory changed to /tmp/sapinst_instdir/ERP/SYSTEM/ORA/CENTRAL/AS.

ERROR 2007-09-28 16:33:21

CJS-00084 SQL statement or script failed.DIAGNOSIS: Error message: ORA-01940: cannot drop a user that is currently connected

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

.SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2007-09-28 16:33:21

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2007-09-28 16:33:21

FCO-00011 The step createABAPSchemaUser with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBMCOD|ind|ind|ind|ind|2|0|NW_OraDbSchema|ind|ind|ind|ind|5|0|createABAPSchemaUser was executed with status ERROR .

##########################

Content of ora_sql_results.log:

2007-09-28, 16:33:21 SAPINST ORACLE start logging for

DROP USER "SAPSR3" CASCADE;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Sep 28 16:33:21 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

DROP USER "SAPSR3" CASCADE

*

ERROR at line 1:

ORA-01940: cannot drop a user that is currently connected

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

SAPINST: End of output of SQL executing program /oracle/SDB/102_64/bin/sqlplus.

SAPINST found errors.

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

2007-09-28, 16:33:21 SAPINST ORACLE stop logging

#########################

Any idea what might have caused this? What is this user SAPSR3 and why does it connect to the database?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:02 PM

    sorry, i posted before you wrote the answer of my first question:)

    Didn't you define your database schemaID during the installation?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There are more than 30 entries for SAPSR3 username in V$SESSION

      Status of v$instance is: open

      Before starting the ERP installation, am I supposed to stop the database?

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 09:48 PM

    Hello Andrew,

    do you have an DB User which is called SAPSR3?

    <b><i>select username from dba_users where username like '%SAP%';</i></b>

    If yes, can you log on to the database with this user?

    best regards

    Baran

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes, I have the user SAPSR3 and was able to connect using it.

      ###############################

      SQL> select username from dba_users where username like '%SAP%';

      USERNAME

      -


      OPS$SAPSERVICESSS

      SAPSR3

      SAPSR3DB

      SQL> connect

      Enter user-name: SAPSR3

      Enter password:

      Connected.

      SQL>

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 09:59 PM

    Is there also an DB User SAPSR3DB? I think SAPSR3 ist ABAP Default name for NetWeaver ABAP+Java Installationen, the Java database schema is called SAP<SCHEMA_ID>DB. Default name is SAPSR3DB.

    How is dbs_ora_schema set?

    Add comment
    10|10000 characters needed characters exceeded