Database Administration (MOSC)

MOSC Banner

startup nomount pfile='..' takes quite long time in 11g

edited May 25, 2014 8:55PM in Database Administration (MOSC) 4 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center