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 184.108.40.206.0 is incompatible with diskgroup
ORA-1501 signalled during: CREATE DATABASE …
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’.
compatible = 11.2.0
compatible = 220.127.116.11.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
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.
Start the database instance again
OS> sqlplus / as sysdba
Return to SAPINST and <RETRY>.
Creating the database should now succeed and SAPINST will continue.
Related topicsDb2 sql error 873
Case You are installing a non-unicode and unicode abap+j2ee system on db2 database and getting SQLCODE=-873 and perhaps additionaly a SQLSTATE error or you install […]SAP trex writer already open failed to create jacket filer CabinetException in Stapler.cpp
Case In TREX, during daily operation for example indexing, you get the following error: ERROR: writer already open  2010-04-29 15:47:22.386 e TrexCabinet Stapler.cpp(01821) :ERROR: […]Error UJO_READ_EXCEPTION_000 in EPM add-in
Case When running reports in the EPM add-in, you get following errors: Bad request. Server message: Code: UJO_READ_EXCEPTION_000 Solution You must re-implement the old MDX […]SQL1641N The db2start command failed on sap server
Case You are installing a sap server with DB2 database on Unix/Linux System. During executing db2 binaries, for example db2start you get following error: SQL1641N […]Exporting and importing sap tables with controlfile
Exporting client In order to export sap tables, create a controlfile (under /usr/sap/trans/bin/controlfile_export) with following content. EXPORT client = 500 file = export_file select * […]