sap install: ORA-00955: name is already used by an existing object

[Former Member]

Hi there,

I have installed SAP R/3 4.7 central and database instance. Now I am installing CRM 4.0 instance. While install database instance i get the following error:

ORA-00955: name is already used by an existing object.

create table "/SAAPTRX/AOTREF" ( "CLIENT" VARCHAR2(3) .. . . . . . . )

TABLESPACE PSAPORA(where ORA is the databse name)

(few other tables also give similar error in the Logs).

SAP Notes recommend that few of the tables had to be deleted by sql commands from ORACLE database.

Please advise !

Regards,

Faiq

[Former Member · Accepted solution]

hello Faiq,

Ben has a point. Are you using the same database instance name for both 4.6 C and CRM?

Regards.

Ruchit.

[Former Member · Accepted solution]

Check the guide for MCOD (Multiple Component on one database) tht will give good idea about how you can go with this kind of installation

Arun

[Former Member]

Hi all,

I solved the issue. Actually listener number was the same for both the current and previously installed database instance. I also installed seperate database without the use of MCOD and this solved the issue !

Regards,

Faiq

[ravi_raman2]

Hi Faiq,

I seem to have run into something quite similar, i am doing a mcod install already have xi system installed successfully. However doing an mcod with the same database is throwing an error that the object is already in use...Any ideas

Regards

Ravi Raman

[Former Member]

Hi,

I have installed again with seperate database instances but still get the same error.

ORA-00955: name is already used by an existing object.

create table "/SAAPTRX/AOTREF" ( "CLIENT" VARCHAR2(3) .. . . . . . . )

TABLESPACE PSAPORA(where ORA is the databse name)

Do I need to stop any oracle or sap Service in windows services?

Please advise,

Regards,

Faiq

[Former Member]

Hi Faiq,

2 seperate SAP installation should have two seperate database instances. You can retain the same name for seperate installations. Just differentiating with the help of system numbr is not enough. Database instances should be different. CRM and SAP 4.7 database instances can not be the same.

Please award points accordingly,

Regards.

Ruchit.

[Former Member]

Hi Guys,

Thanks for the assistance. Following is the installation steps I am using.

Database instance name: ORA

intance for R/3 4/7 = 00

instance number for CRM = 01

Is this correct way to do or I should create a seperate database intance name for CRM to create a new one for CRM. Thanks.

Regards,

Faiq

[Former Member]

Hi,

Are you trying to install CRM and R/3 4.7 on same box.

Are you trying to install both on same database?

Regards

Ben