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
> -----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:
: 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 Schoop
> Fa. DSA - Daten- und Systemtechnik GmbH
> Pascalstr. 28
> D-52076 Aachen
> 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