SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

SAPINST fails ORA-15204 database version is incompatible with diskgroup

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.

Leave a Reply

Your email address will not be published.

Related topics

Db2 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 [1201441088] 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 * […]