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

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.

-- 
J.Bratières

Enlever paspub pour répondre
Please remove paspub when answering