ORA-01110 & ORA-26040

Login issues in Oracle EBS 11i after Clone ( from hotbackup)

Error in login page:

ORA-01110: data file 98: '/disk09_250/oradata/mine/a_txn_data14.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option

SOLUTION:
1. Compile jsp:
cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush

2. Access the form directly using the URL:
http://sanop.mine.com:8020/forms/frmservlet?form_params=config=PRODMINE

3. Run the request:
"Synchronize WF LOCAL tables" - Parameters: ALL
"Synchronize WF LOCAL tables" - Parameters: FND_USER
Restart Apache. This will resolve the issue.

No comments:

Size of schema in Oracle database 23AI

  How to find the size of schema in the 23AI ORACLE Database. SQL>  select sum(bytes)/1024/1024 "SIZE_IN_MB" from dba_segments;...