Prev: ORA-00600: internal error code, arguments: [17059]
Next: APEX in Oracle XE stopped working
From: Charles Hooper on 1 Nov 2006 12:00
Mathijs wrote:
> 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\listener.ora
Listener Log File
D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myservername)(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.

From: HansF on 1 Nov 2006 13:03
On Wed, 01 Nov 2006 14:59:10 +0000, Mathijs wrote:


> "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/products/database/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.

From: Frank van Bortel on 1 Nov 2006 14:22
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...
From: Charles Hooper on 1 Nov 2006 14:37
Frank van Bortel wrote:
> 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.

From: Mathijs on 2 Nov 2006 03:21
01 nov 2006, (HansF):

> 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."

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

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

> 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 :(
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: ORA-00600: internal error code, arguments: [17059]
Next: APEX in Oracle XE stopped working