When you get the message ORA-00845: MEMORY_TARGET not supported on this system while starting the DB.
It means you are running short of memory for that instance.
1) Increase RAM on your machine.
2) Else rework on the memory assigned for your database.
3) Else stop other database and start the needed one.
Here I get a error while starting a DB called "ORCL"
SQL> startup;
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
Since I already have a DB called "TEST". I am stopping it and starting the "ORCL".
SQL> select name from v$database;
NAME
---------
TEST
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
It means you are running short of memory for that instance.
1) Increase RAM on your machine.
2) Else rework on the memory assigned for your database.
3) Else stop other database and start the needed one.
Here I get a error while starting a DB called "ORCL"
SQL> startup;
ORA-00845: MEMORY_TARGET not supported on this system
SQL>
Since I already have a DB called "TEST". I am stopping it and starting the "ORCL".
SQL> select name from v$database;
NAME
---------
TEST
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup;
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 536872992 bytes
Database Buffers 293601280 bytes
Redo Buffers 2412544 bytes
Database mounted.
Database opened.
SQL> select name from v$database;
NAME
---------
ORCL
SQL>
No comments:
Post a Comment