Solution : https://service.sap.com/sap/support/notes/1773593 (SAP Service marketplace login required)
Summary :
Creating a new Oracle database with SAPINST on ASM (Automatic Storage Management) fails due to incorrect `COMPATIBLE` parameter settings, reflected by error messages such as ORA-00200 and ORA-15001. This issue affects installations using database version 11.2.0.0.0, which is incompatible with the diskgroup. The necessary database parameter should match or exceed the compatible.rdbms version set on the ASM disk groups. The solution involves updating the COMPATIBLE parameter either by modifying the INITSID112.ORA file or setting it through the Advanced DB Configuration in SAPINST. Users can avoid this issue by using the latest version of Software Provisioning Manager.
Key words :
create database os1 controlfile reuse maxlogfiles 255 maxlogmembers 3 maxloghistory 1000 maxdatafiles 1000 maxinstances 50 noarchivelog character set utf8 national character set utf8 datafile '+data' size 350m reuse autoextend, 20m maxsize 10000m extent management local default temporary tablespace psaptemp tempfile '+data' size 300m reuse autoextend, 20m maxsize 10000m undo tablespace psapundo001 datafile '+data' size 700m reuse autoextend, 20m maxsize 32700m sysaux datafile '+data' size 200m reuse autoextend, file /oracle/os1/saptrace/diag/rdbms/os1/os1/trace/os1_ora_23163, /portal/prtroot/docs/library/uuid/90e629a6-0611-2e10-0f9d-860802da0a05, create file +data/os1/cntrlos1, terms sapinst software provisioning manageradvanced db configuration -, ora-00200 ora-00202 ora-17502 ora-15001 ora-15204messages, 20m maxsize 10000mlogfile group 11
Related Notes :
| 1590515 | SAP Software and Oracle Exadata |
| 1550133 | Oracle Automatic Storage Management (ASM) |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |