Archive for February, 2009

Resize Undo Tablespace after ORA-03297 file contains used data beyond…

February 12, 2009  |  dba  |  8 Comments

Every Oracle Database must have a way of maintaining information that is used to rollback changes to the database. This information consists of records of the actions of transactions, primarily before they are committed. All these records are called undo. When an user or application issue a rollback statement, undo records...

Read More

Oracle Enterprise Manager fails to start! OC4J Configuration issue

February 8, 2009  |  dba, linux  |  28 Comments

If you ever tried to start the Enterprise Manager with the command 'emctl start dbconsole' and you got stuck with the error: OC4J Configuration issue. <ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<YOURHOST>_<YOURDB> not found. for instance: OC4J Configuration issue. /opt/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_db.neoface.pt_ORCL not found. Then the cause may be that Database Control is not configured or misconfigured... This can be verified by...

Read More