- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle error 27 HP-UX
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 01:05 AM
тАО05-24-2002 01:05 AM
oracle error 27 HP-UX
"
Fri May 24 05:23:10 2002
KCF: write/open error block=0x40004 online=1
file=2 /busdata/rsme/eur0/_lgi/oracle/vol2/rbs01_01.dbf
error=27072 txt: 'HP-UX Error: 27: File too large
Additional information: 262148'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 1476
"
We are running HPUX and Oracle 8.1.6. Result of ulimit by Oracle user :
"
$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 307200
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048
"
result of fsadm :
"
nomultifsets
largefiles
"
Any help would be useful.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 01:12 AM
тАО05-24-2002 01:12 AM
Re: oracle error 27 HP-UX
What is the size of the database file ?
Does the filesystem which you have used to create this db file use the largefiles option? I presume it to be vxfs.
Just my two cents
-Sukant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 01:19 AM
тАО05-24-2002 01:19 AM
Re: oracle error 27 HP-UX
If not a largefile problem then
Is the oracle started by a cron script such as
OMNIBACK with the at command
If so it may be
/var/adm/cron/.proto
file should temporarily work around this problem:
Change ulimit line From:
# @(#) $Revision: 27.1 $
cd $d
ulimit $l <--------- as indicated
umask $m
$<
To:
ulimit unlimited
Remeber what you changed and put it back if needed.
steve steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 03:27 AM
тАО05-24-2002 03:27 AM
Re: oracle error 27 HP-UX
$ fsdam -v vxfs /dev/... :
"
nomultifsets
largefiles
"
Thanks for all the current help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 05:20 AM
тАО05-24-2002 05:20 AM
Re: oracle error 27 HP-UX
the .jobmanrc for root :
"#!/usr/bin/ksh "
the ulimit in sh :
"ulimeted"
and in ksh :
"4194303"
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 05:40 AM
тАО05-24-2002 05:40 AM
Re: oracle error 27 HP-UX
Check out oracle Note:1067314.6 if you can. Something very, very similar to what you are getting. I have pasted the solution below.
Solution Description:
=====================
You need to ensure that the ulimit is set to "unlimited for filesize".
Check the ulimit all users that start oracle. If there are scripts used for automatic startup and shutdown , check the scripts for limit commands that may set the ulimit.
To check the ulimit :
(in c-shel)
[tchp1]/u02/home/usupport> limit
cputime unlimited
filesize unlimited
datasize 262144 kbytes
stacksize 32768 kbytes
coredumpsize 2097151 kbytes
descriptors 2048 files
memoryuse unlimited
ksh - will not show the detail
$ ulimit
4194303
from this you can not see what the filesize is set to.
Explanation:
============
The error occurs because the database is started with a ulimit less than the
datafile size. The limit filesize is greater than the size of the system
datafiles, however the size other datafiles in the database exceeds the ulimit.
When the data beyond the ulimit threshold is accessed in the datafiles, the
error occurs.
Hope this helps.
Kind Regards,
Kawah