Saturday, November 22, 2008

CURRENT / ACTIVE REDO LOG FILE LOST

SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1247900 bytes
Variable Size 79693156 bytes
Database Buffers 83886080 bytes
Redo Buffers 2945024 bytes
Database mounted.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBG2\REDO03.LOG'
ORA-00312: online log 3 thread 1:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DBG2\SYSTEM\REDO03B.LOG'

SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

Sunday, November 16, 2008

oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.


Following error may appear when you click on AppsLocalLogin.jsp link while doing adconfig on DB tier:JSP errororacle.apps.fnd.common.PoolException: Exception creating new Poolable object.

It is best to have the services down while doing autoconfig, to avoid such errors.