- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle cannot create large files during TS set...
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
тАО06-04-2003 01:42 AM
тАО06-04-2003 01:42 AM
oracle cannot create large files during TS setup
our client's DBAs are trying in vain to create large table space data files during Oracle9i set up.
I definitely created the target filesystem of type Veritas with the largefiles option.
e.g.
newfs -F vxfs -b 8192 -o largefiles /dev/vg*/rlvol*
(asterisks here only substitute the proper raw device)
I'm also convinced that the filesystem got mounted correctly as being largefiles aware, although I didn't specify any largefile mount option in the package's control script that mounts the cluster shared volume (e.g. FS_MOUNT_OPT[0]="-o rw")
I fully logged in as user oracle and created a 6 GB chunk full of zeros in the target filesystem which should host the ts datafiles.
e.g.
dd if=/dev/zero of=/mount/of/packages/lv/testchunk bs=1024k count=6000
This worked, as well as a copying to another largefiles aware filesystem, and even a splitting of the chunk.
All under user oracle.
Despite the DBAs insist that they cannot create large data files.
I have no Oracle knowledge.
So I don't know if anything else is required on the DBAs' behalf in advance.
Maybe could it be that the user limits need to be raised.
This is what they show for oracle:
# su - oracle -c "ulimit -a"
time(seconds) unlimited
file(blocks) 4000000
data(kbytes) unlimited
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
What strikes me a bit is the file(blocks) restriction, but I cannot raise it
ulimit -f unlimited
ksh: ulimit: exceeds allowable limit
Regards
Ralph
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2003 01:58 AM
тАО06-04-2003 01:58 AM
Re: oracle cannot create large files during TS setup
ksh is known to be limited and cannot be extended.
Use csh as shell for oracle, is better !
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2003 02:02 AM
тАО06-04-2003 02:02 AM
Re: oracle cannot create large files during TS setup
I think ksh is stuck to 2Gb for ulimit -f.
There is no kernel paraemter controlling it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2003 02:10 AM
тАО06-04-2003 02:10 AM
Re: oracle cannot create large files during TS setup
yes, ksh on hpux is compiled with the 2G limitation is.
I had already my head over it :(
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2003 02:10 AM
тАО06-04-2003 02:10 AM
Re: oracle cannot create large files during TS setup
yes, ksh on hpux is compiled with the 2G limitation in.
I had already my head over it :(
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-04-2003 02:17 AM
тАО06-04-2003 02:17 AM
Re: oracle cannot create large files during TS setup
the (HP-UX) Korn shell doesn't impose such a boundary either.
Guess what I discovered in oracle's .profile %-{
# grep ulimit ~oracle/.profile
# ulimit 4000000
The DBAs themselves must have restricted their child processes.
Btw. the comment hash mark has just now been inserted by me.
I asked the DBAs to give oracle a new login shell (e.g. login anew) and give it another try.
I'm awaiting their response...