Prev: ORA-00600: internal error code, arguments: [17059]
Next: APEX in Oracle XE stopped working
From: HansF on 1 Nov 2006 09:35
A few common problems with XE installations:

1) If XE was installed by a Domain Administrator, XE may not install
correctly. The actual problems vary depending on the Domain
Administrator's real capabilities and range from complete failure (while
appearing to install, based on the setup response) to 'crippled install
with various problems'.

Solution: install as a local XP administrator.

2) If XE was installed on a machine using DHCP, and loopback adapter was
not used, XE may install correctly but fail after the IP expired and was
not renewed to the same adddress. This may occur after one or more
reboots. The problems are usually isolated to the listener interaction,
as the listener.ora indicates the host at XE install time and that may
change. One interesting effect is that local SQLPlus logons on the local
machine work (bequeath adapter) whereas remote accesses 'can not display
the database home page' - Oracle's new HTTP listener technique uses the
database listener.

Solution: install with a loopback adapter, and/or keep listener.ora up to
date

3) If XE was installed on the a machine that previously hosted an older
version of Oracle, interesting failures (usually during install) will be
observed due to conflicting pieces in the registry and/or stray DLLs.

Solution: clean the machine thoroughly and reinstall

4) If firewalls are used, they may block ports 1521 and/or 8080 (the
default APEX port). On Linux, these may be inadvertently activated using
SELinux. Symptoms are often similar to listener.ora failures

Solution: properly configure firewalls and SELinux, or disable these
utilities

5) On XP, a number of issues have seen seen when installing on drives
other than C: which seem to relate to 'directory permission inheritance'
on other drives. These may be simply local policies at the site of the
people installing, but are troublesome. The symptoms are often apparent
install, but no database filess or alert_xe.log

Solution: ensure installing user and Oracle really have permission to
create directories and files on the drive



These, and a lot more, are discussed in the Oracle Discussion Forum
specific to XE. To access that, access the OTN discussion forums, sign in
and look for the XE forum. If it does not show up, you need to register -
search for 'register XE' in the Database-General forum for steps.

--
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: Mathijs on 1 Nov 2006 09:59
01 nov 2006, (HansF):

> A few common problems with XE installations:
>
> 1) If XE was installed by a Domain Administrator, XE may not install
> correctly. The actual problems vary depending on the Domain
> Administrator's real capabilities and range from complete failure
> (while appearing to install, based on the setup response) to 'crippled
> install with various problems'.

Crippled install with various problems, you say? Sounds exactly like my
problem. :(

> These, and a lot more, are discussed in the Oracle Discussion Forum
> specific to XE. To access that, access the OTN discussion forums,
> sign in and look for the XE forum. If it does not show up, you need
> to register - search for 'register XE' in the Database-General forum
> for steps.

"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 can't access the database homepage... sigh...
From: Frank van Bortel on 1 Nov 2006 10:00

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?

From: Mathijs on 1 Nov 2006 10:30
01 nov 2006, (Frank van Bortel):

> Any more messages after this line?

No, that is the very alst line of alert_xe.log.
From: Charles Hooper on 1 Nov 2006 11:49
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.

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