AIX, Troubleshooting

HPUX-ia64 Error: 28: No space left on device

Hello, problem HPUX-ia64 Error: 28: No space left on device .

ROCPSTEST oracle@rocpstest:/home/oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 27 14:04:48 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
ORA-09817: Write to audit file failed.
HPUX-ia64 Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on

I solve it immediately. Is database   runnig ?

ROCPSTEST oracle@rocpstest:/home/oracle>ps -ef |grep smon
root 5200 1 0 Nov 12 ? 7:31 /etc/opt/resmon/lbin/p_client
root 4443 1 0 Nov 12 ? 5:35 /etc/opt/resmon/lbin/emsagent
oracle 5452 1 0 Nov 12 ? 9:25 asm_smon_+ASM
oracle 9690 9400 0 14:06:07 pts/1 0:00 grep smon

yes. After this I checked space available in the FS. I got this:
ROCPSTEST oracle@rocpstest:/home/oracle> df -g
/home (/dev/vg00/lvol4 ) :
8192 file system block size 8192 fragment size
655360 total blocks 652013 total free blocks
646929 allocated free blocks 163232 total i-nodes
163000 total free i-nodes 163000 allocated free i-nodes
1073741828 file system id vxfs file system type
0x10 flags 255 file system name length
/home file system specific string
/opt (/dev/vg00/lvol5 ) :
8192 file system block size 8192 fragment size
1310720 total blocks 497345 total free blocks
493471 allocated free blocks 214080 total i-nodes
124307 total free i-nodes 124307 allocated free i-nodes
1073741829 file system id vxfs file system type
0x10 flags 255 file system name length
/opt file system specific string
/oracle (/dev/vgrocps/lvol3 ) :
8192 file system block size 1024 fragment size
157286400 total blocks 0 total free blocks  -> the problem is here
0 allocated free blocks 365152 total i-nodes
155812 total free i-nodes 155812 allocated free i-nodes
1073872899 file system id vxfs file system type
0x10 flags 255 file system name length
/oracle file system specific string
/rocps_data2 (/dev/vgrocps/lvol1 ) :
8192 file system block size 8192 fragment size
268451840 total blocks 220795054 total free blocks
219085406 allocated free blocks 56915456 total i-nodes
55198754 total free i-nodes 55198754 allocated free i-nodes
1073872897 file system id vxfs file system type
0x10 flags 255 file system name length
/rocps_data2 file system specific string
/rocps_home2 (/dev/vgrocps/lvol2 ) :
8192 file system block size 1024 fragment size
62914560 total blocks 53639679 total free blocks
50290045 allocated free blocks 13412360 total i-nodes
13409919 total free i-nodes 13409919 allocated free i-nodes
1073872898 file system id vxfs file system type
0x10 flags 255 file system name length
/rocps_home2 file system specific string
/tmp (/dev/vg00/lvol6 ) :
8192 file system block size 8192 fragment size
1310720 total blocks 1198551 total free blocks
1189189 allocated free blocks 301152 total i-nodes
299637 total free i-nodes 299637 allocated free i-nodes
1073741830 file system id vxfs file system type
0x10 flags 255 file system name length
/tmp file system specific string
/usr (/dev/vg00/lvol7 ) :
8192 file system block size 8192 fragment size
1310720 total blocks 860929 total free blocks
854207 allocated free blocks 245344 total i-nodes
215213 total free i-nodes 215213 allocated free i-nodes
1073741831 file system id vxfs file system type
0x10 flags 255 file system name length
/usr file system specific string
/var (/dev/vg00/lvol8 ) :
8192 file system block size 8192 fragment size
3682304 total blocks 2872951 total free blocks
2850644 allocated free blocks 770176 total i-nodes
718236 total free i-nodes 718236 allocated free i-nodes
1073741832 file system id vxfs file system type
0x10 flags 255 file system name length
/var file system specific string
/stand (/dev/vg00/lvol1 ) :
8192 file system block size 8192 fragment size
262144 total blocks 191626 total free blocks
190135 allocated free blocks 48256 total i-nodes
47901 total free i-nodes 47901 allocated free i-nodes
1073741825 file system id vxfs file system type
0 flags 255 file system name length
/stand file system specific string
/ (/dev/vg00/lvol3 ) :
8192 file system block size 8192 fragment size
262144 total blocks 228445 total free blocks
226673 allocated free blocks 59808 total i-nodes
57110 total free i-nodes 57110 allocated free i-nodes
1073741827 file system id vxfs file system type
0x10 flags 255 file system name length
/ file system specific string
ROCPSTEST oracle@rocpstest:/home/oracle>ls -la

I changed /oracle directory space size:

ROCPSTEST oracle@rocpstest:/home/oracle>df -g
/home (/dev/vg00/lvol4 ) :
8192 file system block size 8192 fragment size
655360 total blocks 652013 total free blocks
646929 allocated free blocks 163232 total i-nodes
163000 total free i-nodes 163000 allocated free i-nodes
1073741828 file system id vxfs file system type
0x10 flags 255 file system name length
/home file system specific string
/opt (/dev/vg00/lvol5 ) :
8192 file system block size 8192 fragment size
1310720 total blocks 497345 total free blocks
493471 allocated free blocks 214080 total i-nodes
124307 total free i-nodes 124307 allocated free i-nodes
1073741829 file system id vxfs file system type
0x10 flags 255 file system name length
/opt file system specific string
/oracle (/dev/vgrocps/lvol3 ) :
8192 file system block size 1024 fragment size
157286400 total blocks 41163168 total free blocks
38629464 allocated free blocks 10499968 total i-nodes
10290792 total free i-nodes 10290792 allocated free i-nodes
1073872899 file system id vxfs file system type
0x10 flags 255 file system name length
/oracle file system specific string
/rocps_data2 (/dev/vgrocps/lvol1 ) :
8192 file system block size 8192 fragment size
268451840 total blocks 220794999 total free blocks
219085351 allocated free blocks 56915456 total i-nodes
55198747 total free i-nodes 55198747 allocated free i-nodes
1073872897 file system id vxfs file system type
0x10 flags 255 file system name length
/rocps_data2 file system specific string
/rocps_home2 (/dev/vgrocps/lvol2 ) :
8192 file system block size 1024 fragment size
62914560 total blocks 53640771 total free blocks
50291069 allocated free blocks 13412632 total i-nodes
13410191 total free i-nodes 13410191 allocated free i-nodes
1073872898 file system id vxfs file system type
0x10 flags 255 file system name length
/rocps_home2 file system specific string
/tmp (/dev/vg00/lvol6 ) :
8192 file system block size 8192 fragment size
1310720 total blocks 1198551 total free blocks
1189189 allocated free blocks 301152 total i-nodes
299637 total free i-nodes 299637 allocated free i-nodes
1073741830 file system id vxfs file system type
0x10 flags 255 file system name length
/tmp file system specific string
/usr (/dev/vg00/lvol7 ) :
8192 file system block size 8192 fragment size
1310720 total blocks 860929 total free blocks
854207 allocated free blocks 245344 total i-nodes
215213 total free i-nodes 215213 allocated free i-nodes
1073741831 file system id vxfs file system type
0x10 flags 255 file system name length
/usr file system specific string
/var (/dev/vg00/lvol8 ) :
8192 file system block size 8192 fragment size
3682304 total blocks 2873730 total free blocks
2851423 allocated free blocks 770176 total i-nodes
718413 total free i-nodes 718413 allocated free i-nodes
1073741832 file system id vxfs file system type
0x10 flags 255 file system name length
/var file system specific string
/stand (/dev/vg00/lvol1 ) :
8192 file system block size 8192 fragment size
262144 total blocks 191626 total free blocks
190135 allocated free blocks 48256 total i-nodes
47901 total free i-nodes 47901 allocated free i-nodes
1073741825 file system id vxfs file system type
0 flags 255 file system name length
/stand file system specific string
/ (/dev/vg00/lvol3 ) :
8192 file system block size 8192 fragment size
262144 total blocks 228507 total free blocks
226735 allocated free blocks 59808 total i-nodes
57110 total free i-nodes 57110 allocated free i-nodes
1073741827 file system id vxfs file system type
0x10 flags 255 file system name length

after delete old *trm and *trc files older than 7 days.

find /oracle/diag/rdbms/rocpstest/ROCPSTEST/trace/*.trc -mtime +7 -exec rm {} \;

find /oracle/diag/rdbms/rocpstest/ROCPSTEST/trace/*.trm -mtime +7 -exec rm {} \;

connect to oracle as sysdba:

ROCPSTEST oracle@rocpstest:/home/oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 27 15:42:44 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

 

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select version from v$instance;

VERSION
—————–
11.2.0.4.0

SQL>

 

problem is solved,

Br.Erman

Advertisements
Standard