partition database

[Roshan]

Hello,

when I am starting a database, I am getting the error below:

Enter user-name: / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device

I deleted the audit file in the path in file(audit_file_dest).

Filesystem            Size  Used Avail Use% Mounted on
/dev/cciss/c0d0p2      24G   23G     0 100% /
/dev/cciss/c0d0p1      99M   17M   77M  18% /boot
tmpfs                  16G   56M   16G   1% /dev/shm
/dev/emcpowera1       1.4T  1.2T  131G  90% /u02
/dev/emcpowera2        46G   23G   22G  52% /u01/oradata
/dev/emcpowera3       9.2G  8.6G  192M  98% /u02/oradata
/dev/emcpowera5       9.2G  175M  8.6G   2% /u03/oradata
/dev/emcpowera6       3.7G   72M  3.5G   3% /u02/oradata/common
/dev/emcpowera7       950M   18M  885M   2% /u02/oradata/catalog
/dev/emcpowera8        46G  3.4G   41G   8% /db01/oradata
/dev/emcpowera9        19G  179M   18G   2% /db02/oradata
/dev/emcpowera10       19G  173M   18G   1% /db03/oradata

Do you think i need to resize the /u02 partition. It contains some dbf and redo log files.

Thanks,
Roshan

Thanks,

[ErmanArslansOracleBlog]

Audit file dest is full. İt is obvious. Delete some files from there.

31 Ağu 2016 13:27 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hello,

when I am starting a database, I am getting the error below:

Enter user-name: / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device

I deleted the audit file in the path in file(audit_file_dest).

Filesystem            Size  Used Avail Use% Mounted on
/dev/cciss/c0d0p2      24G   23G     0 100% /
/dev/cciss/c0d0p1      99M   17M   77M  18% /boot
tmpfs                  16G   56M   16G   1% /dev/shm
/dev/emcpowera1       1.4T  1.2T  131G  90% /u02
/dev/emcpowera2        46G   23G   22G  52% /u01/oradata
/dev/emcpowera3       9.2G  8.6G  192M  98% /u02/oradata
/dev/emcpowera5       9.2G  175M  8.6G   2% /u03/oradata
/dev/emcpowera6       3.7G   72M  3.5G   3% /u02/oradata/common
/dev/emcpowera7       950M   18M  885M   2% /u02/oradata/catalog
/dev/emcpowera8        46G  3.4G   41G   8% /db01/oradata
/dev/emcpowera9        19G  179M   18G   2% /db02/oradata
/dev/emcpowera10       19G  173M   18G   1% /db03/oradata

Do you think i need to resize the /u02 partition. It contains some dbf and redo log files.

Thanks,
Roshan

Thanks,

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/partition-database-tp1274.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML