My Oracle DB 12c instance was not starting up. While connected as an idle instance ( / as sysdba ) and executing startup; command, I was getting an error:
ORA-00093: pga_aggregate_target must be between 10M and 4096G-1
Getting an error “ORA-00093: pga_aggregate_target must be between 10M and 4096G-1” on Oracle DB startup
connectivityoracleoracle-12c
Related Question
- I am getting error ORA-03113 at the time of startup database.
- Where is the oracle 12c logfile
- Oracle Database Not Opening – How to Resolve ORA-00600 Error
- Oracle Error ORA-00959 – Tablespace Does Not Exist But Visible in Select
- Oracle Database – Unable to Start Troubleshooting
- Oracle 12c – ORA-01017 Error When Connecting Remotely as SYSDBA
Best Answer
Found an answer at : http://www.databaseskill.com/400704/
But the explanation is not very clear. To summarize :
This property 'pga_aggregate_target' is in a file called an spfile which is present at '
C:\app\dbhome\product\12.1.0\dbhome_1\database' for example.I edited this value to one fitting the range which in my case I changed to
855638016Further you require a init file at the same path. If one is not present at the above path you can retrieve a file from '
C:\app\dbhome\admin\orcl\pfile' and rename it toinitorcl.oraAfter doing the above steps connect to an idle instance by running
sqlplus / as sysdbaand try thestartup;commandAnswered my own question for future reference