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

Hello!

I believe that I am having the same problem. I have 8.0.5 installed under linux. I "upgraded" from redhat 5.2 to 6.1 and now cant get the DB started anymore.

I do not understand what you mean about "oracle owner binaries". Do you mean who owns the files and which permissions they have?

In my case it looks like:

for root
> id
> uid=0(root) gid=0(root)

groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

for user "oracle"
> id
> uid=20(oracle) gid=60 groups=60

where the /etc/group file defines
dba:x:60:
osoper:x:61:

I would be very grateful for any tips or hints you have.

thanks

Bruce Sams

In article <83dl23$s18$1_at_nnrp1.deja.com>,   Bernard Polarski <bpolarsk_at_yahoo.com> 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.
>
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 30 1999 - 15:24:04 CST