ORA-27101: shared memory realm does not exist

#11

Mathijs wrote:

Quote:

Hi,

I installed OracleExpress on a windows 2003 server. Right after the
installation, I was able to create and use a database. Then, after the
first reboot, the database didn't start automatically, but after
SQL> connect /
SQL> startup
things worked fine again. Now, after a third reboot, this trick doesn't
work anymore:
SQL> connect /
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Q: How can I fix this? (there is already data in my database that I
really would like to use) And that Oracle behaves differently after the
second and the third reboot?

Thanks in advance for your help. Below is the result of a few obvious
things that I checked before posting this message.

M.

I've checked the ORACLE_SID in the environment and it is set to XE.
>set
...
ORACLE_SID=XE
...

The listener is running:
>lsnrctl status XE
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit W..: Ver.. 10.2.0.1.0 - Production
Start Date 01-NOV-2006 10:29:36
Uptime 0 days 0 hr. 1 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE

and tnsping works:
>tnsping xe
...
OK (30 msec)

I compared your LSNRCTL STATUS SID output with that of my server. This
is what my output looks like:
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version
10.2.0.2.0 - Production
Start Date 28-OCT-2006 09:35:22
Uptime 4 days 3 hr. 4 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
D:\oracle\product\10.2.0\db_1\network\admin\listen er.ora
Listener Log File
D:\oracle\product\10.2.0\db_1\network\log\listener .log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver name)(PORT=1521)))
Services Summary...
Service "DB1" has 1 instance(s).
Instance "DB1", status UNKNOWN, has 1 handler(s) for this service...
Service "DB1.world" has 1 instance(s).
Instance "DB1", status READY, has 1 handler(s) for this service...
Service "DB1_XPT.world" has 1 instance(s).
Instance "DB1", status READY, has 1 handler(s) for this service...
Service "DB2" has 1 instance(s).
Instance "DB2", status UNKNOWN, has 1 handler(s) for this service...
Service "DB2.world" has 1 instance(s).
Instance "DB2", status READY, has 1 handler(s) for this service...
Service "DB2_XPT.world" has 1 instance(s).
The command completed successfully

It looks like your system is set to automatically register databases,
while I hand edited the listener.ora file to add the connections.

Also, I noticed that your spfile specifies 20 sessions, while the alert
log shows 49 on the last startup, but I am not sure if this has any
impact.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

#12

On Wed, 01 Nov 2006 14:59:10 +0000, Mathijs wrote:

Quote:

"Forum registration is possible only by downloading and installing Oracle
Database XE. After installation, click on the "Registration" link from
the Database homepage."
- http://www.oracle.com/technology/pro.../xe/forum.html

I am sorry to note that the search capability for OTN Discussion Forum
does not seem to work for you. I have posted the solution to this umpteen
times in Oracle's Database-General and Database-Installation forums. The
link on your database home page is a courtesy copy only.

Here it is again:

1) Register your request to access tyhe XE forum at
http://www.oracle.com/technology/xe/registration

2) Sign in to the OTN Discussion groups with the same userid that you
registered;

3) Access the discussion forum at
http://forums.oracle.com/forums/forum.jspa?forumID=251

Notes:

There is no need to wait for the registeration confirmation email.

You must to log in to discussion forums every time you want to access XE
forum

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

#13

Charles Hooper schreef:

Quote:

Frank van Bortel wrote:
Mathijs schreef:

01 nov 2006, (Charles Hooper):

Check the initialization file, check the alert log.
I suspect this has something to do with it:

Mon Oct 30 11:35:58 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
However, I would not know where to start resolving this...
Someone else, perhaps?

Any more messages after this line?

I believe that "Heap size 2208K exceeds notification threshold (2048K)"
just indicates that a large object is being read into the SGA. Each
object loaded into the SGA requires a continuous range of memory.
Loading and unloading of large objects into the SGA can cause lot of
little available memory areas, that may be too small for a slightly
larger object to use, thus the instance may reach the SGA_MAX size
quicker than expected. This is just a polite warning that a large
(2.2MB) object is being loaded.

I almost tripped over that warning too.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

Hm - it has nothing to do with limits imposed on XE, then?

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

#14

Frank van Bortel wrote:

Quote:

Charles Hooper schreef:
Frank van Bortel wrote:
Mathijs schreef:

01 nov 2006, (Charles Hooper):

Check the initialization file, check the alert log.
I suspect this has something to do with it:

Mon Oct 30 11:35:58 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
However, I would not know where to start resolving this...
Someone else, perhaps?

Any more messages after this line?

I believe that "Heap size 2208K exceeds notification threshold (2048K)"
just indicates that a large object is being read into the SGA. Each
object loaded into the SGA requires a continuous range of memory.
Loading and unloading of large objects into the SGA can cause lot of
little available memory areas, that may be too small for a slightly
larger object to use, thus the instance may reach the SGA_MAX size
quicker than expected. This is just a polite warning that a large
(2.2MB) object is being loaded.

I almost tripped over that warning too.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

Hm - it has nothing to do with limits imposed on XE, then?

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Correction:
"continuous" should read "contiguous"
"cause lot of little available memory areas" should read "cause a large
number of small non-contiguous memory areas"

http://download-east.oracle.com/oowsf2005/003wp.pdf (bottom of page 10,
top of page 11)

This is a new feature of 10g R2. I have seen the same warning in
10.2.0.2 Standard Edition. There is a way to disable the warning, but
I can't recall the method right now (might be
_kgl_large_heap_warning_threshold).

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

#15

01 nov 2006, (HansF):

Quote:

1) Register your request to access tyhe XE forum at
http://www.oracle.com/technology/xe/registration

"Thank you for registering for the private Oracle Database XE Discussion
Forum hosted by Tom Kyte. A confirmation email containing the Forum URL
should arrive shortly."

Quote:

2) Sign in to the OTN Discussion groups with the same userid that you
registered;

http://forums.oracle.com/forums/cate...?categoryID=84
(I'm logged in, top right says Welcome, Mathijs)

Quote:

3) Access the discussion forum at
http://forums.oracle.com/forums/forum.jspa?forumID=251

Error: you do not have permission to view the requested forum or
category.

Thanks for your help, Hans but it seems that Oracle doesn't like me at
all

#16

On Thu, 02 Nov 2006 08:21:06 +0000, Mathijs wrote:

Quote:

2) Sign in to the OTN Discussion groups with the same userid that you
registered;

http://forums.oracle.com/forums/cate...?categoryID=84
(I'm logged in, top right says Welcome, Mathijs)

Does it show the XE forum on the bottom of that page?
Did you sign in using the same userid that was registered for XE?

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

#17

On Thu, 02 Nov 2006 13:54:22 +0000, HansF wrote:

Quote:

On Thu, 02 Nov 2006 08:21:06 +0000, Mathijs wrote:

2) Sign in to the OTN Discussion groups with the same userid that you
registered;

http://forums.oracle.com/forums/cate...?categoryID=84
(I'm logged in, top right says Welcome, Mathijs)

Does it show the XE forum on the bottom of that page?
Did you sign in using the same userid that was registered for XE?

And ... did you re-sign in after you registered?

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

#18

02 nov 2006, (HansF):

Quote:

Does it show the XE forum on the bottom of that page?
Did you sign in using the same userid that was registered for XE?

And ... did you re-sign in after you registered?

I managed to enter the forum, thanks alot.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ORA-27101: shared memory realm does not exist

comp.databases.oracle.misc comp.databases.oracle.misc

Re: ORA-27101: shared memory realm does not exist - 11-01-2006 , 11:00 AM

Re: ORA-27101: shared memory realm does not exist - 11-01-2006 , 12:03 PM

Re: ORA-27101: shared memory realm does not exist - 11-01-2006 , 01:22 PM

Re: ORA-27101: shared memory realm does not exist - 11-01-2006 , 01:37 PM

Re: ORA-27101: shared memory realm does not exist - 11-02-2006 , 02:21 AM

Re: ORA-27101: shared memory realm does not exist - 11-02-2006 , 07:54 AM

Re: ORA-27101: shared memory realm does not exist - 11-02-2006 , 08:08 AM

Re: ORA-27101: shared memory realm does not exist - 11-02-2006 , 09:39 AM