How to solve the ORA-01658 error

Ora-01658:unable to create INITIAL extent for segment in tablespace string

Cause:failed to find sufficient contiguous spaces to allocate INITIAL extent for segment being.

Action:use ALTER tablespace ADD datafile to add additional spaces to the tablespace or retry with a smaller value for INIT IAL

Problem Reason:

A the table is out of space and is not set to grow automatically

: Table space is self grown, a) is excluded

(b) Insufficient disk space, Oracle cannot allocate space

: View the physical disk space and find the usage rate to be 100%.

Workaround:

A try to connect to the database, error ORA-01658, ORA-09817 and OS 28, the operating system does not have enough space

(b) Attempt to delete the archive log, Oracle does not open archive

c) Try to delete backup files, no backup

D to view the size of the Flash_recovery_area space, the space is very small, there is no need to remove

E to view the Alert.log log file, no useful error information

F Consulting Test colleagues, they can connect to the database, test colleagues can connect to the database, and can create tables on other instances, now the problem is that only sid01 create the table when the report ORA-01658

G Try to get the test colleagues to solve and I'll give him a way to operate

1) Modify the size of the table space

View the table space adaptation, found that a table space allocated more than 5G, the utilization rate of less than 1G;

ALTER DATABASE datafile ... resize data file for this tablespace.

h) You can use the Sqlplus connection database

Delete Udump, Bdump,

In this Document

Symptoms

Cause

Solution

References

________________________________________

This document was being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been SU Bject to a independent technical review.

2. Applies To:

Oracle server-enterprise edition-version:8.1.7.4 to 11.1

This problem can occur to any platform.

3. Symptoms

When startin the database, below Errors occurred

ERROR:

Ora-09817:write to audit file failed.

HP-UX Error:28:no space left on device

Ora-09945:unable to initialize the audit trail file

4. Cause

Running Df-k found that "Mount" where Oracle is installed are full causing the Startup to throw errors

5. Solution

To implement the solution, please execute the following steps::

Free some spaces from the Mountpoint

Files that can is deleted are tracefiles in the Udump/bdump/cdump

Note:its advisable to backup the files before they are dropped since they might is useful in future

6. References

note:387200.1-ora-2002 Ora-9817 Error while writing to Audit Trail

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/