Wednesday, February 3, 2010

Unable to create anonymous session.

Unable to create anonymous session. Your session is no longer valid. Oracle error 20001: java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: Oracle error -1653: ORA-01653: unable to extend table APPLSYS.FND_LOGINS by 16 in tablespace APPS_TS_ARCHIVE has been detected in FND_SIGNON.AUDIT_USER. has been detected in FND_SIGNON.NEW_PROXY_ICX_SESSION. ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.FND_SIGNON", line 18 ORA-06512: at "APPS.FND_SIGNON", line 530 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 390 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 538 ORA-06512: at "APPS.FND_AOLJ_UTIL", line 217 ORA-06512: at line 1 has been detected in createSession(int, String)(userid=6','716498702FC0487EE044001A4B0621D724654810232605405413161982081592').

Solution:
Check the available space in the server.

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...