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

On Oct 29, 4:31 pm, DA Morgan <damor...@xxxxxxxxx> 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
damor...@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org

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.


.

Relevant Pages

  • Re: why cant i do this?? any clues on how i should go about
    ... Oracle is not a variant on SQL ... practice for alter tables. ...
    (comp.databases.oracle.misc)
  • Re: Informix beats Oracle
    ... in Informix would similarly use techniques not used in Oracle. ... What might constitute a fair test is "best practice" in both products ... The issue, if you want to benchmark, is not does it compile but is ...
    (comp.databases.informix)
  • Re: Storage problems with Oracle Blobs.
    ... And SYS should only be used, infrequently, for those specific jobs ... For MANY coporations it is not institutional practice, ... I am a "newbie" (to Oracle at least) and who are you to determine from ... why do you insist on assigning the SYSDBA role to application ...
    (comp.databases.oracle.server)
  • Re: Oracle transactions and DDL statements.
    ... Sybrand Bakker, Senior Oracle DBA ... you've written flies in the face of good practice in an Oracle database. ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)
  • Re: 7.32 patching questions
    ... It is not on the patch site!?) ... It has been my experience that MUP CD's usually duplicate patches ... It is always good practice to check. ... "production" load/data on your test box, to uncover any problems. ...
    (comp.os.vms)