Hello Damien, just for curiosity sake: was your installation to generate the sqlnet.ora? netca?
Fabrizio
> -- --Original Message-- -- > From: Pinault, Damien [mailto:DPinault@(protected)] > Sent: Wednesday, January 26, 2005 5:44 PM > To: Tilman Schoop; suse-oracle@(protected) > Subject: RE: [suse-oracle] oracle9 on sles9: problem cannot > connect "/ as sysdba" > > > I encountered this issue recently too. > Because of sqlnet.ora .. It looks like. > Comment : #SQLNET.AUTHENTICATION_SERVICES=(NONE) > > And that should work. > > D> > > -- --Original Message-- -- > From: Tilman Schoop [mailto:ts@(protected)] > Sent: Wednesday, January 26, 2005 11:24 AM > To: suse-oracle@(protected) > Subject: Re: [suse-oracle] oracle9 on sles9: problem cannot connect "/ > as sysdba" > > > Hello Magni, hello Mathias, > > thanks for your quick answers, but I still cannot connect to "/": > > this is id of my oracle user: > uidY(oracle) gidT(oinstall) groupsT(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 > > > -- > 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
