Case

During creating a new database on ASM, SAPINST fails with errors: ORA-00200 ORA-00202 ORA-17502 ORA-15001 ORA-15204. In oracle trace file there are detailed error descriptions:

ORA-00200: control file could not be created
ORA-00202: control file: ‘+DATA/os1/cntrlos1.dbf’
ORA-17502: ksfdcre:3 Failed to create file +DATA/os1/cntrlos1.dbf
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-15204: database version 11.2.0.0.0 is incompatible with diskgroup
DATA
ORA-1501 signalled during: CREATE DATABASE …

Solution

Your database Parameter COMPATIBLE is not set properly and probably too low.

There a few workarounds

1) Use the latest SWPM version

 

2) For older versions of SAPINST edit initora. in installation master dvd in directory ‘…/COMMON/INSTALL/ORA/INITSID112.ORA’.

Change line

compatible = 11.2.0

to

compatible = 11.2.0.2.0

Save your changes and restar the installation from the beginning.

 

3) If you don’t want to restart SAPINST from the beginning.

 

logon to the database server as user ‘oracle’ and set the environment for the database instance

Stop the database instance (from NOMOUNT)
OS> sqlplus / as sysdba
SQL>
SHUTDOWN IMMEDIATE
QUIT
SQL>

Open $ORACLE_HOME/dbs/init<SID>.ora in an editor (vi)

Set parameter compatible to a value that allows to create the database on the chosen ASM disk groups.
Example:
compatible=11.2.0.2.0
or
compatible=11.2.0.3.0

Start the database instance again
OS> sqlplus / as sysdba
SQL>
STARTUP NOMOUNT
QUIT
SQL>

Return to SAPINST and <RETRY>.

Creating the database should now succeed and SAPINST will continue.