Re: ORA-01031: insufficient privileges

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