Re: ORA 10G -ORA-12546 Error [semi solved]

nwjb wrote:
> Le Tue, 27 Jun 2006 15:18:00 +0200, nwjb <j.bra.invalid.paspub_at_online.fr>
> a écrit:
>
> > Le Wed, 21 Jun 2006 13:42:50 +0200, nwjb
> > <j.bra.invalid.paspub_at_online.fr> a écrit:
> >
> >> Le Tue, 20 Jun 2006 22:56:34 +0200, joel garry <joel-garry_at_home.com> a
> >> écrit:
> >>
> >>>
> >>> nwjb wrote:
> >>>> Le Tue, 20 Jun 2006 10:34:26 +0200, StefanKapitza
> >>>> <skapitza_at_volcanomail.com> a écrit:
> >>>>
> >>>> >
> >>>> > nwjb wrote:
> >>>> >> Le Mon, 19 Jun 2006 15:33:55 +0200, <ravisista_at_gmail.com> a écrit:
> >>>> >>
> >>>> >> > nwjb wrote:
> >>>> >> >> I forgot to mention: was OK before we changed IP adress of the
> >>> ards
> >> [...]
> >>> Where are all your sqlnet.ora files and what are their permissions and
> >>> what is in them.
> >>
> >> where:
> >> /opt/oracle/product/10G/network/admin
> >> permissions:
> >> 640 (rw r ) oracle oinstall
> >> content:
> >> names.directory_path= (TNSNAMES,EZCONNECT)
> >>
> >>> Do you have TNS_ADMIN set?
> >> Dont think so , is it an environment variable?
> >>
> >>> What does ipcs say the mode is for your SGA?
> >>
> >> owner oracle , permission 640
> >>
> >>> ll $ORACLE_HOME/bin/oracle
> >>> -rwsr-s--x ...
> >>>
> >> That is right.
> >>> jg
> >> More investigation gives following result:
> >> This machine is being installed , so much work is done being connected
> >> as root.
> >> And things differ:
> >>
> >> telnet x.x.x.x
> >> login: root
> >> password: XX
> >> . /v/xxxxx (creating ORACLE_HOME , SID ... and others)
> >> sqlplus scott/tiger -> does not work (insufficient priveleges TNS)
> >> su - root
> >> . /v/xxxxx
> >> sqlplus scott/tiger -> WORKS !!!!!
> >>
> >>
> >>
> > Has anyone any idea ??
> >
> >
>
> Answering to ourselves:
>
> root is member of oinstall and oracle groups .
> logging in as root and doing id shows ONLY root group.
> suing root gives correct groups.
>
> Looking for the reason.

man newgrp
Oh wait, bash doesn't have that. Try a shell that does. I think this is a purposeful security issue. Are you sure it worked before? Why do you want to be root and use sqlplus, anyways?

jg

--
@home.com is bogus.
AOL had service?
http://www.signonsandiego.com/uniontrib/20060804/news_1b4aol.html