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 ??
--
J.Bratières
Enlever paspub pour répondre
Please remove paspub when answering
Received on Tue Jun 27 2006 - 08:18:00 CDT
