Ask the Expert

Unable to allocate bytes of shared memory

On HP P-IV 2 MHz, 2 GB RAM, Windows 2000 Server, during installation of Oracle 8.1.5, an error message appears: "unable to allocate 82731112 bytes of shared memory." After this message, the installation is complete. TNSlistener service starts, Services service starts, and it connects with only internal at STARTUP.

    Requires Free Membership to View

There may be a number of reasons why this is happening, but the most obvious is that the shared pool defined for your database is not large enough. Try increasing the SHARED_POOL_SIZE initialization parameter for your database and restart it. Another possibility is to pin frequently used large packages so that they are not aged out.

This was first published in October 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: