Re: Urgent: Can't connect internal (Oracle8i on Solaris7)

Hi Bernard

Bernard Polarski wrote:

> You recieve this message if your current unix user and the oracle owner
> binaries are not the same when connect internal into svrmgrl. Look
> carrefully in your tree starting $ORACLE_HOME for such an issue.

Possible, but not the case in my installation. User is always 'oracle'.

Any ohter ideas? I don't have any special installation. It's pretty much standard, done with runInstaller and dbassist.

Manfred

>
>
> B. Polarski
>
> In article <385A05FC.8130F6FD_at_itServe.ch>,
> Manfred Sturm <Manfred.Sturm_at_itServe.ch> wrote:
> > This is a multi-part message in MIME format.
> > --------------FD2A50F10A08058E363B5F3D
> > 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' nor 'oracle' 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).
> >
> > Note: Using dbassist produces me a db (or scripts incl. init<SID>.ora
> > and opapw<SID>) not password file authentication, but I'd like to use
> OS
> > authentication. What are the steps to switch?
> >
> > 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
> >
> > --------------FD2A50F10A08058E363B5F3D
> > 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
> >
> > --------------FD2A50F10A08058E363B5F3D--
> >
> >
>
> --
> B.Polarski
>
> http://www.geocities.com/bpolarsk
> Email : bpolarsk_at_yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Mon Dec 20 1999 - 08:57:04 CST