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
Error in opening DB

Error in opening DB

2005-09-16       - By Hallas, John, Tech Dev

Reply:     1     2     3     4     5     6     7  

Frank,



This is not a resource to be used by companies who will not provide
necessary access to the internet to allow proper DBA support to be
undertaken.



Key sites to search before posting here should be Metalink and a Google
search (and obviously my site www.hcresources.co.uk
<http://www.hcresources.co.uk/>  ) :-)



My commiserations to any DBA who does not have internet access on demand
but that is an issue they should address themselves rather than
expecting listers to do the lookup for them



John



 __ __  

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Foelz.Frank
Sent: 16 September 2005 09:18
To: oracle-l@(protected)
Subject: RE: Error in opening DB



Carel,



not everybody who is enrolled here, has internet access on demand. Did
you ever consider this ?

It's not questions that bother......... but answers !

> Frank  <



  -- --Original Message-- --
  From: Carel-Jan Engel [mailto:cjpengel.dbalert@(protected)]
  Sent: Friday, September 16, 2005 10:12 AM
  To: oracle.tutorials@(protected)
  Cc: oracle-l@(protected)
  Subject: Re: Error in opening DB

  Deepak,
 
  Try google with "ORA-39700 (See ORA-39700.ora-code.com): database must be opened with UPGRADE
option".
 
  It's a good habit to search for answers yourself, before
bothering a list. Besides, you will get the answer pretty much faster
anyway.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===

 
  On Fri, 2005-09-16 at 11:16 +0530, DBA Deepak wrote:
 
 

  ORA-39700 (See ORA-39700.ora-code.com): database must be opened with UPGRADE option

 


<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]-->
<title>Nachricht</title>
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Wingdings;
  panose-1:5 0 0 0 0 0 0 0 0 0;}
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
@(protected)
  {font-family:"Comic Sans MS";
  panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0cm;
  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:purple;
  text-decoration:underline;}
p
  {mso-margin-top-alt:auto;
  margin-right:0cm;
  mso-margin-bottom-alt:auto;
  margin-left:0cm;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailStyle18
  {mso-style-type:personal-reply;
  font-family:"Comic Sans MS";
  color:blue;
  font-weight:normal;
  font-style:normal;
  text-decoration:none none;}
@(protected) Section1
  {size:595.3pt 841.9pt;
  margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>Frank,<o:p></o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>This is not a
resource
to be used by companies who will not provide necessary access to the internet
to allow proper DBA support to be undertaken.<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>Key sites to
search before posting here should be Metalink and a Google search (and
obviously my site <a href="http://www.hcresources.co.uk/">www.hcresources.co.uk
</a>
) </span></font><font size=2 color=blue face=Wingdings><span style='font-size:
10.0pt;font-family:Wingdings;color:blue'>J</span></font><font size=2
color=blue face="Comic Sans MS"><span style='font-size:10.0pt;font-family:
"Comic Sans MS";
color:blue'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>My
commiserations
to any DBA who does not have internet access on demand but that is an issue
they should address themselves rather than expecting listers to do the lookup
for them<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'>John<o:p></o:p>
</span></font></p>

<p class=MsoNormal><font size=2 color=blue face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:blue'><o:p>&nbsp;</o
:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US 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 lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font
></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Foelz.Frank<br>
<b><span style='font-weight:bold'>Sent:</span></b> 16 September 2005 09:18<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Error in opening DB<
/span></font><span
lang=EN-US><o:p></o:p></span></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 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Carel,</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 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>not everybody who is enrolled here, has
internet access on demand. Did you ever consider this ?</span></font><o:p></o:p
></p>

</div>

<div><!-- Converted from text/plain format -->

<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>It's not questions that bother.........
but&nbsp;answers !</span></font><o:p></o:p></p>

</div>

<p style='margin-bottom:12.0pt'><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'>&gt; Frank&nbsp; &lt;<br>
<br>
</span></font><o:p></o:p></p>

<blockquote style='margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Tahoma><span
lang=DE style='font-size:10.0pt;font-family:Tahoma'>-- --Original Message-- --
<br>
<b><span style='font-weight:bold'>From:</span></b> Carel-Jan Engel
[mailto:cjpengel.dbalert@(protected)] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, September 16, 2005
10:12 AM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle.tutorials@(protected)<br>
<b><span style='font-weight:bold'>Cc:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: Error in opening DB<
/span></font><span
lang=DE><o:p></o:p></span></p>

<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Deepak,<br>
<br>
Try google with &quot;ORA-39700 (See ORA-39700.ora-code.com): database must be opened with UPGRADE
option&quot;.<br>
<br>
It's a good habit to search for answers yourself, before bothering a list.
Besides, you will get the answer pretty much faster anyway.<o:p></o:p></span><
/font></p>

<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%"
style='width:100.0%'>
<tr>
 <td style='padding:0cm 0cm 0cm 0cm'>
 <p class=MsoNormal><font size=3 face="Times New Roman"><span
 style='font-size:12.0pt'>Best regards,<br>
 <br>
 Carel-Jan Engel<br>
 <br>
 ===<br>
 If you think education is expensive, try ignorance. (Derek Bok)<br>
 === <o:p></o:p></span></font></p>
 </td>
</tr>
</table>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
On Fri, 2005-09-16 at 11:16 +0530, DBA Deepak wrote:<br>
<br>
<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>ORA-39700 (See ORA-39700.ora-code.com): database must be opened with
UPGRADE option</span></font><o:p></o:p></p>

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

</blockquote>

</div>

</body>

</html>