2014年3月11日火曜日

ORA-01157:cannot identify/local data file

Error info:
ORA-01157: cannot identify/lock data file 5
ORA-01110: data file 5 ‘/u01/app/oracle/oradata/SID/users02.dbf’

Solution1:
> sqlplus / as sysdba
SQL> startup mount;
SQL> alter database datafile  ‘/u01/app/oracle/oradata/SID/users02.dbf‘ offline drop;
SQL> alter database open;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

Solution2:
SQL>startup mount;
SQL>recover datafile filename;
SQL>alter database open;

Doc:
http://oracle.na7.info/11_2_datafile.html

2014年3月4日火曜日

[ADF Mobile]About deployment error

ADF Mobile deployment error below:
Can not run program "... platform-tools\aapt"
CreateProcess error=2, The system cannot find the file specified.

Workaround:
Simply copy those files and the lib sub directory to the platform-tools directory.

This is a known issue, and error cause is JDeveloper can not find these libraries(If you download the complete Android SDK as of 14th May 2013 and later, Google has changed the structure of the SDK such that some critical files) .....