Rajeevi, Thanks for pointing out the things that I missed. One otherway to find out which parameter file is being used by the current instance (BIT TEDIOUS APPROACHE)
do the query:
spool out.txt
select name, value from v$parameter;
spool off;
exit;
From the out.txt you can figure out which one is being used by matching the values to the existing parameter files.
Sam




Reply With Quote