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
9.2.0.6 or 9.2.0.7 for AIX 5.3 (64 bit)

9.2.0.6 or 9.2.0.7 for AIX 5.3 (64 bit)

2005-10-12       - By Gogala, Mladen

Reply:     1     2     3     4  

Be careful with 9.2.0.7. It cannot export from lower versions of Oracle. I
didn't have any other problems, but this one is

a big one. The compatibility with the previous releases is broken. After
closer inspection,

DBMS_EXPORT_EXTENSION package has 3 more units in 9.2.0.7 then in 9.2.0.5:


FUNCTION CHECK_MATCH_TEMPLATE RETURNS NUMBER(38)
FUNCTION FUNC_INDEX_DEFAULT RETURNS VARCHAR2
FUNCTION NULLTOCHR0 RETURNS VARCHAR2



The error I am getting is:



. exporting table DEF$_AQCALL 0 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904 (See ORA-00904.ora-code.com): "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid
identifier



This is yet another Oracle patchset to have QA done by customers. I have a
TAR open

about this and support analysts are dragging their feet. I should forward
this to Mr. Scott Adams.



--

Mladen Gogala

Ext. 121

 __ __  

From: Ruth Gramolini [mailto:rgramolini@(protected)]
Sent: Wednesday, October 12, 2005 9:46 AM
To: oracle-l
Subject: 9.2.0.6 or 9.2.0.7 for AIX 5.3 (64 bit)



Good morning,



We are finally going to update our 9.2.0.4 installation and we are also
going to upgrade AIX from 5.2 to 5.3.  Does anyone have any insights as to
which version 9.2.0.6 or 9.2.0.7 is better or worse.  



I know there have been some problems with 9.2.0.6 but I am not familiary
with problems specifie to AIX 5.3. Any insights will be welcome!



Thanks in advance,

 

Ruth Gramolini

Oracle DBA

Vermont Department of Taxes

Phone 802-828-5708

Email rgramolini@(protected) <mailto:rgramolini@(protected)>  


<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">


<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:blue;
  text-decoration:underline;}
span.EmailStyle17
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
 <o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>

<body bgcolor=white lang=EN-US link=blue vlink=blue>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Be careful with 9.2.0.7. It cannot export
from lower versions of Oracle. I didn't have any other problems, but this
one is<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>a big one. The compatibility with the
previous releases is broken.</span></font><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> <font color="#333399"><span
style='color:#333399'>After closer inspection, <o:p></o:p></span></font></span>
</font></p>

<p class=MsoNormal><font size=2 color="#333399" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#333399'>DBMS_EXPORT_EXTENSION
package has 3 more units in 9.2.0.7 then in 9.2.0.5:<o:p></o:p></span></font><
/p>

<p class=MsoNormal><font size=2 color="#333399" face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:#333399'><br>
FUNCTION CHECK_MATCH_TEMPLATE RETURNS NUMBER(38)<br>
FUNCTION FUNC_INDEX_DEFAULT RETURNS VARCHAR2<br>
FUNCTION NULLTOCHR0 RETURNS VARCHAR2<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The error I am getting is:<o:p></o:p><
/span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>. exporting table DEF$_AQCALL 0 rows
exported<br>
EXP-00056: ORACLE error 904 encountered<br>
ORA-00904 (See ORA-00904.ora-code.com):
&quot;SYS&quot;.&quot;DBMS_EXPORT_EXTENSION&quot;.&quot;FUNC_INDEX_DEFAULT&quot
;:
invalid identifier<o:p></o:p></span></font></p>

<div>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>This is yet another Oracle patchset to
have QA done by customers. I have a TAR open<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>about this and support analysts are
dragging
their feet. I should forward this to Mr. Scott Adams.<o:p></o:p></span></font><
/p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>--</span></font><font color=navy><span
style='color:navy'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mladen Gogala</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Ext. 121</span></font><o:p></o:p></p>

</div>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Ruth Gramolini
[mailto:rgramolini@(protected)] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, October 12, 2005
9:46 AM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l<br>
<b><span style='font-weight:bold'>Subject:</span></b> 9.2.0.6 or 9.2.0.7 for
AIX 5.3 (64 bit)</span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Good morning,</span></font><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>We are finally going to update our 9.2.0.4 installation and
we are also going to upgrade AIX from 5.2 to 5.3.&nbsp; Does anyone have any
insights as to which version 9.2.0.6 or 9.2.0.7 is better or worse.&nbsp; <
/span></font><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I know there have been some problems with 9.2.0.6 but I am
not familiary with problems specifie to AIX 5.3. Any insights will be welcome!<
/span></font><o:p></o:p></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks in advance,</span></font><o:p></o:p></p>

</div>

<div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;</span></font><font face=Arial><span style='font-family:Arial'>
<o:p></o:p></span></font></p>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Ruth Gramolini</span></font><font face=Arial><span
style='font-family:Arial'><o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Oracle DBA</span></font><font face=Arial><span
style='font-family:Arial'><o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Vermont Department of Taxes</span></font><font face=Arial>
<span
style='font-family:Arial'><o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Phone 802-828-5708</span></font><font face=Arial><span
style='font-family:Arial'><o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Email <a href="mailto:rgramolini@(protected)">rgramolini
@(protected)</a></span></font><font
face=Arial><span style='font-family:Arial'>&nbsp;<o:p></o:p></span></font></p>

</div>

</div>

</div>

</div>

</body>

</html>