Error at SAP ERP 2005 SR2 IDES installation with Oracle on Linux RHEL5

[Former Member]

Hi gurus,

I am trying to install SAP ERP 2005 SR2 IDES with Oracle on RHEL5.

When sapinst at 13th phase of 45 (Create database), it gives some errors:

ERROR 2010-03-09 15:41:33

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-955 for defaultdest

SQL> Rem bnainani 11/29/00 - specify compatible=8.0 for create_queue_table

SQL> Rem liwong 10/20/00 - add def$_destination.flag

SQL> Rem bnainani 11/15/00 - specify compatible=8.0 for queue table

SQL> Rem narora 09/13/00 - add comment on new def$_destination columns

SQL> Rem liwong 09/01/00 - add master w/o quiesce: fixes

SQL> Rem liwong 07/12/00 - add total_prop_time_lat

SQL> Rem liwong 06/29/00 - add total_txn_count, total_prop_time

SQL> Rem liwong 05/17/00 - add_master_db w/o quiesce

SQL> Rem jstamos 05/17/00 - add_master_db w/o quiesce

SQL> Rem elu 01/24/00 - add column apply_init to def$_destination

SQL> Rem alakshmi 12/02/99 - Bug 979398: Before-row insert trigger on

SQL> Rem def$_propagator

SQL> Rem wesmith 10/31/98 - change shape of table def$_pushed_transactions

SQL> Rem jnath 02/23/98 - bug 601972: split anonymous pl/sql blocks

SQL> Rem wesmith 01/21/98 - create def$_pushed_transactions table for

SQL> Rem server-side RepAPI

SQL> Rem nbhatt 07/27/97 - change create_queuetable -> create_queue_table

SQL> Rem nbhatt 04/21/97 - change 'TRACKING' in CREATE_QUEUE to 'DEPENDENCY

SQL> Rem nbhatt 04/21/97 - change syntax of create_queue

SQL> Rem liwong 04/16/97 - Alter view system.AQ$DEF$_AQ{CALL,ERROR}

SQL> Rem liwong 04/11/97 - Fixing defaultdest_primary typo

SQL> Rem jstamos 04/10/97 - remove unneeded indexes

SQL> Rem nbhatt 04/08/97 - change create_qtable to create_queuetable

SQL> Rem jstamos 04/04/97 - tighter AQ integration

SQL> Rem liwong 04/02/97 - Add schema_name, package_name in def$_calldest

SQL> Rem ato 03/31/97 - create_qtable interface change

SQL> Rem liwong 03/25/97 - remove batch_no from def$_tranorder

SQL> Rem liwong 02/24/97 - pctversion --> 0 for def$_aqcall, def$_aqerror

SQL> Rem liwong 02/22/97 - Remove dropping view aq$def$_aqcall

SQL> Rem ademers 02/07/97 - Remove constraint def$_calldest_call

SQL> Rem liwong 01/11/97 - drop and create aq$def$_aqcall (temporary)

SQL> Rem liwong 01/10/97 - Alter view aq$def$_aqcall

SQL> Rem liwong 01/07/97 - Alter default value for batch_no

SQL> Rem jstamos 12/23/96 - change temp$nclob col

SQL> Rem jstamos 11/21/96 - nchar support

SQL> Rem sjain 11/11/96 - Remove dummy buffer # comment

SQL> Rem asgoel 11/05/96 - Disable misc_tracking in def$_aqerror

SQL> Rem sjain 11/06/96 - deferror changes

SQL> Rem vkrishna 10/28/96 - change STORED IN to STORE AS for lob

SQL> Rem sjain 10/02/96 - Aq conversion

SQL> Rem sbalaram 09/24/96 - ARPC performance - add foreign key index

SQL> Rem jstamos 09/06/96 - rename temp$lob and temporarily change nclob

SQL> Rem sjain 09/03/96 - AQ converson

SQL> Rem ademers 08/02/96 - queue_batch default in def_destination

SQL> Rem ademers 07/29/96 - queue_batch default in def_call

SQL> Rem ademers 07/29/96 - queue_batch default

SQL> Rem jstamos 07/24/96 - add system.temp$lob

SQL> Rem sbalaram 07/22/96 - create def$_aqcall and def$_aqerror tables

SQL> Rem jstamos 06/12/96 - LOB support for deferred RPCs

SQL> Rem ldoo 06/28/96 - Comment out queue_table from def_tranorder

SQL> Rem ademers 05/30/96 - create def_origin

SQL> Rem ademers 05/28/96 - fix def_destination col names

SQL> Rem ldoo 05/09/96 - New security model

SQL> Rem sjain 05/01/96 - add seq col to def_destination

SQL> Rem ademers 04/29/96 - add batch_no, dep_scn to def_call

SQL> Rem jstamos 12/04/95 - 324303: use index to avoid sorting the queue

SQL> Rem jstamos 08/17/95 - code review changes

SQL> Rem jstamos 08/16/95 - add comments to tables

SQL> Rem wmaimone 01/04/96 - 7.3 merge

SQL> Rem hasun 01/31/95 - Modify tables.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2010-03-09 15:41:33

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

ERROR 2010-03-09 15:41:33

FCO-00011 The step runCatprocSql 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|in

d|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_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with

status ERROR .

How can I solve this problem and continue the installation. Please help me.

Thanks.

Ozgur

Edited by: ozgur_tas on Mar 9, 2010 3:02 PM

[markus_doehr2 · Accepted solution]

> How can I solve this problem and continue the installation. Please help me.

Did you install all the patches?

10.2.0.4 plus all interim patches with OPatch?

Markus

[Former Member · Accepted solution]

Yes, I have installed 10.2.0.4 patch and all interim patches with OPatch.

[markus_doehr2 · Accepted solution]

Ok...

I'd try the following:

- stop sapinst

- open keydb.xml

- search for ERROR (next to a CDATA)

- change it to "OK"

- restart sapinst

Markus

[Former Member · Accepted solution]

Hi,

It works, thank you for help.

Ozgur

[Former Member · Accepted solution]

Dear Markus,

This has worked and migration has moved forward .

Regards,

Rahul.

[Former Member · Accepted solution]

Hi Markus,

I have same problem and your solution looks fine , I will try your solution by changing keydb.xml file.

I have also applied oralce patch and at 10.2.0.4

Just wondering what caused of this problem , is there any other solution with any other oracle interim patch ? or this is just a bug ?

I have also installed other systems same way , didnot have any problem.

Thanks

Al Mamun

[Former Member · Accepted solution]

HI Markus,

I was having same error while ECC 6.0 installation on HP-UX and Oracle 10.2.0.4 db.

The solution given by you worked for me. But in addition with solution provided by you, I had to do activity mentioned in blog http://scn.sap.com/message/8973918 with solution given by Mark.

Thanks & Regards,

Ishan