DROP USER "SAPSR3" CASCADE

[Former Member]

Hi all,

I am installing SAP ERP 2005 support Release 2 on Linux 5.1. I use Oracle database. I installed to step "create database schema", it is error. I view sapinst.log, it is show below

"ERROR 2009-02-20 13:57:29

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-00604: error occurred at recursive SQL level 2

ORA-08103: object no longer exists

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

With the Partitioning, OLAP and Data Mining options

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

ERROR 2009-02-20 13:57:29

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

ERROR 2009-02-20 13:57:29

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 .

"

I view ora_sql_results.log, it is show below

"DROP USER "SAPSR3" CASCADE

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 2

ORA-08103: object no longer exists

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

With the Partitioning, OLAP and Data Mining options

SAPINST: End of output of SQL executing program /oracle/TOT/102_32/bin/sqlplus.

SAPINST found errors.

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

2009-02-20, 13:57:29 SAPINST ORACLE stop logging

"

[Former Member · Accepted solution]

Hi,

Check note 1003936.

Regards,

Sachin Rane.

[Former Member]

Hi,

I checked alert_<SID>.log, Content of log do not appear ORA_xxxx. But, content is show below:

"Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

RPATH = /ade/aime_has_30063/oracle/has/lib/:/ade/aime_has_30063/oracle/lib/:/ade/aime_has_30063/oracle/has/lib/:

LD_LIBRARY_PATH = /tmp/sapinst_exe.8534.1235196084

The default library directories are /lib and /usr/lib

Unable to find dynamic library libocrb10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

Unable to find dynamic library libocrutl10.so in search paths

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.2.0.

"

I do not know,Was It affected my system?

[Former Member]

Hello,

since the error is occuring at a recursive SQL statement, the problem must be related to the objects of the oracle dictionary. Therefore, you should verify the consistency of the dictionary in the first step. This can be done with the following command:

brconnect -u / -c -f stats -t oradict_tab -v

I am not quite sure whether the OPS$ user already exists at this point in time during the installation so it might be necessary to specify "-u system/<password>" instead of "-u /". Are any errors returned here?

Best Regards,

Michael

[Former Member]

Hi,

Both ora-00604 and ora-08103 are pointing towards block corrupution. Could you please check your alertSID.log file for more ora-XXX errors.

Also check SAP note 365481.

Regards,

Sachin Rane.

[Former Member]

Hi,

I do not think, this is solution. Do you have anything another solution?

Thanks & Regards

Minh Duy