SAP installation error

[Former Member]

During IDES installation when I come in Create database statistics it stop .

when I check Log

C:\Program Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS\sapinst.log

BR0280I BRCONNECT thread 1: time stamp: 2012-06-09 15.00.36

BR0850I 86 of 155 objects processed - 0.117 of 0.211 units done

BR0204I Percentage done: 55.48%, estimated end time: 15:04

BR0001I ****************************______________________

BR0280I BRCONNECT thread 1: time stamp: 2012-06-09 15.00.36

BR0301E SQL error -3114 in thread 1 at location stats_ind_collect-2, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"DDMTT~0"', ESTIMATE_PERCENT => 1, DEGREE => NULL, NO_INVALIDATE => FALSE); END;'

ORA-03114: not connected to ORACLE

BR0886E Checking/collecting statistics failed for index SAPSR3.DDMTT~0

BR0280I BRCONNECT thread 1: time stamp: 2012-06-09 15.00.36

BR0301E SQL error -3114 in thread 1 at location stats_ind_collect-2, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"DDNTDONE~0"', ESTIMATE_PERCENT => 1, DEGREE => NULL, NO_INVALIDATE => FALSE); END;'

ORA-03114: not connected to ORACLE

BR0886E Checking/collecting statistics failed for index SAPSR3.DDNTDONE~0

BR0280I BRCONNECT thread 1: time stamp: 2012-06-09 15.00.36

BR0301E SQL error -3114 in thread 1 at location stats_ind_collect-2, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"DDNTF_CONV_UC~0"', ESTIMATE_PERCENT => 1, DEGREE => NULL, NO_INVALIDATE => FALSE); END;'

ORA-03114: not connected to ORACLE

BR0886E Checking/collecting statistics failed for index SAPSR3.DDNTF_CONV_UC~0

BR0280I BRCONNECT thread 1: time stamp: 2012-06-09 15.00.36

BR0301E SQL error -3114 in thread 1 at location stats_ind_collect-2, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"DDNTF_HIST~0"', ESTIMATE_PERCENT => 1, DEGREE => NULL, NO_INVALIDATE => FALSE); END;'

ORA-03114: not connected to ORACLE

BR0886E Checking/collecting statistics failed for index SAPSR3.DDNTF_HIST~0

BR0280I BRCONNECT thread 1: time stamp: 2012-06-09 15.00.36

BR0301E SQL error -3114 in thread 1 at location stats_ind_collect-2, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPSR3"', INDNAME => '"DDNTT_CONV_UC~0"', ESTIMATE_PERCE

I check my Oracle stop . I again start my Oracle and retery . But after some time problem is same.

C:\Documents and Settings\Administrator>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 9 16:31:04 2012

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

Enter user-name: /as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

I also done set oracle_SID=IDE

But problem again and again

kavi

I

[former_member185031 · Accepted solution]

>SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 9 16:31:04 2012

You should install the patch first either 10.2.0.2.0 or 10.2.0.4.0

Regards,

Subhash

[markus_doehr2 · Accepted solution]

> >SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 9 16:31:04 2012

>

> You should install the patch first either 10.2.0.2.0 or 10.2.0.4.0

I'd go even further and suggest: Reinstall the system.

10.2.0.1 was never supported and has SERIOUS bugs. He may already have corrupt blocks in the database.

Markus

[Former Member · Accepted solution]

Thanks all of you . now i have fresh installed SAP Ides . It working fine.

thankskavi