Knowledge

Technical Tips

Tips:
Oracle on LINUX Admin
APEX Developer
DBA Developer
Portal Developer
Log Miner

Oracle on Linux Administration

 

Oracle Startup Automation on LINUX

Read the tip
This tip provides the necessary steps to integrate Oracle startups and shutdowns into the server startup scripts.  It is designed for Oracle Enterprise Linux (versions 4 and 5) but is equally applicable to RHEL and related LINUX flavors.

APEX Developer

 

APEX Developer

Read the tip
This tech tip demonstrates an APEX v2.2 generic solution to overcome invalid numeric value errors.

DBA Developer

 

Deletion of Duplicate Records

Read the tip
This tip provides the necessary steps to delete duplicate records in a table..

Portal Developer

 

PORTAL Template Usage Report

Read the tip
Determining which pages will be affected when changing a portal template is not something that Oracle Portal gives you out of the box. However, creating a report that shows you this information is not difficult to do (once you know how to get the data!)

LogMiner

 

Using LogMiner

Read the tip
Oracle LogMiner is a tool that can do a little magic when needed.  What can it do for you?  A couple of its uses are retrieving data that has been deleted or changed, it can do a low level audit to find out what happend, or it can be used to create a rollback of statements for data recovery.