Home » SQL & PL/SQL » Client Tools » [oracle 10g] ora-27101 shared memory realm does not exist windows xp
[oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610639] Sat, 22 March 2014 06:09 Go to next message
Vivek21
Messages: 7
Registered: March 2014
Junior Member
I am getting following error on executing this command

sql>connect system
password : 

ora-01034: ORACLE not available
ora-27101: shared memory realm does not exist windows


>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-MAR-2014 17:06:22

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date                22-MAR-2014 14:58:44
Uptime                    0 days 2 hr. 7 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\listener.ora
Listener Log File         D:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


I have set the ORACLE_HOME, ORACLE_SID, path & TNS_ADMIN variables. Still not working. Also, i have started services. I also cannot open the database home page i.e.

127.0.0.1:8081/apex

8081 is the set port.

coudnt understand the problem. Is it the pfile or spfile problem ?

Thanks

[Updated on: Sat, 22 March 2014 06:39]

Report message to a moderator

Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610643 is a reply to message #610639] Sat, 22 March 2014 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The instance is not started.

Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610645 is a reply to message #610643] Sat, 22 March 2014 07:06 Go to previous messageGo to next message
Vivek21
Messages: 7
Registered: March 2014
Junior Member
What can i do now ?

By default, my initXE.ora file data is

*.SPFILE='D:\oraclexe\app\oracle\product\10.2.0\server\dbs\spfileXE.ora'
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610646 is a reply to message #610645] Sat, 22 March 2014 07:22 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
has OS Service for the database been started & is now running?

open Command Window & do exactly (line for line) as below

sqlplus
/ as sysdba
startup

COPY the results from above then PASTE all back here
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610647 is a reply to message #610646] Sat, 22 March 2014 07:33 Go to previous messageGo to next message
Vivek21
Messages: 7
Registered: March 2014
Junior Member
Yes, I have checked OracleServiceXE & OracleXETNSListener in the Services, both have status as started.


The result is

SQL> startup
ORA-03113: end-of-file on communication channel

[Updated on: Sat, 22 March 2014 07:35]

Report message to a moderator

Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610648 is a reply to message #610647] Sat, 22 March 2014 07:39 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
post excerpt from alert_SID.log file showing the attempted STARTUP & resultant error

when was the last time the DB started without error?
what changed since then?
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610649 is a reply to message #610648] Sat, 22 March 2014 07:43 Go to previous messageGo to next message
Vivek21
Messages: 7
Registered: March 2014
Junior Member
I have freshly installed oracle 10g on my system. I havent got it run till now.

I have found an alert_XE.log here "D:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\trace\".

Dump file d:\oraclexe\app\oracle\product\10.2.0\server\rdbms\trace\alert_xe.log
Sat Mar 22 10:03:05 2014
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU                 : 4 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1530M/2713M, Ph+PgF:3209M/4603M, VA:1945M/2047M
Sat Mar 22 10:03:05 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0


I have other databases also installed on my system like SQL server 2008. Is it the cause of the problem or the pfile or spfile are the cause of the problem ?

Thanks
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610650 is a reply to message #610649] Sat, 22 March 2014 07:45 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
post excerpt from alert_SID.log file showing the attempted STARTUP & resultant error
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610651 is a reply to message #610650] Sat, 22 March 2014 07:51 Go to previous messageGo to next message
Vivek21
Messages: 7
Registered: March 2014
Junior Member
Where can i find that file ?

I got this file at D:\oraclexe\app\oracle\product\10.2.0\server\RDBMS\trace location. So, i posted the content of it.
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610652 is a reply to message #610651] Sat, 22 March 2014 08:01 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
>Where can i find that file ?
I don't know for sure.
AFAIK Windows systems has a "find file" capability.
I suggest you use it.
I do know the correct alert_XE.log file will contain the STARTUP command plus a line containing ORA-03113 error.
IIRC, only singe XE instance can exist on same DB Server system.
Does another XE instance currently exist on this system?
Re: [oracle 10g] ora-27101 shared memory realm does not exist windows xp [message #610740 is a reply to message #610652] Mon, 24 March 2014 00:07 Go to previous message
Vivek21
Messages: 7
Registered: March 2014
Junior Member
I have searched the alert_XE file through windows search functionality, but i got the same one which i posted above.

>Does another XE instance currently exist on this system?

How can i check this ?

Another strange thing i found in my oraclexe directory. When i installed oracle in my friends system, its size was 1.30 GB but my system's oraclexe directory's size is only 248 MB.

Why is the difference in installation size ? I have properly installed it too.

Also, i have installed it about 4-5 times in my system after reinstalling since it was not working. At first install, it worked fine for a while, but creating problems, so i reinstalled it. Now it is not working at all.

Can somebody suggest my the right solution ?

Thanks

[Updated on: Mon, 24 March 2014 01:57]

Report message to a moderator

Previous Topic: execute long time ( table lock )
Next Topic: [oracle 10g]oracle connection problem
Goto Forum:
  


Current Time: Wed Oct 01 22:28:21 CDT 2014

Total time taken to generate the page: 0.11843 seconds