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

Sap language import

Case You want to perform sap language import into sap system but you are not sure about the right steps The language import must always […]

trex writer already open failed to create jacket filer CabinetException in Stapler.cpp

Case In TREX, during daily operation for example indexing, you you get the following error: ERROR: writer already open [1201441088] 2010-04-29 15:47:22.386 e TrexCabinet Stapler.cpp(01821) […]

Could not obtain version info from start service in sum

Case in SAP Java Application Server you are applying patches via SUM and getting following error: Error getting the supported web methods. com.sun.xml.internal.ws.client.ClientTransportException: HTTP transport […]

SAP Install non-unicode system from unicode CDs

Case You want to install a non unicode sap system ECC6. For this, you need ECC6 SR2 installation CDs, which are not available in Sapnet […]

Remote access to the NetWeaver Administrator is forbidden

Case You have installed SAP Java Application Server.  After all,  attempting to access to NWA  you get the error: “Remote access to the NetWeaver Administrator […]