Logrotating of files like default-web-access.log with help of Linux

By | October 27th, 2009|Categories: App. Server|Tags: , |

What to do about the ever growing files on Oracle application server as: - default-web-access.log - server.log and more.. These files are not logrotated (OAS < 10.1.3 ) and cannot always be deleted or renamed manually on a 'normal' way, and it must be scripted to avoid extraordinary large log-files. Quite annoying, until Frits Hoogland pointed me to a standard Linux-functionality, 'logrotate'.

Apex, HTTP-404 while clicking 'application builder'

By | October 26th, 2009|Categories: App. Server, Database|Tags: |

Apex, version, on a is working fine for some time. Then, while clicking the 'application builder' home-page, we got the 'page not found'-error in the browser. Logging of Apache shows: mod_plsql: /pls/apex_schd/f HTTP-404 ORA-03113: end-of-file on communication channel\n mod_plsql: Unable to reset state for mode 0: Err 3114 url=>/pls/apex_schd/f

Java-errors in – ORA-29516 and ORA-03113

By | October 19th, 2009|Categories: Database|Tags: , |

Why is it that java is crossing my path so much now and then... After a restore of a database on another node, including renaming him/her, java classes were invalid. Trying to create / replace them, errors popped up: ORA-29516: Aurora assertion failure: Assertion failure at eox.c:317 Uncaught exception Root of all Java exceptions: java.lang.NullPointerException

RMAN: restore database on another node including rename

By | October 18th, 2009|Categories: Database, RMAN|Tags: , |

Consider this, you've got no DataGuard at your disposal. Single node, relying on your RMAN-backup on disk, which is fortunately copied to tape. Now your complete node is burning down. What's is left is your RMAN-backup. In a bad scenario you'll have to restore this to another node.

Cloning / duplicating with RMAN, the basics

By | October 18th, 2009|Categories: Database, RMAN|Tags: , |

It is considered a skill every DBA should have, cloning / duplicating a database with RMAN. My own basic checklist through an example: Cloning of the DEVDB on the node LARRIE to node ELLISON, new database name DEVDBNEW