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.
November 25, 2009 at 3:46 AM
Peter said…
Thanks - spent almost an hour looking for a solution to this until I found this post!
November 27, 2009 at 4:40 AM
techyuce said…
Since two days I was searching for this solution. You are awesome man!!!
December 9, 2009 at 4:15 AM
A Bilal said…
Thanks! it really works.
August 23, 2015 at 9:29 AM
Unknown said…
U R MASTER , THANKS DEAR
February 11, 2017 at 9:26 PM
suhail said…
it's really great yrrr.......this work immediately
June 30, 2019 at 9:06 AM
Anonymous said…
THX! You saved me a lot of time ;)
July 16, 2019 at 12:51 AM
Anonymous said…
Very helpful, thanks a lot.
March 8, 2020 at 5:48 AM
Anonymous said…
You are owsome
October 13, 2020 at 8:59 AM
Anonymous said…
thanks a lot!
March 2, 2021 at 1:48 PM
Post a Comment

Popular posts from this blog

How to mount a WD Book Live as NFS in OEL6U3

-
Scenario : I have a Windows 8 (Host) laptop on which I am running two OEL6U3 (Guest) machines in a Virtual Box. I want to have a shared mount between the two Linux machine which will allow me to read/write from both the machines concurrently. Its a very common scenario for a High Availability Environment. Virtual Box provides a facility of creating sharable VDI disks which can be mounted on multiple machines, but it doesn’t allow concurrent read/write access from multiple machines. If you are installing RAC database then its still achievable, because ASM will provide the feature of concurrent read/writes, but if you want to install a WebLogic cluster with High Availability the recommended approach would be to have a Shared Mount. Step to create a shared nfs mount is fairly simple. I am using a WD My Book Live, and will mount the Public folder as shared mount 1. Get the hostname/ip of the WD device. 2. On the Linux Machine 1 create the folder where you want to mount the nfs
Read more

Oracle SQL Developer 19.4 font too small

-
Image
I downloaded the latest version of Oracle SQL developer on my windows laptop and when I started it, the font on GUI was too small. To fix the font size scroll to the bottom of the  'Welcome Page' and uncheck 'show on startup'. Restart the SQL Developer and issue will be fixed.
Read more