SQL> startup pfile=initaux.ora ORA-00371: not enough shared pool memory, should be at least 16341008384 bytes |
I was trying to start an auxiliary instance to build a standby database from live database and faced the above error. Normally there is no need to specify sga_target to start an auxiliary instance, however, this was because of a bug (as per MOS) and solution in this case is to specify sga_target in the init file being used to start auxiliary instance.
Although suggested value sga_target was 5G, however, it also did not work and there was another error suggesting to set sga_target to at least 12G, which I did. After that, issue got resolved and I was able to start auxiliary instance without any issue.
No comments:
Post a Comment