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
BEWARE 9.2.0.5 64-BIT SOLARIS 2.9

BEWARE 9.2.0.5 64-BIT SOLARIS 2.9

2004-06-14       - By Chris Stephens

Reply:     1     2     3     4     5  

This is fun to read as I wait for oui to finish applying the 9205
patchset.

Oh well...it is our development machine, it is an HP 11 box, and I have
cma (covered my a$$).

chris

-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of DENNIS WILLIAMS
Sent: Monday, June 14, 2004 2:10 PM
To: 'oracle-l@(protected) '
Subject: RE: BEWARE 9.2.0.5 64-BIT SOLARIS 2.9

Paula
My experience, having worked for software vendors, is that you are
correct. Patchsets generally get a "modest " amount of regression
testing, at
best. Just to cheer you up, individual patches may receive practically
no
regression testing.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@(protected)

-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of
Paula_Stankus@(protected)
Sent: Monday, June 14, 2004 11:56 AM
To: oracle-l@(protected)
Subject: RE:BEWARE 9.2.0.5 64-BIT SOLARIS 2.9


Guys,

I don 't know if you remember but I complained earlier about ORA-07445 (See ORA-07445.ora-code.com),
ORA-0600 (See ORA-0600.ora-code.com) errors, database crashing, trace files being generated on :

sql loader processes
moving tables
imports

It was a bug we faced with 9.2.0.5 and it required "based on the bug
number "
getting the one-off patch. Of course, that was also fun as the one-off
patch instructs you to use the PERL installed with Oracle (which didn 't
work
we ended up using /usr/bin/perl with success) - installing the opatch
software, etc. BTW, I did look to see first if the patchset 9.2.0.6 was
out......so.....

I wondered if Oracle even does regression testing anymore because this
problem was not present with 9.2.0.4.

BEWARE - EITHER GO TO 9.2.0.4 OR WAIT TILL 9.2.0.6 would be my advice
ESPECIALLY IF YOU ARE RUNNING 64-BIT ORACLE ON SOLARIS 2.9

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