Home
All Oracle Error Codes
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

RE: Library Cache Lock

John Kanagaraj

2004-01-29

Replies:
Jonathan,

We have had many similar situations where we had lib cache locks/pins on a
_table_ - did you notice that all the waiters were queueing up behind
another session that was 'hanging' on a 'row cache lock'? (for this happened
consistently in our siutation). This is a fairly large Oracle Apps 11.5.7
installation - this occurred in a schema that has a number of partitioned
tables and MVs. It is possible that there were partial refreshes of the MVs
occurring at the time of the problem.

In any case, we had a large reduction in the occurrences when we upgraded
from 8.1.7.3 to 8.1.7.4, and obtained another reduction when we re-arranged
and serialized some background jobs (Apps concurrent managers). A TAR with
Oracle was useless - we were sent on a runaround and passed from one to
another until we dropped the issue (since the pain went away). I did take
some system dumps, but they might have been purged (I can dig around).

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **


>-----Original Message-----
>From: Jonathan Lewis [mailto:jonathan@(protected)]
>Sent: Wednesday, January 28, 2004 12:13 PM
>To: oracle-l@(protected)
>Subject: Library Cache Lock
>
>
>
>8.1.7.4
>Windows 2000 Server
>ca.200 sessions, about 30 active.
>
>About a dozen sessions go into waits
>for Library Cache Lock for the best
>part of 300 seconds. (At which they
>probably all get ORA-04021 and free
>themselves, but I couldn't tell, the problem
>happened a few minutes before I was due to
>leave the site, and the end-users were
>on the other side of the Atlantic). The
>odd session might get a library cache pin
>wait.
>
>The object they were waiting for (tracked
>via x$kglob.kglhdadr = v$session_wait.p1raw)
>was a table. No-one has done ANYTHING
>untoward to the table, such as truncate, add column,
>index, analyze, for at least 3 days. The table is
>a normal heap table with half a dozen indexes.
>
>The best bet I could come up with was a
>metalink item that mentioned conflicts relating
>to materialized views - and there is a materialized
>view log on this table.
>
>The only other relevant detail I could come up
>with is that sessions create a session, work hard
>for a few seconds, then drop the session (maintaining
>the connection) so the system may be exercising some
>part of the code that creates x$kgllk items rather more
>heavily than is normal.
>
>Any thoughts ? Any similar experiences ?
>
>
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
>Next public appearances:
> Jan 29th 2004 UKOUG Unix SIG - v$ and x$
> March 2004 Hotsos Symposium - The Burden of Proof
> March 2004 Charlotte NC OUG - CBO Tutorial
> April 2004 Iceland
>
>
>One-day tutorials:
>http://www.jlcomp.demon.co.uk/tutorial.html
>
>
>Three-day seminar:
>see http://www.jlcomp.demon.co.uk/seminar.html
>____UK___February
>____UK___June
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request@(protected)
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------