Skip to main content

ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1678

Unable to login in R12.1.3


Problem :- When users are trying to login into oracle applications, they are unable to login.

Error is :- 

==========================================================

Exception Details. 
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01653: unable to extend table ICX.ICX_SESSION_ATTRIBUTES by 16 in tablespace APPS_TS_TX_DATA
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1678
ORA-06512: at line 1

    at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
    at oracle.apps.fnd.framework.webui.OAServerDelegate.setIcxSessionAttribute(OAServerDelegate.java:794)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.writePersistentSessionValue(OAPassivationClientUtils.java:461)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.isFailoverEventFired(OAPassivationClientUtils.java:263)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.handleFailoverEvent(OAPassivationClientUtils.java:628)
    at oracle.apps.fnd.framework.webui.OAHttpSessionManager.handleSessionBoundaryEvents(OAHttpSessionManager.java:383)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1528)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    at _OA._jspService(_OA.java:212)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
    at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
    at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
    at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
    at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    at _RF._jspService(_RF.java:225)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    at java.lang.Thread.run(Thread.java:619)
## Detail 0 ##
java.sql.SQLException: ORA-01653: unable to extend table ICX.ICX_SESSION_ATTRIBUTES by 16 in tablespace APPS_TS_TX_DATA
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1678
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    at oracle.apps.fnd.framework.webui.OAServerDelegate.setIcxSessionAttribute(OAServerDelegate.java:771)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.writePersistentSessionValue(OAPassivationClientUtils.java:461)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.isFailoverEventFired(OAPassivationClientUtils.java:263)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.handleFailoverEvent(OAPassivationClientUtils.java:628)
    at oracle.apps.fnd.framework.webui.OAHttpSessionManager.handleSessionBoundaryEvents(OAHttpSessionManager.java:383)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1528)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    at _OA._jspService(_OA.java:212)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
    at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
    at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
    at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
    at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    at _RF._jspService(_RF.java:225)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    at java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: ORA-01653: unable to extend table ICX.ICX_SESSION_ATTRIBUTES by 16 in tablespace APPS_TS_TX_DATA
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1678
ORA-06512: at line 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    at oracle.apps.fnd.framework.webui.OAServerDelegate.setIcxSessionAttribute(OAServerDelegate.java:771)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.writePersistentSessionValue(OAPassivationClientUtils.java:461)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.isFailoverEventFired(OAPassivationClientUtils.java:263)
    at oracle.apps.fnd.framework.webui.OAPassivationClientUtils.handleFailoverEvent(OAPassivationClientUtils.java:628)
    at oracle.apps.fnd.framework.webui.OAHttpSessionManager.handleSessionBoundaryEvents(OAHttpSessionManager.java:383)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1528)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
    at _OA._jspService(_OA.java:212)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
    at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
    at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
    at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
    at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    at _RF._jspService(_RF.java:225)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
    at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    at java.lang.Thread.run(Thread.java:619)
=================================================================================


Solution:- 

In my case, First I check database processes on O/S level.

=============================
ps -lef |grep -i fcpora
0 S fcpora    4183     1  0  75   0 - 300550 -     21:59 ?        00:00:00 ora_vkrm_FCPR12
4 S root      4563  4260  0  76   0 -  1915 -      22:32 ?        00:00:00 sshd: fcpora [priv]
5 S fcpora    4565  4563  0  76   0 -  1915 -      22:33 ?        00:00:00 sshd: fcpora@pts/1
0 S fcpora    4566  4565  0  75   0 -  1334 wait   22:33 pts/1    00:00:00 -bash
0 S fcpora    4594  4566  0  76   0 -  1529 wait   22:33 pts/1    00:00:00 bash
4 S root      5448  4749  0  76   0 -  1396 wait   22:53 pts/1    00:00:00 su - fcpora
4 S fcpora    5449  5448  0  75   0 -  1145 wait   22:53 pts/1    00:00:00 -bash
0 S fcpora    5477  5449  0  75   0 -  1115 wait   22:53 pts/1    00:00:00 bash
0 S fcpora    5495  5477  0  76   0 -  9199 pipe_w 22:53 pts/1    00:00:00 sqlplus
0 S fcpora    5496  5495  0  76   0 - 301014 -     22:53 ?        00:00:00 oracleFCPR12 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
4 S root      5530  4260  0  76   0 -  1965 -      22:58 ?        00:00:00 sshd: fcpora [priv]
5 S fcpora    5534  5530  0  76   0 -  1965 -      22:58 ?        00:00:00 sshd: fcpora@pts/2
0 S fcpora    5535  5534  0  75   0 -  1191 wait   22:58 pts/2    00:00:00 -bash
0 S fcpora    5563  5535  0  75   0 -  1397 wait   22:58 pts/2    00:00:00 bash
0 R fcpora    5586  5563  0  76   0 -   620 -      22:59 pts/2    00:00:00 ps -lef
0 S fcpora    5587  5563  0  77   0 -  1002 pipe_w 22:59 pts/2    00:00:00 grep -i fcpora
0 S fcpora   20293     1  0  76   0 - 302232 -     Sep17 ?        00:00:01 oracleFCPR12 (LOCAL=NO)
0 S fcpora   20346     1  0  76   0 - 302232 -     Sep17 ?        00:00:01 oracleFCPR12 (LOCAL=NO)
0 S fcpora   21342     1  0  76   0 - 10376 -      Sep21 ?        00:00:00 /u01/FCPR12/db/tech_st/11.2.0/bin/tnslsnr LISTENER -inherit
0 S fcpora   23516     1  0  75   0 - 303073 399795 01:35 ?       00:00:11 oracleFCPR12 (LOCAL=NO)
0 S fcpora   26162     1  0  76   0 - 300708 -     Sep17 ?        00:00:24 ora_pmon_FCPR12
0 S fcpora   26164     1  0  75   0 - 300550 -     Sep17 ?        00:00:00 ora_vktm_FCPR12
0 S fcpora   26168     1  0  76   0 - 300550 -     Sep17 ?        00:00:00 ora_gen0_FCPR12
0 S fcpora   26170     1  0  76   0 - 300566 -     Sep17 ?        00:00:06 ora_diag_FCPR12
0 S fcpora   26172     1  0  76   0 - 300692 -     Sep17 ?        00:00:00 ora_dbrm_FCPR12
0 S fcpora   26174     1  0  76   0 - 300550 -     Sep17 ?        00:00:01 ora_psp0_FCPR12
0 S fcpora   26176     1  0  76   0 - 300934 -     Sep17 ?        00:05:36 ora_dia0_FCPR12
0 S fcpora   26178     1  0  76   0 - 300550 -     Sep17 ?        00:00:01 ora_mman_FCPR12
0 S fcpora   26180     1  0  76   0 - 301926 -     Sep17 ?        00:01:13 ora_dbw0_FCPR12
0 S fcpora   26182     1  0  76   0 - 304440 -     Sep17 ?        00:19:43 ora_lgwr_FCPR12
0 S fcpora   26184     1  0  76   0 - 300566 -     Sep17 ?        00:01:19 ora_ckpt_FCPR12
0 S fcpora   26186     1  0  76   0 - 302249 -     Sep17 ?        00:00:34 ora_smon_FCPR12
0 S fcpora   26188     1  0  76   0 - 300689 -     Sep17 ?        00:00:00 ora_reco_FCPR12
0 S fcpora   26644     1  0  75   0 - 10483 -      Sep17 ?        00:46:10 /u01/FCPR12/db/tech_st/11.2.0/bin/tnslsnr FCPR12 -inherit
0 S fcpora   27570     1  0  75   0 - 301267 370912 07:02 ?       00:00:00 oracleFCPR12 (LOCAL=NO)


Two listener process are running, check it the same in below command again.
==============================================================
$ ps -lef |grep -i tnslsnr

0 S fcpora   21342     1  0  76   0 - 10376 -      Sep21 ?        00:00:00 /u01/FCPR12/db/tech_st/11.2.0/bin/tnslsnr LISTENER -inherit
0 S fcpora   26644     1  0  76   0 - 10483 -      Sep17 ?        00:46:10 /u01/FCPR12/db/tech_st/11.2.0/bin/tnslsnr FCPR12 -inherit
=================================================================

and some datafiles are getting full also.

=================================================================

 sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 22 22:34:21 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name, kbytes/1024 total, used/1024 Used, free/1024 free_mb, pct_used,largest/1024 max_chunk_available_MB
  2  from ( select nvl(b.tablespace_name,
  3               nvl(a.tablespace_name,'UNKOWN')) name,
  4         kbytes_alloc kbytes,
  5         kbytes_alloc-nvl(kbytes_free,0) used,
  6         nvl(kbytes_free,0) free,
  7         ((kbytes_alloc-nvl(kbytes_free,0))/
  8                            kbytes_alloc)*100 pct_used,
       nvl(largest,0) largest
  9   10  from ( select sum(bytes)/1024 Kbytes_free,
 11                max(bytes)/1024 largest,
 12  tablespace_name
 13         from sys.dba_free_space
 14         group by tablespace_name ) a,
 15       ( select sum(bytes)/1024 Kbytes_alloc,
 16                tablespace_name
 17         from sys.dba_data_files
 18         group by tablespace_name )b
 19  where a.tablespace_name (+) = b.tablespace_name
 20  )
 21  where pct_used >= 90 and free/1024 <= 500;

NAME                                TOTAL       USED    FREE_MB   PCT_USED
------------------------------ ---------- ---------- ---------- ----------
MAX_CHUNK_AVAILABLE_MB
----------------------
CTXD                                   16 14.8828125  1.1171875 93.0175781
             1.0859375

APPS_TS_NOLOGGING                      64         62          2     96.875
                  1.75

APPS_TS_ARCHIVE                       866    856.125      9.875 98.8596998
                 9.875


NAME                                TOTAL       USED    FREE_MB   PCT_USED
------------------------------ ---------- ---------- ---------- ----------
MAX_CHUNK_AVAILABLE_MB
----------------------
SYSAUX                                860   792.8125    67.1875    92.1875
                1.0625

APPS_TS_TX_DATA                  8846.875   8846.875          0        100
                     0
=========================================================


First, down the Listener, only one listener process should be ran for an instance and it should be ran by database SID name.


lsnrctl stop LISTENER

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-SEP-2014 22:59:45

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully



====================================================

Second, resize or add datafile, which are getting full.

SQL> select FILE_NAME, TABLESPACE_NAME from dba_data_files where TABLESPACE_NAME='APPS_TS_TX_DATA';

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
/u01/FCPR12/data/a_txn_data03.dbf
APPS_TS_TX_DATA

/u01/FCPR12/data/a_txn_data02.dbf
APPS_TS_TX_DATA

/u01/FCPR12/data/a_txn_data01.dbf
APPS_TS_TX_DATA


FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
/u01/FCPR12/data/a_txn_data05.dbf
APPS_TS_TX_DATA

/u01/FCPR12/data/a_txn_data04.dbf
APPS_TS_TX_DATA


SQL> !du -sh /u01/FCPR12/data/a_txn_data04.dbf
2.4G    /u01/FCPR12/data/a_txn_data04.dbf

SQL> alter database datafile '/u01/FCPR12/data/a_txn_data04.dbf' resize 3G;

Database altered.

SQL> !du -sh /u01/FCPR12/data/a_txn_data03.dbf
1.3G    /u01/FCPR12/data/a_txn_data03.dbf

SQL> alter database datafile '/u01/FCPR12/data/a_txn_data03.dbf' resize 2G;

Database altered.
=======================================================

After completed the above steps, clean bounce the application and database.
Note:- each and every application process should be down from O/S level.

Error resolved :)


Thanks & Regards,
Ravindra 



Comments

Post a Comment

Popular posts from this blog

[INS-06001] Failed to perform operation due to internal driver error (During installation of RAC 11g)

Solution: root@NFSP70DB # cat /tmp/OraInstall2013-03-05_01-43-51PM/sshsetup3_2013-03-05_01-43-51PM.log INFO: Environment Variables: INFO:   ORACLE_HOME = INFO:   PATH = /usr/bin:/usr/ccs/bin:/usr/bin::/oracle/dump/install INFO:   CLASSPATH = INFO: Username:grid INFO: Lock Retry Count 120 INFO: Lock Sleep Time 30000 INFO: Home Dir /export/home/grid INFO: Lock Location : /export/home/grid/.ssh/lock INFO: Trying to get Lock .... INFO: Lock Acquired INFO: LIBRARY_LOC = /tmp/OraInstall2013-03-05_01-43-51PM/oui/lib/solaris INFO: Validating remote binaries.. INFO: [NFSP70DB] INFO: /bin/bash -c '/bin/true' INFO: Exit-status: 0 INFO: Error: INFO: INFO: INFO: [NFSP70DB] INFO: /bin/bash -c 'if [[ -f /usr/local/etc/ssh_host_rsa_key.pub ]] ; then exit 0; else exit 1; fi' INFO: Exit-status: 0 INFO: Error: INFO: INFO: INFO: An error occured which will cause the program to abort. Refer to latest Log file that was supplied while running the program. The Log file woul...
Post a Comment
Read more

Configuration workflow mailer on R12 (Mailer server working in SSL and Application running without SSL)

Steps: ---------------------- In order to Configure Workflow Java Mailer with IMAP and SMTP email servers SSL enabled, need to perform the below steps 1. Export the Certificate from the Email server.     2. Create a keystore on the Concurrent Manager Tire. Import the certificate to keystore     3. Configure the Mailer to work with IMAPSSL / SMTPSSL.     4. Steps for Debugging the Mailer.     5. R12.1.3 feature - Mailer Authentication     Protocol: SMTP/SSL Port : 465 Protocol: IMAP/SSL Port : 993 1. Export the Certificate from the Email server.   In order to be able to establish a Secure communication channel, the certificate from the Email Server (issued by a Certification Authority) needs to be imported on the Concurrent Manager Tire. The email server certificate issued by a trusted Certification Authority (i.e. Verisign), can be obtain from the System Administrator or downloaded by following the below steps A. A...
Post a Comment
Read more

Installation Single Sign-On (Oracle Internet Directory) & Oracle Web Discoverer 10g on solaris 10 configured with E-Business Suit R12

Discoverer Configuration Step 1- Check OS Prerequisite on erpdisc (erpdisc is discoverer Node) Hostname -hostname OSVERSION - uname -r Maintenance level - /etc/release RAM - /usr/sbin/prtconf | grep -i memory SWAP - swap -s Tmp - df -k /tmp Kernel Parameter- /etc/system JDK & JRE - /usr/bin/java -version Ulimit- ulimit -a Hostname settings- /etc/hosts OS 64 bit or 32 bit - /bin/isainfo -kv File Descriptor- /etc/system set rlim_fd_max=65536 Oracle OS Group - /etc/group Oracle OS Discoverer User – mkuser -disc OS Packages- pkginfo <package name> OS Patches- showrev -p <patch_name> Software Requirement – which ar which ld which make which X Display Server Step 2 – Make changes in hosts file root@erpdisc # more /etc/hosts # # Internet host table # 127.0.0.1        localhost.localdomain    localhost xxx.xx.xx.xx  ...
Post a Comment
Read more