Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01031: insufficient privileges

Re: ORA-01031: insufficient privileges

From: Manfred Sturm <Manfred.Sturm_at_itServe.ch>
Date: Fri, 17 Dec 1999 09:11:42 +0100
Message-ID: <3859F03E.7F9BCD65@itServe.ch>


Nope. Same result: ORA-01031: insufficient privileges

Thx

Manfred

NetComrade wrote:

> connect internal/oracle
>
> On Thu, 16 Dec 1999 18:08:48 +0100, Manfred Sturm
> <Manfred.Sturm_at_itServe.ch> wrote:
>
> >This is a multi-part message in MIME format.
> >--------------4603F4F057A5CEDC03C520C7
> >Content-Type: text/plain; charset=us-ascii
> >Content-Transfer-Encoding: 7bit
> >
> >Hi
> >
> >I'm not able to dbshut/dbstart my 3 successfully instances of my
> >Oracle8i (8.1.5.0.0 for Solaris7) installation anymore. Trying to
> >connect using svrmgrl with my Oracle installation user (named: oracle8i,
> >member of groups: dba,oinstall,oper) using
> > SVRMGR> connect internal
> > Password:
> > ORA-01031: insufficient privileges
> >a password, I never have been prompted for. Neither 'manager' nor
> >'change_on_install' works.
> > SVRMGR> connect / as sysdba
> > ORA-01031: insufficient privileges
> >pretty much the same result here.
> >
> >Note: I expect to be able to log in internally to the currently set
> >ORACLE_SID database instance. I intent to use OS authentication with
> >remote_login_passwordfile set to none and a removed
> >$ORACLE_HOME/dbs/orapw<ORACLE_SID> file (I did this modification while
> >the particular db instance was shut down).
> >
> >I try to find a way to use OS authentication with no password for the
> >internal user, so dbstart/dbshut work unchanged for a UNIX user being
> >member of the dba or oper group (as described in the administration
> >manual).
> >
> >But for now it seems I have locked myself out of the system for
> >startup/shutdown or database manipulation operations.
> >
> >P.S.: user sys/change_on_install and system/manager still work fine :-|
> >
> >Who can help me out?
> >
> >Cheers
> >
> >Manfred
> >
> >--------------4603F4F057A5CEDC03C520C7
> >Content-Type: text/x-vcard; charset=us-ascii;
> > name="Manfred.Sturm.vcf"
> >Content-Transfer-Encoding: 7bit
> >Content-Description: Card for Manfred Sturm
> >Content-Disposition: attachment;
> > filename="Manfred.Sturm.vcf"
> >
> >begin:vcard
> >n:Sturm;Manfred
> >tel;fax:031 305 16 17
> >tel;work:031 305 16 19
> >x-mozilla-html:FALSE
> >org:itServe AG
> >version:2.1
> >email;internet:Manfred.Sturm_at_itServe.ch
> >title:Software Engineer
> >adr;quoted-printable:;;L=E4nggass-Strasse 26=0D=0APostfach 690=0D=0A3000 Bern 9;;;;
> >x-mozilla-cpt:;9744
> >fn:Manfred Sturm
> >end:vcard
> >
> >--------------4603F4F057A5CEDC03C520C7--
> >
>
> In case I forgot to mention:
> We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email


Received on Fri Dec 17 1999 - 02:11:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US