Re: [suse-oracle] oracle9 on sles9: problem cannot connect "/
as sysdba " 2005-01-27 - By Arun Singh
I guess, we have to fix orarun to solve this problem. Any other glitch?
Thanks,
Arun
>>> "Robert Scheckle" <RobertS@(protected)> 1/26/2005 9:46:38 PM >>>
I have always created the Oracle user with the correct groups
before running orarun. This works very well.
This is not the first time that I have heard of Oracle user problems
when the user is left to be created by the orarun package.
Regards;
Robert Scheckle
Database Administrator
__ ____ ____ ____ ____ ___
MxO Information Systems
T: +27 (0)12 673 8139
E: roberts@(protected)
-- --Original Message-- --
From: Magni Fabrizio [mailto:Fabrizio.Magni@(protected)]
Sent: 26 January 2005 17:19
To: Tilman Schoop; suse-oracle@(protected)
Subject: RE: [suse-oracle] oracle9 on sles9: problem cannot connect "/
as sysdba"
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
>
>
--
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
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
