ORA-27102: out of memory - is this joke ???
When I try to start my fresh installed Oracle I get this error:
ORA-27102: out of memory
SVR4 Error: 12: Not enough space select *
The problem is with shared_pool_size.
I Cant change this parameter from SQL Plus (Oracle is down) so the only way is to change it in pfile.
When I decrease shared_pool_size = 172M then with next startup I receive error:
ORA-00371: not enough shared pool memory, should be atleast 294359756 bytes
If I increase this value by 1 MB or to suggester 294359756 bytes (so around 300 Mb) than back again I got error:
ORA-27102: out of memory
SVR4 Error: 12: Not enough space select *
Then what on Earth should I to do ???