- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- datafile larger then 2048 Mo
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-06-2004 09:14 PM
тАО05-06-2004 09:14 PM
Following install ORACLE 9;
The DBA with created files superior to 2048 Mo. And no error.Then the data were imported successfully and no error. But when the dBa makes a copy of table in sql it obtains this message:
ERROR at line 1:
ORA-01116: error in opening database file 6
ORA-01110: data file 6: '/U02/oradata/GPF/users01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 448001
--------------------
J looked at the value of ulimit and:
# uxsar13:/> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 29296
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 1500
What to make? and why 262143 (2 Go)
and when DBA reduce file under 2 Go, that working !
regards.
Julien.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-06-2004 09:22 PM
тАО05-06-2004 09:22 PM
Re: datafile larger then 2048 Mo
I guess your oracle block size is 8Kb.
1) What is the user used for the SQL copy (Unix user , local or remote)
2) What is the ulimit of this user ?
ulimit for the user who starts the listener ?
3) Shell used : ksh or POSIX shell ?
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-06-2004 09:22 PM
тАО05-06-2004 09:22 PM
Re: datafile larger then 2048 Mo
Take a look at this thread :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=550089
Same thing with oerr
ksh> oerr ora 27092
27092, 00000, "skgfofi: size of file exceeds file size limit of the process"
// *Cause: an attempt was made to open a file that exceeds the process's
// file size limit (ulimit), additional information shows the current
// limit (logical blocks) and the size of the file (logical blocks)
// *Action: increase the processes file size limit (ulimit) and retry
It's seems that the problem is with ulimit, whether it's not tested for the Oracle user or because there is a flaw in ksh.
Cheers
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-06-2004 09:42 PM
тАО05-06-2004 09:42 PM
Re: datafile larger then 2048 Mo
And my db block size is 8kb.
1) user for sql copy is Unix user local (gpfadm)
and when I do ulimit -a for this user I have :
gpfadm:/home/gpfadm > ulimit -a
ksh: ulimit: bad option(s)
and when I do ulimit
gpfadm:/home/gpfadm > ulimit
4194303
user who launch oracle is oracle9 and when I do ulimit thas is same of user gpfadm
:ulimit -a
ksh: ulimit: bad option(s)
ulimit
4194303
3) Oracle are installed whith user oracle9 in sh, but that I chosse then in Ksh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-06-2004 10:00 PM
тАО05-06-2004 10:00 PM
Re: datafile larger then 2048 Mo
and try again
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 02:23 AM
тАО05-07-2004 02:23 AM
Solution1.check the .profile file of the oracle user to see whether the oraenv script is present in the startup file.
THis oraenv file sets the ulimit value as 4194303
.
Remove the script from .profile or change the script from "4194303
" to "unlimited" in the "if condition".
If that is not present.
2.Load the patches
PHCO_26783 (11.00)
PHCO_27019 (11.11)
which should make the ulimit values for ksh to unlimited.
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 02:25 AM
тАО05-07-2004 02:25 AM
Re: datafile larger then 2048 Mo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 02:27 AM
тАО05-07-2004 02:27 AM
Re: datafile larger then 2048 Mo
I install patch PHCO_26738 and I resolve my problem !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-07-2004 02:40 AM
тАО05-07-2004 02:40 AM
Re: datafile larger then 2048 Mo
Regards,
Fred
"Reality is just a point of view." (P. K. D.)