oracle9 on sles9: problem cannot connect "/ as sysdba " 2005-01-26 - By Tilman Schoop
Hello Magni, hello Mathias,
thanks for your quick answers, but I still cannot connect to "/":
this is id of my oracle user:
uid=59(oracle) gid=54(oinstall) groups=54(oinstall),55(dba)
Magni, you are right: oracle user is not in dba after installation,
so I added him to dba group manually. (this was before writing my first
question).
Adding user oracle to group disk(6) did not help either.
(btw. how can I check afterwards with which admin group I have installed it?)
The permissions of my oracle binary are also correct:
-rwsr-s--x 1 oracle oinstall 48217581 2004-12-13 12:21 oracle
Orarun package is: orarun-1.8-109.5
Oracle installation is: 9.2.0.4 + patchset 9.2.0.5 as described in Arun`s
howto.
Regards
Tilman
Am Mittwoch, 26. Januar 2005 16:19 schrieb Magni Fabrizio:
> Are you sure your oracle user is in dba group?
>
> During my last oracle/SLES9 installation I was surprised by discoverying
> that orarun placed my oracle user as member of "oinstall" and "disks"
> but not "dba".
> When I installed oracle the dba group was automatically placed to disk
> (have you checked you haven't installed with "disk" group as group with
> database administrator privileges?).
>
> Anyone got a similar results during installation? Orarun was
> orarun-1.8-109.5.
>
> Fabrizio
>
> > -- --Original Message-- --
> > From: Tilman Schoop [mailto:ts@(protected)]
> > Sent: Wednesday, January 26, 2005 4:05 PM
> > To: suse-oracle@(protected)
> > Subject: [suse-oracle] oracle9 on sles9: problem cannot
> > connect "/ as sysdba"
> >
> >
> > Hello there,
> >
> > I have installed oracle9 on sles9. it is configured, I have
> > got a database
> > instance. But, and here is my problem:
> > I cannot connect with sqlplus "/ as sysdba"
> > I get the error:
> > ERROR:
> > ORA-01031 (See ORA-01031.ora-code.com): insufficient privileges
> >
> > I am trying this with user oracle (main group: oinstall),
> > which is also member of group dba.
> >
> > I can connect using sys/password, but it would be much nicer to
> > be able to connect to "/" , for example to use dbstart without putting
> > the sys password.
> >
> > I thought the "/" authentication is made via the Linux user
> > and membership in
> > dba group. what else needs to be configured?
> >
> > Thanks in advance for any hints
> >
> > Tilman
> >
> > --
> > Tilman Schoop
> > Fa. DSA - Daten- und Systemtechnik GmbH
> > Pascalstr. 28
> > D-52076 Aachen
> > Germany
> > Email: ts<ar>dsa-ac.de
> > Tel.: +49-2408-9492-661
> > Fax.: +49-2408-9492-92
> >
> > --
> > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > For additional commands, email: suse-oracle-help@(protected)
> > Please see http://www.suse.com/oracle/ before posting
--
Tilman Schoop
Fa. DSA - Daten- und Systemtechnik GmbH
Pascalstr. 28
D-52076 Aachen
Germany
Email: ts<ar>dsa-ac.de
Tel.: +49-2408-9492-661
Fax.: +49-2408-9492-92
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
