Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2006
    Posts
    12

    Unanswered: Oracle write to file system

    Dears,

    I have a problem in Optima application which is based on Oracle database. The problem is that the application is not writing partition u01 as in the below snapshot, although there is physical space,

    Filesystem kbytes used avail %used Mounted on
    /dev/vg00/lvol3 10289152 752904 9462272 7% /
    /dev/vg00/lvol1 1835008 428832 1395240 24% /stand
    /dev/vg00/lvol8 20512768 2532408 17840032 12% /var
    /dev/vg00/lvol7 20512768 3992632 16391096 20% /usr
    /dev/vg02/lvol8 52428800 66809 49089595 0% /u07/data/external_dir
    /dev/vg02/lvol6 214958080 2269821 199395249 1% /u06/data/oracle
    /dev/vg02/lvol5 209715200 22135851 175855750 11% /u05/data/oracle
    /dev/vg02/lvol4 209715200 2063952 194673048 1% /u04/data/oracle
    /dev/vg02/lvol3 157286400 310029 147165355 0% /u03/data/oracle
    /dev/vg02/lvol1 157286400 42433501 107674617 28% /u01/app/oracle
    /dev/vg02/lvol7 367001600 367001600 0 100% /u01/app/oracle/oradata/optimadb2
    /dev/vg00/lvol6 10289152 5575192 4677592 54% /tmp
    /dev/vg00/lvol5 25624576 15593240 9952976 61% /opt
    /dev/vg00/lvol4 40960000 75608 40565048 0% /home

    Best regards,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >although there is physical space,

    below contradicts statement above

    >/dev/vg02/lvol7 367001600 367001600 0 100% /u01/app/oracle/oradata/optimadb2
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2006
    Posts
    12
    Quote Originally Posted by anacedent View Post
    >although there is physical space,

    below contradicts statement above

    >/dev/vg02/lvol7 367001600 367001600 0 100% /u01/app/oracle/oradata/optimadb2
    Hello there,

    There is a typing mistake here, I meant u02 not u01.


    Regards,

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >There is a typing mistake here, I meant u02 not u01.
    I am sorry to see that COPY & PASTE are broken for.

    Since u02 does not exist in orginal df output, I understand why Oracle can not write to it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2006
    Posts
    12
    Quote Originally Posted by anacedent View Post
    >There is a typing mistake here, I meant u02 not u01.
    I am sorry to see that COPY & PASTE are broken for.

    Since u02 does not exist in orginal df output, I understand why Oracle can not write to it.
    Hello there,

    Our support team needs to install a certain patch to solve the problem.
    It is my mistake u02 originally did not exist in the mnttab file (i am using HP unix). However the problem as I said before, I cannot create any new indexes for a table, although Oracle should move to the next available partition.

    /dev/vg00/lvol3 / vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40000003 0 1 1312801231
    /dev/vg00/lvol1 /stand vxfs ioerror=mwdisable,nolargefiles,log,nodatainlog,tra nflush,dev=40000001 0 0 1312801236
    /dev/vg00/lvol8 /var vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40000008 0 0 1312801278
    /dev/vg00/lvol7 /usr vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40000007 0 0 1312801278
    /dev/vg02/lvol8 /u07/data/external_dir vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020001 0 0 1312801278
    /dev/vg02/lvol6 /u06/data/oracle vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020002 0 0 1312801278
    /dev/vg02/lvol5 /u05/data/oracle vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020003 0 0 1312801279
    /dev/vg02/lvol4 /u04/data/oracle vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020004 0 0 1312801279
    /dev/vg02/lvol3 /u03/data/oracle vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020005 0 0 1312801279
    /dev/vg02/lvol1 /u01/app/oracle vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020006 0 0 1312801279
    /dev/vg02/lvol7 /u01/app/oracle/oradata/optimadb2 vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40020007 0 0 1312801279
    /dev/vg00/lvol6 /tmp vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40000006 0 0 1312801279
    /dev/vg00/lvol5 /opt vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40000005 0 0 1312801279
    /dev/vg00/lvol4 /home vxfs ioerror=mwdisable,largefiles,delaylog,nodatainlog, dev=40000004 0 0 1312801280



    Regards,

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >However the problem as I said before, I cannot create any new indexes for a table,
    I only know what you write here & no where prior in this thread is "index" mentioned.
    I'll avoid further response & allow you to enjoy your delusions since I can not differentiate
    what is real & what only exists between your ears.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •