Symtomps: When you run a Request appears this error:".. unable to extend index APPLSYS.FND_LOGINS by 16 in tablespace APPS_TS_ARCHIVE ..."
Conclusion: The tablespace APPS_TS_ARCHIVE is full. Just add a new datafile to the tablespace and fix it.
How:
1.Go to sqlplus logging as SYSDBA:
$sqlplus sys as sysdba/YYYY
note:where YYYY is password sysdba
2.ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_archive0X.dbf' SIZE 1024M AUTOEXTEND OFF;
note: where X is a new number for datafile. In my case: if you list(ls -la /u02/oracle/iosaproddata/ ) data folder and get this output:
$ls -la /u02/oracle/iosaproddata/
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive03.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive04.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_int01.dbf
-rw-r----- 1 oratest oinstall 1610620928 Dec 13 11:58 a_media01.dbf
-rw-r----- 1 oratest oinstall 62922752 Dec 13 11:58 a_nolog01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue02.dbf
drwxr-xr-x 2 oratest oinstall 4096 Feb 19 2011 archive
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref01.dbf
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ02.dbf
-rw-r----- 1 oratest oinstall 134225920 Dec 13 11:58 a_tools01.dbf
-rw-r----- 1 oratest oinstall 2147491840 Dec 13 11:58 a_txn_data01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data03.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind02.dbf
the last .dbf file is a_archive04.dbf, soX should be 5, so sqlplus sentece would be:ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_archive05.dbf' SIZE 1024M AUTOEXTEND OFF;
No comments:
Post a Comment