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

[Former Member]

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

[Former Member]

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

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

[Former Member]

maybe your user SAPSR3 is connected to the database anywhere.

<b><i>ORA-01940: cannot drop a user that is currently connected</i></b>

[Former Member]

I think I did define it. Is there a way to check it?

Can I start a new installation? Will it mess up any of my existing SolutionManager installation?

Thanks

[Former Member]

How do I check if SAPSR3 is connected? How can i disconnect it?

[Former Member]

you can check on the database if there are still sessions which are started by this user:

<i>desc V$SESSION</i>;

something like that:

<i>select sid, username from V$SESSION

where username = <username> order by sid;</i>

which status does the database have?

select status from v$instance;

[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?

[Former Member]

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?

[Former Member]

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

[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>