Home » Other » 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  |
 |
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 #610740 is a reply to message #610652] |
Mon, 24 March 2014 00:07   |
 |
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
|
|
|
|
Goto Forum:
Current Time: Sun May 04 03:38:57 CDT 2025
|