新系统创建表空间时报错如下：

CREATE TABLESPACE KPI_DATA DATAFILE  '/oraprod/oradata/KPIPROD/kpi_data01.dbf' SIZE 3072M AUTOEXTEND ON MAXSIZE UNLIMITED    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO ;
 
  ERROR at line 1:
ORA-01119: error in creating database file '/oraprod/oradata/KPIPROD/kpi_data.dbf'
ORA-27039: create file failed, file size limit reached
Additional information: 1

没有设置ORACLE用户的limits
  default:
        fsize = 2097151
        core = 2097151
        cpu = -1
        data = 262144
        rss = 65536
        stack = 65536
        nofiles = 2000

修改 /etc/security/limits
oracle:
        core = -1
        data = -1
        stack = -1
        fsize_hard = -1
        core_hard = -1
        cpu_hard = -1
        data_hard = -1
        stack_hard = -1
        nofiles= -1
        rss= -1

或者使用smitty chuser 修改相应 limits  , -1 表示unlimted 。
        
 P740A:oracle:/home/oracle$ulimit -a
time(seconds)        unlimited
file(blocks)         2097151
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user)  unlimited
P740A:oracle:/home/oracle$exit
# su - oracle
P740A:oracle:/home/oracle$ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user)  unlimited


修改成功后，再次创建，还是报错。
P740A:oracle:/home/oracle$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 4 16:51:57 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>    CREATE TABLESPACE "KPI_DATA" DATAFILE  '/oraprod/oradata/KPIPROD/kpi_data.dbf' SIZE 3072M autoextend on maxsize unlimited    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO ;
   CREATE TABLESPACE "KPI_DATA" DATAFILE  '/oraprod/oradata/KPIPROD/kpi_data.dbf' SIZE 3072M autoextend on maxsize unlimited    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/oraprod/oradata/KPIPROD/kpi_data.dbf'

DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/oraprod/oradata/KPIPROD/kpi_data.dbf01'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 131071 (xxxxx)
Additional information: 393217 (yyyyy)

where xxxxx is the filesize limit, and yyyyy is the datafile size (both in Oracle blocks).


决定重启系统shutdown -Fr  （小插曲：如果采用shutdown的方式属于计划内重启，那么HACMP不会自动跳到另一个节点(halt ：计划外重启））


重启后创建成功。