SAP installation - Control file could not be created

[former_member199849]

I am installing SAP NW 7.3 on HPUX IA64 bits witth Oracle 11G, and in phase 12 "Create Database", I got the follwing error:

An error ocurred while processing option SAP netweaver 7.3 Ora-01501 create database failed ora-00200 An error occurred while processing option SAP NetWeaver 7.3 > SAP Systems > Application Server Java > Standard System > Standard System( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: ORA-01501: CREATE DATABASE failed ORA-00200: control file could not be created ORA-00202: control file: '/oracle/PTP/origlogA/cntrl/cntrlPTP.dbf' ORA-27037: unable to obtain file status HPUX-ia64 Error: 251: Function is not available Additional information: 46 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options . SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.). You can now: Choose Retry to repeat the current step. Choose Log Files to get more information about the error. Stop the option and continue with it later.

In ora_sql_results.olg I got this error:

SHUTDOWN IMMEDIATE; exit; Executed with error.

STARTUP NOMOUNT; exit; Executed successfully.

CREATE DATABASE PTP CONTROLFILE REUSE  MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/PTP/sapdata1/system_1/system.data1' SIZE 450M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/PTP/sapdata2/temp_1/temp.data1' SIZE 500M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PTP/sapdata2/undo_1/undo.data1' SIZE 600M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/PTP/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M LOGFILE GROUP 1 ('/oracle/PTP/origlogA/log_g11m1.dbf', '/oracle/PTP/mirrlogA/log_g11m2.dbf') SIZE 50M  REUSE , GROUP 2 ('/oracle/PTP/origlogB/log_g12m1.dbf', '/oracle/PTP/mirrlogB/log_g12m2.dbf') SIZE 50M  REUSE , GROUP 3 ('/oracle/PTP/origlogA/log_g13m1.dbf', '/oracle/PTP/mirrlogA/log_g13m2.dbf') SIZE 50M  REUSE , GROUP 4 ('/oracle/PTP/origlogB/log_g14m1.dbf', '/oracle/PTP/mirrlogB/log_g14m2.dbf') SIZE 50M  REUSE ; exit; Executed with error. #

Do you have any idea?, My filesystem has the right permisions with oraSID dba.

[former_member199849 · Accepted solution]

Hi,

My problem was solved,

SAPnote 1586546 and apply the latest SAP bundle patch, an then re-star my SAP installation.

[Former Member]

Hi Andy,

In addition to the previous comments, check the OS version and patch level. It should be "HP-UX 11i V3 patch Bundle Sep/ 2008 (B.11.31.0809.326a) or higher (Part Number E10851-01)". You can check the OS version, by "uname -a".

Additionally, check the documentation on Oracle Metalink;

"Bulletin : Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)"

Best regards,

Orkun Gedik

[Former Member]

As an additional information, it seems that you hit the bug "10302203". Check the document on the Oracle Metalink, "Bug 10302203 - HPUX: ORA-27037 with HPUX error 251 (ENOSYS) during VXFS file operations [ID 10302203.8]"

Best regards,

Orkun Gedik

[former_member1029779]

Hi,

Can you make sure that /oracle/PTP/origlogA/cntrl location is available. Also there should be no already existing control files with same name.

Check pfile for the locations of control files and make sure the file system is available.

Can you paste few lines which are being reported in Oracle alert log when the error occurs.

Thanks,

Faisal.

[sunny_pahuja2]

Hi,

check SAP note 1586546.

Thanks

Sunny

[nicholas_chang]

Hi Andy,

How about the space on file system?

refer to Note 546006 - Problems with Oracle due to operating system errors for more info.

Cheers,

Nicholas Chang