.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
DATAFILE??

DATAFILE??

2005-10-19       - By Ram K
Reply:     <<     21     22     23     24     25     26     27     28     29     30     >>  

When a person starts learning the DBA side of things they see tremendous
amount of information, spread among hundreds of Oracle manuals (which change
every version), let alone books, online sources, etc. Even if we consider
the manuals only, reference to a specific topic probably could be found in
200 different locations in 10 different manuals. It is quite possible the
answer may be in one manual, but when I am a beginner it gets difficult for
me to sort things out. This could be sometimes overwhelming if I am new to
the topic.

So when people who are experienced see such questions, it will be greatly
helpful if they can put themselves in the shoes of beginners for a bit. If
you like an analogy let us say some of the very experienced DBAs set to
learn medicine. There are thousands of manuals and books. All the
terminilogy, the talk, the terms, etc will be completely new. It will be
very confounding to them. The questions they ask may sound very basic to
experienced doctors. New learners of Oracle are in a similar situation.
Experts: please bear with us. Thanks as always for all your help which we
get for free here :)

Ram.

On 10/19/05, Murching, Bob <bob_murching@(protected)> wrote:
>
>  > I am not sure how we can collectively balance out as you suggested.
> > Should we take turns ask one mid to advanced question for every newbie
> > question posted to keep this list interesting?
>  First, for the record, I agree with much of what you said; the concern I
> have is that this list isn't necessary "better" if it concerns only
> questions that less than 20 people on the planet are qualified to answer.
> Some of the best discussion I see here begins rather innocuously with a
> newbie question that evolves into something much more interesting... people
> read the original question and ask it again but with a different spin. Some
> of these innocent questions have led to the so-called experts disagreeing
> with each other and making for some interesting debate. It would be a shame
> to see all that gone. The best signal sometimes comes with a little bit of
> noise.
>  To answer your question.... absolutely. That's exactly what people should
> be doing. The list is what its members make it. If you feel that the content
> doesn't meet a certain bar, then raise the bar by asking tough questions or
> offering answers of a caliber that you feel should set the standard. Or take
> the newbie question and rephrase it in a way that takes it to the "next
> level" (whatever that may mean.)
>  Bob
>

<div><br>&nbsp;&nbsp; When a person starts learning the DBA side of things they
see tremendous amount of information, spread among&nbsp; hundreds of Oracle
manuals (which change every version), let alone books, online sources, etc.
Even if we consider the manuals only, reference to a specific topic probably
could be found in 200 different locations in 10 different manuals. It is quite
possible the answer may be in one manual, but when I am a beginner it gets
difficult for me to sort things out. This could be sometimes overwhelming if
&nbsp;I am new to the topic.
<br>&nbsp;&nbsp; <br>&nbsp;&nbsp; So when people who are experienced see such
questions, it will be greatly helpful if they can put themselves in the shoes
of beginners for a bit.&nbsp; If you like an analogy let us say some of the
very experienced DBAs set to learn medicine. There are thousands&nbsp;of
manuals and books. All the terminilogy, the talk, the terms, etc will be
completely new. It will be very confounding to them. The questions they ask
&nbsp;may sound very basic to experienced doctors. New learners of Oracle are in
a similar situation.&nbsp;&nbsp;
<br>&nbsp;&nbsp; </div>
<div>Experts: please bear with us. Thanks as always for all your help which we
get for free here :) </div>
<div>&nbsp;&nbsp;&nbsp; <br>Ram.</div>
<div><br>&nbsp;</div>
<div><span class="gmail_quote">On 10/19/05, <b class="gmail_sendername"
>Murching, Bob</b> &lt;<a href="mailto:bob_murching@(protected)">bob_murching
@(protected)</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid"><span class="q">
<div dir="ltr" align="left"><font size="2"><span><font face="Arial" color="
#0000ff">&nbsp;<font face="Times New Roman" color="#000000">&gt; </font></font><
/span>I am not sure how we can collectively balance out as you suggested.
<br><span><font face="Arial" color="#0000ff">&nbsp;<font face="Times New Roman"
color="#000000">&gt; </font>&nbsp;</font></span>Should we take turns ask one
mid to advanced question for every newbie<br><span><font face="Arial" color="
#0000ff">
&nbsp;<font face="Times New Roman" color="#000000">&gt; </font>&nbsp;</font><
/span>question posted to keep this list interesting?<br><span><font face="Arial"
color="#0000ff">&nbsp;</font></span></font></div></span>
<div dir="ltr" align="left"><font size="2"><span><font face="Arial" color="
#0000ff">First, for the record, I agree with much of what you said;&nbsp;the
concern I have is that this list isn't necessary &quot;better&quot; if it
concerns only questions that less than 20 people on the planet are qualified to
answer.&nbsp; Some of the best discussion I see here begins rather innocuously
with a newbie question that evolves into something much more interesting...
people read the original question and ask it again but with a different spin.
&nbsp; Some of these innocent questions have led to the so-called experts
disagreeing with each other and making for some interesting debate.&nbsp; It
would be a shame to see all that gone.&nbsp; The best signal sometimes comes
with a little bit of noise.
</font></span></font></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span><
/span></font>&nbsp;</div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span
>To answer your question.... absolutely.&nbsp; That's exactly what people should
be doing.&nbsp; The list is what its members make it.&nbsp; If you feel that
the content doesn't meet a certain bar, then raise the bar by asking tough
questions or offering answers of a caliber that you feel should set the
standard.&nbsp; Or take the newbie question and rephrase it in a way that takes
it to the &quot;next level&quot; (whatever that may mean.)
</span></font></div><span class="sg">
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span><
/span></font>&nbsp;</div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span
>Bob</span></font></div></span></blockquote></div><br>