How to clear apache cache

1. Stop apache

2. cd $OA_HTML

3. rm -rf _pages

4. Start apache

Oracle DBA / Apps DBA Interview Questions

Q:- Discuss how to open the database in the event that the parameter file is lost

A :- The alert.log file records all the changes at the database level.
When we start the database the parameters settings (non-default values)
are entered in the alert.log file. e.g. from an alert.log file,

processes = 200
__shared_pool_size = 805306368
shared_pool_size = 637534208
__large_pool_size = 33554432
large_pool_size = 33554432
control_files = /u001/app/oraclet/oradata/blake/control/control01.ctl
sga_target = 1375731712
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ENABLE
log_archive_max_processes= 2
log_archive_min_succeed_dest= 1
db_domain = cup.cam.ac.uk
....................
..................
...................

Recreate the pfile from alert.log file