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
AIX, Linux

Aix/Linux/Solaris commands for DBA

1) How many Oracle instances running on OS
ps -aef | grep pmon

2) Seting unix Prompt.
export PS1=”`hostname`:$ORACLE_SID:$PWD>”

PS1 – The value of this parameter is expanded (see PROMPTING below) and used as the primary prompt string. The default value is \s-\v\$ .
PS2 – The value of this parameter is expanded as with PS1 and used as the secondary prompt string. The default is >
PS3 – The value of this parameter is used as the prompt for the select command
PS4 – The value of this parameter is expanded as with PS1 and the value is printed before each command bash displays during an execution trace. The first character of PS4 is replicated multiple times, as necessary, to indicate multiple levels of indirection. The default is +

(ref : https://www.cyberciti.biz/tips/howto-linux-unix-bash-shell-setup-prompt.html )

3) Useful commands in Aix/Linux/Solaris.
Ekran Alıntısı1

Standard
AIX

AIX server : The file access permissions do not allow the specified action Error Solutions !

Hello, my server version AIX fraudms80 2 7 00CC51B74C00 while copy folder, creating a new folder or etc. is returning:

The file access permissions do not allow the specified action Error. 

the file is being copied with the expected permissions so why is AIX giving me this error?

Look for the dot “.” directory, ownership and permissions?

fraudms80:/home/oracle#ls -lart
total 16
drwxr-xr-x 2 500 dba 256 Feb 26 14:30 .
-rwxr----- 1 500 dba 254 Feb 26 14:30 .profile
drwxr-xr-x 17 bin bin 4096 Mar 20 14:54 ..

If you are a system administrator and have access to the NFS mount check/change the permission again (it should be dynamic), and if you NOT, then you can notify them saying the same.

-rw-r--r-- 1 root system 3603 Dec 08 2008 README_nmon12e.txt
drwxr-xr-x 10 oracle dba 4096 Sep 03 2011 jdk1.6.0_27
drwxr-xr-x 3 oracle dba 256 Dec 23 2011 .java
-rwx------ 1 oracle dba 275 Dec 23 2011 .profile
drwxr-xr-x 3 oracle dba 256 Dec 23 2011 .oracle

home directory should be as follows for Oracle Database .

now we changing folder owner in the /home.

Like chmod -R 777 somefolder and someotherfolder.
Make sure, while chmod’ing to use -R flag (recursive)

 fraudms80:/oracle#ls -la
total 8
drwxr-xr-x 4 oracle dba 256 Apr 12 10:52 .
drwxr-xr-x 31 root system 4096 Apr 05 14:11 ..
drwxr-xr-x 2 root system 256 Feb 26 16:04 lost+found
drwxrwxrwx 4 oracle dba 256 Apr 12 10:59 setup
fraudms80:/oracle#

trying;
fraudms80:/home/oracle#cp .profile .profile_asm
fraudms80:/home/oracle#

yes, problem is solved.

BR.

erman

 

Standard