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 > >
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
