Pages

Thursday, January 13, 2011

R12 Blank Login Page

This may happen some times, mainly after the clone or even after some bounce.

There are multiple options to check, and try:-

Wednesday, January 12, 2011

11g alert log

The alert log location is obviously changed in 11g. The parameter that defines the top location ( Can be called ADR Base ) is "diagnostic_dest"


SQL> show parameter diag

Friday, November 5, 2010

Tablespace Administration - 1

ORA-XXXX: unable to extend ...in tablexpace XYZ

The error will always have a tablespace name defined at the place of XYZ above.
The error code may be different as the issue may be with table, index, temp segment etc, but the reason and resolution are same.
Reason:- Running short of space
Resolution:- Add space