Re: ORA 10G -ORA-12546 Error

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 !!!!!

-- 
J.Bratières

Enlever paspub pour répondre
Please remove paspub when answering