Today, my buddy told me that some modules in OA are invalid. After checking the system logs, it turns out that the temporary tablespace of the Oracle database is full, restart the database during lunch (this method is the easiest and not prone to errors ),
Today, my buddy told me that some modules in OA are invalid. After checking the system logs, it turns out that the temporary tablespace of the Oracle database is full, restart the database during lunch (this method is the easiest and not prone to errors ),
Today, my buddy told me that some modules in OA are invalid. When I checked the system logs on the Hong Kong server, it turned out that the temporary tablespace of the Oracle database was full, during lunch, I restarted the database (this method is the easiest and not prone to errors). I did not expect the temporary tablespace to be faulty. I will perform the following operations to restore it:
1. view the temporary tablespace size:
Select name, to_char (bytes/1024/1024) | 'M' from v $ tempfile;
The result shows that the temporary table size is 0 MB, as shown below:
NAMETO_CHAR (BYTES/1024/1024) | 'M'
/App/oracle/oradata/metenoa/temp01.dbf0M
2. Check the mounting status of the database file again:
Select file #, name, status, enabled from v $ tempfile;
Show STATUS as offline
Use the following statement:
Alter database tempfile '/app/oracle/oradata/metenoa/temp01.dbf' online;
Check the temporary table status as follows (ONLINE is normal ):
FILE # NAMESTATUSENABLED
1/app/oracle/oradata/metenoa/temp01.dbfONLINEREAD WRITE
Check the space size, which is displayed in numerical values as follows:
NAMETO_CHAR (BYTES/1024/1024) | 'M'
/App/oracle/oradata/metenoa/temp01.dbf351M
This article is from "Life is not limited, fighting is endless !" Blog, Hong Kong Server rental, please be sure to keep this source
, Website Space