startup nomount pfile='..' takes quite long time in 11g
Hello,
Today I removed half of my total physical memory and tried to reduce my db memory. So I altered sga_max_size without resizing sga_target and tried to restart an instance. During a startup it gave me an "ORA-00823: Specified value of sga_target greater than sga_max_size". Then I reduced the sga_target in the pfile and executed startup nomount pfile='...'. The problem is that I can't login. It seems it is still executing as showing a black window. So what would be the further action against this?
Thank you.