ORA-44412: XE edition memory parameter invalid or not specified

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-44412: XE edition memory parameter invalid or not specified

SQL> startup pfile=C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora
ORACLE instance started.

Total System Global Area 805306368 bytes
Fixed Size 1289996 bytes
Variable Size 209715444 bytes
Database Buffers 591396864 bytes
Redo Buffers 2904064 bytes
Database mounted.
Database opened.

SQL> create spfile from pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora';

File created.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 805306368 bytes
Fixed Size 1289996 bytes
Variable Size 209715444 bytes
Database Buffers 591396864 bytes
Redo Buffers 2904064 bytes
Database mounted.
Database opened.

Comments

Asim said…
You are the best my problem has been resolved thanks to you Master.

I really appriciate you help to all of us keep it up.
Peter said…
Thanks - spent almost an hour looking for a solution to this until I found this post!
techyuce said…
Since two days I was searching for this solution. You are awesome man!!!
A Bilal said…
Thanks! it really works.
Unknown said…
U R MASTER , THANKS DEAR
suhail said…
it's really great yrrr.......this work immediately
Anonymous said…
THX! You saved me a lot of time ;)
Anonymous said…
Very helpful, thanks a lot.
Anonymous said…
You are owsome
Anonymous said…
thanks a lot!

Popular posts from this blog

How to mount a WD Book Live as NFS in OEL6U3

Oracle SQL Developer 19.4 font too small