To have two copies of PFILE in a ORACLE Database, follow the below steps...
UNIX:
Create a Symbolic link in $ORACLE_HOME/dbs folder that points to the file in $ORACLE_BASE/admin/XYZ/pfile/initXYZ.ora
ln -s $ORACLE_BASE/admin/XYZ/pfile/initXYZ.ora $ORACLE_BASE/dba/initXYZ.ora
where XYZ is the database
WINDOWS:
Create a pfile in ORACLE_BASE\admin\XYZ\pfile and put an entry in the ORACLE_HOME\dbs\initXYZ.ora as given below
ifile=\admin\XYZ\pfile\initXYZ.ora
where XYZ is the database
Checking the tablespace is a day today activity. We can use the Enterprise Manager in ORACLE 10g to monitor the tablespace. But sometimes the EM eats up lots of system resources, so I don't use EM to monitor the database, but it is quite useful in many places. I decided to come up with a shell script to generate a tablespace report as shown below,
Script to generate and mail the report : Code.zip
