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

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.

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 Fri Dec 17 1999 - 09:32:18 CST