Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01031 insufficient privileges - what am i missing?

Re: ORA-01031 insufficient privileges - what am i missing?

From: Helma <>
Date: Tue, 30 Oct 2007 10:55:40 -0700
Message-ID: <>

On Oct 29, 4:31 pm, DA Morgan <> wrote:
> Helma wrote:
> > <snipped>, i should stick to this on the ora10 machine.
> > Helma
> Why? I wouldn't. Continuing a bad practice is not something to be proud of.
> --
> Daniel A. Morgan
> University of Washington
> (replace x with u to respond)
> Puget Sound Oracle Users

Hello Daniel,

I guess you've been around in the Oracle land long enough to know that technical people have to violate the things they perceive as ' best practice'. I gave you an example of this in one of my previous posts : they are running oracle 9 the very first version here and refuse to apply patches for non-technical reasons. With my 10 years of DBA experience i know well that there is no virtue in not applying patches.

You were dismissive of this, telling me that there was no excuse for me to run behind so many versions - as if it was my choice not to use patches.

And in this post , you suggest i would be proud to willfully continue a bad practice.

If you would have been a junior in the business, i might have understood you. After all, you know the best practices, you see people not adhere to it, and you assume that these people are not well informed about the best practices.
After gaining some experience - and reading too many Dilbert jokes - you start to realize that companies often are way understaffed, badly managed, adhere to historic(wrong) standards, don't listen to technical people or have more issue's than in the technical realm.

In this chaos i need to operate, i have only one extra week before i fly back to my country, and i am experiencing a technical issue, for which i want to turn to my helpful fellow DBA's. I would appreciate pure technical advice.

Now, i've read the checklist:

Subject: UNIX: Checklist for Resolving Connect AS SYSDBA Issues metalink: Note:69642.1

problem appeared that after the installation, there was no passwordfile created. So i created one, so i was able to at least log in with the ' connect sys/passwd as sysdba' . However, the connect / as sysdba still doesn't work, which worries me whether the oracle has some extra flaws in it.

I think i checked the obvious:

  1. location and permissions of the init-file
  2. $ORACLE_HOME and $ORACLE_SID variables are ok
  3. group assingments seem ok ( checked /etc/group & /etc/passwd )
  4. $TWO_TASKS isn't set
  5. permission on the oracle executable are ok
  6. filesystem isn't nosuid mounted

appearantly i am missing something, I might decide to reinstall....

Helma. Received on Tue Oct 30 2007 - 12:55:40 CDT

Original text of this message