walkerdba
asked on
01075
Is there any permanent solution for this problem..
[oracle@term1 dbs]$ ls
hc_DBUA0.dat initorcl.ora orapworcl peshm_prim_0 spfileprim.ora
hc_orcl.dat initprim.ora orapwprim snapcf_orcl.f
hc_prim.dat lkORCL peshm_DBUA0_0 snapcf_prim.f
init.ora lkPRIM peshm_orcl_0 spfileorcl.ora
[oracle@term1 dbs]$ . oraenv prim
ORACLE_SID = [prim] ?
The Oracle base for ORACLE_HOME=/u01/app/oracl e/product/ 11.2.0/dbh ome_1 is /u01/app/oracle
[oracle@term1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 20 09:40:25 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on
Enter user-name:
[oracle@term1 dbs]$ ls
hc_DBUA0.dat initorcl.ora orapworcl peshm_prim_0 spfileprim.ora
hc_orcl.dat initprim.ora orapwprim snapcf_orcl.f
hc_prim.dat lkORCL peshm_DBUA0_0 snapcf_prim.f
init.ora lkPRIM peshm_orcl_0 spfileorcl.ora
[oracle@term1 dbs]$ . oraenv prim
ORACLE_SID = [prim] ?
The Oracle base for ORACLE_HOME=/u01/app/oracl
[oracle@term1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 20 09:40:25 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on
Enter user-name:
ASKER
this is the init.ora file
how will I find out from this ..
orcl.__db_cache_size=15099 4944
orcl.__java_pool_size=4194 304
orcl.__large_pool_size=419 4304
orcl.__oracle_base='/u01/a pp/oracle' #ORACLE_BA SE set from environment
orcl.__pga_aggregate_targe t=22229811 2
orcl.__sga_target=41523609 6
orcl.__shared_io_pool_size =0
orcl.__shared_pool_size=24 3269632
orcl.__streams_pool_size=4 194304
*.audit_file_dest='/u01/ap p/oracle/a dmin/orcl/ adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/ oracle/ora data/orcl/ control01. ctl','/u01 /app/oracl e/flash_re covery_are a/orcl/con trol02.ctl '
*.db_block_size=8192
*.db_domain='localdomain'
*.db_file_name_convert='/o radata/sta nd','/orad ata/orcl'
*.db_name='orcl'
*.db_recovery_file_dest='/ u01/app/or acle/flash _recovery_ area'
*.db_recovery_file_dest_si ze=4039114 752
*.diagnostic_dest='/u01/ap p/oracle'
*.dispatchers='(PROTOCOL=T CP) (SERVICE=orclXDB)'
*.fal_client='ORCL'
*.fal_server='STAND'
*.log_archive_config='dg_c onfig=(orc l,stand)'
*.log_archive_dest_1='loca tion=/u01/ app/oracle /oradata/o rcl/archiv e_log valid_for=(all_logfiles,al l_roles) db_unique_name=orcl'
*.log_archive_dest_2='serv ice=newdb valid_for=(online_logfiles ,primary_r ole) db_unique_name=orcl'
*.log_archive_dest_state_2 ='defer'
*.log_file_name_convert='/ oradata/st and','/ora data/orcl'
*.memory_target=636485632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil e='EXCLUSI VE'
*.standby_file_management= 'AUTO'
*.undo_tablespace='UNDOTBS 1'
how will I find out from this ..
orcl.__db_cache_size=15099
orcl.__java_pool_size=4194
orcl.__large_pool_size=419
orcl.__oracle_base='/u01/a
orcl.__pga_aggregate_targe
orcl.__sga_target=41523609
orcl.__shared_io_pool_size
orcl.__shared_pool_size=24
orcl.__streams_pool_size=4
*.audit_file_dest='/u01/ap
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_domain='localdomain'
*.db_file_name_convert='/o
*.db_name='orcl'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
*.fal_client='ORCL'
*.fal_server='STAND'
*.log_archive_config='dg_c
*.log_archive_dest_1='loca
*.log_archive_dest_2='serv
*.log_archive_dest_state_2
*.log_file_name_convert='/
*.memory_target=636485632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil
*.standby_file_management=
*.undo_tablespace='UNDOTBS
run a df -hi and see if there is anything thats 100% or close to it and increase the space as needed if you can.
>>how will I find out from this ..
With *.audit_trail='db' you are not writing audit records to the file system so that isn't it.
Use the df command above to find out what file system is full. Given that you are writing audit records to the database, you have filled up one of the database file folders if you have auto extend turned on or you have filled up a datafile.
Check the database alert log for more information.
With *.audit_trail='db' you are not writing audit records to the file system so that isn't it.
Use the df command above to find out what file system is full. Given that you are writing audit records to the database, you have filled up one of the database file folders if you have auto extend turned on or you have filled up a datafile.
Check the database alert log for more information.
ASKER
[oracle@term1 ~]$ df -hi
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda2 3.5M 174K 3.3M 5% /
/dev/sda6 4.1M 42K 4.1M 1% /u01
/dev/sda5 1.3M 72 1.3M 1% /tmp
/dev/sda1 50K 33 49K 1% /boot
tmpfs 190K 1 190K 1% /dev/shm
[oracle@term1 ~]$ df -hi
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda2 3.5M 174K 3.3M 5% /
/dev/sda6 4.1M 42K 4.1M 1% /u01
/dev/sda5 1.3M 72 1.3M 1% /tmp
/dev/sda1 50K 33 49K 1% /boot
tmpfs 190K 1 190K 1% /dev/shm
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda2 3.5M 174K 3.3M 5% /
/dev/sda6 4.1M 42K 4.1M 1% /u01
/dev/sda5 1.3M 72 1.3M 1% /tmp
/dev/sda1 50K 33 49K 1% /boot
tmpfs 190K 1 190K 1% /dev/shm
[oracle@term1 ~]$ df -hi
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda2 3.5M 174K 3.3M 5% /
/dev/sda6 4.1M 42K 4.1M 1% /u01
/dev/sda5 1.3M 72 1.3M 1% /tmp
/dev/sda1 50K 33 49K 1% /boot
tmpfs 190K 1 190K 1% /dev/shm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry, df -h, the i was a typo.... my bad.
ASKER
fine
Check the value of the AUDIT_FILE_DEST parameter, this will point you where the sys audit operation are recorded. Probably you don't have privileges to write on that path or the path is full, so you are unable to write the sys user log.
Writing sys audit records is an operation configured by default. Check the value of the instance parameter AUDIT_SYS_OPERATIONS.
Source URL