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: Re: Controlling developers is like herding cats, to the point

Juan Cachito Reyes Pacheco

2004-03-22

Replies:
I think this kind of things are unevitable in a medium database, the point
I t alk about is more
critical, you haev to do a project, how you assign, how you know what is
doing every person,
how do you control the time he is using in every task.
Not only to control a person, too to detect other kind of problems, if a
person takes 10 hours every week executing backups, you could start to think
to find a way to improve them.
But to know that you need a way to measure.
What do you use ryan, do you use gannt, write in excel, in a workbook, etc.
I this could be very interesting to share the techniques we use, to improve
them.

For example ryan, how do you replicate the changes done in test database in
production, do you have a script in a folder, where you are pasting all the
changes.
do you compare databases and generate a script??
How do you do?

----- Original Message -----
From: <ryan.gaffuri@(protected)>
To: <oracle-l@(protected)>
Sent: Monday, March 22, 2004 5:28 PM
Subject: Re: Re: Controlling developers is like herding cats, to the point


> thought I know how people feel when they get that error...
>
> just about an hour ago
>
> 1. I get an email stating that an object doesn't exist. It's because the
developers are looking in the wrong database.
> 2. So I lock all the accounts in the database and bounce it. I send out an
email stating that all the accounts in this database are locked and which
databases they should be using.
> 3. I then get a screen shot with the following error:
>
> ORA-28000: the account is locked
>
> Dont you just love build day?
> >
> > From: "Juan Cachito Reyes Pacheco" <jreyes@(protected)>
> > Date: 2004/03/22 Mon PM 01:18:22 EST
> > To: <oracle-l@(protected)>
> > Subject: Re: Re: Controlling developers is like herding cats, to the
point
> >
> > Ryan how you organize your job, what we do Very very simple.
> >
> > what we had done is develop a software that create a task orders,
> > the advantage of them is when you say something, you know in some moment
> > this is
> > going to be done.
> > The second is a time management, every time you start to do a job, you
> > select from a lov your current job, this allow to measure the time you
> > invest in every task.
> > There are generic tasks, like phone calls, meetings, etc.
> > And the person who gives the task must do a brief quality control after.
> >
> > weekly there are reports so you can see what a specific person did, an
> > analyze why he took too much time doing something,or you can get
knowledge
> > about a problem you didn't knew.
> >
> > Aditionally we created a software to create releases by object, this is
if
> > you create a database object, you enter in the database, so to update
> > production database you generate the releases you did.
> >
> > Obviously there are dozens of details, but this is the general idea,
this is
> > very intesresting, because which is the other chance you have.
> > to Say to you partner why you take too much time?
> > Then he says, because there were other problems,
> > In that way you can't control, not only the work, else the problems
there
> > are too, and the exactly time there are investing in them.
> >
> > ----- Original Message -----
> > From: <ryan.gaffuri@(protected)>
> > To: <oracle-l@(protected)>
> > Sent: Monday, March 22, 2004 1:46 PM
> > Subject: Re: Re: Controlling developers is like herding cats
> >
> >
> > > It's not a 'developer' problem. It's a team and management problem.
It's
> > also a lack of technical skill amongst Developer's and/or DBA problem.
> > >
> > >
> > > >
> > > > From: Mladen Gogala <mladen@(protected)>
> > > > Date: 2004/03/22 Mon PM 12:31:53 EST
> > > > To: oracle-l@(protected)
> > > > Subject: Re: Controlling developers is like herding cats
> > > >
> > > > Yes, that's true. One thing to remember when talking about
developers is
> > > > that work liberates, or in German: "Arbeit Macht Frei". Good
> > organization
> > > > is the final solution of the developer problem. Of course, I'm a
DBA,
> > > > in case anyone had any doubts.
> > > >
> > > > On 03/22/2004 12:15:33 PM, Juan Cachito Reyes Pacheco wrote:
> > > > > This is true ryan,
> > > > > But comments like "Controlling developers is like herding cats"
> > > > > Seems that someone have problems organizing the work,
> > > > > Independently of who is responsible of that, they must be solved.
> > > > >
> > > > > The point is if some one wants to talk about their problems as
dba,
> > > > > working with other people and how to solve them.
> > > > > I have some experience and this could be interesting, sahre ideas
> > found to
> > > > > solve them.
> > > > > Now if no body have problems with that then there is no reason for
> > this
> > > > > post.
> > > > > :)
> > > > >
> > > > > ----- Original Message -----
> > > > > From: <ryan.gaffuri@(protected)>
> > > > > To: <oracle-l@(protected)>
> > > > > Sent: Monday, March 22, 2004 1:11 PM
> > > > > Subject: Re: Controlling developers is like herding cats
> > > > >
> > > > >
> > > > > > your question is vague. what do you mean by organizing
developers.
> > its not
> > > > > the DBAs responsibility to do that. It's their management's
> > responsibility.
> > > > > >
> > > > > > what do you mean?
> > > > > > >
> > > > > > > From: "Juan Cachito Reyes Pacheco" <jreyes@(protected)>
> > > > > > > Date: 2004/03/22 Mon AM 10:32:06 EST
> > > > > > > To: <oracle-l@(protected)>
> > > > > > > Subject: Controlling developers is like herding cats
> > > > > > >
> > > > > > > I don't know if some dba, want to talk about the way to solve
> > > > > > > organizing a group of developer (including times, work to be
done,
> > > > > > > quality control, etc.)
> > > > > > > We have some experience, and had developed a software for
internal
> > use,
> > > > > > >
> > > > > > > Maybe someone want to talk about this, I think this is a
critical
> > work
> > > > > > > for the dba.
> > > > > > >
> > > > > >
> ----------------------------------------------------------------
> > > > > > > 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
> > > > > -----------------------------------------------------------------
> > > > >
> > > > ----------------------------------------------------------------
> > > > 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
> > -----------------------------------------------------------------
> >
>
> ----------------------------------------------------------------
> 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
-----------------------------------------------------------------