HI,
I am currently trying to prepare an Oracle Database (which uses ASM for the Tablespaces) for our new wM 10.11 production.

Which tablespace directory needs to be specified in this case in DB Configurator when using automatic Tablespace and User creation?

@ Holger von Thomsen could you please help on this

for Index and Data

yes while runiing db configurator we would be supplying table space directory along with db credentials in addition to custom table space names,so for Oracle ASM based storage db team has given directory structure-+DON_DATA/DEVON/DATAFILE.it’s throwing below error,when supplied in the tablespace directory of the db configurator,

image1050×293 9.07 KB

Hi Sangamesh,

can you try with tabelspace directory as “+DATA”?
The database itself will then translate this to the correct path on the ASM disks internally.
This worked for my Oracle Databases which are already using ASM.

Regards,
Holger

Hi Holger,

Thanks for your response.it worked.

Hi Holger,

Thanks for responding, after entering the table spacedirectory text box with value as +DATA,now i am getting below error,not sure where it’s going wrong,could you please help.

status       : executing

error: java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into (“BAM_USER”.“COMPONENT_EVENT”.“COMPONENT_EVENT_ID”)