This content has been marked as final. Show 9 replies
Do you have privileges in /data3/ora10/dbs ?
Nope, if privileges was an issue, the error wou have been different right?
It is showing error realted to space and that too on /var, cant understand the same?
What OS? What does the /var mount point say about how much space is left?
Some operating systems are sluggish about cleaning up /var/tmp (or you have to tell them to). See your ex man page, you may want to use a different directory, set it in .exrc.
OS is solaris, i have checked the same, the /var has 10g available space.
show us ls -la initxyz.ora (I'm wondering if you linked to something different than you thought you did)
Edit: also see https://blogs.oracle.com/patch/entry/freeing_up_space_in_var (is it on the root filesystem? Are you checking free space properly? Remember, some utilities may not show deleted files that are still open).
Edit 2: How many files are under /var? You could be running out of inodes.
Edited by: jgarry on Oct 23, 2012 9:45 AM
Edited by: jgarry on Oct 23, 2012 9:55 AM
hi can u check this
The second point by you is correct, my file system is runnig out of inodes. I want to know if each mount point has dedicated inodes or that is true for the entire filesystem.
Every separated FileSystem have own pool of inodes. Number of inodes depend from type of FS and used options when FW ws create.
UFS gives less inodes comparing with ZFS.
If you are using UFS, and filesystem size is 1+ TB, inode count will be less. to get more inodes in UFS, have the filesystem size less than 1 TB, say 999 gb.