Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle not Available, Shared Memory realm doesn't exist

925371Mar 21 2012 — edited Mar 27 2012
Hi,

I have problem during XE installation on Windows 2003 R2 SP 2 Enterprise edition. I have uninstall the oracle xe and the result still the same. Finally I uninstall the windows and start all over again, surprisingly the result still the same. FYI, we normally has no issue during installation because this is part of our system we sell to our customer which require oracle xe. This is the first time we have seen this issue.

ORA-01034 : Oracle Not available
ORA-27101 : Shared memory realm doesn't exist.

Oracle XE and listener services is started in the windows services.

if we try to do startup the following message occured.

SQL> connect /as sysdba

Connected to an idle instance.
SQL> startup
ORA-44412: XE edition memory parameter invalid or not specified
SQL>

I can send you the oracle_xe log, init ora, and OpsBuildAll.log to create the database.

When we compare with the working installation, we saw that the size of oraclexe folder is less, it's just 233MB while the working one is over 1GB. After investigation, found out that the .dbf files is not avaiable in the oradata folder, i have tried to copy those files from the working one but the problem stay the same, probably there are a lot of files more missing.


Appreciate your help on this.

Thanks,

Agus
This post has been answered by Udo on Mar 23 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2012
Added on Mar 21 2012
22 comments
2,046 views