Showing posts with label Login issues in Oracle EBS 11i after Clone ( from hotbackup). Show all posts
Showing posts with label Login issues in Oracle EBS 11i after Clone ( from hotbackup). Show all posts

Thursday, 12 April 2012

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.