.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
ORA-04031
ORA-04031:unable to allocate string bytes of shared memory ("string","string","string","string")
Cause:More shared memory is needed than was allocated in the shared pool.
Action:If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".
Posts about ORA-04031

RMAN memory issue

I believe that ORA-04031 is coming from your target database. I would set large pool size to something more reasonable than 1.5M or 3M... like 16 or 32M at least. 2006/7/17 John P Weatherman <asahos

Oracle 10 on linux

I am running Oracle 10 R2 on linux with automatic memory management and keep getting the following error ORA-04031 unable to allocate 3888 bytes of shared memory ( "shared pool " "unknown object " "

ORA-04031 on Oracle 8.1.7.0

Oracle Version 8.1.7.0 Solaris 2.8 We ran into an issue using database links and mv 's. It seemed to work to recreate instead of refreshing mv 's but I am thinking that that might be causing an

X$ksmsp (OSEE 10.2.0.2 on Solaris 8)

A couple of months ago Oracle Support sent me a query to run against x$ksmsp in order to identify shared pool fragmentation. They assured me that any problems with querying x$ tables were from earl

ORA-04031 in SLES9/Itanium with 9ir2

Hi I installed recently oracle 9 with 9.2.0.7 patchset in an itanium SLES 9 server (thanks to the people in this list that helped me) and created a database and populated it and everything was workin

SGA Free memory

This is normal behavior as chunks are flushed from and added to the shared pool the memory fluctuates. As long as you are not seeing ORA-04031 error or contention on the shared pool latch is not too

"session param valu " in x$ksmlru

> It seems that these cause a lot of flushes. Are these chunks of type > "freeable "? The session param values (memory allocated at the start of each session) are large contiguous allocations. Once

ORA-04031 error while trying to load a PL/SQL object

Folks I have an 11i (11.5.0)/9.2.0.6 (64-bit) database running on Solaris 8 with the following shared pool sizing Shared_pool 1.2 GB Db_cache_size 6 GB ODM is enabled and that is why the cache s

Top Shared Pool Consumers

Hi Check these Note on Metalink. - Oracle Note 61623.1 Resolving shared pool fragmentation. - Oracle Note 146599.1 Diagnosing and Resolving Error ORA-04031. there are way too many thing

optimizer time reported as?

I remember the default on 8.1.7 being 80 000 and Oracle support had us lower it to 2 000 while we were working on an ORA-04031 iTAR. ora817 > @(protected)/parms 'For all columns Y Yes/True N No/Fals

Large Pool and ORA-04031

Is it possible to receive an ORA-04031on a large_pool that is too small? I did not think so until I stumbled across the following note (62140.1) on Metalink MTS and the Large Pool ~~~~~~~~~~~~~~~

Ora 4031

On 05/02/2005 07 13 44 PM Burton Laura wrote > I have just created a database for 9.2.0.1 on Windows 2003. This was an > 8.1.6 database that I imported the database from. Today we started >

ORA-04031: unable to allocate 4200 bytes of shared memory

I have a couple of unrelated Oracle 8.1.7 databases that occasionally getting the following error ORA-04031 unable to allocate 4200 bytes of shared memory ( "shared pool " "unknown object " "sga hea

Shared pool from 8i to 9i

I would not totally blame Oracle. PeopleSoft still has LONG data types running around that are problematic at best and cause ORA-04031 errors. The real fix is to get rid of the longs which in 99%

relation shared pool elements phys mem

Hi I have an undersized development box where my main problem is the memory I regularly get ERROR ORA-04031 unable to allocate 48 bytes of shared memory ( "large pool " "unknown object " "

-none-

We have worked a half-dozen 04031 related iTARs that support acknowledge trace to Oracle memory management bugs . Pinning packages reducing the size of objects considered large and increasing the

Miss Bamima

Hi Listers Take it easy I am not gonna introduce some DBA chick (sorry feminists... just kidding). While creating a new database in 8.1.7 I received the following error. ORA-04031

4031 - errors

Hi Lists Jonathan is right. There may be two possible reasons for this error 1) really have very low value of allocated for shared sql area or 2) High version counts of cursors are consuming

Simulate a StandBy with Standard Edition

--- Mary Bahrami <mbahrami@(protected) > wrote > Jared had an example of this at > http //www.dbazine.com/still1.shtml > Mary ... and dbazine is subsequently slashdotted. no one hears

MTS versus dedicated for resolving a ORA-04031.

We have upgraded our databases from 8174 to 9203. We have started encountering ORA-04031 's on processes that are using MTS. Once we switch that process to use a dedicated connection then the pro

ora-04031

Hi all weird thing the developers is executing pretty big queries via java. Sometimes on some of the queries they get this error if they take the SQL and execute it via sqlplus immediate it works

Determining library_cache usage

We get this error ORA-04031 unable o allocate 40048 bytes of shared memory ( "shared pool " "SELECT SASOFPD.PD_DT ... " "sqa area " "text kpp_extend ") -4031 when trying to run a mon
User Posts


No registration required.
Post Topic:
Oracle Database Server Error Codes
ORA-00020   ORA-00054   ORA-00119   ORA-00279   ORA-00381   ORA-00439   ORA-00600   ORA-00604   ORA-00904   ORA-00907   ORA-00911   ORA-00922   ORA-00923   ORA-00936   ORA-00942   ORA-01000   ORA-01017   ORA-01031   ORA-01033   ORA-01034   ORA-01078   ORA-01092   ORA-01113   ORA-01122   ORA-01161   ORA-01422   ORA-01501   ORA-01555   ORA-01562   ORA-01578   ORA-01650   ORA-01652   ORA-01658   ORA-01722   ORA-01756   ORA-01843   ORA-01925   ORA-01940   ORA-02019   ORA-02097   ORA-02143   ORA-03113   ORA-04030   ORA-04031   ORA-04068   ORA-06502   ORA-06512   ORA-06531   ORA-06550   ORA-07445   ORA-12154   ORA-12203   ORA-12500   ORA-12535   ORA-12540   ORA-12545   ORA-12560   ORA-12599   ORA-12638   ORA-12709   ORA-12838   ORA-12913   ORA-16038   ORA-20000   ORA-24324   ORA-27125   ORA-28575   ORA-28576   ORA-29283   ORA-29540   ORA-32004