Ora-27092:size of file exceeds file size limit of the process

The following issues were encountered while stopping the database:

$./addbctl.sh Stop

You are running addbctl.sh version 120.1

Shutting down database UAT ...

Sql*plus:release 11.1.0.7.0-production on Fri Jan 16 09:31:52 2015

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

Connected. Ora-01116:error in opening database file 6 ora-01110:data file 6: '/u01/uat01/db/apps_st/data/system06.dbf ' ora-27092:s Ize of file exceeds file size limit of the process Additional information:131071 Additional information:211585 Disconnec Ted from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production with the partitioning, OLAP, Data Mi Ning and Real Application testing options

Addbctl.sh:exiting with status 1

Solution:

Modify the/etc/security/limits, modify the corresponding limits , 1 means unlimted.

log on to the server again to resolve the problem .

Ora-27092:size of file exceeds file size limit of the process