Because of your initial post we supposed you were using spfile but, if you are using pfile you have to alter init.ora.Originally Posted by bittus
Could you please check your initialization method by running query below?
Code:SELECT instance_name, DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter , v$instance WHERE name = 'spfile';




Reply With Quote