cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ECC6.0 Installation problem as abap on oracle 10g

Former Member
0 Kudos

Hi guru's

i am facing following error during installation of SAP ECC6.0

development server with oracle 10g (10.1) database & windows 2003 server OS.

During the installation step "create database statistics" following error occured.

ERROR 2009-03-07 03:23:40

CJS-30023 Process call 'D:\usr\sap\DEV\SYS\exe\uc\NTI386\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -p 2' exits with error code 5. For details see log file(s) brconnect.log.

ERROR 2009-03-07 03:23:40

FCO-00011 The step createOracleStatistics 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_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|0|0|NW_ORA_Statistics_Create|ind|ind|ind|ind|0|0|createOracleStatistics was executed with status ERROR .

-


brconnect.log

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0301E SQL error -1001 in thread 2 at location stats_ind_collect-3, SQL statement:

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

ORA-01001: invalid cursor

ORA-06512: at "SYS.DBMS_STATS", line 10621

ORA-06512: at "SYS.DBMS_STATS", line 10645

ORA-06512: at line 1

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

BR0280I BRCONNECT thread 2: time stamp: 2009-03-07 03.23.39

BR0844E 100 errors occurred in thread 2 - terminating processing of the thread...

BR0280I BRCONNECT time stamp: 2009-03-07 03.23.39

BR0848I Thread 2 finished with return code -1

BR0280I BRCONNECT time stamp: 2009-03-07 03.23.39

BR0879I Statistics checked for 22 tables

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 0/14 tables/indexes

BR1308E Collection of statistics failed for 17956/17936 tables/indexes

BR0806I End of BRCONNECT processing: cepzzztx.sta 2009-03-07 03.23.39

BR0280I BRCONNECT time stamp: 2009-03-07 03.23.40

BR0804I BRCONNECT terminated with errors

-


Regards

Manvir Bhatia

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Problem resolved after rebooting the os & continuing the old installation. Oracle database version is 10.1 only. Now system is working fine.

Thanks for your inputs

Manvir Bhatia

former_member603052
Contributor
0 Kudos

Hi Manvir,

Yes, Oracle 10.1 version is not supported as Mahesh already told you . Try applying patch 10.2 or 10.4

Regards,

Kalyan

Former Member
0 Kudos

Hi,

Your DB is running on 10.1, it is not recommended. Update the patch to 10.2.0.2 and apply the interim patches. Then retry the installation.

Mahesh